flipside

    Top 5 Memecoins Based on the Swap Count
    Eman-RazTop 5 Memecoins Based on the Swap Count
    Updated 2023-06-07
    WITH TAB1 AS (select SYMBOL_IN AS symbol_in, count(distinct tx_hash) as selling_count,
    sum(amount_in_usd) as selling_volume_usd, count(distinct origin_from_address) as seller_count,
    avg(amount_in_usd) as avg_selling_vol_usd
    from ethereum.core.ez_dex_swaps
    where BLOCK_TIMESTAMP::DATE>='2023-04-01' and platform in ('uniswap-v2','uniswap-v3') AND
    token_in in ('0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce', -- SHIB
    '0x6982508145454ce325ddbe47a25d4ec3d2311933', --PEPE
    '0xcf0c122c6b73ff809c693db761e7baebe62b6a2e', --FLOKI
    '0xac57de9c1a09fec648e93eb98875b212db0d460b', --BABYDOGE
    '0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3', --ELON
    '0xc5fb36dd2fb59d3b98deff88425a3f425ee469ed', --TSUKA
    '0x7f792db54b0e580cdc755178443f0430cf799aca', --VOLT
    '0x27c70cd1946795b66be9d954418546998b546634', --LEASH
    '0xa2b4c0af19cc16a6cfacce81f192b024d625817d', --KISHU
    '0x6bc40d4099f9057b23af309c08d935b890d7adc0', --SNAIL
    '0x12970e6868f88f6557b76120662c1b3e50a646bf', --LADYS
    '0xa71d0588eaf47f12b13cf8ec750430d21df04974', --QOM
    '0x7d8146cf21e8d7cbe46054e01588207b51198729', --BOB
    '0x1151cb3d861920e07a38e03eead12c32178567f6', --BONK
    '0x12b6893ce26ea6341919fe289212ef77e51688c8', --TAMA
    '0xd8fa690304d2b2824d918c0c7376e2823704557a', --SQUIDGROW
    '0xf05897cfe3ce9bbbfe0751cbe6b1b2c686848dcb', --CATE
    '0x49642110b712c1fd7261bc074105e9e44676c68f', --DINO
    '0xa35923162c49cf95e6bf26623385eb431ad920d3', --TURBO
    '0xafcdd4f666c84fed1d8bd825aa762e3714f652c9', --VINU
    '0x5026f006b85729a8b14553fae6af249ad16c9aab', --WOJAK
    '0xbaac2b4491727d78d2b78815144570b9f2fe8899', --DOG
    '0xfad45e47083e4607302aa43c65fb3106f1cd7607', --HOGE
    '0xe20b9e246db5a0d21bf9209e4858bc9a3ff7a034', --BAN
    '0xf3a3023e6dede84ad88a656a3269f2a36e83c9a9', --SHARBI
    '0x8db4beaccd1698892821a9a0dc367792c0cb9940', --4TOKEN
    '0x6bf765c43030387a983f429c1438e9d2025b7e12', --PEPES
    '0xfb130d93e49dca13264344966a611dc79a456bc5', --DOGEGF
    '0xe1590a6fa0cff9c960181cb77d8a873601772f64', --WSB
    '0x244b797d622d4dee8b188b03546acaabd0cf91a0', --FOUR
    '0x2c5bc2ba3614fd27fcc7022ea71d9172e2632c16', --SOV
    Run a query to Download Data