with act1 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), ----------------------------------------------------------- act2 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), --------------------------------------------------- act3 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), --------------------------------------- act4 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), ------------------------------------- act5 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), ------------------------------------------ act6 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), --------------------------------- act7 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), ----------------------------- act8 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), --------------------------- act9 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), ------------------------------- act10 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), ------------------------- act11 as ( with tab1 as ( select EVENT_DATA:to as user ,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), tab2 as ( select EVENT_DATA:from as user, 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) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1), ------------------------------ act12 as ( with tab1 as ( select EVENT_DATA:to as user ,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<=current_date group by 1), tab2 as ( select EVENT_DATA:from as user, 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<=current_date group by 1) select tab2.user ,sum (deposit_volume - withdraw_volume) as flow_Balance from tab1 full outer join tab2 on tab1.user = tab2.user where tab2.user<>'null' group by 1) --------------------------------------------------------------------- select 'Jan-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act1 where dis_flow is not null group by 3 union all select 'Feb-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act2 where dis_flow is not null group by 3 union all select 'Mar-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act3 where dis_flow is not null group by 3 union all select 'Apr-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act4 where dis_flow is not null group by 3 union all select 'May-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act5 where dis_flow is not null group by 3 union all select 'Jun-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act6 where dis_flow is not null group by 3 union all select 'July-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act7 where dis_flow is not null group by 3 union all select 'Aug-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act8 where dis_flow is not null group by 3 union all select 'Sep-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act9 where dis_flow is not null group by 3 union all select 'Oct-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act10 where dis_flow is not null group by 3 union all select 'Nov-2022' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act11 where dis_flow is not null group by 3 union all select 'Currently' as month,count(distinct user) as Holders_Count ,case when flow_Balance>0 and flow_Balance<=5 then 'Below 5 FLOW' when flow_Balance>5 and flow_Balance<=10 then '5 ~ 10 FLOW' when flow_Balance>10 and flow_Balance<=50 then '10 ~ 50 FLOW' when flow_Balance>50 and flow_Balance<=100 then '50 ~ 100 FLOW' when flow_Balance>100 and flow_Balance<=500 then '100 ~ 500 FLOW' when flow_Balance>500 and flow_Balance<=1000 then '500 ~ 1000 FLOW' when flow_Balance>1000 then 'Up To 1000 FLOW'end as dis_flow from act12 where dis_flow is not null group by 3

Who's Got The Flow?