flipside

    4. crv
    boomer774. crv
    Updated 2022-01-10
    select date_trunc('week', block_timestamp) as dt, to_address_name as pools, sum(tx_fee) as fee_ETH, sum(fee_usd) as fees_USD,
    count(distinct from_address) as active_users,
    SUM(fees_usd) OVER(partition by pools ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS Cumulative_Fees
    from ethereum.transactions
    where to_label_type = 'dex' and to_label_subtype = 'pool' and to_label = 'curve fi' and
    block_timestamp > '2021-01-01' and success = 'TRUE' and pools = 'ankrETH' or pools = 'sAAVE'
    group by 1,2
    Run a query to Download Data