SELECT

--TRUNC(block_timestamp, 'hour') as hour,

TRUNC(block_timestamp, 'day') as date,

delegator_address,

SUM(amount) / 1e6 as osmo_claimed

FROM

osmosis.core.fact_staking_rewards

WHERE

block_timestamp >= '{{start_date}}'

AND block_timestamp <= '{{end_date}}'

GROUP BY /* hour, */date, delegator_address

HAVING osmo_claimed >= {{min_claimed}} AND osmo_claimed < {{max_claimed}}

),

swaps AS (

SELECT

TRUNC(block_timestamp, 'day') as date,

trader,

SUM(IFF(from_currency = 'uosmo', from_amount, -to_amount)) / 1e6 as osmo_sold

FROM

osmosis.core.fact_swaps sw

WHERE EXISTS (

SELECT 1

FROM stake_claims st

WHERE sw.trader = st.delegator_address AND TRUNC(sw.block_timestamp, 'day') = st.date

)

AND (from_currency = 'uosmo' OR to_currency = 'uosmo')

AND tx_status = 'SUCCEEDED'

GROUP BY date, trader

),

stakes AS (

SELECT

--TRUNC(block_timestamp, 'hour') as hour,

TRUNC(block_timestamp, 'day') as date,