bmorkaiTerra Transaction Fees Detail
    Updated 2021-11-10
    select
    -- tx_id,
    trader,
    swap_pair as "Swap Pair",
    -- token_0_currency,
    -- token_1_currency,
    token_0_amount_usd as "Trade Size USD",
    -- token_1_amount_usd,
    swap_fee_amount_usd as "Swap Fee USD"
    from terra.swaps
    --where block_timestamp > getdate() - interval '30 days'
    where date_trunc('day', block_timestamp) = '2021-06-03T00:00:00Z'
    order by swap_fee_amount_usd desc
    limit 3
    Run a query to Download Data