hessaverage fee per block
    Updated 2022-12-13
    with price as ( select date(hour) as date,'Ethereum' as chain, 'ETH' as symbol , avg(price) as token_price
    from ethereum.core.fact_hourly_token_prices
    where date >= CURRENT_DATE - 60 and symbol = 'WETH'
    group by 1,2,3
    UNION
    select date(TIMESTAMP) as date,'Flow' as chain, 'Flow' as symbol , avg(PRICE_USD) as token_price
    from flow.core.fact_prices
    where date >= CURRENT_DATE - 60 and token = 'Flow'
    group by 1,2,3
    UNION
    select date(hour) as date,'Optimism' as chain, 'ETH' as symbol , avg(price) as token_price
    from ethereum.core.fact_hourly_token_prices
    where date >= CURRENT_DATE - 60 and symbol = 'WETH'
    group by 1,2,3
    UNION
    select date(hour) as date,'Arbitrum' as chain, 'ETH' as symbol , avg(price) as token_price
    from ethereum.core.fact_hourly_token_prices
    where date >= CURRENT_DATE - 60 and symbol = 'WETH'
    group by 1,2,3
    UNION
    select date(RECORDED_AT) as date,'Osmosis' as chain, 'Osmo' as symbol , avg(price) as token_price
    from osmosis.core.dim_prices
    where date >= CURRENT_DATE - 60 and symbol ilike '%osmo%'
    group by 1,2,3
    UNION
    select date(BLOCK_HOUR) as date,'Algorand' as chain, 'Algo' as symbol , avg(PRICE_USD) as token_price
    from algorand.defi.ez_price_swap
    where BLOCK_HOUR::date >= CURRENT_DATE - 60 and ASSET_NAME = 'Governance Algo'
    group by 1,2,3
    UNION
    select date(TIMESTAMP) as date,'Near' as chain, 'Near' as symbol , avg(PRICE_USD) as token_price
    from near.core.fact_prices
    where date >= CURRENT_DATE - 60 and SYMBOL = 'wNEAR'
    group by 1,2,3
    UNION
    select date(hour) as date,'Polygon' as chain, 'Matic' as symbol , avg(price) as token_price
    Run a query to Download Data