MufasaTotal transaction fees in Luna
    Updated 2023-01-10
    with total_txns as (
    select
    -- date_trunc('week', block_timestamp) as week,
    case when block_timestamp >= '2023-01-01' then '2023'
    else '2022'
    END as category,
    sum(fee) as volume
    -- count(*) as total_count
    from terra.core.fact_transactions
    where block_timestamp > current_date - 90
    group by 1
    -- order by week desc
    )
    select * from total_txns

    Run a query to Download Data