Ask questions like:
SELECT ticker, enterprise_value FROM profile WHERE ticker IN ('NVDA','AAPL','MSFT','GOOGL') ORDER BY ticker
SELECT period_label, ticker, revenue_growth FROM financials WHERE ticker IN ('TSLA','META','GOOGL','IBM','TSLA','^GSPC') AND horizon='quarter' AND period_label='2022-Q1' ORDER BY ticker
Select date, ticker, adjusted_close FROM prices WHERE ticker IN ('XOM','CVX', 'CLUSD') AND date > (CURRENT_DATE - INTERVAL 3 year) ORDER BY date
WITH days AS (SELECT now.year, now.ticker, now.date date_reported, now.adjusted_close price_now, prices.adjusted_close price_later, now.change_intraday, prices.date later_date, row_number() over (partition by prices.ticker, now.date order by prices.date asc ) as rn from prices now
join prices on now.ticker=prices.ticker and prices.date > now.date+ INTERVAL 1 year where now.ticker='AAPL' and now.change_intraday<-0.05 and now.year>2012)
select ticker, date_reported, change_intraday, (price_later-price_now)/price_now value from days where rn=1 order by date_reported desc
SELECT date, ticker, adjusted_close FROM prices WHERE ticker IN ('NFLX','AMZN') AND weekly='True' AND date > (CURRENT_DATE - INTERVAL 3 year) ORDER BY date