Nige7777activating nft drops
Updated 2021-08-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- select
-- *
-- from ethereum.transactions where 1=1
-- AND To_address = '0xdfc243bb46dbdbc5923a52cb46dd237b3648f20c'
-- and function_name = 'activate'
-- and date_trunc('day',block_timestamp ) > '2021-08-06T09:55:55Z'
select *
from ethereum.transactions t
where 1=1
AND To_address = '0xc6c1ba87b62a6ef1ac734da67a1ae061a3f6943c'
and function_name = 'safeTransferFrom'
and date_trunc('hour',block_timestamp ) > '2021-08-07T09:55:55Z'
--where contract_address = lower('0x7afeda4c714e1c0a2a1248332c100924506ac8e6')
Run a query to Download Data