ins as (

select

trunc(block_timestamp, 'day') as date,

event_data:to as wallet,

sum(event_data:amount) as volume_in

from

flow.core.fact_events

where

event_contract = 'A.53f389d96fb4ce5e.SloppyStakes'

and event_type = 'TokensDeposited'

group by

1,

2

),

outs as (

select

trunc(block_timestamp, 'day') as date,

event_data:

from

as wallet,

sum(event_data:amount) as volume_out

from

flow.core.fact_events

where

event_contract = 'A.53f389d96fb4ce5e.SloppyStakes'

and event_type = 'TokensWithdrawn'

group by

1,

2

),

transfer_flow as (

SELECT

ifnull(x.date, y.date) as dates,

ifnull(x.wallet, y.wallet) as traders,