maybeyonasArtBlocks - daily stats
Updated 2021-09-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 artblocks as(
select
contract_address,
creator_name,
project_name,
token_id,
-- token_metadata,
token_metadata:platform::string as platform,
token_metadata:collection_name::string as collection,
token_metadata:artist::string as artist,
-- token_metadata:features as traits,
token_metadata:name::string as nft_name
from ethereum.nft_metadata
where
platform like '%Art Blocks%'
),
art_blocks_events as(
select
tx_id,block_timestamp,
case when price is null then 'transfer' else event_type end as event_type,
n.contract_address,n.token_id,platform,collection,artist,
event_from as seller, event_to as buyer,
tx_currency, price, price_usd
from ethereum.nft_events n
inner join artblocks s on s.contract_address = n.contract_address and s.token_id = n.token_id
),
sales as(
select * from art_blocks_events
where event_type = 'sale'
),
mints as(
select * from art_blocks_events
where event_type = 'mint'
),
over_stats as(
select
Run a query to Download Data