flipside

    2024-02-05 06:24 PM
    AnalyticSages2024-02-05 06:24 PM
    Updated 2024-02-09
    --select -from -where -group by -order by

    SELECT
    swaps.block_timestamp,
    swaps.tx_hash,
    swaps.event_name,
    swaps.contract_address,
    swaps.symbol_in,
    swaps.origin_to_address,
    swaps.amount_in_usd,
    swaps.platform,
    labels.address_name,
    labels.label

    FROM ethereum.defi.ez_dex_swaps AS swaps
    JOIN ethereum.core.dim_labels AS labels
    ON swaps.contract_address = labels.address


    WHERE platform LIKE 'uniswap-v2'
    AND amount_in_usd IS NOT NULL
    ORDER BY amount_in_usd DESC
    LIMIT 10 ;



    Last run: over 1 year ago
    BLOCK_TIMESTAMP
    TX_HASH
    EVENT_NAME
    CONTRACT_ADDRESS
    SYMBOL_IN
    ORIGIN_TO_ADDRESS
    AMOUNT_IN_USD
    PLATFORM
    ADDRESS_NAME
    LABEL
    1
    		2020-11-14 15:36:30.0000x46a03488247425f845e444b9c10b52ba3c14927c687d38287c0faddc7471150aSwap0x0d4a11d5eeaac28ec3f61d100daf4d40471f1852WETH0x675bd0a0b03096c5ead734cfa00c7620538c7c6f35327852.26uniswap-v2uniswap v2: eth/usdt pooluniswap v2
    2
    		2020-11-14 15:36:30.0000x46a03488247425f845e444b9c10b52ba3c14927c687d38287c0faddc7471150aSwap0x0d4a11d5eeaac28ec3f61d100daf4d40471f1852USDT0x675bd0a0b03096c5ead734cfa00c7620538c7c6f30933036.4uniswap-v2uniswap v2: eth/usdt pooluniswap v2
    3
    		2020-11-17 00:47:19.0000xe1c76241dda7c5fcf1988454c621142495640e708e3f8377982f55f8cf2a8401Swap0xa478c2975ab1ea89e8196811f51a7b7ade33eb11WETH0x47c3d84394043a4f42f6422accd27bb7240fdfe224123875.32uniswap-v2uniswap v2: dai/eth pooluniswap v2
    4
    		2020-11-17 00:47:19.0000xe1c76241dda7c5fcf1988454c621142495640e708e3f8377982f55f8cf2a8401Swap0xa478c2975ab1ea89e8196811f51a7b7ade33eb11DAI0x47c3d84394043a4f42f6422accd27bb7240fdfe219080401.57uniswap-v2uniswap v2: dai/eth pooluniswap v2
    5
    		2021-04-07 23:11:20.0000x05303267c635fd8a82c1a70a39fea056d2715892a254668fa360027a000e63dbSwap0x94b0a3d511b6ecdb17ebf877278ab030acb0a878FEI0x9271d303b57c204636c38df0ed339b18bf98f90913846312.71uniswap-v2fei-weth uni-v2 lpuniswap
    6
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    7
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    8
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    9
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    10
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    11
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    12
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    13
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    14
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    15
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    16
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    17
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    18
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    19
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    20
    		2021-03-30 23:37:08.0000x8fbf63eefe9b3d2ca119790f3408b79cd87656d6656872522b562b6aae400b53Swap0x7d7e813082ef6c143277c71786e5be626ec77b20WETH0xfcfc434ee5bff924222e084a8876eee74ea7cfba13027117.85uniswap-v2delta-weth uni-v2 lpuniswap
    100
    25KB
    23s