txns -- avg(tx_fee) copy

messari txns -- avg(tx_fee) copy

Updated 3 days ago

-- forked from BlockTracker / txns -- avg(tx_fee) @ https://flipsidecrypto.xyz/BlockTracker/q/kpGB32Sl5HlD/txns----avg-tx_fee

select

date_trunc('{{granularity}}', BLOCK_TIMESTAMP) as date,

count(distinct tx_hash) as n_transaction,

sum(n_transaction) over (order by date) as total_txns,

-- count(distinct case when TX_SUCCEEDED = 'TRUE' then tx_hash end ) as succeed_txns,

-- sum(succeed_txns) over (order by date) as total_succeed_txns,

-- count(distinct case when TX_SUCCEEDED <> 'TRUE' then tx_hash end ) as Failed_txns,

-- sum(Failed_txns) over (order by date) as Failed_txns_txns,

-- succeed_txns / (succeed_txns + Failed_txns) as success_rate,

count(distinct from_address) as n_active_users

-- sum(tx_fee) as fee,

-- sum(fee) over (order by date) as total_fee_mon,

-- avg(tx_fee) as avg_tx_fee,

-- median(tx_fee) as median_tx_fee

from monad.testnet.fact_transactions

group by 1

order by date

Last run: 3 days ago

	DATE	N_TRANSACTION	TOTAL_TXNS	N_ACTIVE_USERS
1	2025-01-07 00:00:00.000	1169	1169	8
2	2025-01-08 00:00:00.000	2972	4141	25
3	2025-01-09 00:00:00.000	18197	22338	37
4	2025-01-10 00:00:00.000	2121	24459	39
5	2025-01-11 00:00:00.000	208	24667	18
6	2025-01-12 00:00:00.000	218	24885	15
7	2025-01-13 00:00:00.000	2085	26970	55
8	2025-01-14 00:00:00.000	2760	29730	49
9	2025-01-15 00:00:00.000	6615	36345	68
10	2025-01-16 00:00:00.000	4717	41062	86
11	2025-01-17 00:00:00.000	2484	43546	94
12	2025-01-18 00:00:00.000	447	43993	30
13	2025-01-19 00:00:00.000	2816	46809	142
14	2025-01-20 00:00:00.000	989	47798	223
15	2025-01-21 00:00:00.000	5522	53320	78
16	2025-01-22 00:00:00.000	2761	56081	77
17	2025-01-23 00:00:00.000	2191	58272	119
18	2025-01-24 00:00:00.000	14555064	14613336	2138
19	2025-01-25 00:00:00.000	486	14613822	41
20	2025-01-26 00:00:00.000	1202	14615024	39

4KB

45s