elsinaUntitled Query
Updated 2022-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
select *
from ethereum.core.ez_eth_transfers t join ethereum.core.fact_event_logs e on t.tx_hash = e.tx_hash
where
to_address in (lower('0x3666f603cc164936c1b87e207f36beba4ac5f18a'),lower('0x3e4a3a4796d16c0cd582c382691998f7c06420b6'),lower('0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1') )
and CONTRACT_ADDRESS in (lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48'),lower('0xdac17f958d2ee523a2206206994597c13d831ec7'),lower('0x6b175474e89094c44da98b954eedeac495271d0f') )
limit 20
-- bridge address
-- USDC :: 0x3666f603cc164936c1b87e207f36beba4ac5f18a
-- USDT :: 0x3e4a3a4796d16c0cd582c382691998f7c06420b6
-- DAI :: 0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1
--
-- token contract
-- 0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48 :: USDC
-- 0xdac17f958d2ee523a2206206994597c13d831ec7 :: USDT
-- 0x6b175474e89094c44da98b954eedeac495271d0f :: DAI
Run a query to Download Data