with depositt as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' group by 1), withdrawt as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' group by 1), maintable as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt t1 join withdrawt t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable), depositt1 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-01-01' group by 1), withdrawt1 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-01-01' group by 1), maintable1 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt1 t1 join withdrawt1 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt1 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable1), depositt2 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-02-01' group by 1), withdrawt2 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-02-01' group by 1), maintable2 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt2 t1 join withdrawt2 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt2 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable2), depositt3 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-03-01' group by 1), withdrawt3 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-03-01' group by 1), maintable3 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt3 t1 join withdrawt3 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt3 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable3), depositt4 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-04-01' group by 1), withdrawt4 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-04-01' group by 1), maintable4 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt4 t1 join withdrawt4 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt4 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable4), depositt5 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-05-01' group by 1), withdrawt5 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-05-01' group by 1), maintable5 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt5 t1 join withdrawt5 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt5 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable5), depositt6 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-06-01' group by 1), withdrawt6 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-06-01' group by 1), maintable6 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt6 t1 join withdrawt6 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt6 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable6), depositt7 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-07-01' group by 1), withdrawt7 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-07-01' group by 1), maintable7 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt7 t1 join withdrawt7 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt7 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable7), depositt8 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-08-01' group by 1), withdrawt8 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-08-01' group by 1), maintable8 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt8 t1 join withdrawt8 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt8 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable8), depositt9 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-09-01' group by 1), withdrawt9 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-09-01' group by 1), maintable9 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt9 t1 join withdrawt9 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt9 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable9), depositt10 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-10-01' group by 1), withdrawt10 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-10-01' group by 1), maintable10 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt10 t1 join withdrawt10 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt10 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable10), depositt11 as ( select event_data:to as flowuser, sum (event_data:amount) as Deposit_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' and block_timestamp <='2022-11-01' group by 1), withdrawt11 as ( select event_data:from as flowuser, sum (event_data:amount) as Withdraw_Volume from flow.core.fact_events where event_contract = 'A.1654653399040a61.FlowToken' and event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' and block_timestamp <='2022-11-01' group by 1), maintable11 as ( select t1.flowuser, contract_name, sum (deposit_volume - withdraw_volume) as Balance from depositt11 t1 join withdrawt11 t2 on t1.flowuser = t2.flowuser full outer join flow.core.dim_contract_labels t3 on t1.flowuser = t3.account_address where t1.flowuser != 'null' group by 1,2), finalt11 as ( select count (distinct flowuser) as Total_Holders, sum (balance) as Total_Flow_Balance from maintable11) select '2022-01-01' as date1, Total_Flow_Balance from finalt1 union ALL select '2022-02-01' as date1, Total_Flow_Balance from finalt2 union ALL select '2022-03-01' as date1, Total_Flow_Balance from finalt3 union ALL select '2022-04-01' as date1, Total_Flow_Balance from finalt4 union ALL select '2022-05-01' as date1, Total_Flow_Balance from finalt5 union ALL select '2022-06-01' as date1, Total_Flow_Balance from finalt6 union ALL select '2022-07-01' as date1, Total_Flow_Balance from finalt7 union ALL select '2022-08-01' as date1, Total_Flow_Balance from finalt8 union ALL select '2022-09-01' as date1, Total_Flow_Balance from finalt9 union ALL select '2022-10-01' as date1, Total_Flow_Balance from finalt10 union ALL select '2022-11-01' as date1, Total_Flow_Balance from finalt11 union ALL select 'Current' as date1, Total_Flow_Balance from finalt

Who's Got the Flow?