messarisolana_fee_payers copy
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
-- forked from solana_fee_payers @ https://flipsidecrypto.xyz/edit/queries/34996e52-7bb7-4cb9-aeb3-bca3fc6167d4
select
date(block_timestamp) as date,
count(distinct tx_id) as txs,
count(distinct signers[0]) as unique_fee_payers,
sum(fee/pow(10,9)) as total_tx_fees_sol
from solana.core.fact_transactions
group by date
order by date DESC
Run a query to Download Data