headitmanagerAre there any trends with these collections
Updated 2022-04-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with tokens as (select
distinct event_inputs:token::string as token
from Ethereum_core.fact_event_logs
where contract_address='0x85aa7f78bdb2de8f3e0c0010d99ad5853ffcfc63'
and event_name = 'Mint'
)
, Deposit as (select tx_hash from Ethereum_core.fact_event_logs where contract_address in (select token from tokens) and event_name = 'Deposit'
)
, Approval as (select tx_hash from Ethereum_core.fact_event_logs where tx_hash in (select tx_hash from Deposit) and event_name = 'Approval'
)
, Transfer as (select * from Ethereum_core.fact_event_logs where tx_hash in (select tx_hash from Approval) and event_name = 'Transfer'
)
select count(*),contract_address,date(block_timestamp) from Transfer
where contract_address in
('0x417cf58dc18edd17025689d13af2b85f403e130c','0xbb3d13260b3f6893ace34a4284be70eccf4cc0f1',
'0xfd082f6e5fc7cf1b6393969c64bf4d7cff774e7a','0xc22616e971a670e72f35570337e562c3e515fbfe','0xb159f1a0920a7f1d336397a52d92da94b1279838')
group by contract_address,date(block_timestamp)
Run a query to Download Data