BaseTransfer
    Updated 2024-09-25

    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