DATE | FABLEBORNE | TX_COUNT | USER_COUNT | FEES | |
|---|---|---|---|---|---|
1 | 2025-01-30 00:00:00.000 | After | 1057826 | 592838 | 3142.976400003 |
2 | 2024-11-23 00:00:00.000 | After | 1567439 | 1101710 | 3527.179802754 |
3 | 2025-01-27 00:00:00.000 | After | 1148347 | 646640 | 2960.351444513 |
4 | 2024-10-06 00:00:00.000 | Before | 1638601 | 1216466 | 2305.870281705 |
5 | 2024-10-27 00:00:00.000 | Before | 1340495 | 1071857 | 2087.331394328 |
6 | 2024-12-13 00:00:00.000 | After | 1169702 | 806335 | 2512.265502302 |
7 | 2025-03-08 00:00:00.000 | After | 975908 | 541591 | 2430.8807385 |
8 | 2024-10-13 00:00:00.000 | Before | 1117774 | 869309 | 1793.726781969 |
9 | 2024-10-31 00:00:00.000 | Before | 1110949 | 769218 | 1846.587444028 |
10 | 2024-12-09 00:00:00.000 | After | 1833600 | 1137194 | 3494.357649353 |
11 | 2024-12-23 00:00:00.000 | After | 1172940 | 748701 | 2263.404834757 |
12 | 2025-02-20 00:00:00.000 | After | 1110620 | 636592 | 3462.155397166 |
13 | 2025-03-17 00:00:00.000 | After | 789640 | 476773 | 1600.25813088 |
14 | 2025-01-24 00:00:00.000 | After | 1116473 | 653322 | 2998.961017103 |
15 | 2024-12-03 00:00:00.000 | After | 2431617 | 1344141 | 4437.740113241 |
16 | 2025-02-24 00:00:00.000 | After | 928478 | 591858 | 2664.800636359 |
17 | 2025-02-17 00:00:00.000 | After | 966124 | 594292 | 2640.03460857 |
18 | 2025-03-16 00:00:00.000 | After | 776321 | 504789 | 1642.105525172 |
19 | 2024-10-18 00:00:00.000 | Before | 1163440 | 915546 | 1888.227475721 |
20 | 2024-11-14 00:00:00.000 | After | 1267261 | 905360 | 2659.441543933 |
elsinaDaily amount
Updated 1 hour ago
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc('day', block_timestamp) as date,
case
when date < '2024-11-13' then 'Before'
else 'After' end as Fableborne,
count(distinct tx_hash) as tx_count,
count(distinct from_address) as user_count,
sum(tx_fee) as fees
from ronin.core.fact_transactions
group by 1, 2
Last run: about 1 hour ago
...
174
11KB
17s