with base1 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-04-12' group by 1,2,3), base14 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base1) and block_timestamp <= '2022-04-12' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base1) and block_timestamp <= '2022-04-12'), base15 as (select mint, max(block_timestamp) as latest_transfer from base14 group by 1), base16 as (select latest_transfer, nft_owner, a.mint, sum_locked from base15 a join base14 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base1 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base1), base17 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base16 where mint is not null group by 2), base18 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base16 a join base17 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base13 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-04-12' group by 1,2,3 ), vote1 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base18 a left join base13 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_1 as (select count(distinct(signers)) as holder_vote1 from vote1), base2 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-05-03' group by 1,2,3), base24 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base2) and block_timestamp <= '2022-05-03' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base2) and block_timestamp <= '2022-05-03'), base25 as (select mint, max(block_timestamp) as latest_transfer from base24 group by 1), base26 as (select latest_transfer, nft_owner, a.mint, sum_locked from base25 a join base24 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base2 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base2), base27 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base26 where mint is not null group by 2), base28 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base26 a join base27 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base23 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-05-03' group by 1,2,3 ), vote2 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base28 a left join base23 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_2 as (select count(distinct(signers)) as holder_vote2 from vote2), base3 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-05-08' group by 1,2,3), base34 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base3) and block_timestamp <= '2022-05-08' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base3) and block_timestamp <= '2022-05-08'), base35 as (select mint, max(block_timestamp) as latest_transfer from base34 group by 1), base36 as (select latest_transfer, nft_owner, a.mint, sum_locked from base35 a join base34 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base3 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base3), base37 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base36 where mint is not null group by 2), base38 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base36 a join base37 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base33 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-05-08' group by 1,2,3 ), vote3 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base38 a left join base33 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_3 as (select count(distinct(signers)) as holder_vote3 from vote3), base4 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-06-12' group by 1,2,3), base44 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base4) and block_timestamp <= '2022-06-12' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base4) and block_timestamp <= '2022-06-12'), base45 as (select mint, max(block_timestamp) as latest_transfer from base44 group by 1), base46 as (select latest_transfer, nft_owner, a.mint, sum_locked from base45 a join base44 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base4 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base4), base47 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base46 where mint is not null group by 2), base48 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base46 a join base47 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base43 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-06-12' group by 1,2,3 ), vote4 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base48 a left join base43 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_4 as (select count(distinct(signers)) as holder_vote4 from vote4), base5 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-06-20' group by 1,2,3), base54 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base5) and block_timestamp <= '2022-06-20' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base5) and block_timestamp <= '2022-06-20'), base55 as (select mint, max(block_timestamp) as latest_transfer from base54 group by 1), base56 as (select latest_transfer, nft_owner, a.mint, sum_locked from base55 a join base54 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base5 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base5), base57 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base56 where mint is not null group by 2), base58 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base56 a join base57 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base53 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-06-20' group by 1,2,3 ), vote5 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base58 a left join base53 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_5 as (select count(distinct(signers)) as holder_vote5 from vote5), base6 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-07-23' group by 1,2,3), base64 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base6) and block_timestamp <= '2022-07-23' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base6) and block_timestamp <= '2022-07-23'), base65 as (select mint, max(block_timestamp) as latest_transfer from base64 group by 1), base66 as (select latest_transfer, nft_owner, a.mint, sum_locked from base65 a join base64 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base6 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base6), base67 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base66 where mint is not null group by 2), base68 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base66 a join base67 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base63 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-07-23' group by 1,2,3 ), vote6 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base68 a left join base63 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_6 as (select count(distinct(signers)) as holder_vote6 from vote6), base7 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-08-05' group by 1,2,3), base74 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base7) and block_timestamp <= '2022-08-05' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base7) and block_timestamp <= '2022-08-05'), base75 as (select mint, max(block_timestamp) as latest_transfer from base74 group by 1), base76 as (select latest_transfer, nft_owner, a.mint, sum_locked from base75 a join base74 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base7 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base7), base77 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base76 where mint is not null group by 2), base78 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base76 a join base77 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base73 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-08-05' group by 1,2,3 ), vote7 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base78 a left join base73 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_7 as (select count(distinct(signers)) as holder_vote7 from vote7), base8 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-09-10' group by 1,2,3), base84 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base8) and block_timestamp <= '2022-09-10' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base8) and block_timestamp <= '2022-09-10'), base85 as (select mint, max(block_timestamp) as latest_transfer from base84 group by 1), base86 as (select latest_transfer, nft_owner, a.mint, sum_locked from base85 a join base84 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base8 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base8), base87 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base86 where mint is not null group by 2), base88 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base86 a join base87 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base83 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-09-10' group by 1,2,3 ), vote8 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base88 a left join base83 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_8 as (select count(distinct(signers)) as holder_vote8 from vote8), base9 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-09-10' group by 1,2,3), base94 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base9) and block_timestamp <= '2022-09-10' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base9) and block_timestamp <= '2022-09-10'), base95 as (select mint, max(block_timestamp) as latest_transfer from base94 group by 1), base96 as (select latest_transfer, nft_owner, a.mint, sum_locked from base95 a join base94 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base9 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base9), base97 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base96 where mint is not null group by 2), base98 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base96 a join base97 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base93 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-09-10' group by 1,2,3 ), vote9 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base98 a left join base93 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_9 as (select count(distinct(signers)) as holder_vote9 from vote9), base_10 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-09-21' group by 1,2,3), base_104 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_10) and block_timestamp <= '2022-09-21' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_10) and block_timestamp <= '2022-09-21'), base_105 as (select mint, max(block_timestamp) as latest_transfer from base_104 group by 1), base_106 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_105 a join base_104 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_10 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_10), base_107 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_106 where mint is not null group by 2), base_108 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_106 a join base_107 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_103 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-09-21' group by 1,2,3 ), vote_10 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_108 a left join base_103 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_10 as (select count(distinct(signers)) as holder_vote_10 from vote_10), base_11 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-09-25' group by 1,2,3), base_114 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_11) and block_timestamp <= '2022-09-25' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_11) and block_timestamp <= '2022-09-25'), base_115 as (select mint, max(block_timestamp) as latest_transfer from base_114 group by 1), base_116 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_115 a join base_114 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_11 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_11), base_117 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_116 where mint is not null group by 2), base_118 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_116 a join base_117 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_113 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-09-25' group by 1,2,3 ), vote_11 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_118 a left join base_113 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_11 as (select count(distinct(signers)) as holder_vote_11 from vote_11), base_12 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-09-25' group by 1,2,3), base_124 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_12) and block_timestamp <= '2022-09-25' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_12) and block_timestamp <= '2022-09-25'), base_125 as (select mint, max(block_timestamp) as latest_transfer from base_124 group by 1), base_126 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_125 a join base_124 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_12 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_12), base_127 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_126 where mint is not null group by 2), base_128 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_126 a join base_127 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_123 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-09-25' group by 1,2,3 ), vote_12 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_128 a left join base_123 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_12 as (select count(distinct(signers)) as holder_vote_12 from vote_12), base_13 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-10-09' group by 1,2,3), base_134 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_13) and block_timestamp <= '2022-10-09' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_13) and block_timestamp <= '2022-10-09'), base_135 as (select mint, max(block_timestamp) as latest_transfer from base_134 group by 1), base_136 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_135 a join base_134 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_13 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_13), base_137 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_136 where mint is not null group by 2), base_138 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_136 a join base_137 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_133 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-10-09' group by 1,2,3 ), vote_13 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_138 a left join base_133 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_13 as (select count(distinct(signers)) as holder_vote_13 from vote_13), base_14 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-10-15' group by 1,2,3), base_144 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_14) and block_timestamp <= '2022-10-15' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_14) and block_timestamp <= '2022-10-15'), base_145 as (select mint, max(block_timestamp) as latest_transfer from base_144 group by 1), base_146 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_145 a join base_144 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_14 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_14), base_147 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_146 where mint is not null group by 2), base_148 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_146 a join base_147 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_143 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-10-15' group by 1,2,3 ), vote_14 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_148 a left join base_143 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_14 as (select count(distinct(signers)) as holder_vote_14 from vote_14), base_15 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-10-15' group by 1,2,3), base_154 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_15) and block_timestamp <= '2022-10-15' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_15) and block_timestamp <= '2022-10-15'), base_155 as (select mint, max(block_timestamp) as latest_transfer from base_154 group by 1), base_156 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_155 a join base_154 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_15 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_15), base_157 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_156 where mint is not null group by 2), base_158 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_156 a join base_157 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_153 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-10-15' group by 1,2,3 ), vote_15 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_158 a left join base_153 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_15 as (select count(distinct(signers)) as holder_vote_15 from vote_15), base_16 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-10-21' group by 1,2,3), base_164 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_16) and block_timestamp <= '2022-10-21' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_16) and block_timestamp <= '2022-10-21'), base_165 as (select mint, max(block_timestamp) as latest_transfer from base_164 group by 1), base_166 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_165 a join base_164 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_16 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_16), base_167 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_166 where mint is not null group by 2), base_168 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_166 a join base_167 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_163 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-10-21' group by 1,2,3 ), vote_16 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_168 a left join base_163 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_16 as (select count(distinct(signers)) as holder_vote_16 from vote_16), base_17 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-10-22' group by 1,2,3), base_174 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_17) and block_timestamp <= '2022-10-22' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_17) and block_timestamp <= '2022-10-22'), base_175 as (select mint, max(block_timestamp) as latest_transfer from base_174 group by 1), base_176 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_175 a join base_174 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_17 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_17), base_177 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_176 where mint is not null group by 2), base_178 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_176 a join base_177 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_173 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-10-22' group by 1,2,3 ), vote_17 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_178 a left join base_173 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_17 as (select count(distinct(signers)) as holder_vote_17 from vote_17), base_18 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-10-23' group by 1,2,3), base_184 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_18) and block_timestamp <= '2022-10-23' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_18) and block_timestamp <= '2022-10-23'), base_185 as (select mint, max(block_timestamp) as latest_transfer from base_184 group by 1), base_186 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_185 a join base_184 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_18 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_18), base_187 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_186 where mint is not null group by 2), base_188 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_186 a join base_187 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_183 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-10-23' group by 1,2,3 ), vote_18 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_188 a left join base_183 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_18 as (select count(distinct(signers)) as holder_vote_18 from vote_18), base_19 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-12-08' group by 1,2,3), base_194 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_19) and block_timestamp <= '2022-12-08' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_19) and block_timestamp <= '2022-12-08'), base_195 as (select mint, max(block_timestamp) as latest_transfer from base_194 group by 1), base_196 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_195 a join base_194 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_19 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_19), base_197 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_196 where mint is not null group by 2), base_198 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_196 a join base_197 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_193 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-12-08' group by 1,2,3 ), vote_19 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_198 a left join base_193 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_19 as (select count(distinct(signers)) as holder_vote_19 from vote_19), base_20 as (select date_trunc('day', block_timestamp) as day, signer, locker_nft, sum(amount) as sum_locked from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action in ('MINT LOCK', 'UPDATE LOCK') and succeeded = 'TRUE' and block_timestamp <= '2022-12-10' group by 1,2,3), base_204 as (select block_timestamp, mint, purchaser as nft_owner from solana.core.fact_nft_sales where succeeded = 'TRUE' and mint in (select locker_nft from base_20) and block_timestamp <= '2022-12-10' union select block_timestamp, mint, tx_to from solana.core.fact_transfers where mint in (select locker_nft from base_20) and block_timestamp <= '2022-12-10'), base_205 as (select mint, max(block_timestamp) as latest_transfer from base_204 group by 1), base_206 as (select latest_transfer, nft_owner, a.mint, sum_locked from base_205 a join base_204 b on a.mint = b.mint and a.latest_transfer = b.block_timestamp join base_20 c on a.mint = c.locker_nft UNION select day, signer, locker_nft, sum_locked from base_20), base_207 as (select max(latest_transfer) as latest_transfer_date, mint as locker_nft from base_206 where mint is not null group by 2), base_208 as (select latest_transfer_date, locker_nft, sum_locked, nft_owner from base_206 a join base_207 b on a.latest_transfer = b.latest_transfer_date and a.mint = b.locker_nft), base_203 as (select block_timestamp as burn_date, signer, locker_nft, sum(amount) as sum_burned from solana.core.fact_gov_actions where mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' and program_name = 'marinade' and action = 'EXIT' and succeeded = 'TRUE' and block_timestamp <= '2022-12-10' group by 1,2,3 ), vote_20 as (select a.nft_owner as signers, a.locker_nft, ifnull(sum_locked, 0) as sum_lockedz, ifnull(sum_burned,0) as sum_burnedz, sum_lockedz - sum_burnedz as net_mnde_locked, case when net_mnde_locked >= 1000 and net_mnde_locked <= 4999 then 'Level 1 NFT: 1K - 4.999K' when net_mnde_locked >= 5000 and net_mnde_locked <= 24999 then 'Level 2 NFT: 5K - 24.999K' when net_mnde_locked >= 25000 and net_mnde_locked <= 99999 then 'Level 3 NFT: 25K - 99.999K' when net_mnde_locked >= 100000 and net_mnde_locked <= 249999 then 'Level 4 NFT: 100K - 249.999K' when net_mnde_locked >= 250000 then 'Level 5 NFT: 250K +' end as levels, 1 as n from base_208 a left join base_203 b on a.nft_owner = b.signer and a.locker_nft = b.locker_nft where a.locker_nft is not null and net_mnde_locked > 0), holder_20 as (select count(distinct(signers)) as holder_vote_20 from vote_20), proposals as (select proposal, max(block_timestamp) as latest_vote, count(distinct(voter)) as count_voter, row_number() over (order by latest_vote asc) as proposal_num from solana.core.fact_proposal_votes where program_name = 'marinade' and succeeded = 'TRUE' group by 1), base11 as (select *, '1' as proposal_num from holder_1 union select *, '2' from holder_2 union select *, '3' from holder_3 union select *, '4' from holder_4 union select *, '5' from holder_5 union select *, '6' from holder_6 union select *, '7' from holder_7 union select *, '8' from holder_8 union select *, '9' from holder_9 union select *, '10' from holder_10 union select *, '11' from holder_11 union select *, '12' from holder_12 union select *, '13' from holder_13 union select *, '14' from holder_14 union select *, '15' from holder_15 union select *, '16' from holder_16 union select *, '17' from holder_17 union select *, '18' from holder_18 union select *, '19' from holder_19 union select *, '20' from holder_20) select a.proposal_num, case when a.proposal_num = 1 then 'Proposal 0001' when a.proposal_num = 2 then 'Proposal 0002' when a.proposal_num = 3 then 'Proposal 0005' when a.proposal_num = 4 then 'Proposal 0007' when a.proposal_num = 5 then 'Proposal 0008' when a.proposal_num = 6 then 'Proposal 0009' when a.proposal_num = 7 then 'Proposal 0010' when a.proposal_num = 8 then 'Proposal 0011' when a.proposal_num = 9 then 'Proposal 0012' when a.proposal_num = 10 then 'Proposal 0013' when a.proposal_num = 11 then 'Proposal 0016' when a.proposal_num = 12 then 'Proposal 0017' when a.proposal_num = 13 then 'Proposal 0018' when a.proposal_num = 14 then 'Proposal 0020' when a.proposal_num = 15 then 'Proposal 0021' when a.proposal_num = 16 then 'Proposal 0022' when a.proposal_num = 17 then 'Proposal 0024' when a.proposal_num = 18 then 'Proposal 0025' when a.proposal_num = 19 then 'Proposal 0027' when a.proposal_num = 20 then 'Proposal 0028' end as proposal_names, holder_vote1 as eligible_voters, count_voter as count_voters, count_voter/eligible_voters * 100 as participation_rate from proposals a join base11 b on a.proposal_num = b.proposal_num

Marinade Governance