BaseDaily Transfers
Updated 2024-09-25
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
-- micro mc UNDER 200K MC
('0x0002BcDaf53f4889BF2f43A3252d7c03Fe1b80bc', ' GORPLE' ),
('0x7480527815ccAE421400Da01E052b120Cc4255E9', ' WORKIE' ),
('0xC48E605c7b722a57277e087a6170B9E227e5AC0A', ' OMNI' ),
('0x48164eA5Df090E80a0eAeE1147e466Ea28669221', ' MOB' ),
('0x72cCF64EE5E2C7629eE4eEe3e6AD6990289178ae', ' VINU' ),
('0x48164eA5Df090E80a0eAeE1147e466Ea28669221', ' MARVIN' ),
('0xe095780bA2A64a4Efa7a74830F0b71656f0b0AD4', ' BYTE' ),
('0xC7DcCA0a3e69bD762C8DB257f868f76Be36c8514', ' KIBSHI' ),
('0x803b629C339941e2b77D2dC499DAc9e1fD9eAC66', ' EARN' ),
('0xA067436Db77aB18b1a315095E4b816791609897c', ' WASSIE' ),
('0x2ad3d80c917ddBf08aCc04277f379e00e4D75395', ' COW'),
('0xdb08CA267e824fb29eb455B7e06Fe73FB0370895', ' GODCAT'),
('0x76Baa16FF15D61d32E6B3576c3a8C83A25C2F180', ' PLEB'),
('0x1804e3Db872eed4141E482fF74C56862f2791103', ' RIKE'),
('0xFd008f937B4d73EEb00Cf74CE90c392be5f07F96', ' MOON'),
('0xb043BaD01195700e737D0AEE852584eAE9393134', ' FLOWER'),
('0xD1dB4851bcF5B41442cAA32025Ce0Afe6B8EabC2', ' ZOOMER'),
('0xfB18511F1590a494360069F3640c27d55c2B5290', ' WGC'),
('0xc9b6eF062Fab19D3F1eABc36b1f2E852AF1Acd18', ' BALT'),
('0x6223901eA64608c75Da8497d5eff15D19A1D8fd5', ' CORGI')
) AS t (contract_address, token_name)
),
transfer AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
TX_HASH,
QueryRunArchived: QueryRun has been archived