AndyCoolDaily Newcomers to Polygon Through Bentobox
    Updated 2022-05-16
    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

    Run a query to Download Data