zakkisyedLesson 1
Updated 2024-03-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- find transaction count for each month in the last 180 days
-- find monthly unique addresses in the last 6 months
select
date_trunc(month, block_timestamp) as date,
-- truncates the date to monthly
count(tx_hash) as tx_count --count (distinct from_address) as unique_from_addresses,
--count(distinct to_address) as unique_to_addresses
from
ethereum.core.fact_transactions
where
block_timestamp >= current_date - 180
AND from_address = lower('{{enter_address}}')
group by
date
order by
date desc
QueryRunArchived: QueryRun has been archived