Elprognerdosmo airdrop
Updated 2022-11-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
CASE WHEN currency = 'uosmo' THEN 'OSMO' END AS token_type,
sum(amount/pow(10,DECIMAL)) AS total_amount,
COUNT(tx_id) AS total_txs,
COUNT(DISTINCT sender) AS total_claimers
FROM osmosis.core.fact_airdrop
WHERE currency = 'uosmo' AND TX_STATUS='SUCCEEDED' AND TRANSFER_TYPE='AIRDROP'
GROUP BY 1
UNION
SELECT
CASE WHEN currency = 'uion' THEN 'ION' END AS token_type,
sum(amount/pow(10,DECIMAL)) AS total_amount,
COUNT(tx_id) AS total_txs,
COUNT(DISTINCT sender) AS total_claimers
FROM osmosis.core.fact_airdrop
WHERE currency = 'uion' AND TX_STATUS='SUCCEEDED' AND TRANSFER_TYPE='AIRDROP'
GROUP BY 1
Run a query to Download Data