FROM flow.core.fact_events

WHERE TX_SUCCEEDED ilike 'TRUE'

AND event_data:to IS NOT NULL AND event_contract = 'A.1654653399040a61.FlowToken'

and event_type ilike 'TokensDeposited' and block_timestamp <= CURRENT_DATE - 1

and block_timestamp >= '2022-01-01')

UNION all

(SELECT event_data:from as FLOW_user, -1 * event_data:amount as amount

FROM flow.core.fact_events

WHERE TX_SUCCEEDED ilike 'TRUE'

AND event_data:from IS NOT NULL AND event_contract = 'A.1654653399040a61.FlowToken'

and event_type ilike 'TokensWithdrawn'and block_timestamp <= CURRENT_DATE - 1

and block_timestamp >= '2022-01-01'))

select FLOW_user::string as top_users, sum(amount) as balance from p1 group by 1

having FLOW_user <> 'null'

order by 2 desc limit 30