DATETIME | TX_CNT | TOKEN_CNT | CREATOR_CNT | CUMSUM_TX_CNT | CUMSUM_TOKEN_CNT | CUMSUM_CREATOR_CNT | |
|---|---|---|---|---|---|---|---|
1 | 2024-07-20 00:00:00.000 | 4 | 4 | 4 | 125 | 125 | 106 |
2 | 2024-08-14 00:00:00.000 | 4 | 4 | 4 | 182 | 182 | 160 |
3 | 2024-08-05 00:00:00.000 | 2 | 2 | 2 | 173 | 173 | 151 |
4 | 2024-07-07 00:00:00.000 | 2 | 2 | 1 | 88 | 88 | 72 |
5 | 2024-08-28 00:00:00.000 | 91 | 91 | 75 | 4188 | 4188 | 3236 |
6 | 2024-07-02 00:00:00.000 | 4 | 4 | 3 | 8 | 8 | 6 |
7 | 2024-07-03 00:00:00.000 | 66 | 66 | 54 | 74 | 74 | 60 |
8 | 2024-08-22 00:00:00.000 | 1672 | 1672 | 1203 | 2998 | 2998 | 2260 |
9 | 2024-07-05 00:00:00.000 | 1 | 1 | 1 | 84 | 84 | 69 |
10 | 2024-07-10 00:00:00.000 | 1 | 1 | 1 | 90 | 90 | 74 |
11 | 2024-07-22 00:00:00.000 | 8 | 8 | 7 | 135 | 135 | 115 |
12 | 2024-07-26 00:00:00.000 | 3 | 3 | 3 | 149 | 149 | 129 |
13 | 2024-08-25 00:00:00.000 | 175 | 175 | 133 | 3855 | 3855 | 2953 |
14 | 2024-07-15 00:00:00.000 | 9 | 9 | 7 | 100 | 100 | 82 |
15 | 2024-08-15 00:00:00.000 | 2 | 2 | 2 | 184 | 184 | 162 |
16 | 2024-07-16 00:00:00.000 | 5 | 5 | 5 | 105 | 105 | 87 |
17 | 2024-08-11 00:00:00.000 | 1 | 1 | 1 | 178 | 178 | 156 |
18 | 2024-08-31 00:00:00.000 | 39 | 39 | 35 | 4401 | 4401 | 3415 |
19 | 2024-08-02 00:00:00.000 | 2 | 2 | 2 | 167 | 167 | 147 |
20 | 2024-07-18 00:00:00.000 | 3 | 3 | 3 | 111 | 111 | 93 |
tkvresearchbetter-amber
Updated 2025-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
--0x9b911b5e (create_token_function)
select datetime,
count(distinct tx_hash) as tx_cnt,
count(distinct CONTRACT_ADDRESS) as token_cnt,
count(distinct TO_ADDRESS) as creator_cnt,
sum(count(distinct tx_hash)) over (order by datetime) as cumsum_tx_cnt,
sum(count(distinct CONTRACT_ADDRESS)) over (order by datetime) as cumsum_token_cnt,
sum(count(distinct TO_ADDRESS)) over (order by datetime) as cumsum_creator_cnt
from
(select date(BLOCK_TIMESTAMP) as datetime,
TX_HASH,
CONTRACT_ADDRESS,
TO_ADDRESS
from bsc.core.ez_token_transfers
where ORIGIN_FUNCTION_SIGNATURE = '0x470d871e'
and
to_address != '0xec4549cadce5da21df6e6422d448034b5233bfbc'
)
group by 1
Last run: 3 months ago
55
3KB
4s