flipside

    😎Ethereum Token Fresh Wallet Accumulation Over 1D copy
    toming😎Ethereum Token Fresh Wallet Accumulation Over 1D copy
    Updated 2024-02-09
    -- forked from OCTOPUS / 😎Ethereum Token Fresh Wallet Accumulation Over 1D @ https://flipsidecrypto.xyz/OCTOPUS/q/majZ-sSQL_C1/ethereum-token-fresh-wallet-accumulation-over-1d

    With fresh_wallet_traders AS(
    SELECT from_address, min(block_timestamp)
    FROM ethereum.core.fact_transactions
    WHERE from_address IN (
    SELECT trader
    FROM crosschain.defi.ez_dex_swaps
    WHERE block_timestamp > CURRENT_TIMESTAMP() - interval '1 days'
    )
    GROUP BY 1
    HAVING MIN(block_timestamp) > CURRENT_TIMESTAMP() - interval '1 day'
    ),

    fresh_wallet_buys AS(
    SELECT
    SUM(amount_out_usd) AS total,
    token_out
    FROM crosschain.defi.ez_dex_swaps
    WHERE trader IN (SELECT from_address FROM fresh_wallet_traders)
    AND amount_out_usd IS NOT NULL
    AND blockchain = 'ethereum'
    AND block_timestamp > CURRENT_TIMESTAMP() - interval '1 days'
    GROUP BY 2
    HAVING SUM(amount_out_usd) > 1000
    ORDER BY 1 DESC
    )

    SELECT DISTINCT
    to_varchar(total, '$999,999,999') AS "Total Bought",
    symbol AS "Symbol",
    token_out AS "Token Address",
    total AS "Bought"
    FROM fresh_wallet_buys
    INNER JOIN crosschain.core.dim_contracts
    ON address = token_out
    Last run: 3 days ago
    Total Bought
    Symbol
    Token Address
    Bought
    1
    		 $160,356FRAX0x853d955acef822db058eb8505911ed77f175b99e160356.13
    2
    		 $61,810SOL0xd31a59c85ae9d8edefec411d448f90841571b89c61810.3
    3
    		 $56,495LINK0x514910771af9ca656af840dff83e8264ecf986ca56494.99
    4
    		 $55,107DEVVE0x8248270620aa532e4d64316017be5e873e37cc0955106.82
    5
    		 $51,381STARL0x8e6cd950ad6ba651f6dd608dc70e5886b1aa6b2451380.94
    6
    		 $41,151DIVER0xfb782396c9b20e564a64896181c7ac8d8979d5f441150.68
    7
    		 $40,201KEKIUS0x26e550ac11b26f78a04489d5f20f24e3559f7dd940200.81
    8
    		 $34,345GYD0xe07f9d810a48ab5c3c914ba3ca53af14e4491e8a34345.44
    9
    		 $32,441TALK0x0aff507ac29b8cea2fb10d2ad14408c2d79a35ad32440.9
    10
    		 $27,414RSC0xd101dcc414f310268c37eeb4cd376ccfa507f57127413.63
    11
    		 $26,591WLD0x163f8c2467924be0ae7b5347228cabf26031875326590.87
    12
    		 $26,588$PAAL0x14fee680690900ba0cccfc76ad70fd1b95d10e1626588.12
    13
    		 $20,345DOGC0xeeacc51af745846ddf46012b46c6910ea9b1289820345.13
    14
    		 $19,704PAXG0x45804880de22913dafe09f4980848ece6ecbaf7819703.98
    15
    		 $18,855DSync0xf94e7d0710709388bce3161c32b4eea56d3f91cc18854.93
    16
    		 $18,342UNI0x1f9840a85d5af5bf1d1762f925bdaddc4201f98418342.34
    17
    		 $17,977BITCOIN0x72e4f9f808c49a2a61de9c5896298920dc4eeea917977.03
    18
    		 $14,681SEI0xbdf43ecadc5cef51b7d1772f722e40596bc1788b14681.08
    19
    		 $14,077M870x80122c6a83c8202ea365233363d3f4837d13e88814077.31
    20
    		 $12,957APES0x09675e24ca1eb06023451ac8088eca1040f4758512956.79
    ...
    114
    9KB
    112s