DATE | FABLEBORNE | TX_COUNT | USER_COUNT | FEES | |
|---|---|---|---|---|---|
1 | 2024-10-14 00:00:00.000 | Before | 1129923 | 836708 | 1771.43472657 |
2 | 2025-02-16 00:00:00.000 | After | 983141 | 573107 | 2463.051544861 |
3 | 2024-12-19 00:00:00.000 | After | 1241684 | 795765 | 2659.222415624 |
4 | 2025-02-21 00:00:00.000 | After | 694739 | 496994 | 1645.968075518 |
5 | 2025-01-02 00:00:00.000 | After | 939957 | 604106 | 1694.160932765 |
6 | 2025-02-01 00:00:00.000 | After | 965422 | 633908 | 2216.15772247 |
7 | 2024-11-23 00:00:00.000 | After | 1567439 | 1101710 | 3527.179802754 |
8 | 2025-01-30 00:00:00.000 | After | 1057826 | 592838 | 3142.976400003 |
9 | 2024-11-17 00:00:00.000 | After | 1229954 | 944351 | 2404.101339531 |
10 | 2024-11-15 00:00:00.000 | After | 1152862 | 888755 | 2385.015573376 |
11 | 2024-12-27 00:00:00.000 | After | 1172082 | 781402 | 2386.167965549 |
12 | 2024-12-29 00:00:00.000 | After | 1092374 | 709607 | 1935.587999698 |
13 | 2024-10-22 00:00:00.000 | Before | 1185966 | 902500 | 2213.08830586 |
14 | 2025-01-08 00:00:00.000 | After | 973094 | 591578 | 1854.998537715 |
15 | 2024-12-26 00:00:00.000 | After | 1110914 | 711118 | 2216.33663541 |
16 | 2024-11-18 00:00:00.000 | After | 1243448 | 936608 | 2681.349144444 |
17 | 2024-12-06 00:00:00.000 | After | 2518446 | 1157206 | 3844.028609375 |
18 | 2024-10-11 00:00:00.000 | Before | 1078173 | 851884 | 1828.312572209 |
19 | 2025-01-25 00:00:00.000 | After | 1203778 | 654149 | 3090.979323067 |
20 | 2025-01-09 00:00:00.000 | After | 1056049 | 723978 | 2041.884620282 |
elsinaDaily amount
Updated 2025-02-21
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: 28 days ago
...
144
9KB
14s