maybeyonasairdrop_laddies
    Updated 2022-07-07
    with airdrop_claims as(
    select
    block_timestamp,
    claimer,
    amount,
    -- contract_address,
    case contract_address
    when 'terra1s2yuugawj98gkpy6h9ua7ppss94sqgw2r7tyma' then 'stt' ---vesting public'
    when 'terra1ld47cz4t7gpt7ux4llee3le75y4rhqksw6xfpa' then 'stt' --vesting marketing'
    when 'terra1268e62h8r0fcr2nt0kplxp8jx5qalwq73a5fuk' then 'stt' --vesting private/seed'
    when 'terra1ud39n6c42hmtp2z0qmy8svsk7z3zmdkxzfwcf2' then 'pylon'
    when 'terra1s5ww3afj9ym9k5ceu5m3xmea0t9tl7fmh7r40h' then 'valkyrie'
    when 'terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw' then 'mirror'
    -- when terra1lwkmcfdwfyxq4hk0laty4l9xrp9mauxgt3ekr7 then 'anc i guess' -- not used now i guess
    when 'terra146ahqn6d3qgdvmj8cj96hh03dzmeedhsf0kxqm' then 'anchor'
    when 'terra1atch4d5t25csx7ranccl48udq94k57js6yh0vk' then 'loop' -- i guess'
    when 'terra1992lljnteewpz0g398geufylawcmmvgh8l8v96' then 'psi'
    when 'terra12k0p3qvfhy6j5e3ef8kzusy29lzwykk5d95kk5' then 'psi'
    end as airdrop_name,
    case contract_address
    when 'terra1s2yuugawj98gkpy6h9ua7ppss94sqgw2r7tyma' then 'terra13xujxcrc9dqft4p9a8ls0w3j0xnzm6y2uvve8n' ---stt vesting public'
    when 'terra1ld47cz4t7gpt7ux4llee3le75y4rhqksw6xfpa' then 'terra13xujxcrc9dqft4p9a8ls0w3j0xnzm6y2uvve8n' --stt vesting marketing'
    when 'terra1268e62h8r0fcr2nt0kplxp8jx5qalwq73a5fuk' then 'terra13xujxcrc9dqft4p9a8ls0w3j0xnzm6y2uvve8n' --stt vesting private/seed'
    when 'terra1ud39n6c42hmtp2z0qmy8svsk7z3zmdkxzfwcf2' then 'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' -- mine
    when 'terra1s5ww3afj9ym9k5ceu5m3xmea0t9tl7fmh7r40h' then 'terra1dy9kmlm4anr92e42mrkjwzyvfqwz66un00rwr5' -- vkr
    when 'terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw' then 'terra15gwkyepfc6xgca5t5zefzwy42uts8l2m4g40k6' -- mir
    -- when terra1lwkmcfdwfyxq4hk0laty4l9xrp9mauxgt3ekr7 then 'anc i guess' -- not used now i guess
    when 'terra146ahqn6d3qgdvmj8cj96hh03dzmeedhsf0kxqm' then 'terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76' --anc
    when 'terra1atch4d5t25csx7ranccl48udq94k57js6yh0vk' then 'terra1nef5jf6c7js9x6gkntlehgywvjlpytm7pcgkn4' -- loop
    when 'terra1992lljnteewpz0g398geufylawcmmvgh8l8v96' then 'terra12897djskt9rge8dtmm86w654g7kzckkd698608' --psi
    Run a query to Download Data