flipside

    Uniswap V3 : Trading Volume
    AnalyticSagesUniswap V3 : Trading Volume
    Updated 2024-02-19
    SELECT
    date_trunc('{{param_md2P}}', block_timestamp) AS Date,
    origin_from_address,
    amount_in_usd,
    platform,
    symbol_in,
    tx_hash,
    event_name
    FROM ethereum.defi.ez_dex_swaps
    WHERE event_name = 'Swap'
    AND amount_in_usd IS NOT NULL
    AND platform = 'uniswap-v3'
    AND DATE(block_timestamp) >= '2023-01-01'
    ORDER BY 3 DESC
    LIMIT 1000
    Last run: about 1 year ago
    DATE
    ORIGIN_FROM_ADDRESS
    AMOUNT_IN_USD
    PLATFORM
    SYMBOL_IN
    TX_HASH
    EVENT_NAME
    1
    		2023-03-11 00:00:00.0000xa1faa827846e34166c34ac749918db52eda15fee85808976.93uniswap-v3DAI0xec82b6391ebbf6fb71a66145754edf5f63ed2f36c6a978fd707e47f65686467aSwap
    2
    		2023-03-11 00:00:00.0000x0124d0fa0dfb1430dfcff16ec6a96945e7a0bc1059466083.74uniswap-v3USDC0x983ee3386c921da56f07bdcaf5642c7a999571eb9db8cfe3854cbcd7140bf51fSwap
    3
    		2023-03-11 00:00:00.0000xfb91715172b52a56c968d95acc6eb01dd051744151506719.46uniswap-v3DAI0x35144aa6c2333e79b1034d667412cef44ccf09fd0a64d460371e650e911caf4eSwap
    4
    		2024-01-18 00:00:00.0000x68cc21f7c777243d1a9c71c2349bfdccd8ca7b7836111051.44uniswap-v3USDC0x5251c03f6897d94a5fa81b0c74f0b1f3f884f881d5cb02210825e43b58f531fcSwap
    5
    		2024-01-18 00:00:00.0000x68cc21f7c777243d1a9c71c2349bfdccd8ca7b7835963583.84uniswap-v3USDT0xb0ad6da9cd35723063eae2aeb2743abc9dc728783e67dfd1679af9e39825adb4Swap
    6
    		2023-11-29 00:00:00.0000xf480fab87c07ec2ddd68a83ec0319bb466b1afa235376353.98uniswap-v3USDT0xcdaa071fd5babeaa6b31cbfa9536436f44c5e07301696f0168e48c4496980d48Swap
    7
    		2023-11-29 00:00:00.0000xf480fab87c07ec2ddd68a83ec0319bb466b1afa235373488.28uniswap-v3USDC0x15fe3a0be1c6592eb1db926e0915c0ae8555f07de9d9f4420a55559d027fa5ddSwap
    8
    		2023-03-13 00:00:00.0000xb2698c2d99ad2c302a95a8db26b08d17a77cedd433903457.73uniswap-v3USDC0x9f43b6577f513435368b4b339a24932a9b2465906bc5ac8a1b1239d7bef0f705Swap
    9
    		2023-03-12 00:00:00.0000x0e63ee1a039bcc422b1baaf65c7ae30c497d3fc831028133.44uniswap-v3DAI0xb6889979bfa4000bc18b99798eefccbcaa24d2facc76643f60c7e483cbb711d4Swap
    10
    		2023-03-11 00:00:00.0000x18709e89bd403f470088abdacebe86cc60dda12e21613951.94uniswap-v3USDC0xd525b5f45bc044031985ebac1a2527dbd96b2db62a882bb4b079ab896dd593cbSwap
    11
    		2024-01-05 00:00:00.0000x6fb9ea028eecddc6f4845194ab844131a71279fe21481630.67uniswap-v3USDT0xe9627db0ae913916c0851d449ded78c4dbe50c03affba103276d9c2f03795741Swap
    12
    		2024-02-16 00:00:00.0000xf480fab87c07ec2ddd68a83ec0319bb466b1afa221459496.24uniswap-v3USDT0xdf0d9856abb6a58ebe3d9e89ddc3385003e148c9ca4e7c69fd0a3184737c96a4Swap
    13
    		2024-02-16 00:00:00.0000xf480fab87c07ec2ddd68a83ec0319bb466b1afa221414569.13uniswap-v3USDC0xe2341d089c5a7216d87d678eb161e48780d46350c1f5dfe43b185e981dd9939cSwap
    14
    		2024-01-04 00:00:00.0000xf480fab87c07ec2ddd68a83ec0319bb466b1afa220496562.19uniswap-v3USDT0x53a2f5d13667c9afe275ce056a91ec786e20a411d631cc9eb4d64d839f8c733cSwap
    15
    		2024-01-04 00:00:00.0000xf480fab87c07ec2ddd68a83ec0319bb466b1afa220487802.35uniswap-v3USDC0x9d1d37261ef4af9fc7a928dad9865b2491af63d99d2112cf57dc9284f7181fa9Swap
    16
    		2023-03-11 00:00:00.0000x517cbe77cb330fb7fb204d7a6d01a79e61f1af7420284548.36uniswap-v3DAI0x5debbcfa79e91ba49ec0b2b6008add53bcc60760ed41b8405d36c55e638f8c80Swap
    17
    		2023-03-11 00:00:00.0000x517cbe77cb330fb7fb204d7a6d01a79e61f1af7420283730.37uniswap-v3DAI0x5debbcfa79e91ba49ec0b2b6008add53bcc60760ed41b8405d36c55e638f8c80Swap
    18
    		2023-03-11 00:00:00.0000x517cbe77cb330fb7fb204d7a6d01a79e61f1af7420282754.4uniswap-v3DAI0x5debbcfa79e91ba49ec0b2b6008add53bcc60760ed41b8405d36c55e638f8c80Swap
    19
    		2023-05-12 00:00:00.0000xa51b24e54bfc91f2fa4ac125e97cf0da526e171619703098.05uniswap-v3WBTC0x8910158070e840a583d440f9a9b1fcd9490883cedd5d61587770dc8b6588b4f3Swap
    20
    		2023-05-12 00:00:00.0000xa51b24e54bfc91f2fa4ac125e97cf0da526e171619470122.75uniswap-v3WETH0x8910158070e840a583d440f9a9b1fcd9490883cedd5d61587770dc8b6588b4f3Swap
    ...
    1000
    176KB
    4s