freemartianTotal LVN Airdrop
Updated 2024-03-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH airdrop AS (
SELECT
block_timestamp,
tx_id,
msg:contract AS contract,
msg:sender AS sender,
value:addr AS address,
value:coins[0]:amount AS raw_amount,
(value:coins[0]:amount)/pow(10,6) AS amount,
value:coins[0]:denom AS token
FROM osmosis.core.fact_tx_body_msgs, LATERAL FLATTEN (input => msg:msg:transfer:recipients)
WHERE sender = 'osmo1qrwt8r63jks74ykgq7d28fvy6msd2dpgz8zxaj'
ORDER BY amount DESC
)
SELECT
SUM(amount) AS "LVN amount",
count(address) AS receivers
FROM airdrop
QueryRunArchived: QueryRun has been archived