LTirrellmedian sol fee and 95% copy
Updated 2023-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with ()
select
date(block_timestamp) as date,
count(distinct tx_id) as txs,
sum(fee * POWER(10, -8)) as total_fees_paid,
(total_fees_paid / txs) as fee_per_tx,
percentile_cont(0.5) WITHIN GROUP (
ORDER BY
(fee * POWER(10, -8))
) OVER () AS median_fee_sol,
percentile_cont(0.95) WITHIN GROUP (
ORDER BY
(fee * POWER(10, -8))
) OVER () AS p95_fee_sol
from
solana.core.fact_transactions
where
date(block_timestamp) between current_date() -61
and current_date() -1
group by
1
Run a query to Download Data