truevineGetting Started
    Updated 2024-02-02
    SELECT
    swaps.block_timestamp,
    swaps.event_name,
    swaps.tx_hash,
    swaps.platform,
    swaps.contract_address,
    swaps.symbol_in,
    swaps.symbol_out,
    FROM ethereum.defi.ez_dex_swaps AS swaps
    --JOIN ethereum.core.dim_labels AS labels ON


    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
    EVENT_NAME
    TX_HASH
    PLATFORM
    CONTRACT_ADDRESS
    SYMBOL_IN
    SYMBOL_OUT
    1
    2021-12-25 18:01:25.000Swap0x24f222e1b453aefcf780e66b33d1ecae0003ae52441d2c70517a8e806c205a95uniswap-v20xdb4f0e1f537ed1d4bc4714367dec1e2417f35592WETHSOS
    2
    2021-12-25 13:45:36.000Swap0x79bae48bfb28ce9b503476650eec5fc6ed9e38f670f6a877dec6af1db546f36euniswap-v20xe9c966bc01b4f14c0433800efbffef4f81540a97COMFIWETH
    3
    2021-12-25 13:57:02.000Swap0xd4c738ee282ac2bb0d765139558f9650dd79e1f8e55331d3a4bab01623ca5a0funiswap-v20xdb4f0e1f537ed1d4bc4714367dec1e2417f35592SOSWETH
    4
    2021-12-25 13:50:56.000Swap0x16f711c86a5eb4aeb69a50a03f442ddce1aac70bdb0fbb34c023460e639fba34uniswap-v20xdb4f0e1f537ed1d4bc4714367dec1e2417f35592SOSWETH
    5
    2021-12-25 13:46:17.000Swap0x91e5b92d75e86463d24164cfe41586e4baa6c2146bdd70922a53ac22af58a93buniswap-v20xdb4f0e1f537ed1d4bc4714367dec1e2417f35592SOSWETH
    6
    2021-12-25 13:45:57.000Swap0x3d17353ee1d79b3142e4efca3fd493c8dbd7e106760ecf56368afb753becba1duniswap-v20xdb4f0e1f537ed1d4bc4714367dec1e2417f35592WETHSOS
    7
    2021-12-25 00:40:16.000Swap0x622a0d1d26b3054abe0e8194400b7c911362988556ff36d2ba206656596cfb25uniswap-v20xee09d851b4ba4642ab0f8a6ebebb1293fee9c0fbWETHCLIFF
    8
    2021-12-25 07:34:54.000Swap0xf6e239f165e505f003d95c2a9eec6b11fdffbc7297d82f8c2cb664cd751c2077uniswap-v20x90704ac59e7e54632b0cc9d22573aecd7eb094adCROWETH
    9
    2021-12-25 06:57:40.000Swap0xd54c22a628ddf0a60469f424f6111ab641c3e72213bd95d9343f632c3552f915uniswap-v20x7dd3f5705504002dc946aeafe6629b9481b72272WETHDAO
    10
    2021-12-25 19:17:35.000Swap0x363ed5f39ac57839879e06223ef874d98e1d9895351da925c0fa1a63f4f2a116uniswap-v20xee09d851b4ba4642ab0f8a6ebebb1293fee9c0fbWETHCLIFF
    10
    2KB
    1s