badboyUntitled Query
    Updated 2022-12-22
    WITH eth_price
    as (
    SELECT
    hour::date as p_date,
    avg(price) as eth_price

    FROM ethereum.core.fact_hourly_token_prices

    WHERE symbol = 'WETH'

    AND p_date > CURRENT_DATE - 180
    GROUP by 1

    )

    SELECT
    BLOCK_TIMESTAMP::DATE as date,
    CASE
    WHEN CONTRACT_ADDRESS = '0x6b175474e89094c44da98b954eedeac495271d0f' THEN 'Withdaw DAI'
    WHEN CONTRACT_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' THEN 'Withdaw WETH'
    WHEN CONTRACT_ADDRESS = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 'Withdaw USDC'

    WHEN CONTRACT_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7' THEN 'Withdaw USDT'
    END as status,
    Run a query to Download Data