A data platform for investment research

Query current market datasets for free.

Popular Tables

Table Queries
stocks.stock_price_history_daily 280
real_estate.freddie_mac_house_price_index 115
stocks.s_and_p_500 67
stocks.nasdaq_listed 57
stocks.stock_price 39
commodities.oil_brent_daily 31
crypto.fact_coin_price_history 23
commodities.oil_wti_daily 19
stocks.company 19
real_estate.user_test 1

Top Queries

SQL Executions
SELECT n.symbol, n.company_name FROM stocks.nasdaq... 44
SELECT count(*) FROM stocks.stock_price_history_da... 19
SELECT * FROM stocks.stock_price_history_daily lim... 16
SELECT * FROM stocks.s_and_p_500 limit 10; 15
show databases; 11
SELECT * FROM stocks.company limit 10; 10
SELECT symbol, max(date) FROM stocks.stock_price_h... 9
SELECT symbol, count(*) FROM stocks.stock_price_hi... 9
show tables FROM commodities; 9
SELECT * FROM stocks.stock_price limit 10; 8
SELECT * FROM commodities.oil_brent_daily limit 10... 8
SELECT * FROM commodities.oil_brent_daily; 8
SELECT date, close as 'UBER' FROM stocks.stock_pri... 7
SELECT max(date) FROM stocks.stock_price_history_d... 6
SELECT a.date, uber, apple FROM (SELECT date, clos... 6
SELECT count(*) FROM stocks.stock_price_history_da... 6
SELECT * FROM crypto.fact_coin_price_history limit... 6
SELECT * FROM `stocks`.`stock_price_history_daily`... 6
SELECT * FROM real_estate.freddie_mac_house_price_... 6
SELECT * FROM stocks.stock_price_history_daily WHE... 6

Common Joins

Table1 Table2 Queries
stocks.nasdaq_listed stocks.s_and_p_500 44
stocks.s_and_p_500 stocks.stock_price 3

Recent Queries

SQL
SELECT u.date, u.close as 'UBER', g.close as 'GOOG... 1 day ago
SELECT concat(year, '-', month) as date, index_nsa... Feb 9
SELECT * FROM crypto.fact_coin_price_history WHERE... Nov 16, 24
SELECT max(high) FROM crypto.fact_coin_price_histo... Nov 16, 24
SELECT * FROM crypto.fact_coin_price_history WHERE... Nov 16, 24
SELECT * FROM crypto.fact_coin_price_history WHERE... Nov 16, 24
SELECT max(high) FROM crypto.fact_coin_price_histo... Nov 16, 24
SELECT * FROM crypto.fact_coin_price_history limit... Nov 16, 24
SELECT * FROM crypto.fact_coin_price_history limit... Nov 16, 24
SELECT * FROM stocks.stock_price sp join stocks.s_... Nov 16, 24