MLDZMNfee1
Updated 2023-11-25
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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