cypherparaswap new active users
Updated 2022-05-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- select * from flipside_prod_db.ethereum_core.ez_dex_swaps
-- where tx_hash in (select tx_hash from flipside_prod_db.ethereum_core.fact_event_logs
-- where contract_address = lower('0xDEF171Fe48CF0115B1d80b88dc8eAB59176FEe57'))
-- limit 100
with first_transactions as (select
date_trunc('day', min(block_timestamp)) as first_transaction,
topics[1] as address
from flipside_prod_db.ethereum_core.fact_event_logs
where contract_address = lower('0xDEF171Fe48CF0115B1d80b88dc8eAB59176FEe57')
and block_timestamp >= current_date() - 60
group by address)
select
first_transaction as date,
count(distinct(address)) as n_new_unique_active_users
from first_transactions
group by date
Run a query to Download Data