mehdimarjanTotal Miners ETH Sales
Updated 2022-09-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH miners AS (
SELECT miner, COUNT(HASH) AS total_mines
FROM ethereum.core.fact_blocks
GROUP BY 1
)
SELECT
COUNT(DISTINCT tx_hash) AS number_of_sales,
COUNT(DISTINCT origin_from_address) AS number_of_users,
SUM(amount_in) AS total_amount,
SUM(amount_in_usd) AS total_amount_usd
FROM ethereum.core.ez_dex_swaps
WHERE origin_from_address IN (SELECT miner FROM miners)
AND symbol_in = 'WETH'
AND block_number >= '15537351'
AND block_timestamp::DATE >= '2022-09-01'
Run a query to Download Data