2024-02-22 10:59 AM

toming2024-02-22 10:59 AM

Updated 2024-03-18

-- SELECT

-- *

-- FROM

-- ethereum.defi.ez_dex_swaps

-- WHERE

-- tx_hash = '0x506d916e9c36f6ec91f013c55fb7bf3e114fcd67078ec1ecbd0b2baf8b620138'

-- SELECT

-- *

-- FROM

-- ethereum.core.ez_native_transfers

-- WHERE

-- tx_hash = '0xdcf4e70a6dc4d396d19682ad551116ed15afc23b1152b7a1cbc50bd5e93afd15'

-- select

-- tx_hash,

-- block_timestamp,

-- AMOUNT_IN as Sell_Volume,

-- AMOUNT_OUT as Sell_Income,

-- SYMBOL_OUT,

-- EVENT_NAME

-- from ethereum.defi.ez_dex_swaps

-- where

-- (TOKEN_IN = '0xac57de9c1a09fec648e93eb98875b212db0d460b'

-- OR

-- TOKEN_out = '0xac57de9c1a09fec648e93eb98875b212db0d460b')

-- and

-- ORIGIN_FROM_ADDRESS = '0x33c9e83f9f6b936c284598cf0feb0bc944c24703'

-- -- and SYMBOL_OUT = 'wETH'

-- -- and EVENT_NAME = 'Swap'

-- order BY 2 DESC

SELECT

FROM

QueryRunArchived: QueryRun has been archived

flipside