0-MIDDaily New Traders on Gains Network Platform
    Updated 2023-04-13
    with tab1 as (
    select min(BLOCK_TIMESTAMP::date) as date
    ,ORIGIN_FROM_ADDRESS
    from polygon.core.fact_event_logs
    where (ORIGIN_TO_ADDRESS='0x65187fec6ecc4774c1f632c7503466d5b4353db1'
    or ORIGIN_TO_ADDRESS='0xd8d177efc926a18ee455da6f5f6a6cfcee5f8f58'
    or ORIGIN_TO_ADDRESS='0xf8a140db8b05bec52c7e86d0d40d72f8e54fe559')
    and EVENT_NAME='Transfer'
    and ORIGIN_FUNCTION_SIGNATURE='0x9aa7c0e5'
    group by 2)
    select date,count(ORIGIN_FROM_ADDRESS)as new_traders
    from tab1
    group by 1

    Run a query to Download Data