kasadeghDaily Earned Fees
Updated 2022-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select day,
daily_amount_usd,
sum(daily_amount_usd) over (order by day rows between unbounded preceding and current row ) as cumulative_daily_amount_usd
from
(
SELECT
BLOCK_TIMESTAMP::date as day,
sum(amount_usd) as daily_amount_usd
FROM polygon.udm_events
WHERE to_address = '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073'
AND amount_usd IS NOT NULL
AND from_address='0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
GROUP BY 1
)
order by day
Run a query to Download Data