nsa2000Luna market cap
Updated 2022-10-07
9
1
2
3
4
5
6
7
8
›
⌄
SELECT date_trunc( 'day', date ) AS date,
sum( CASE WHEN currency = 'LUNA' THEN balance_usd END ) AS marketcap
FROM terra.classic.dim_daily_balances
WHERE date >= '2022-05-15'
AND balance > 0
and address != 'terra1gr0xesnseevzt3h4nxr64sh5gk4dwrwgszx3nw' and address != 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6' and address !='terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh' and address != 'terra1wqmfu6w725sal3nvr0ggy49mmtwqgc6tyf4anp' and address != 'terra1jgp27m8fykex4e4jtt0l7ze8q528ux2lh4zh0f' and address != 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts' and address != 'terra1jv65s3grqf6v6jl3dp4t6c9t9rk99cd8pm7utl' and address != 'terra1tygms3xhhs3yv487phx3dw4a95jn7t7l8l07dr' /*and address_label_subtype != 'mints_burns'*/ and currency = 'LUNA'
GROUP BY DATE
order by 1 asc
Run a query to Download Data