-- forked from Aurora - New user Count @ https://flipsidecrypto.xyz/edit/queries/b27283c8-fde2-4066-bdd3-a91b70caf147

-- forked from Aurora - Daily Transaction Count copy @ https://flipsidecrypto.xyz/edit/queries/c095a177-78aa-4611-bfcc-8c3a3f758c43

WITH qmain as (

select date_trunc('day',block_timestamp) as day,

tx_hash,

from_address,

row_number() OVER (partition by from_address order by day asc) as rn

from aurora.core.fact_transactions

select count(from_address) new_user_count

from qmain

where rn = 1

*/