zakkisyedNFTX user activity
Updated 2022-06-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
count (distinct origin_to_address) as wallet_count,
event_inputs:vaultAddress::string as vault_address
FROM
(
select * from ethereum.core.fact_event_logs
where contract_address = lower('0xBE86f647b167567525cCAAfcd6f881F1Ee558216')
and event_inputs:vaultAddress::string is not null
and block_timestamp >= CURRENT_DATE-60
)
group by 2
--0xBE86f647b167567525cCAAfcd6f881F1Ee558216 nftx vault contract
Run a query to Download Data