DATE_DAY | USER_COUNT | HOLDER_TYPE | |
|---|---|---|---|
1 | 2025-01-24 00:00:00.000 | 116 | left >50% |
2 | 2025-01-25 00:00:00.000 | 98 | left <50% |
3 | 2025-02-14 00:00:00.000 | 184 | left <50% |
4 | 2025-02-15 00:00:00.000 | 10 | no change |
5 | 2025-01-16 00:00:00.000 | 16 | left none |
6 | 2025-01-22 00:00:00.000 | 64 | left <50% |
7 | 2025-02-13 00:00:00.000 | 185 | left <50% |
8 | 2025-01-28 00:00:00.000 | 47 | increased |
9 | 2025-01-31 00:00:00.000 | 100 | left >50% |
10 | 2025-02-15 00:00:00.000 | 190 | left <50% |
11 | 2025-01-23 00:00:00.000 | 40 | left none |
12 | 2025-01-27 00:00:00.000 | 54 | left none |
13 | 2025-01-31 00:00:00.000 | 32 | no change |
14 | 2025-01-21 00:00:00.000 | 36 | left none |
15 | 2025-01-19 00:00:00.000 | 77 | no change |
16 | 2025-02-11 00:00:00.000 | 16 | no change |
17 | 2025-02-01 00:00:00.000 | 46 | increased |
18 | 2025-01-20 00:00:00.000 | 63 | left <50% |
19 | 2025-02-02 00:00:00.000 | 30 | no change |
20 | 2025-02-13 00:00:00.000 | 12 | no change |
winnie-fsket yeeters copy
Updated 2025-02-18
999
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
30
31
32
33
34
35
36
›
⌄
-- forked from cloudr3n / ket yeeters @ https://flipsidecrypto.xyz/cloudr3n/q/mE8R8aIqw0Rp/ket-yeeters
-- identify airdrop tx
with
initial_airdrop as (
select
block_timestamp,
to_address as user_address,
amount -- as initial_amount
from
avalanche.core.ez_token_transfers
where
1=1
and contract_address = '0xffff003a6bad9b743d658048742935fffe2b6ed7'
and from_address = '0xb64292e86990184381b1c117d6edf1cbd3d0ef73'
and block_timestamp = '2025-01-15 16:24:00.000'
),
date_ls as (
select
date_day
from
ethereum.core.dim_dates
where
date_day>='2025-01-15'
and date_day <= current_date()
),
user_date_ls as (
select
date_day,
user_address,
amount as initial_amount
from
date_ls
cross join
Last run: about 1 month ago
...
175
7KB
3s