MLDZMN$VEXT holders on Ethereum
Updated 2023-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from $HXRO holders on Ethereum @ https://flipsidecrypto.xyz/edit/queries/e44a4d6f-cee5-4cbd-b9aa-8fcfd62aeac0
with price_tab as (SELECT
max(HOUR) as latest_hour,
avg(PRICE) as token_price
from ethereum.price.fact_hourly_token_prices
where TOKEN_ADDRESS = lower('0xB2492E97a68a6E4B9E9a11B99F6C42E5aCCD38c7')
and PROVIDER='coinmarketcap'
)
select
distinct USER_ADDRESS as Wallet,
round(CURRENT_BAL,2) as "VEXT Balance",
round(CURRENT_BAL/1062588 * 100, 3) as "(%) of Supply"
from ethereum.core.ez_current_balances,price_tab
where CONTRACT_ADDRESS = lower('0xB2492E97a68a6E4B9E9a11B99F6C42E5aCCD38c7')
order by "VEXT Balance" desc
Run a query to Download Data