strawbettystETH seller
    Updated 2022-06-15
    SELECT
    date_trunc('day', block_timestamp) as day,
    COUNT(tx_id),
    COUNT(origin_address) as sellers,
    sum(amount) as stETH_amount,
    sum(amount_usd) as stETH
    from ethereum.udm_events
    WHERE to_address = '0x4028daac072e492d34a3afdbef0ba7e35d8b55c4'
    AND contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    AND day >= '2022-01-01'
    AND tx_id IN (
    SELECT
    tx_id
    FROM ethereum.udm_events
    WHERE contract_address = '0x4028daac072e492d34a3afdbef0ba7e35d8b55c4'
    AND event_name ='Swap'

    )
    AND origin_address IN (
    SELECT
    origin_address
    FROM ethereum.udm_events
    WHERE to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    AND event_type = 'native_eth'


    )

    GROUP BY 1


    Run a query to Download Data