date(block_timestamp) as date,

count(distinct tx_id) as txs,

sum(fee) * POWER(10,-9) as total_fees_paid,

(total_fees_paid / txs) as "Average",

APPROX_PERCENTILE(fee, .99) * POWER(10,-9) as "99th percentile",

APPROX_PERCENTILE(fee, .95) * POWER(10,-9) as "95th percentile",

APPROX_PERCENTILE(fee, .50) * POWER(10,-9) as "Median"

from

solana.core.fact_transactions

where

date(block_timestamp) between current_date() -61

and current_date() -1

group by

1

order by date desc