Moexpxp15
Updated 2023-01-12
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('day', BLOCK_TIMESTAMP)::date AS DAY,
monthname(BLOCK_TIMESTAMP) AS Month,
count(TX_ID) AS txns,
count(distinct TX_SENDER) AS act_users,
sum(FEE) AS tot_fee,
tot_fee/txns as fee_per_tx,
txns/act_users as txs_per_user
from terra.core.fact_transactions where TX_SUCCEEDED='TRUE' and BLOCK_TIMESTAMP::date between '2022-12-01' and CURRENT_DATE-1
group by 1,2
Run a query to Download Data