pandaETH Down Bad | MATIC Price and Volume
    Updated 2022-12-23
    WITH matic_PriceTrend AS
    (
    SELECT
    hour::date as timestamps,
    avg(price) as usd_Price
    FROM
    ethereum.core.fact_hourly_token_prices
    WHERE
    TOKEN_ADDRESS = lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0')

    AND
    timestamps >= CURRENT_DATE - 14
    GROUP BY
    1
    ),

    swap_Transactions AS
    (
    SELECT
    BLOCK_TIMESTAMP::date as timestamps,
    CASE WHEN SYMBOL_IN = 'MATIC' AND SYMBOL_OUT != 'MATIC' then 'SELL'
    WHEN SYMBOL_IN != 'MATIC' AND SYMBOL_OUT = 'MATIC' then 'BUY'
    END AS decision,
    AMOUNT_IN_USD as USD_IN,
    AMOUNT_OUT_USD as USD_OUT,
    TX_HASH
    FROM
    ethereum.core.ez_dex_swaps
    WHERE
    EVENT_NAME = 'Swap'
    AND
    SYMBOL_IN = 'MATIC'
    AND
    SYMBOL_OUT != 'MATIC'
    AND
    timestamps >= CURRENT_DATE - 14
    Run a query to Download Data