amelia-leeUntitled Query
Updated 2022-07-29
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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