hessaverage fee per block
Updated 2022-12-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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