DATE | NEW_TOKENS | TOTAL_TOKENS | |
|---|---|---|---|
1 | 2024-11-27 00:00:00.000 | 111 | 4345 |
2 | 2024-11-26 00:00:00.000 | 765 | 4234 |
3 | 2024-11-25 00:00:00.000 | 497 | 3469 |
4 | 2024-11-24 00:00:00.000 | 468 | 2972 |
5 | 2024-11-23 00:00:00.000 | 287 | 2504 |
6 | 2024-11-22 00:00:00.000 | 131 | 2217 |
7 | 2024-11-21 00:00:00.000 | 321 | 2086 |
8 | 2024-11-20 00:00:00.000 | 239 | 1765 |
9 | 2024-11-19 00:00:00.000 | 23 | 1526 |
10 | 2024-11-17 00:00:00.000 | 20 | 1503 |
11 | 2024-11-16 00:00:00.000 | 111 | 1483 |
12 | 2024-11-15 00:00:00.000 | 401 | 1372 |
13 | 2024-11-14 00:00:00.000 | 226 | 971 |
14 | 2024-11-13 00:00:00.000 | 61 | 745 |
15 | 2024-11-12 00:00:00.000 | 33 | 684 |
16 | 2024-11-11 00:00:00.000 | 19 | 651 |
17 | 2024-11-10 00:00:00.000 | 223 | 632 |
18 | 2024-11-09 00:00:00.000 | 219 | 409 |
19 | 2024-11-08 00:00:00.000 | 134 | 190 |
20 | 2024-11-07 00:00:00.000 | 38 | 56 |
Flipside TeamClanker world
Updated 2024-11-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with tab1 as (
SELECT
DISTINCT tx_hash
FROM base.core.fact_transactions
where from_address in (lower('0xE0c959EeDcFD004952441Ea4FB4B8f5af424e74B'), lower('0xC204af95b0307162118f7Bc36a91c9717490AB69'))
AND STATUS like 'SUCCESS'
)
SELECT
date(block_timestamp) as date,
count(*) as new_tokens,
sum(new_tokens) over (order by date) as total_tokens
from base.core.fact_token_transfers
where tx_hash in (SELECT * from tab1)
and from_address like '0x0000000000000000000000000000000000000000'
GROUP BY 1
ORDER BY 1 DESC
Last run: about 1 month ago
21
760B
60s