theericstonegovernance__n_projects_staked
Updated 2021-11-12
99
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
›
⌄
-- supporting ANC, MINE, LOOP, MIR, PSI, VKR, STT
-- This is a collection of relavant token details for each token that we use below
WITH token_details as (
(
select
'terra1f32xyep306hhcxxxf7mlyh0ucggc00rm2s9da5' as staking_contract,
'terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76' as token_contract,
'ANC' as token
)
union
(
select
'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' as staking_contract,
'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' as token_contract,
'MINE' as token
)
union
(
select
-- LOOP has no staking contract yet
'none' as staking_contract,
'terra1nef5jf6c7js9x6gkntlehgywvjlpytm7pcgkn4' as token_contract,
'LOOP' as token
)
union
(
select
'terra1w6xf64nlmy3fevmmypx6w2fa34ue74hlye3chk' as staking_contract,
'terra1dy9kmlm4anr92e42mrkjwzyvfqwz66un00rwr5' as token_contract,
'VKR' as token
)
union
(
select
'terra1wh39swv7nq36pnefnupttm2nr96kz7jjddyt2x' as staking_contract,
'terra15gwkyepfc6xgca5t5zefzwy42uts8l2m4g40k6' as token_contract,
Run a query to Download Data