PREVIEW / stock_daily / 2012-10-01

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-01.parquet
  size:    200 KB
  rows:    6,169
  symbols: 3,492

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-01	AAPL	Stock	23.97	24.1696	23.4464	23.5496	543594800.0
2012-10-01	MSFT	Stock	29.81	29.98	29.42	29.49	54042700.0
2012-10-01	NVDA	Stock	0.335	0.337	0.3268	0.328	504236000.0
2012-10-01	AMZN	Stock	12.77	12.808	12.5245	12.6005	51624000.0
2012-10-01	META	Stock	22.08	22.59	21.73	21.99	51262700.0
2012-10-01	TSLA	Stock	1.9667	1.9927	1.9333	1.944	13266000.0
2012-10-01	TLT	Stock	123.97	124.47	123.38	124.41	4842566.0
2012-10-01	ES	Stock	38.4	38.71	38.24	38.65	2276800.0
2012-10-01	CL	Stock	53.42	54.37	53.265	53.995	3412400.0
2012-10-01	A	Stock	27.5393	28.269	27.4535	27.7969	5903614.0
2012-10-01	AABA-DELISTED	Stock	16.0	16.0877	15.77	15.82	20230266.0
2012-10-01	AACC-DELISTED	Stock	7.51	7.52	7.27	7.38	10048.0
2012-10-01	AACG	Stock	5.48	5.55	5.48	5.55	3200.0
2012-10-01	AAIC-DELISTED	Stock	23.9	24.06	23.79	24.03	175069.0
2012-10-01	AAME	Stock	2.8	2.8	2.78	2.78	1800.0
2012-10-01	AAMRQ-DELISTED	Stock	0.371	0.3935	0.371	0.3875	2160758.0
2012-10-01	AAON	Stock	5.8904	5.9259	5.7067	5.7719	100575.0
2012-10-01	AAP	Stock	68.53	68.54	67.71	67.99	1228400.0
2012-10-01	AAT	Stock	26.83	27.24	26.49	26.85	258400.0
2012-10-01	AAU-DELISTED	Stock	2.77	2.8114	2.68	2.68	132144.0
2012-10-01	AAUAF-DELISTED	Stock	2.74	2.78	2.65	2.68	134124.0
2012-10-01	AAV-DELISTED	Stock	3.76	3.96	3.76	3.93	261988.0
2012-10-01	AAWW-DELISTED	Stock	52.17	52.99	51.33	51.88	208737.0
2012-10-01	AAXJ	Stock	56.58	57.19	56.5291	56.795	457375.0
2012-10-01	AAXN-DELISTED	Stock	6.01	6.15	6.01	6.15	310916.0
2012-10-01	AB	Stock	15.46	15.59	15.28	15.44	159000.0
2012-10-01	ABAC-DELISTED	Stock	1.5	1.66	1.47	1.47	45499.0
2012-10-01	ABAX-DELISTED	Stock	36.36	38.24	36.36	37.88	220814.0
2012-10-01	ABB-DELISTED	Stock	19.02	19.16	18.87	18.95	2211359.0
2012-10-01	ABBNY-DELISTED	Stock	19.02	19.16	18.87	18.94	2218678.0
2012-10-01	ABC-DELISTED	Stock	38.79	39.07	38.69	38.98	1972235.0
2012-10-01	ABCB	Stock	12.66	12.78	12.61	12.71	55600.0
2012-10-01	ABCD-DELISTED	Stock	0.99	0.99	0.981	0.981	56734.0
2012-10-01	ABCO-DELISTED	Stock	48.42	48.42	47.43	47.89	205997.0
2012-10-01	ABCW-DELISTED	Stock	0.38	0.385	0.38	0.38	34332.0
2012-10-01	ABE-DELISTED	Stock	20.63	20.909	20.63	20.738	13607.0
2012-10-01	ABEO	Stock	562.5	562.5	562.5	562.5	1.0
2012-10-01	ABFS-DELISTED	Stock	7.97	8.07	7.71	7.74	332737.0
2012-10-01	ABG	Stock	28.15	28.7	27.97	28.1	273900.0
2012-10-01	ABM	Stock	19.04	19.15	18.85	18.91	255700.0
2012-10-01	ABMD-DELISTED	Stock	21.08	21.29	20.935	21.04	554110.0
2012-10-01	ABR	Stock	6.01	6.24	5.95	6.08	77300.0
2012-10-01	ABT	Stock	32.8615	33.3797	32.7703	33.1446	11205294.0
2012-10-01	ABTL-DELISTED	Stock	3.82	4.01	3.78	3.83	36879.0
2012-10-01	ABUS	Stock	3.47	3.51	3.22	3.32	74000.0
2012-10-01	ABV-DELISTED	Stock	38.88	39.13	38.76	38.98	2498269.0
2012-10-01	ABVA-DELISTED	Stock	4.58	4.645	4.5	4.645	11822.0
2012-10-01	ABX-DELISTED	Stock	42.22	42.54	41.76	41.9	5053167.0
2012-10-01	ACAD	Stock	2.52	2.6	2.45	2.47	819300.0
2012-10-01	ACAS-DELISTED	Stock	11.49	11.71	11.4021	11.56	3300510.0

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

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