blue2GEN 2 Wallets
    Updated 2022-05-25
    with gen2_wallet as (select sum(amount),address from flipside_prod_db.algorand.account_asset where asset_name like '%Octo Prime Gen2%'
    and amount>0
    group by 2)
    ,gen1_wallet as (
    select sum(amount),address from flipside_prod_db.algorand.account_asset where asset_name like '%Octorand #%'
    and amount>0
    group by 2)
    ,gen2_holders as (select count(distinct address) from gen2_wallet)
    ,gen1_holders as (select count(distinct address) from gen1_wallet)
    ,gen2_holds_gen1 as (select count(distinct address) from gen2_wallet where address in (select address from gen1_wallet))
    , gen2_sales as (select count(1),block_timestamp::date from flipside_prod_db.algorand.payment_transaction
    where receiver in ('ZI35SDCVSLRTKUQWCA6SXYX2VUKDJ5JJEWDMDH6ZYMXTQBQDAE6GWUEU6I','XIUCOQPPZO2UNFD2TXQAEW7W5MPGZROVD2YUOGME22GNORYCJVMEYK3P5U' ,
    'KPCXKFGBLR3WZN74BHG3RTKVOK6PW3UP53BHAYK7BLYDUCOTXJYKJU7JUY','AB4T4VD7LRGHH75Z3KISVPNDENGY4W227RPAJEBYUDVKVNF2PWDKMHTO4A',
    'VVCR4Q2GYOQO3ENWQDQEFFGTNDJRA56QIYHUQ3RCZT36I6WXBAUU2FS7QE','UFFXUBZ5DFRLOQOB4LOC7GA3HTWMEEE54U3DJRTL27RKKV4UWOIID3I4FU',
    '6DGJ4FUQP623YFFIZXXOJ7OK63VILGT2FDGYCYI62VW2767DRBZFDTRMI4','VOKX5CEPHTY6WJNZU4SQGCHCBK5MWNYXXIBUFQAMVTOCVP6VS6MFEEAFLM')
    and amount>0
    group by 2)
    , gen2_algo_volume as (select sum(amount),block_timestamp::date from flipside_prod_db.algorand.payment_transaction
    where receiver in ('ZI35SDCVSLRTKUQWCA6SXYX2VUKDJ5JJEWDMDH6ZYMXTQBQDAE6GWUEU6I','XIUCOQPPZO2UNFD2TXQAEW7W5MPGZROVD2YUOGME22GNORYCJVMEYK3P5U' ,
    'KPCXKFGBLR3WZN74BHG3RTKVOK6PW3UP53BHAYK7BLYDUCOTXJYKJU7JUY','AB4T4VD7LRGHH75Z3KISVPNDENGY4W227RPAJEBYUDVKVNF2PWDKMHTO4A',
    'VVCR4Q2GYOQO3ENWQDQEFFGTNDJRA56QIYHUQ3RCZT36I6WXBAUU2FS7QE','UFFXUBZ5DFRLOQOB4LOC7GA3HTWMEEE54U3DJRTL27RKKV4UWOIID3I4FU',
    '6DGJ4FUQP623YFFIZXXOJ7OK63VILGT2FDGYCYI62VW2767DRBZFDTRMI4','VOKX5CEPHTY6WJNZU4SQGCHCBK5MWNYXXIBUFQAMVTOCVP6VS6MFEEAFLM')
    and amount>0
    group by 2)
    , gen1_sales as (select count(1),block_timestamp::date from flipside_prod_db.algorand.payment_transaction
    where receiver='X5YPUJ2HTFBY66WKWZOAA75WST5V7HWAGS2346SQFK622VNIRQ5ASXHTGA'
    and amount>0
    group by 2)
    , gen1_algo_volume as (select sum(amount),block_timestamp::date from flipside_prod_db.algorand.payment_transaction
    where receiver='X5YPUJ2HTFBY66WKWZOAA75WST5V7HWAGS2346SQFK622VNIRQ5ASXHTGA'
    and amount>0
    group by 2)
    select * from gen2_wallet
    Run a query to Download Data