mehrancrypto-dxoepqUntitled Query
Updated 2022-08-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tx1 as (
SELECT ADDRESS
from ethereum.core.dim_labels
where LABEL_TYPE = 'nft'
and LABEL ilike '%cryptopunk%'
)
SELECT CURRENCY_SYMBOL , sum(price_usd )
from tx1 B , ethereum.core.ez_nft_sales A
where NFT_ADDRESS = ADDRESS
and BLOCK_TIMESTAMP::date = '2022-06-19'
and BUYER_ADDRESS <> '0x0000000000000000000000000000000000000000'
GROUP by 1
Run a query to Download Data