metricsdaoUntitled Query
Updated 2023-01-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- SELECT
-- COUNT(tx_hash) as n_swaps,
-- COUNT(DISTINCT tx_hash) as "Number of transactions"
-- FROM ethereum.core.ez_dex_swaps
-- WHERE
-- (pool_name LIKE 'ENS-%'
-- OR pool_name LIKE '%-ENS %')
-- AND (block_timestamp::DATE BETWEEN '2022-12-01' AND '2022-12-31')
SELECT
count(tx_hash)
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp::DATE BETWEEN '2023-01-01' AND '2023-01-07'
AND platform_name = 'opensea'
SELECT max(block_timestamp)
FROM ethereum.core.ez_nft_mints
WHERE block_timestamp::date = '2023-01-16'
SELECT distinct event_type
FROM ethereum.core.ez_nft_transfers
Run a query to Download Data