scottincryptoDBT General Airdrop Emissions Query Progress Saver
Updated 2021-11-22
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Sequence generator
with seq as (
select
row_number() over (order by seq4()) as num
from table(generator(rowcount => 500))
)
--, pre_label as (
-- Mirror Genesis airdrop on Terra
select
'terra' as blockchain
, 'mirror' as protocol_label
, 'terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw' as airdrop_contract
, 'mirror_terra_airdrop' as airdrop_contract_label
, 'terra15gwkyepfc6xgca5t5zefzwy42uts8l2m4g40k6' as airdrop_token_contract
, 'MIR' as airdrop_token_symbol
, 'genesis_luna_staker' as airdrop_label
, 1 as stage
-- , 1 as total_stages
, 820000 as block_height
, 9150000 as airdrop_emissions
union all
-- Mirror weekly airdrop on Terra
select
'terra' as blockchain
, 'mirror' as protocol_label
, 'terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw' as airdrop_contract
, 'mirror_terra_airdrop' as airdrop_contract_label
, 'terra15gwkyepfc6xgca5t5zefzwy42uts8l2m4g40k6' as airdrop_token_contract
, 'MIR' as airdrop_token_symbol
, 'weekly_luna_staker' as airdrop_label
, num as stage
, 820000 + (num - 1) * 100000 as block_height
, 345283 as airdrop_emissions
Run a query to Download Data