flipside

    fake_tokens
    oscarqfake_tokens
    Updated 2025-04-02
    WITH table_1 AS (
    SELECT
    creator_address,
    address AS contract_address,
    symbol,
    name,
    blockchain
    FROM
    crosschain.core.dim_contracts
    WHERE
    (
    symbol LIKE 'USDC%'
    OR symbol LIKE 'USDT%'
    OR symbol LIKE 'Tether%'
    OR symbol LIKE 'DAI%'
    OR symbol LIKE 'PYUSD%'
    OR symbol LIKE 'USDC%'
    OR symbol LIKE 'USDE%'
    OR name LIKE 'USDT%'
    OR name LIKE 'Tether%'
    OR name LIKE 'DAI%'
    OR name LIKE 'Paypal%'
    OR name LIKE 'Ethena%'
    )
    )
    SELECT
    DATE_TRUNC('month',tr.block_timestamp) AS reported_month,
    t1.creator_address,
    t1.contract_address,
    t1.name,
    t1.symbol,
    t1.blockchain AS blockchain,
    count(*) AS number_transfers,
    count(distinct tr.to_address) AS number_recipients
    FROM
    Last run: 2 months ago
    REPORTED_MONTH
    CREATOR_ADDRESS
    CONTRACT_ADDRESS
    NAME
    SYMBOL
    BLOCKCHAIN
    NUMBER_TRANSFERS
    NUMBER_RECIPIENTS
    1
    		2025-03-01 00:00:00.0000x2729dd71b39cc3f8e728a211794fcace21f71d660x584ed8c285382e18975d2690ef6653993f52668dTether USDUSDTethereum21
    2
    		2025-03-01 00:00:00.0000x0e4b0053183487e7c69457e582094e54ffc153b40xe9f11e08eda20510771dbbdbc08afd45420de27bTether USDUSDT͏⁠͏⁡bsc32
    3
    		2025-03-01 00:00:00.0000x138eb30f73bc423c6455c53df6d89cb01d9ebc630xe664fd3a278b1e49c20f9b0af77aa57dc770b21bUSDT-LPS*USDTbsc4917
    4
    		2025-03-01 00:00:00.0000x7c6e04b01b49a4a35ea11973abdc4e81910aa3cc0xf3372c192f5799e3308fa9cc1c5200390edd34cdUSDTUSDTbsc11
    5
    		2025-03-01 00:00:00.0000xdceb95fde52a8886c42514f3d300ceda6418469b0xb2894a18efa773eb3d5f0659a74fe0e474c6f454Tether USDUSDTethereum33
    6
    		2025-03-01 00:00:00.0000x7a91498d5fa6705d35c9406b752d6d50f49c95100x52d7e0a859d979997cb5a8f55f725b443d32a531USD CoinUSDCethereum11
    7
    		2025-03-01 00:00:00.0000x4f3b7c08e56390eb2b1037425a879a106c79733d0x53e45377dfdb0f68750faa88152e32cd1bfac160Degen AIDAIbase43
    8
    		2025-03-01 00:00:00.0000xf8bf882435f74825c170c1ce8e312dc688e95cc10x7db54758503c25200b331131c219acd64cfa74c8Classic USDCUSDCbsc44
    9
    		2025-03-01 00:00:00.0000xb84b1dea15c2fe94f131db58428a7451ea03c85b0x5fc6fee02e9fa09f7a49276476b0ee088430de2cTetherUSDTbsc44
    10
    		2025-03-01 00:00:00.0000xacf5d669dfe0325668ef9f6a9f785e94e0f3881c0x000af433a9e57f799324b93f5ab0525b951410aaTetherUSDTbsc22
    11
    		2025-03-01 00:00:00.0000x249887102ea0ba6caf12ef88fd66f367126e26540x5d5bfc0cd0d31d0e13cd0669cbb5ea4cfd312683Tether USDUSDT͏⁠bsc32
    12
    		2025-03-01 00:00:00.0000x5c6ce14b47761d9ba19a28cd10b8f1536a1234560x9ae4fedffba392b29bfd6e9cf4cd7387c01184b3Tether USDUSDTbsc11
    13
    		2025-03-01 00:00:00.0000x6d5cd07b1610c07c856529316b1824d1ce25c2c50xc4c161738c6ad1fd612af96b880066612104d1f6Tether USDUSDTethereum261237
    14
    		2025-03-01 00:00:00.0000x5e5a7b76462e4bdf83aa98795644281bdba80b880x7f74de3002a6af0ea698e317ed0fd77914100c32USDTUSDTethereum126
    15
    		2025-03-01 00:00:00.0000x2ac4442cccbfe7f75384b34ce61a16a89d36f2c10xe35a55c31a6b65c1492009b3e0af5085e13e727bTether USDUSDTethereum22
    16
    		2025-03-01 00:00:00.0000x3ee18b2214aff97000d974cf647e7c347e8fa5850x1cdd2eab61112697626f7b4bb0e23da4febf7b7cUSDTUSDTethereum22
    17
    		2025-03-01 00:00:00.0000xb02e44e316c652ce8302e33b3253ecc0ee8ae1dd0xeee3a430999e4921dd1604bacb0f8e9cdc69e719USDTBUSDTBbase11
    18
    		2025-03-01 00:00:00.0000x632165d93915df14f891be0e27227fb3b1fe26b10x271f38c5e8576fdfbde5285d7a8257ad5b6b9057UsdtthhjUSDTbsc11
    19
    		2025-03-01 00:00:00.0000x65b5ee6fb7319f0536d853606143a2cbd605a0850x82bdb063bc56ef25964bc991b5c99fb0a435a7f3Tether USDUSDTethereum22
    20
    		2025-03-01 00:00:00.0000x7a4aaea834574c3668440522efe409cd92edcc5c0x4ce3a1eb8e4147db2550ee8c1a9699796aa3a149Tether USDUSDTpolygon52
    ...
    237
    35KB
    25s