Flipside Community2a) Backup : popular apps among new users polygon copy
    -- forked from 2a) popular apps among new users polygon @ https://flipsidecrypto.xyz/edit/queries/6aa328a2-f647-4d89-8d83-520e67d6e9c6

    -- forked from 2a) popular apps among new users Arbitrum @ https://flipsidecrypto.xyz/edit/queries/d16c95d1-0b28-41b3-a220-5ab32e440800

    -- forked from 2a) popular apps among new users optimism @ https://flipsidecrypto.xyz/edit/queries/2dac8520-2500-49d6-861a-52244ead6f7c

    -- forked from 2a) popular apps among new users optimism @ https://flipsidecrypto.xyz/edit/queries/81e6f7eb-8f38-475a-b4c1-a77e1a549069

    -- forked from 2a) popular apps among new users @ https://flipsidecrypto.xyz/edit/queries/55a92b86-1d0c-4bd8-920d-4c95a2745bce

    -- forked from 2a) popular apps among new users @ https://flipsidecrypto.xyz/edit/queries/956394e3-fe4f-4801-b8b3-68e508994b63


    with addresses as
    (
    select from_address, min(block_timestamp) as first_transaction_sent
    from polygon.core.fact_transactions
    group by from_address
    having first_transaction_sent >= '{{Start_date}}'
    ),
    all_transactions as
    (
    select * from polygon.core.fact_transactions
    where 1=1
    and block_timestamp >= '{{Start_date}}'
    and from_address in ( select from_address from addresses)
    ),
    top_apps as (
    select to_address, count(distinct from_address) as new_user
    from all_transactions ft
    group by to_address
    order by new_user desc
    limit 200
    ),
    top_200 as
    (
    Run a query to Download Data