flipside

    Find largest token purchase - ETH
    ghostcrabFind largest token purchase - ETH
    Updated 2025-03-04
    WITH flock_swaps AS (
    SELECT
    tx_hash,
    block_timestamp,
    token_in,
    symbol_in,
    amount_in,
    token_out,
    symbol_out,
    amount_out,
    amount_out_usd,
    origin_from_address AS buyer_address,
    platform
    FROM ethereum.defi.ez_dex_swaps
    WHERE
    -- FLOCK as the token received (purchased)
    LOWER(token_out) = '0xb33d999469a7e6b9ebc25a3a05248287b855ed46'
    )

    SELECT
    tx_hash,
    block_timestamp,
    symbol_in AS paid_with_token,
    amount_in AS paid_amount,
    amount_out AS flock_received,
    amount_out_usd AS estimated_value_usd,
    buyer_address,
    platform AS dex_platform
    FROM flock_swaps
    ORDER BY amount_out DESC
    LIMIT 20;
    Last run: about 2 months ago
    TX_HASH
    BLOCK_TIMESTAMP
    PAID_WITH_TOKEN
    PAID_AMOUNT
    FLOCK_RECEIVED
    ESTIMATED_VALUE_USD
    BUYER_ADDRESS
    DEX_PLATFORM
    1
    		0x4b22b3ac20ac436f9f629a49104279e4ef280871e745df6b421bb37c845fe4682025-02-11 06:23:59.000WETH4.60968290211601587.918051111024.990x6520a54dbdc914fb87483f6560f7efa0c6466897uniswap-v3
    2
    		0xa4c7a8c69b3cc2c4d56f8e7c9d567c741b418bf6f72e6bc6da19c997785bae8a2025-01-27 14:51:23.000WETH4.98510353394.56697080xa9b158fb9f14b25b5fad860d669b785309424feduniswap-v3
    3
    		0x348ff86b47f5d6c82839f8cd30a171deb3a7055abaca5602485e1ee8464bfb252025-01-27 14:07:59.000WETH4.9751243788695056.809778050x61d2799799afc6a29fd9e7139912e3582349e235uniswap-v3
    4
    		0xfc72c66c70a3b2241fff387a042e8b7a06fbd4912f9f0eb773dc558e7d03d8ae2025-02-17 19:00:47.000WETH3.4220327618474587.290852038563.320xae2fc483527b8ef99eb5d9b44875f005ba1fae13uniswap-v3
    5
    		0xc8943781f6043bf4c14adc429e7766c5966dd46b1e25b7e67d77654838df7a092025-02-11 06:31:23.000WETH3.8268325867713016.634246937329.680x5eb6befd9f2fef34f83f63a6d06eb7c4f995161auniswap-v3
    6
    		0xb8d05673678bbec31276a947c9f9caf44f84008edd26d786d9570248fa20821a2025-01-27 14:55:59.000WETH3.9887448788.381132340xa9b158fb9f14b25b5fad860d669b785309424feduniswap-v3
    7
    		0x1a71ad377938f202fb1bd88962e2b196c6f679d105059cd795342e73aa9535092025-01-27 14:08:35.000WETH4.4778878927146487.497793160x605169c8b40103014288be54cae42a78e3125ee2uniswap-v3
    8
    		0x112df7c5b74dd64292fb222e8e3e6ebc41bf0ef080e2cb85c30936648f266bd52025-01-27 15:00:59.000WETH57115770.850137390xa9b158fb9f14b25b5fad860d669b785309424feduniswap-v3
    9
    		0xfd049b311c27f92b8940fe733074545b63c892995f899dd70668698eabe711382025-01-28 10:56:11.000WETH26764767.851223790x1b718fd3975ce08793052d1221315ac6dda55f51uniswap-v3
    10
    		0xbbb4847037c68610157ce85660355b3cec41ee458cce415e81ba23668d9b9f222025-01-27 14:08:59.000WETH4.9751243786726829.29491280x78c1bf7dba36fe3d2cc9a18fbefb140fecef3fbfuniswap-v3
    11
    		0x2186ce1063eaeade54f6f2913ce0dd2b92197cb77587e89239fd8873c7fb62192025-02-09 23:31:35.000WETH2.3702015116645353.70538376455.960x3e638b0d1739c2556f2dfb5302ee6560a828e31buniswap-v3
    12
    		0xaa97027d5cda4886acd7d06404733bc1ab381f4a889c8f702eba460213d08eba2025-01-30 11:00:47.000WETH1.62197646606292.684543045452.240xf276173f787ec9003241ba4df6892d56d0746594uniswap-v3
    13
    		0x87a13b70dc349aef318d16156e69eef31a56b97e1fb8cc7fc9f0cbc89cfe9f7e2025-01-27 15:23:35.000WETH66510139.328472890xa9b158fb9f14b25b5fad860d669b785309424feduniswap-v3
    14
    		0x1573e551015721a71c5cff30e477c8f48abd9baeb4e9abc0cc26beabff89bb132025-02-21 15:14:47.000WETH26368854.945326085560.840xbbd9d2d2af24616fcc0c6bafaadda1bd49be65efuniswap-v3
    15
    		0x093ffa2fc0ece1a193633abc3a43647dc8e0e9c545d78216e759d42c1ebe457e2025-01-28 10:46:11.000WETH1.867792556043399.003688610x0950489ff7ba306774f9b389ce95657983fb3b56uniswap-v3
    16
    		0xdfcf3863f428386202e3f1ff5b4cf436ec50bbe927d038b061e9056c758ff4ee2025-01-27 14:15:35.000WETH25658558.664356220x1b718fd3975ce08793052d1221315ac6dda55f51uniswap-v3
    17
    		0x6d69c9a06d8d742de4c45a8147a798ca55e26d5d5c624813c1f276608502a3282025-01-28 07:27:11.000WETH25475051.361398570x1b718fd3975ce08793052d1221315ac6dda55f51uniswap-v3
    18
    		0xa0d8c736b4beec4b16d944dd1f921be21ebbfc57bf3c197fc913c1c8258502542025-01-27 15:19:11.000WETH55213338.088999360xa9b158fb9f14b25b5fad860d669b785309424feduniswap-v3
    19
    		0xb082fa4568ae469df328d9f6b5919cd859bf6bd717dd24907f3ad3504d6e1e512025-01-31 22:22:35.000WETH2.0817634265045118.226990736514.050x6520a54dbdc914fb87483f6560f7efa0c6466897uniswap-v3
    20
    		0x5e13bae0b6dcb4cba9fbf4f53d1a7c22f60a6ec5a4180338445025ed5c1edb132025-01-27 14:28:47.000WETH25006243.258913160xb70912c98bf4df1526be4af618cb3e35ade06f19uniswap-v3
    20
    4KB
    6s