flipside

    sushi_new_tokens copy
    tomingsushi_new_tokens copy
    Updated 2024-02-06
    -- forked from maybeyonas / sushi_new_tokens @ https://flipsidecrypto.xyz/maybeyonas/q/Km8IVLy9fbYJ/sushi_new_tokens

    with
    new_tokens as (
    select
    token_out,
    -- first_value(platform),
    min(block_timestamp) as first_swap
    from ethereum.defi.ez_dex_swaps
    --where platform = 'uniswap-v3'
    group by 1
    order by first_swap desc
    limit 100
    )

    select symbol_out, ethereum.defi.ez_dex_swaps.token_out, block_number, block_timestamp, platform, tx_hash
    from ethereum.defi.ez_dex_swaps
    inner join new_tokens
    ON ethereum.defi.ez_dex_swaps.block_timestamp=new_tokens.first_swap
    and ethereum.defi.ez_dex_swaps.token_out = new_tokens.token_out





    Last run: over 1 year ago
    SYMBOL_OUT
    TOKEN_OUT
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    PLATFORM
    TX_HASH
    1
    		SHARK0xbbdfb09b487ead48cf38314733faed7b67962cb7191641472024-02-05 19:29:47.000uniswap-v20xbf2a9ff52697dbef88d267905b12d37285bbbe2399efec2c7cd0a021ee2febc5
    2
    		ELONDRUGS0xd7a887f962e92272ecf5d139d43a6e67b31b2c88191650832024-02-05 22:38:35.000uniswap-v20x87a6c98344a9e2ae92510dc421b80181d8d70da8303b270c5722d0a333c0195c
    3
    		COGNI0x6e7d3433ab7fe07227ead895c496b7ca8eb4f76d191651322024-02-05 22:48:23.000uniswap-v20x8ad4a00922dfbba8d12d2413fb016d1e7f563aee8c8c6cead941ba1fa76381ae
    4
    		中本聪0x221d32c7002fa1453ce8d7f687c8d527f9984664191652292024-02-05 23:07:47.000uniswap-v20xa8cfee36b4a35fd9444bef582c3cb49356a163b7110c5bb4755144523d820f66
    5
    		XRP0x14f42d9098075a2eb19afea74209717d33bed96e191648142024-02-05 21:44:11.000uniswap-v20x4c8448eef60df5f03199ab5b01078b863cd0af90ef4819955d997be75df14d3c
    6
    		PORKSY0x8cde2fbebc9347c6b6c98a5dc7517f25eeebeabd191653862024-02-05 23:39:11.000uniswap-v20xb2f2b04b0a27548af1dc72a76e593cc351b0218d771c0293b1dc73cdab6a042e
    7
    		中本聪0x221d32c7002fa1453ce8d7f687c8d527f9984664191652292024-02-05 23:07:47.000uniswap-v20x57bc7dd01dd41d0077a5f9047f7e5c833f78aa5b2ffb825d86437b91c5a2ff8d
    8
    		Old Pepe0x9bd7e77a96494407b2ea4f95cd97f3cdb6079a4f191647342024-02-05 21:28:11.000uniswap-v30x3c1513c592e419366c03e9bd884eebf5d0b750155d247db5e31b85ee37e157b5
    9
    		SHARK0xbbdfb09b487ead48cf38314733faed7b67962cb7191641472024-02-05 19:29:47.000uniswap-v20x46f562a92bc5b40018659019e92ee849f6e9e39d374c46b035f5cf4aee53d074
    10
    		DONMUSK0x0e8ff703514f7e851148253809dc63e5afcdb05a191647142024-02-05 21:24:11.000uniswap-v20x70d4e10f02bab024ffb5ee3826a832b29b5742f3f21dc7387524a3d84b73eb2b
    11
    		DONMUSK0x0e8ff703514f7e851148253809dc63e5afcdb05a191647142024-02-05 21:24:11.000uniswap-v20xb2fd06b22caeee7638a17022ad1adba640ec7ff6055d0b3605d0bedeed1be002
    12
    		BLINK0x3a5c867277a84bf5df6b470886963034b379d7d2191641862024-02-05 19:37:35.000uniswap-v20xd9156cbd562a15884da522d9f76727fdf21a60a3f6cac4ae4016b59717c643f2
    13
    		SHARK0xbbdfb09b487ead48cf38314733faed7b67962cb7191641472024-02-05 19:29:47.000uniswap-v20x0697c200eeb3a4c3723b9e45a8c39b13bb1cc06a2ea3994ece4a27569ba9123c
    14
    		DONMUSK0x0e8ff703514f7e851148253809dc63e5afcdb05a191647142024-02-05 21:24:11.000uniswap-v20x1c948300e2f4e3d8cebf359e01ce5a54fdb5b0aac43c17bb1d092649add5967d
    15
    		PORKSY0x8cde2fbebc9347c6b6c98a5dc7517f25eeebeabd191653862024-02-05 23:39:11.000uniswap-v20x521b2c1c3d1ded0fc65c20d17c32d1c6ec60df1de1d6a44a19999c0ddff8b727
    16
    		SHARK0xbbdfb09b487ead48cf38314733faed7b67962cb7191641472024-02-05 19:29:47.000uniswap-v20xb44d6f373862e0f74cf2e55cfe3d8b86352d3d4ed6b7fdfdf60f3e24e2348a31
    17
    		QB0x7a4ef93109f936f17d8611562f4be728d6fb6c40191643962024-02-05 20:19:59.000uniswap-v20xf6d94c2915107a6f440f3db8d8f1d87630aba8edc97981668779d0266676d257
    18
    		0xf29a0b94aa63b42c9054dac849bcbe9c0d4eec4e191644102024-02-05 20:22:47.000uniswap-v20x0a95b1255285bd06b3bd1a25f248bec62e98042ec4f219a8e304a5cc49cc0fa5
    19
    		BLINK0x3a5c867277a84bf5df6b470886963034b379d7d2191641862024-02-05 19:37:35.000uniswap-v20x4fb64af7b7ce35eb36f5ef57e593794b7fc815453af551cb0a134e8c25720d23
    20
    		ELONDRUGS0xd7a887f962e92272ecf5d139d43a6e67b31b2c88191650832024-02-05 22:38:35.000uniswap-v20x3413c2e13d2ebc952eac4497a095b06c62ca47a21a9bf66ee416e702257db075
    ...
    937
    157KB
    4s