shahdadi-9ptm8Ysolana 1
Updated 2022-11-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with a as(select
date_trunc('hour',block_timestamp) date,
sum(fee)/pow(10,9) fee
from solana.core.fact_transactions
where block_timestamp >= CURRENT_DATE - 30
group by 1
),b as(
select RECORDED_HOUR,close
from solana.core.fact_token_prices_hourly where id='5426' and RECORDED_HOUR>= CURRENT_DATE - 30
),c as(
select
date,
fee*close fee
from a join b on a.date=b.RECORDED_HOUR
)
select
sum(fee)
from c
Run a query to Download Data