amelia-leeUntitled Query
    Updated 2022-07-29
    SELECT date_trunc('week',block_timestamp) as date,
    sum(amount) as amnt,
    sum(amnt)over(ORDER BY date) as cum_amnt,
    sum(amount_usd) as amnt_usd,
    sum(amnt_usd)over(ORDER BY date) as cum_amnt_usd,
    count(tx_id) as n_sales,
    sum(n_sales)over(ORDER BY date) as cum_sales
    FROM flipside_prod_db.polygon.udm_events
    WHERE from_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' and to_address = '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073' AND origin_function_signature = '0xbbbfa60c'
    GROUP BY date
    ORDER BY date DESC
    Run a query to Download Data