DAY | PURCHASERS | PURCHASES | PURCHASE_VOLUME | TICKET_AMOUNT | |
|---|---|---|---|---|---|
1 | 2025-02-16 00:00:00.000 | 882 | 1057 | 1311900 | 26238 |
2 | 2025-02-14 00:00:00.000 | 487 | 540 | 221550 | 4431 |
3 | 2025-02-17 00:00:00.000 | 2900 | 4455 | 12720650 | 254413 |
4 | 2025-02-13 00:00:00.000 | 1029 | 1208 | 493850 | 9877 |
5 | 2025-02-15 00:00:00.000 | 435 | 512 | 390550 | 7811 |
0-MIDhourly stats
Updated 2025-02-18
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select date_trunc('day',BLOCK_TIMESTAMP) as day
,count(distinct FROM_ADDRESS) as purchasers
,count(distinct TX_HASH) as purchases
,sum(VALUE) as purchase_volume
,(sum(VALUE)/50) as ticket_amount
from ronin.core.fact_transactions
where TO_ADDRESS='0xbe21424c284654c8b4b1d1b11e732bd1e654b3c4'
and ORIGIN_FUNCTION_SIGNATURE='0xf1151e76'
group by 1
Last run: 28 days ago
5
252B
3s