MLDZMNfee1
    Updated 2023-11-25
    select
    date_trunc('{{Time_basis}}',BLOCK_TIMESTAMP) as date,
    count(*) as no_sent,
    sum(amount) as fee,
    avg(amount) as average_fee,
    sum(fee) over (order by date) as "Total Fee"
    from solana.core.fact_transfers
    where BLOCK_TIMESTAMP >= current_date-{{Days_back}}
    and TX_TO='9BPbqZBJTaP6hRwCbz738GMYgTJ6RsNqDJFtXgmzPoT3'
    and mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    group by 1
    Run a query to Download Data