mucryptoS2 Q10
Updated 2023-01-26
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
-- select
-- count (to_address)
-- from ethereum.core.fact_transactions
-- WHERE block_timestamp::DATE between '2022-10-01' and '2022-10-31'
-- limit 1;
select
count(tx_hash) as n_rows,
count(distinct tx_hash) as unique_tx,
count(distinct from_address)
from ethereum.core.fact_transactions
where DATE_TRUNC('month',block_timestamp) = '2022-10-01'
Run a query to Download Data