BaseTransfer
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
-- MEDIUM MC
('0x8853F0c059C27527d33D02378E5E4F6d5afB574a', ' AIINU' ),
('0x15aC90165f8B45A80534228BdCB124A011F62Fee', ' MEOW' ),
('0x0d97F261b1e88845184f678e2d1e7a98D9FD38dE', ' TYBG' ),
('0x4dd9077269dd08899f2a9e73507125962b5bc87f', ' CRASH' ),
('0x6Bc40d4099f9057b23aF309C08d935b890d7Adc0', ' SNAIL' ),
('0xcdE172dc5ffC46D228838446c57C1227e0B82049', ' BOOMER' ),
('0x0578d8a44db98b23bf096a382e016e29a5ce0ffe', ' HIGHER' ),
('0x70737489DFDf1A29b7584d40500d3561bD4Fe196', ' BORED' ),
('0x698DC45e4F10966f6D1D98e3bFd7071d8144C233', ' PEPE' ),
('0x55027a5b06f4340cC4C82DCC74C90cA93dcb173E', ' TADPOLE' ),
('0x1b6A569DD61EdCe3C383f6D565e2f79Ec3a12980', ' PEEZY' ),
('0x9A86980D3625b4A6E69D8a4606D51cbc019e2002', ' FOMO' ),
('0xeD899bfDB28c8ad65307Fa40f4acAB113AE2E14c', ' ROOST' ),
('0x3c281a39944a2319aa653d81cfd93ca10983d234', ' BUILD' ),
('0x57f5fbd3de65dfc0bd3630f732969e5fb97e6d37', ' TRUMP' ),
('0x88Faea256f789F8dD50dE54F9C807eEf24f71b16', ' WOLF' ),
('0x51B75da3Da2e413eA1B8eD3Eb078dc712304761C', ' MOBY' ),
('0x38d513Ec43ddA20f323f26c7bef74c5cF80b6477', ' CARLO' ),
('0x13741C5dF9aB03E7Aa9Fb3Bf1f714551dD5A5F8a', ' NOGS' ),
('0x42069de48741db40aef864f8764432bbccbd0b69', ' BETS' ),
('0x85e90a5430af45776548adb82ee4cd9e33b08077', ' DINO' )
) AS t (contract_address, token_name)
),
transfer AS (
SELECT
TX_HASH,
CONTRACT_ADDRESS
FROM base.core.fact_token_transfers
QueryRunArchived: QueryRun has been archived