mucryptoUntitled Query
Updated 2023-01-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- SELECT
-- COUNT (DISTINCT tx_hash)
-- FROM ethereum.core.ez_nft_sales
-- WHERE platform_name = 'opensea'
-- AND event_type = 'sale'
-- AND block_timestamp::DATE BETWEEN '2022-06-01' AND '2022-06-30'
SELECT
count(tx_hash) as n_records,
count(distinct tx_hash) as "Number of Transactions"
FROM ethereum.core.ez_nft_sales
WHERE
block_timestamp::DATE BETWEEN '2022-06-01' AND '2022-06-30'
AND platform_name = 'opensea'
;
Run a query to Download Data