StangFAST03 - distribution
    Updated 2023-08-14
    with

    sweat_token AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS days
    , avg( a.price ) AS price
    , a.symbol AS token
    FROM
    ethereum.core.fact_hourly_token_prices a
    WHERE
    a.token_address = '0xb4b9dc1c77bdbb135ea907fd5a08094d98883a35'
    GROUP BY 1 , 3
    ORDER BY 1 DESC LIMIT 1
    )
    ,
    tab1 AS
    (
    SELECT
    min( a.block_timestamp ) AS min_date1
    , a.tx_signer AS new_user1
    FROM
    near.core.fact_transactions a
    WHERE
    a.tx_receiver LIKE '%sweat%'
    AND a.tx_status = 'Success'
    GROUP BY 2
    ORDER BY 1 DESC
    )
    ,
    tab2 AS
    (
    SELECT
    min( a.block_timestamp ) AS min_date2
    , a.tx_signer AS new_user2
    FROM
    Run a query to Download Data