0xaimanBids Matched on Opensea
Updated 2022-12-08
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 raw as (select block_timestamp as t,tx_hash, event_inputs:label as ens_id,event_inputs:name as ens_label, event_inputs:cost/10e17 as mint_cost, length(ens_label) as len
from ethereum.core.fact_event_logs
where event_name = 'NameRegistered' and origin_to_address = '0x283af0b28c62c092c9727f1ee09c02ca627eb7f5' and event_inputs:name is not null),
raw2 as (select * from (select * from raw
where len= {{ENS_Series}} )
where regexp_like(ens_label, '^[0-9]*$')),
mint as ( select block_timestamp as t, tx_hash, tokenid from ethereum.core.ez_nft_mints
where nft_address= '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85' and
project_name = 'ens'),
tid as (select mint.t, raw2.tx_hash, tokenid,ens_label, len
from mint inner join raw2 on
mint.tx_hash=raw2.tx_hash)
, sellens as (select tx_hash, event_inputs:tokenId as token_id from ethereum.core.fact_event_logs fel
where --fel.tx_hash = '0x659f6961fb48db842f061250f6ac28e858e11b211d46a596740b85851297c77a' and
contract_address = '0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85'),
sellens2 as (select fel2.block_timestamp as t, fel2.tx_hash, token_id from ethereum.core.fact_event_logs fel2
inner join sellens on sellens.tx_hash = fel2.tx_hash
inner join tid on tid.tokenid = sellens.token_id
where fel2.event_name = 'OrdersMatched'),
bidtrend as (select date(t) as date, count(DISTINCT tx_hash) as n_matched_bid
from sellens2
group by 1 order by 1 ),
sell as (select fel3.block_timestamp as t2 ,fel3.tx_hash as txn3, event_inputs:tokenId as token_id FROM ethereum.core.fact_event_logs fel3
where-- tx_hash = '0x06ee20512b7821f5d6ef66dddfee6adcf571fd9ca9c07f6b04783958f5f27f25' and
Run a query to Download Data