SELECT

date_trunc('day', block_timestamp) as day,

count(DISTINCT tx_hash) as bets,

sum(raw_amount/power(10, decimals)) as volume_in ,

count(DISTINCT origin_from_address) as users

FROM optimism.core.fact_token_transfers

LEFT outer JOIN optimism.core.dim_contracts

ON address = contract_address

--WHERE tx_hash LIKE lower('0x2072d57af9eb255993f0307d9713a2518ba7686cee15a47d6af1ba07031fa865')

WHERE from_address LIKE lower('0x170a5714112daEfF20E798B6e92e25B86Ea603C1')

AND symbol LIKE 'sUSD'

--AND block_timestamp > CURRENT_DATE - 14

GROUP BY 1

SELECT

*,

sum(volume_in) over (order BY day) as cume_volume,

sum(bets) over (ORDER by day) as sume_bets

FROM tab1

ORDER BY day DESC