Date | Day Name | Transactions | LAG_TXS | TXs Change % | AUs | LAG_AUS | AUs Change % | Fees | LAG_FEES | Fees Change % | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-23 00:00:00.000 | Sun | 272525629 | 233124809 | 16.9 | 59537 | 55360 | 7.55 | 0.370326 | 0.40067 | -7.57 |
2 | 2025-03-22 00:00:00.000 | Sat | 233124809 | 229624856 | 1.52 | 55360 | 54538 | 1.51 | 0.40067 | 0.541577 | -26.02 |
3 | 2025-03-21 00:00:00.000 | Fri | 229624856 | 155860928 | 47.33 | 54538 | 49925 | 9.24 | 0.541577 | 0.559027 | -3.12 |
4 | 2025-03-20 00:00:00.000 | Thu | 155860928 | 155817816 | 0.03 | 49925 | 52553 | -5 | 0.559027 | 0.672503 | -16.87 |
5 | 2025-03-19 00:00:00.000 | Wed | 155817816 | 240897150 | -35.32 | 52553 | 56743 | -7.38 | 0.672503 | 0.791905 | -15.08 |
6 | 2025-03-18 00:00:00.000 | Tue | 240897150 | 264530758 | -8.93 | 56743 | 54834 | 3.48 | 0.791905 | 0.768148 | 3.09 |
7 | 2025-03-17 00:00:00.000 | Mon | 264530758 | 54834 | 0.768148 |
0xHaM-dDaily Repost over past week
Updated 2025-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
select
trunc(BLOCK_TIMESTAMP, 'day') as "Date",
dayname(BLOCK_TIMESTAMP::date) as "Day Name",
count(DISTINCT TX_ID) as "Transactions",
lag("Transactions") over (order by "Date") as lag_txs,
round(100*("Transactions"-lag_txs)/lag_txs,2) as "TXs Change %",
count(distinct SIGNERS[0]) as "AUs",
lag("AUs") over (order by "Date") as lag_AUs,
round(100*("AUs"-lag_AUs)/lag_AUs,2) as "AUs Change %",
sum(fee/1e9) as "Fees",
lag("Fees") over (order by "Date") as lag_fees,
round(100*("Fees"-lag_fees)/lag_fees,2) as "Fees Change %"
from eclipse.core.fact_transactions
where "Date" BETWEEN date_trunc(week, current_date())-7 AND date_trunc(week, current_date())-1
group by 1,2
order by 1 desc
Last run: 10 days ago
7
693B
968s