DATE | DAILY_PARTICIPANTS | RON_COLLECTED | TOTAL_TICKETS_BOUGHT | |
|---|---|---|---|---|
1 | 2025-02-13 00:00:00.000 | 1030 | 530950 | 10619 |
2 | 2025-02-14 00:00:00.000 | 488 | 223250 | 4465 |
3 | 2025-02-15 00:00:00.000 | 436 | 407100 | 8142 |
4 | 2025-02-16 00:00:00.000 | 662 | 945550 | 18911 |
permaryDaily Raffle activity
Updated 2025-02-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
date_trunc('day', block_timestamp) as date,
count(distinct from_address) as daily_participants,
sum(amount) as ron_collected,
sum(amount) / 50 as total_tickets_bought,
from ronin.core.ez_native_transfers
where to_address = '0xbe21424c284654c8b4b1d1b11e732bd1e654b3c4'
and block_timestamp >= '2025-02-13'
group by date
order by date;
Last run: 2 months ago
4
180B
3s