hessTotal Numbers
Updated 2024-06-17
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 hash as (select DISTINCT attribute_value as collection_address,
tx_id
from sei.core.fact_msg_attributes
where attribute_key = 'collection'
and block_timestamp::date >= '2023-08-15'
and tx_id in (select tx_id from sei.core.fact_msg_attributes
where attribute_value = 'mint'
and attribute_key = 'action'
and block_timestamp::date >= '2023-08-15'))
,
nfts as (select block_timestamp,
a.tx_id,
attribute_value as nft,
collection_address
from sei.core.fact_msg_attributes a join hash b on a.tx_id = b.tx_id
where block_timestamp::date >= '2023-08-15'
and attribute_key = 'token_id'
)
,
user as (select DISTINCT nft,
a.block_timestamp,
a.tx_id,
attribute_value as user,
collection_address
from sei.core.fact_msg_attributes a join nfts b on a.tx_id = b.tx_id
where attribute_key = 'fee_payer'
and a.block_timestamp::date >= '2023-08-15'
)
,
final as ( select DISTINCT nft,
b.block_timestamp,
b.tx_id,
user,
collection_address,
attribute_value/pow(10,6) as mint_price
from user a left outer join sei.core.fact_msg_attributes b on a.tx_id = b.tx_id
QueryRunArchived: QueryRun has been archived