0xHaM-dAll Chains
Updated 2023-06-12
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with poly_mainTb as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
DECODED_LOG:receiver as usr
FROM polygon.core.ez_decoded_event_logs
WHERE contract_address in ('0x0b9078874a97d608b7c0c81c2c6998ab5185f8af',
'0x29fbd00940df70cfc5dad3f2370686991e2bbf5c',
'0x9441a867aa68c8a5322f99b6bd6881cc175775c2',
'0x8b47bf9c3cf93d54395a8c19814911a76c13cd66')
)
, eth_mainTb as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
DECODED_LOG:receiver as usr
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address in ('0x0b9078874a97d608b7c0c81c2c6998ab5185f8af',
'0x29fbd00940df70cfc5dad3f2370686991e2bbf5c',
'0x9441a867aa68c8a5322f99b6bd6881cc175775c2',
'0x8b47bf9c3cf93d54395a8c19814911a76c13cd66')
)
, arbi_newUsr as (
SELECT
EVENT_INPUTS:from as new_swapper,
min(BLOCK_TIMESTAMP) as min_date
FROM arbitrum.core.fact_event_logs
WHERE tx_hash IN (SELECT tx_hash FROM arbitrum.core.fact_event_logs WHERE CONTRACT_ADDRESS = '0x7ff1ccb68bdba741650f55218b53098b34a933e5')
AND EVENT_INPUTS:to = '0x0087bb802d9c0e343f00510000729031ce00bf27'
AND EVENT_NAME = 'Transfer'
GROUP by 1
)
, arbi_activeUsr as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
Run a query to Download Data