DAY | NEW DEPOSITORS | VOLUME | TOTAL NEW DEPOSITORS | |
|---|---|---|---|---|
1 | 2023-09-13 00:00:00.000 | 1069 | 534.235187967 | 102680 |
2 | 2023-11-13 00:00:00.000 | 744 | 88.134789046 | 134262 |
3 | 2023-10-25 00:00:00.000 | 373 | 157.931062683 | 124712 |
4 | 2023-10-20 00:00:00.000 | 691 | 176.094469537 | 122361 |
5 | 2023-08-12 00:00:00.000 | 3568 | 597.731665736 | 49424 |
6 | 2023-12-18 00:00:00.000 | 2248 | 747.080401677 | 181513 |
7 | 2024-01-11 00:00:00.000 | 967 | 558.352127152 | 209657 |
8 | 2023-12-29 00:00:00.000 | 1183 | 969.535858162 | 196921 |
9 | 2024-01-06 00:00:00.000 | 947 | 586.597000587 | 205190 |
10 | 2023-11-22 00:00:00.000 | 911 | 233.129698845 | 143043 |
11 | 2023-12-23 00:00:00.000 | 1193 | 821.227446025 | 190293 |
12 | 2023-12-10 00:00:00.000 | 1744 | 703.736442321 | 164590 |
13 | 2023-10-15 00:00:00.000 | 380 | 159.476326447 | 119895 |
14 | 2023-10-14 00:00:00.000 | 362 | 204.743058 | 119515 |
15 | 2024-01-14 00:00:00.000 | 1054 | 442.942761453 | 213181 |
16 | 2023-08-22 00:00:00.000 | 1872 | 475.858211166 | 75633 |
17 | 2023-10-08 00:00:00.000 | 370 | 164.103533 | 117605 |
18 | 2023-11-11 00:00:00.000 | 514 | 199.475948266 | 132831 |
19 | 2023-12-17 00:00:00.000 | 3300 | 841.573367149 | 179265 |
20 | 2023-10-11 00:00:00.000 | 262 | 93.852287 | 118556 |
0-MIDDepositors 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
›
⌄
with tab1 as (
select date_trunc('minute',BLOCK_TIMESTAMP) as time
,TO_ADDRESS
,ETH_VALUE
from base.core.fact_transactions
where FROM_ADDRESS in('0x80c67432656d59144ceff962e8faf8926599bcf8','0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0xd9d74a29307cc6fc8bf424ee4217f1a587fbc8dc')
),
tab2 as (
select date_trunc('day',time) as day
,TO_ADDRESS
,ETH_VALUE
,row_number()over(partition by TO_ADDRESS order by day) as times_row
from tab1)
select
day
,count(TO_ADDRESS) as "NEW DEPOSITORS"
,sum(ETH_VALUE) as volume
,sum("NEW DEPOSITORS")over(order by day) as "TOTAL NEW DEPOSITORS"
from tab2
where times_row=1
group by 1
Last run: about 1 year agoAuto-refreshes every 24 hours
...
184
9KB
125s