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
-- HIGH MC
('0x532f27101965dd16442e59d40670faf5ebb142e4', '$BRETT'),
('0x4ed4e862860bed51a9570b96d89af5e1b0efefed', '$DEGEN'),
('0x4da78059d97f155e18b37765e2e042270f4e0fc4', '$WUF'),
('0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4', '$TOSHI'),
('0x5d559ea7bb2dae4b694a079cb8328a2145fd32f6', '$OWO'),
('0xb1a03eda10342529bbf8eb700a06c60441fef25d', '$MIGGLES'),
('0xBC45647eA894030a4E9801Ec03479739FA2485F0', '$BENJI'),
('0x689644b86075ed61c647596862c7403e1c474dbf', '$BAMBOO'),
('0x2598c30330D5771AE9F983979209486aE26dE875', '$AI'),
('0x6b9bb36519538e0C073894E964E90172E1c0B41F', '$WEWE'),
('0xE3086852A4B125803C815a158249ae468A3254Ca', '$MFER'),
('0x9a26F5433671751C3276a065f57e5a02D2817973', '$KEYCAT'),
('0xF6e932Ca12afa26665dC4dDE7e27be02A7c02e50', '$MOCHI'),
('0xebfF2db643Cf955247339c8c6bCD8406308ca437', '$CHOMP'),
('0x18a8bd1fe17a1bb9ffb39ecd83e9489cfd17a022', '$ANDY'),
('0x2da56acb9ea78330f947bd57c54119debda7af71', '$Mog'),
('0x6921B130D297cc43754afba22e5EAc0FBf8Db75b', '$DOGINME'),
('0x47b464eDB8Dc9BC67b5CD4C9310BB87b773845bD', '$NORMIE'),
('0xb8D98a102b0079B69FFbc760C8d857A31653e56e', '$TOBY'),
('0x6d3B8C76c5396642960243Febf736C6BE8b60562', '$SKOP'),
('0xb166e8b140d35d9d8226e40c09f757bac5a4d87d', '$NPC')
) AS t (contract_address, token_name)
),
transfer AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
TX_HASH,
CONTRACT_ADDRESS
FROM base.core.fact_token_transfers
QueryRunArchived: QueryRun has been archived