WITH source AS (
SELECT tx_from_address, block_timestamp,
row_number() over (partition by tx_from_address order by block_timestamp asc) as rank
FROM flipside_prod_db.polygon.events_emitted
WHERE block_timestamp BETWEEN '2021-05-01' AND '2022-05-15'
AND tx_to_address = '0x0319000133d3ada02600f0875d2cf03d442c3367'
qualify rank <=2
)
SELECT count(DISTINCT tx_from_address), date_trunc ('day', block_timestamp::date) as date
FROM source
GROUP BY date