where platform = 'sushiswap'

limit 10

select * from ethereum.core.fact_event_logs

where origin_to_address = lower('0xd9e1cE17f2641f24aE83637ab66a2cca9C378B9F')

limit 10

with source as (

select

From_address, tx_hash, eth_value, block_number

from ethereum.core.fact_transactions

where TX_JSON:receipt:logs[0]:decoded:inputs:to = '0x397ff1542f962076d0bfe58ea045ffa2d347aca0'

and block_number > '14000000'

and block_number < '15180000'

and eth_value > 0.01)

select

From_address,

tx_hash,

block_number,

avg(amount_out) as X

from ethereum.core.ez_dex_swaps s

inner join source on source.block_number = s.block_number

where token_out = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'

and block_number > source.block_number - 100

and block_number < source.block_number - 1

group by block_number

select * from ethereum.core.ez_dex_swaps

where origin_to_address = '0x397ff1542f962076d0bfe58ea045ffa2d347aca0'