satsihUntitled Query
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 nfts_inbound_latest as (
SELECT
max(block_timestamp) as block_timestamp,
nft_address,
tokenid
FROM
ethereum.core.ez_nft_transfers
WHERE nft_to_address IN
-- List of 3AC addresses
('0x5491fb87ebc0d870ddaa1f757719e11928b1a8cb',
'0xf2820c8165ac170863b63d8b3996faef12a8742b',
'0x4862733b5fddfd35f35ea8ccf08f5045e57388b3',
'0x3ba21b6477f48273f41d241aa3722ffb9e07e247',
'0xf30026fe8a2c0d01b70b1949ceaf2e09efd8b4a5',
'0xff4c60814adc5ee4cdf9a57e0944b1e4678ff09c',
'0x82ac5170a837f6554d518c71c0590723437e6b64',
'0x57bb6525c489ee43bee420f90379b047d7c40f31',
'0x085af684acdb1220d111fee971b733c5e5ae6ccd',
'0xe6754b5ee999c875ff4b8299cf7ddb3532e6f2ef',
'0x25ad8b7cd0738331e65b92736b71a4979691e479',
'0x5cfd0cddf989959a6a6c3ad985ce324460d46dfd',
'0x38ca81849baf9b22301af89d203e095536d3066e',
'0x2e675eeae4747c248bfddbafaa3a8a2fdddaa44b')
GROUP BY 2, 3
),
nfts_outbound_latest as (
SELECT
max(block_timestamp) as block_timestamp,
nft_address,
tokenid
FROM
ethereum.core.ez_nft_transfers
WHERE nft_from_address IN
-- List of 3AC addresses
('0x5491fb87ebc0d870ddaa1f757719e11928b1a8cb',
'0xf2820c8165ac170863b63d8b3996faef12a8742b',
Run a query to Download Data