KaskoazulCopy of Daily Price Metrics for ASTRO
Updated 2022-01-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- SUBMISSION FOR 'Lockdrops Keep Fallin' On My Head' Terrabounty
-- Explain, in your own words, what a “lockdrop” is.
-- Imagine you join a company and the company offers you a small portion of their publicly traded shares.
-- The company holds the shares under your name but you can't sell them until you've completed working there for a specific time.
-- This incentivizes you to work harder to make the company grow in turn making the share prices rise and making you wealthier by the time you get to access those shares.
-- Lockdrops have a similar concept wherein newer cryptocurrencies wish to grow an active userbase without the risk of quick sellers.
-- Unlike airdropping(randomly sending tokens) lockdropping assigns tokens for completion of a small task but does not allow you to make swaps or cash out for a specific time period.
-- This incentivizes the token holder to work towards the awareness and growth of the currency while preventing cashouts and swaps during that time period..
-- Choose a metric for ASTRO tokens (price, circulating supply, amount sold vs. HODL) and display it visually over a time period
SELECT DATE(hour) AS date_, MAX(price) AS Max_Price, MIN(price) AS Min_Price, AVG(price) AS Average_Price, Symbol
FROM ethereum.token_prices_hourly
WHERE symbol LIKE 'ASTRO' and YEAR(hour)>=2021 -- selecting astrotokens and time period as 2021 to present
GROUP BY DATE(hour)
ORDER BY DATE(hour) desc;
Run a query to Download Data