PREVIEW / stock_daily / 2012-10-03

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-03.parquet
  size:    199 KB
  rows:    6,138
  symbols: 3,471

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
2012-10-03	AAPL	Stock	23.745	23.995	23.6654	23.9804	424281200.0
2012-10-03	MSFT	Stock	29.75	29.99	29.67	29.86	46655900.0
2012-10-03	NVDA	Stock	0.33	0.331	0.3243	0.326	430872000.0
2012-10-03	AMZN	Stock	12.5605	12.805	12.478	12.796	54912000.0
2012-10-03	META	Stock	22.3	22.49	21.8	21.83	32000100.0
2012-10-03	TSLA	Stock	1.9833	1.9967	1.9493	1.9533	15792000.0
2012-10-03	TLT	Stock	123.86	124.3	123.62	124.29	3800831.0
2012-10-03	ES	Stock	38.74	38.91	38.67	38.84	1307400.0
2012-10-03	CL	Stock	54.02	54.22	53.785	54.015	2630600.0
2012-10-03	A	Stock	27.897	28.1116	27.6252	27.8827	3500173.0
2012-10-03	AABA-DELISTED	Stock	16.0	16.24	15.99	16.22	20155919.0
2012-10-03	AACC-DELISTED	Stock	7.43	7.54	7.28	7.34	13982.0
2012-10-03	AACG	Stock	5.6	5.65	5.45	5.45	5300.0
2012-10-03	AAIC-DELISTED	Stock	24.15	24.15	23.901	23.97	168711.0
2012-10-03	AAME	Stock	2.75	2.79	2.57	2.78	20900.0
2012-10-03	AAMRQ-DELISTED	Stock	0.3915	0.398	0.3875	0.39	618857.0
2012-10-03	AAON	Stock	5.7067	5.7748	5.6296	5.7481	192038.0
2012-10-03	AAP	Stock	68.9	69.05	68.05	68.13	455300.0
2012-10-03	AAT	Stock	27.22	27.65	27.17	27.57	190700.0
2012-10-03	AAU-DELISTED	Stock	2.58	2.59	2.5	2.51	96020.0
2012-10-03	AAUAF-DELISTED	Stock	2.58	2.59	2.5	2.51	96220.0
2012-10-03	AAV-DELISTED	Stock	4.09	4.09	3.94	4.03	297925.0
2012-10-03	AAWW-DELISTED	Stock	50.99	51.63	50.35	51.23	286619.0
2012-10-03	AAXJ	Stock	57.06	57.06	56.53	56.79	306175.0
2012-10-03	AAXN-DELISTED	Stock	6.06	6.06	5.81	5.92	980973.0
2012-10-03	AB	Stock	15.41	15.6	15.26	15.57	341500.0
2012-10-03	ABAC-DELISTED	Stock	1.55	1.58	1.52	1.58	2100.0
2012-10-03	ABAX-DELISTED	Stock	37.73	37.9808	36.99	37.69	122743.0
2012-10-03	ABB-DELISTED	Stock	19.17	19.18	18.935	19.0	1917419.0
2012-10-03	ABBNY-DELISTED	Stock	19.16	19.18	18.935	19.01	2024910.0
2012-10-03	ABC-DELISTED	Stock	39.05	39.22	38.86	39.07	2041967.0
2012-10-03	ABCB	Stock	12.57	12.66	12.38	12.53	23600.0
2012-10-03	ABCD-DELISTED	Stock	1.0156	1.0157	0.9813	0.99	1417.0
2012-10-03	ABCO-DELISTED	Stock	48.22	48.48	47.69	48.07	133952.0
2012-10-03	ABCW-DELISTED	Stock	0.385	0.4	0.36	0.38	19960.0
2012-10-03	ABE-DELISTED	Stock	20.84	20.84	20.7	20.772	1980.0
2012-10-03	ABEO	Stock	525.0	525.0	525.0	525.0	5.0
2012-10-03	ABFS-DELISTED	Stock	7.57	7.69	7.435	7.6001	286171.0
2012-10-03	ABG	Stock	28.27	29.12	28.21	28.58	392700.0
2012-10-03	ABM	Stock	19.08	19.15	18.91	18.97	356200.0
2012-10-03	ABMD-DELISTED	Stock	20.91	21.0178	20.41	20.63	498726.0
2012-10-03	ABR	Stock	6.1	6.12	6.0	6.06	28000.0
2012-10-03	ABT	Stock	32.991	33.5812	32.8951	33.5044	19096290.0
2012-10-03	ABTL-DELISTED	Stock	3.71	3.85	3.51	3.73	97267.0
2012-10-03	ABUS	Stock	3.72	3.72	3.49	3.6	73000.0
2012-10-03	ABV-DELISTED	Stock	39.48	39.49	39.22	39.42	1405478.0
2012-10-03	ABVA-DELISTED	Stock	4.6	4.73	4.6	4.73	300.0
2012-10-03	ABX-DELISTED	Stock	41.68	41.89	41.01	41.12	4764557.0
2012-10-03	ACAD	Stock	2.47	2.54	2.4	2.48	2433700.0
2012-10-03	ACAS-DELISTED	Stock	11.6	11.65	11.48	11.56	1538487.0

> showing 50 of 6,138 rows — these rows as CSV

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