DATETIME | TX_CNT | USER_CNT | |
|---|---|---|---|
1 | 2024-10-01 00:00:00.000 | 35239635 | 1263896 |
2 | 2024-07-01 00:00:00.000 | 45660823 | 2463210 |
3 | 2024-04-01 00:00:00.000 | 37154560 | 1916757 |
4 | 2024-01-01 00:00:00.000 | 29327283 | 715309 |
tkvresearchdisturbing-fuchsia
Updated 2024-12-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select datetime,
count(distinct tx_hash) as tx_cnt,
count(distinct address) as user_cnt
from
(select date_trunc('quarter',block_timestamp) as datetime,
tx_hash,
from_address as address
from mantle.core.fact_transactions
union all
select date_trunc('quarter',block_timestamp) as datetime,
tx_hash,
to_address as address
from mantle.core.fact_transactions)
where datetime >= '2024-01-01'
group by 1
Last run: 3 months ago
4
180B
15s