-- forked from Hessish / stark - new wallets tot @ https://flipsidecrypto.xyz/Hessish/q/KZgiSkZl0hJA/stark---new-wallets-tot
with
new_w as (
SELECT DISTINCT
CONTRACT,
min(TIMESTAMP::date) as date
from
external.tokenflow_starknet.decoded_transactions
group by
1
)
SELECT
count(DISTINCT CONTRACT) as "New wallets"
from
new_w
where
date >= '2023-05-02'