oooooblahUntitled Query
Updated 2022-08-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with lil_pudgy_sales as (
select block_timestamp, platform_name, project_name, price from ethereum.core.ez_nft_sales where nft_address = loweR('0x524cAB2ec69124574082676e6F654a18df49A048') and block_timestamp >= CURRENT_DATE - 2
),
flowers_sales as (
select block_timestamp,
platform_name,
price,
case when nft_address = loweR('0x7D8820FA92EB1584636f4F5b8515B5476B75171a') then 'Mari Flowers' end as project
from ethereum.core.ez_nft_sales
where nft_address = loweR('0x7D8820FA92EB1584636f4F5b8515B5476B75171a')
and block_timestamp >= CURRENT_DATE - 2
)
select * from flowers_sales
Run a query to Download Data