SELECT '2022-06-01' as label, count(CASE WHEN RUNE_balance =0 AND open_lp_action =1 THEN wallet_address end) as n_open_lp_Action, count(CASE WHEN RUNE_balance> 0 AND open_lp_action =1 THEN wallet_address end) as n_Rune_holder_AND_open_lp_Action, count(CASE WHEN (RUNE_balance =0 AND open_lp_action =1) or RUNE_balance> 0 THEN wallet_address end) as n_RUNE_HOLDER_OR_open_lp_Action from ( SELECT a.wallet as wallet_address, rune_tr_in, rune_tr_out, case WHEN net_liq = 0 THEN '0' ELSE '1' END as open_lp_action, rune_tr_in-rune_tr_out as RUNE_balance FROM ( SELECT to_address as wallet, sum(rune_amount) as RUNE_tr_in FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-06-01' GROUP BY wallet )a FULL JOIN ( SELECT from_address as wallet, sum(rune_amount) as RUNE_tr_out FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-06-01' GROUP BY wallet ) b ON a.wallet = b.wallet LEFT JOIN ( SELECT from_address as wallet, sum(CASE WHEN lp_action = 'add_liquidity' and rune_amount is not null THEN stake_units WHEN lp_action = 'remove_liquidity' THEN -1*stake_units ELSE 0 END) as net_liq FROM flipside_prod_db.thorchain.liquidity_actions WHERE date_Trunc('day',block_timestamp) < '2022-06-01' GROUP by wallet ) c ON a.wallet = c.wallet ) --WHERE a.wallet = 'thor1jhnqpyjh56a9tcul3ek4vqckxwqgesnhswl4ks' UNION SELECT '2022-05-01' as label, count(CASE WHEN RUNE_balance =0 AND open_lp_action =1 THEN wallet_address end) as n_open_lp_Action, count(CASE WHEN RUNE_balance> 0 AND open_lp_action =1 THEN wallet_address end) as n_Rune_holder_AND_open_lp_Action, count(CASE WHEN (RUNE_balance =0 AND open_lp_action =1) or RUNE_balance> 0 THEN wallet_address end) as n_RUNE_HOLDER_OR_open_lp_Action from ( SELECT a.wallet as wallet_address, rune_tr_in, rune_tr_out, case WHEN net_liq = 0 THEN '0' ELSE '1' END as open_lp_action, rune_tr_in-rune_tr_out as RUNE_balance FROM ( SELECT to_address as wallet, sum(rune_amount) as RUNE_tr_in FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-05-01' GROUP BY wallet )a FULL JOIN ( SELECT from_address as wallet, sum(rune_amount) as RUNE_tr_out FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-05-01' GROUP BY wallet ) b ON a.wallet = b.wallet LEFT JOIN ( SELECT from_address as wallet, sum(CASE WHEN lp_action = 'add_liquidity' and rune_amount is not null THEN stake_units WHEN lp_action = 'remove_liquidity' THEN -1*stake_units ELSE 0 END) as net_liq FROM flipside_prod_db.thorchain.liquidity_actions WHERE date_Trunc('day',block_timestamp) < '2022-05-01' GROUP by wallet ) c ON a.wallet = c.wallet ) UNION SELECT '2022-04-01' as label, count(CASE WHEN RUNE_balance =0 AND open_lp_action =1 THEN wallet_address end) as n_open_lp_Action, count(CASE WHEN RUNE_balance> 0 AND open_lp_action =1 THEN wallet_address end) as n_Rune_holder_AND_open_lp_Action, count(CASE WHEN (RUNE_balance =0 AND open_lp_action =1) or RUNE_balance> 0 THEN wallet_address end) as n_RUNE_HOLDER_OR_open_lp_Action from ( SELECT a.wallet as wallet_address, rune_tr_in, rune_tr_out, case WHEN net_liq = 0 THEN '0' ELSE '1' END as open_lp_action, rune_tr_in-rune_tr_out as RUNE_balance FROM ( SELECT to_address as wallet, sum(rune_amount) as RUNE_tr_in FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-04-01' GROUP BY wallet )a FULL JOIN ( SELECT from_address as wallet, sum(rune_amount) as RUNE_tr_out FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-04-01' GROUP BY wallet ) b ON a.wallet = b.wallet LEFT JOIN ( SELECT from_address as wallet, sum(CASE WHEN lp_action = 'add_liquidity' and rune_amount is not null THEN stake_units WHEN lp_action = 'remove_liquidity' THEN -1*stake_units ELSE 0 END) as net_liq FROM flipside_prod_db.thorchain.liquidity_actions WHERE date_Trunc('day',block_timestamp) < '2022-04-01' GROUP by wallet ) c ON a.wallet = c.wallet ) UNION SELECT '2022-03-01' as label, count(CASE WHEN RUNE_balance =0 AND open_lp_action =1 THEN wallet_address end) as n_open_lp_Action, count(CASE WHEN RUNE_balance> 0 AND open_lp_action =1 THEN wallet_address end) as n_Rune_holder_AND_open_lp_Action, count(CASE WHEN (RUNE_balance =0 AND open_lp_action =1) or RUNE_balance> 0 THEN wallet_address end) as n_RUNE_HOLDER_OR_open_lp_Action from ( SELECT a.wallet as wallet_address, rune_tr_in, rune_tr_out, case WHEN net_liq = 0 THEN '0' ELSE '1' END as open_lp_action, rune_tr_in-rune_tr_out as RUNE_balance FROM ( SELECT to_address as wallet, sum(rune_amount) as RUNE_tr_in FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-03-01' GROUP BY wallet )a FULL JOIN ( SELECT from_address as wallet, sum(rune_amount) as RUNE_tr_out FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-03-01' GROUP BY wallet ) b ON a.wallet = b.wallet LEFT JOIN ( SELECT from_address as wallet, sum(CASE WHEN lp_action = 'add_liquidity' and rune_amount is not null THEN stake_units WHEN lp_action = 'remove_liquidity' THEN -1*stake_units ELSE 0 END) as net_liq FROM flipside_prod_db.thorchain.liquidity_actions WHERE date_Trunc('day',block_timestamp) < '2022-03-01' GROUP by wallet ) c ON a.wallet = c.wallet ) UNION SELECT '2022-02-01' as label, count(CASE WHEN RUNE_balance =0 AND open_lp_action =1 THEN wallet_address end) as n_open_lp_Action, count(CASE WHEN RUNE_balance> 0 AND open_lp_action =1 THEN wallet_address end) as n_Rune_holder_AND_open_lp_Action, count(CASE WHEN (RUNE_balance =0 AND open_lp_action =1) or RUNE_balance> 0 THEN wallet_address end) as n_RUNE_HOLDER_OR_open_lp_Action from ( SELECT a.wallet as wallet_address, rune_tr_in, rune_tr_out, case WHEN net_liq = 0 THEN '0' ELSE '1' END as open_lp_action, rune_tr_in-rune_tr_out as RUNE_balance FROM ( SELECT to_address as wallet, sum(rune_amount) as RUNE_tr_in FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-02-01' GROUP BY wallet )a FULL JOIN ( SELECT from_address as wallet, sum(rune_amount) as RUNE_tr_out FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-02-01' GROUP BY wallet ) b ON a.wallet = b.wallet LEFT JOIN ( SELECT from_address as wallet, sum(CASE WHEN lp_action = 'add_liquidity' and rune_amount is not null THEN stake_units WHEN lp_action = 'remove_liquidity' THEN -1*stake_units ELSE 0 END) as net_liq FROM flipside_prod_db.thorchain.liquidity_actions WHERE date_Trunc('day',block_timestamp) < '2022-02-01' GROUP by wallet ) c ON a.wallet = c.wallet ) UNION SELECT '2022-01-01' as label, count(CASE WHEN RUNE_balance =0 AND open_lp_action =1 THEN wallet_address end) as n_open_lp_Action, count(CASE WHEN RUNE_balance> 0 AND open_lp_action =1 THEN wallet_address end) as n_Rune_holder_AND_open_lp_Action, count(CASE WHEN (RUNE_balance =0 AND open_lp_action =1) or RUNE_balance> 0 THEN wallet_address end) as n_RUNE_HOLDER_OR_open_lp_Action from ( SELECT a.wallet as wallet_address, rune_tr_in, rune_tr_out, case WHEN net_liq = 0 THEN '0' ELSE '1' END as open_lp_action, rune_tr_in-rune_tr_out as RUNE_balance FROM ( SELECT to_address as wallet, sum(rune_amount) as RUNE_tr_in FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-01-01' GROUP BY wallet )a FULL JOIN ( SELECT from_address as wallet, sum(rune_amount) as RUNE_tr_out FROM flipside_prod_db.thorchain.transfers WHERE asset = 'THOR.RUNE' AND date_Trunc('day',block_timestamp) < '2022-01-01' GROUP BY wallet ) b ON a.wallet = b.wallet LEFT JOIN ( SELECT from_address as wallet, sum(CASE WHEN lp_action = 'add_liquidity' and rune_amount is not null THEN stake_units WHEN lp_action = 'remove_liquidity' THEN -1*stake_units ELSE 0 END) as net_liq FROM flipside_prod_db.thorchain.liquidity_actions WHERE date_Trunc('day',block_timestamp) < '2022-01-01' GROUP by wallet ) c ON a.wallet = c.wallet )

Active Wallet Addresses