shahdadi-9ptm8YUntitled Query
Updated 2022-11-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with a as(select
date_trunc('hour',block_timestamp) date,
count(tx_id) txn,
sum(fee) hourly_fee_paid,
hourly_fee_paid/txn average
from algorand.core.fact_transaction
where date > CURRENT_DATE - 30
group by 1
),b as(
select
block_hour,price_usd
from algorand.defi.ez_price_pool_balances
where block_hour >= CURRENT_DATE - 30
)
select
a.date,
txn,
hourly_fee_paid,
average*price_usd average_usd_per_transaction
from a join b on a.date=b.block_hour
Run a query to Download Data