badboyNew Addresses on polygon
    Updated 2023-02-12

    with new_poly_2020
    as (
    select from_address as address , min(block_timestamp)::date as min_date, '2020' as type
    from flipside_prod_db.polygon.transactions
    group by address
    having min_date <= '2020-12-31' and min_date >= '2020-01-01'

    )
    , new_poly_2021
    as (
    select from_address as address , min(block_timestamp)::date as min_date, '2021' as type
    from flipside_prod_db.polygon.transactions
    group by address
    having min_date <= '2023-12-31' and min_date >= '2021-01-01'
    )
    , new_poly_2022
    as (
    select from_address as address , min(block_timestamp)::date as min_date, '2023' as type

    from flipside_prod_db.polygon.transactions
    group by address
    having min_date >= '2023-01-01'
    Run a query to Download Data