DAY | NEW WITHDRAWERS | VOLUME | TOTAL NEW WITHDRAWERS | |
|---|---|---|---|---|
1 | 2023-12-29 00:00:00.000 | 985 | 230.717145068 | 163702 |
2 | 2023-08-12 00:00:00.000 | 1735 | 428.852362761 | 14929 |
3 | 2023-12-18 00:00:00.000 | 2760 | 469.60588371 | 147114 |
4 | 2024-01-06 00:00:00.000 | 953 | 160.313287027 | 170971 |
5 | 2024-01-11 00:00:00.000 | 749 | 119.694301128 | 174650 |
6 | 2023-10-25 00:00:00.000 | 527 | 124.802701151 | 74356 |
7 | 2023-09-13 00:00:00.000 | 693 | 108.899579 | 52882 |
8 | 2023-10-20 00:00:00.000 | 485 | 109.123309892 | 71970 |
9 | 2023-11-22 00:00:00.000 | 1463 | 332.198569765 | 99757 |
10 | 2023-10-15 00:00:00.000 | 399 | 153.150755 | 69479 |
11 | 2023-12-10 00:00:00.000 | 2087 | 277.793162866 | 126746 |
12 | 2023-12-23 00:00:00.000 | 1425 | 226.585976695 | 155428 |
13 | 2023-11-13 00:00:00.000 | 355 | 67.907430171 | 85558 |
14 | 2023-10-14 00:00:00.000 | 433 | 150.084413 | 69080 |
15 | 2023-08-11 00:00:00.000 | 2127 | 549.891018 | 13194 |
16 | 2023-11-23 00:00:00.000 | 1101 | 169.765582538 | 100858 |
17 | 2023-10-02 00:00:00.000 | 490 | 152.257299726 | 64429 |
18 | 2024-01-12 00:00:00.000 | 955 | 115.188147703 | 175605 |
19 | 2023-11-12 00:00:00.000 | 428 | 86.21703121 | 85203 |
20 | 2023-10-03 00:00:00.000 | 489 | 140.912391828 | 64918 |
0-MIDwithdrawers new
Updated 2024-01-29
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
25
26
27
28
29
›
⌄
with tab1 as (
select date_trunc('minute',BLOCK_TIMESTAMP) as time
,FROM_ADDRESS
,ETH_VALUE
from base.core.fact_transactions
where TO_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
),
tab2 as (
select date_trunc('day',time) as day
,FROM_ADDRESS
,ETH_VALUE
,row_number()over(partition by FROM_ADDRESS order by day) as times_row
from tab1)
select
day
,count(FROM_ADDRESS) as "NEW WITHDRAWERS"
,sum(ETH_VALUE) as volume
,sum("NEW WITHDRAWERS")over(order by day) as "TOTAL NEW WITHDRAWERS"
from tab2
where times_row=1
group by 1
Last run: about 1 year agoAuto-refreshes every 24 hours
...
183
9KB
10s