oooooblahbayc basic
Updated 2022-08-21
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
›
⌄
with
bayc_sales as(
select min(price) as daily_low,
sum(price) as daily_volume,
date(block_timestamp)
from ethereum.core.ez_nft_sales
where project_name = 'boredapeyachtclub'
and block_timestamp >= CURRENT_DATE - 90
group by date(block_timestamp)
order by date(block_timestamp) desc
),
bayc_transactions as(
select block_timestamp,
date(block_timestamp),
event_type,
platform_name,
project_name,
tokenid,
price,
currency_symbol
from ethereum.core.ez_nft_sales
where project_name = 'boredapeyachtclub'
and block_timestamp >= CURRENT_DATE - 90
and price < 400
order by price desc
)
select * from bayc_transactions where price < (select avg(price)*2 from bayc_transactions)
Run a query to Download Data