maybeyonasfrac_top_nft_basket
Updated 2022-04-26
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
baskets as (
select event_inputs:"_address"::string as basket
from ethereum_core.fact_event_logs
where contract_address = '0xde771104c0c44123d22d39bb716339cd0c3333a1'
and event_name = 'NewBasket'
),
deposits as (
-- Basket Deposits Only
select
block_timestamp,
tx_hash,
-- event_inputs:from::string as user,
event_inputs:token::string as contract,
event_inputs:tokenId as token_id
from ethereum_core.fact_event_logs
where contract_address in (select * from baskets)
and event_name = 'Deposit'
),
mints as (
select
block_timestamp,
tx_hash,
-- event_inputs:from::string as user,
event_inputs:token::string as contract,
event_inputs:id as token_id
from ethereum_core.fact_event_logs
where contract_address = '0x85aa7f78bdb2de8f3e0c0010d99ad5853ffcfc63'
and event_name = 'Mint'
)
select
contract,
symbol,
case when contract = '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85' then 'ENS' else name end as name,
count(token_id) as txs
Run a query to Download Data