A data platform for investment research

Query current market datasets for free.

Popular Tables

Table Queries
stocks.stock_price_history_daily 278
real_estate.freddie_mac_house_price_index 112
stocks.s_and_p_500 66
stocks.nasdaq_listed 57
stocks.stock_price 38
commodities.oil_brent_daily 31
stocks.company 19
commodities.oil_wti_daily 19
crypto.fact_coin_price_history 11
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, count(*) FROM stocks.stock_price_hi... 9
SELECT symbol, max(date) FROM stocks.stock_price_h... 9
show tables FROM commodities; 9
SELECT * FROM commodities.oil_brent_daily limit 10... 8
SELECT * FROM commodities.oil_brent_daily; 8
SELECT * FROM stocks.stock_price limit 10; 8
SELECT date, close as 'UBER' FROM stocks.stock_pri... 7
SELECT * FROM real_estate.freddie_mac_house_price_... 6
SELECT count(*) FROM stocks.stock_price_history_da... 6
SELECT a.date, uber, apple FROM (SELECT date, clos... 6
SELECT * FROM `stocks`.`stock_price_history_daily`... 6
SELECT * FROM stocks.stock_price_history_daily WHE... 6
show tables FROM stocks; 6
SELECT max(date) FROM stocks.stock_price_history_d... 6

Common Joins

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

Recent Queries

SQL
with loc_1 as (SELECT cast(datestr_start as date) ... Sep 29
SELECT count(*) FROM crypto.fact_coin_price_histor... Sep 14
SELECT count(*) FROM crypto.fact_coin_price_histor... Sep 10
SELECT * FROM crypto.fact_coin_price_history limit... Sep 9
SELECT * FROM crypto.fact_coin_price_history limit... Sep 9
SELECT * FROM crypto.fact_coin_price_history limit... Sep 9
SELECT count(*) FROM crypto.fact_coin_price_histor... Sep 9
SELECT count(*) FROM crypto.fact_coin_price_histor... Sep 9
SELECT count(*) FROM crypto.fact_coin_price_histor... Sep 8
SELECT * FROM crypto.fact_coin_price_history; Sep 8