Date | Name | Daily Transfer | Transfer Growth | |
|---|---|---|---|---|
1 | 2025-01-24 00:00:00.000 | SHROOMY | 156 | 156 |
2 | 2025-01-25 00:00:00.000 | SHROOMY | 139 | 295 |
3 | 2025-01-26 00:00:00.000 | SHROOMY | 69 | 364 |
4 | 2025-01-27 00:00:00.000 | SHROOMY | 195 | 559 |
5 | 2025-01-28 00:00:00.000 | SHROOMY | 223 | 782 |
6 | 2025-01-29 00:00:00.000 | SHROOMY | 108 | 890 |
7 | 2025-01-30 00:00:00.000 | SHROOMY | 212 | 1102 |
8 | 2025-01-31 00:00:00.000 | SHROOMY | 323 | 1425 |
9 | 2025-02-01 00:00:00.000 | SHROOMY | 352 | 1777 |
10 | 2025-02-02 00:00:00.000 | SHROOMY | 484 | 2261 |
11 | 2025-02-03 00:00:00.000 | SHROOMY | 561 | 2822 |
12 | 2025-02-04 00:00:00.000 | SHROOMY | 668 | 3490 |
13 | 2025-02-05 00:00:00.000 | SHROOMY | 787 | 4277 |
14 | 2025-02-06 00:00:00.000 | SHROOMY | 625 | 4902 |
15 | 2025-02-07 00:00:00.000 | SHROOMY | 441 | 5343 |
16 | 2025-02-08 00:00:00.000 | SHROOMY | 304 | 5647 |
17 | 2025-02-09 00:00:00.000 | SHROOMY | 329 | 5976 |
18 | 2025-02-10 00:00:00.000 | SHROOMY | 986 | 6962 |
19 | 2025-02-11 00:00:00.000 | SHROOMY | 2789 | 9751 |
20 | 2025-02-12 00:00:00.000 | SHROOMY | 1746 | 11497 |
LordkingSHROOMY
Updated 8 days ago
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
30
31
32
33
34
35
36
›
⌄
WITH contract_info AS (
SELECT * FROM (
VALUES
-- HIGH MC
('0x0c5e2d1c98cd265c751e02f8f3293bc5764f9111', 'SHROOMY', 'ShroomyProject')
) AS t (contract_address, token_name)
),
transfer AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
TX_HASH,
CONTRACT_ADDRESS
FROM ink.core.ez_token_transfers
WHERE CONTRACT_ADDRESS IN (SELECT lower(contract_address) FROM contract_info)
)
SELECT
t.day as "Date",
ci.token_name as "Name",
COUNT( t.TX_HASH) as "Daily Transfer",
SUM(COUNT( t.TX_HASH)) OVER (PARTITION BY t.CONTRACT_ADDRESS ORDER BY t.day) AS "Transfer Growth"
FROM transfer t
JOIN contract_info ci
ON lower(t.CONTRACT_ADDRESS) = lower(ci.contract_address)
GROUP BY t.day, ci.token_name, t.CONTRACT_ADDRESS
ORDER BY t.day, ci.token_name;
Last run: 8 days ago
44
2KB
1s