0xaimanUntitled Query
Updated 2022-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with outflow as (select *
from (select *, datediff('day',dt,getdate()) as dd
from (select date(block_timestamp) as dt,from_address, tx_hash, symbol, amount, amount_usd
from ethereum.core.ez_token_transfers
where tx_hash = '0x35187867f37c65d2d7fc9918d06c99977d9478bc3c57960b5c0245baf2186258' and
origin_to_address = '0x4f4495243837681061c4743b74b3eedf548d56a5'
)
where symbol = 'USDT' or symbol = 'USDC' or symbol = 'DAI')
where dd<=30)
select fel.* from ethereum.core.fact_traces fel
inner join outflow on outflow.tx_hash = fel.tx_hash
limit 1000
Run a query to Download Data