PREVIEW / stock_daily / 2009-12-31

all stock daily files

  file:    by_date/stock_daily/2009/2009-12-31.parquet
  size:    190 KB
  rows:    5,945
  symbols: 3,524

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2009-12-31	AAPL	Stock	7.6118	7.6196	7.52	7.5261	352410800.0
2009-12-31	MSFT	Stock	30.98	30.99	30.48	30.48	31929700.0
2009-12-31	NVDA	Stock	0.4678	0.4738	0.4665	0.467	700340000.0
2009-12-31	AMZN	Stock	6.8545	6.864	6.726	6.726	90460000.0
2009-12-31	TLT	Stock	89.76	90.11	89.05	89.89	3242447.0
2009-12-31	ES	Stock	26.4	26.42	25.79	25.79	774600.0
2009-12-31	CL	Stock	41.47	41.535	41.06	41.075	2650600.0
2009-12-31	A	Stock	22.2031	22.7253	22.1245	22.2246	5224606.0
2009-12-31	AABA-DELISTED	Stock	16.91	16.96	16.77	16.78	9113935.0
2009-12-31	AACC-DELISTED	Stock	6.77	6.92	6.7	6.78	25276.0
2009-12-31	AACG	Stock	4.4	4.54	4.4	4.47	4800.0
2009-12-31	AAI-DELISTED	Stock	5.2	5.3	5.18	5.23	1850941.0
2009-12-31	AAIC-DELISTED	Stock	15.14	15.24	15.02	15.23	12422.0
2009-12-31	AAME	Stock	1.25	1.28	1.15	1.28	4800.0
2009-12-31	AAON	Stock	3.9072	3.9309	3.8499	3.8499	267300.0
2009-12-31	AAP	Stock	41.11	41.11	40.48	40.48	894500.0
2009-12-31	AATI-DELISTED	Stock	3.83	3.98	3.77	3.92	378122.0
2009-12-31	AAU-DELISTED	Stock	1.06	1.07	1.0401	1.05	98061.0
2009-12-31	AAUAF-DELISTED	Stock	1.06	1.07	1.0401	1.05	101161.0
2009-12-31	AAV-DELISTED	Stock	6.63	6.69	6.49	6.55	595044.0
2009-12-31	AAWW-DELISTED	Stock	37.68	37.86	37.22	37.23	96838.0
2009-12-31	AAXJ	Stock	55.92	56.06	55.57	55.71	254666.0
2009-12-31	AAXN-DELISTED	Stock	4.4	4.43	4.32	4.38	399883.0
2009-12-31	AB	Stock	28.18	28.58	27.8	28.1	445800.0
2009-12-31	ABAX-DELISTED	Stock	25.57	25.86	25.51	25.55	91989.0
2009-12-31	ABB-DELISTED	Stock	19.29	19.42	19.12	19.12	1516394.0
2009-12-31	ABBC-DELISTED	Stock	6.88	6.94	6.88	6.9	52692.0
2009-12-31	ABBNY-DELISTED	Stock	19.29	19.42	19.1	19.1	1517994.0
2009-12-31	ABC-DELISTED	Stock	26.39	26.42	26.04	26.04	1461900.0
2009-12-31	ABCB	Stock	7.0519	7.2494	6.7359	7.0717	61863.0
2009-12-31	ABCD-DELISTED	Stock	3.85	4.21	3.7	4.21	57978.0
2009-12-31	ABCO-DELISTED	Stock	15.347	15.477	15.263	15.328	170421.0
2009-12-31	ABCW-DELISTED	Stock	0.64	0.66	0.63	0.63	124890.0
2009-12-31	ABD-DELISTED	Stock	7.54	7.64	7.27	7.28	199170.0
2009-12-31	ABE-DELISTED	Stock	16.69	16.69	16.4	16.58	13989.0
2009-12-31	ABEO	Stock	3937.5	4187.5	3875.0	4112.5	25.0
2009-12-31	ABFS-DELISTED	Stock	31.0	31.24	29.31	29.43	1586096.0
2009-12-31	ABG	Stock	11.77	12.01	11.51	11.53	159700.0
2009-12-31	ABII-DELISTED	Stock	40.74	43.0	39.92	40.55	78619.0
2009-12-31	ABK-DELISTED	Stock	0.8232	0.8298	0.81	0.8101	4390536.0
2009-12-31	ABM	Stock	20.93	21.12	20.62	20.66	87200.0
2009-12-31	ABMD-DELISTED	Stock	8.92	8.98	8.7	8.74	105589.0
2009-12-31	ABR	Stock	1.91	1.99	1.85	1.99	395400.0
2009-12-31	ABT	Stock	26.1347	26.2211	25.8804	25.9044	6238850.0
2009-12-31	ABTL-DELISTED	Stock	4.7339	5.0538	4.3656	5.0	21074.0
2009-12-31	ABV-DELISTED	Stock	102.35	102.35	100.9999	101.25	151294.0
2009-12-31	ABVA-DELISTED	Stock	2.75	3.35	2.6	2.85	22781.0
2009-12-31	ABVT-DELISTED	Stock	65.0	66.0	64.78	64.92	136994.0
2009-12-31	ABX-DELISTED	Stock	39.94	40.2	39.38	39.39	5872747.0
2009-12-31	ACAD	Stock	1.26	1.32	1.25	1.32	598900.0

> showing 50 of 5,945 rows — these rows as CSV

> unlock the full archive -- $79 one-time