Moexpxp15
    Updated 2023-01-12
    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