apostleoffinanceUntitled Query
Updated 2022-12-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
/*SELECT
COUNT(tx_hash),
COUNT(DISTINCT tx_hash)
FROM ethereum.core.ez_dex_swaps
WHERE
(pool_name LIKE '%-ENS %'
OR pool_name LIKE 'ENS-%')
AND DATE(block_timestamp) BETWEEN '2022-10-01' AND '2022-10-31'*/
SELECT
COUNT(tx_hash) AS n_rows,
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp::DATE BETWEEN '2022-10-01' AND '2022-10-31'
Run a query to Download Data