mo115Fees in last 24 hours
    Updated 2024-03-20
    -- forked from # transactions + Fees * @ https://flipsidecrypto.xyz/edit/queries/80cae284-52f9-4a15-9fca-74e868a16ef2

    -- forked from # transactions @ https://flipsidecrypto.xyz/edit/queries/d7daa758-cc9a-4064-986c-4603dbacc4dd
    with fees as(
    select
    BLOCK_TIMESTAMP_HOUR, TOTAL_FEES_NATIVE/1e9 as Fees
    from solana.stats.ez_core_metrics_hourly
    order by BLOCK_TIMESTAMP_HOUR DESC
    limit 24)
    select sum(Fees) as "Fees (SOL)"
    from fees