rahoTerra Fees broken
Updated 2023-04-10
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
›
⌄
with all_tx as (
select
block_id,
block_timestamp,
blockchain,
fee,
fee:amount as fee_amount,
fee:denom as fee_token,
gas_used,
gas_wanted,
tx_code
from terra.classic.fact_transactions
),
grouped_tx as (
select
date_trunc('day', block_timestamp) as date,
sum(fee_amount) as fees
from all_tx
group by 1
order by date asc
)
select *
Run a query to Download Data