PREVIEW / stock_daily / 2012-09-20

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-20.parquet
  size:    200 KB
  rows:    6,149
  symbols: 3,491

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-09-20	AAPL	Stock	24.97	25.0021	24.7721	24.9536	336568400.0
2012-09-20	MSFT	Stock	30.95	31.48	30.91	31.45	45543000.0
2012-09-20	NVDA	Stock	0.342	0.3438	0.3375	0.3402	320596000.0
2012-09-20	AMZN	Stock	13.0015	13.0435	12.9	13.0405	58272000.0
2012-09-20	META	Stock	23.02	23.24	22.54	22.59	57248900.0
2012-09-20	TSLA	Stock	2.062	2.1	2.0453	2.06	13686000.0
2012-09-20	TLT	Stock	122.14	122.32	120.98	121.41	4604257.0
2012-09-20	ES	Stock	36.89	37.32	36.81	37.17	2044100.0
2012-09-20	CL	Stock	52.865	53.615	52.865	53.395	3586000.0
2012-09-20	A	Stock	28.2904	28.4335	27.7325	28.0615	6211733.0
2012-09-20	AABA-DELISTED	Stock	15.76	15.86	15.65	15.785	17115652.0
2012-09-20	AACC-DELISTED	Stock	7.38	7.5	7.21	7.5	23978.0
2012-09-20	AACG	Stock	4.4	4.64	4.4	4.6	5400.0
2012-09-20	AAIC-DELISTED	Stock	25.15	25.44	25.05	25.36	365502.0
2012-09-20	AAME	Stock	2.62	2.72	2.62	2.72	1600.0
2012-09-20	AAMRQ-DELISTED	Stock	0.4005	0.403	0.356	0.364	5822085.0
2012-09-20	AAON	Stock	5.9437	5.9437	5.8311	5.843	95513.0
2012-09-20	AAP	Stock	68.03	69.22	67.5	69.21	1469100.0
2012-09-20	AAT	Stock	27.12	27.21	26.63	26.96	185100.0
2012-09-20	AAU-DELISTED	Stock	2.98	3.02	2.89	2.967	257945.0
2012-09-20	AAUAF-DELISTED	Stock	2.98	3.02	2.89	2.967	269745.0
2012-09-20	AAV-DELISTED	Stock	3.75	3.85	3.67	3.8	142154.0
2012-09-20	AAWW-DELISTED	Stock	55.88	56.99	55.44	55.68	306629.0
2012-09-20	AAXJ	Stock	55.96	56.26	55.8	56.18	182769.0
2012-09-20	AAXN-DELISTED	Stock	5.75	5.81	5.67	5.8	364773.0
2012-09-20	AB	Stock	15.1	15.33	14.95	15.15	577400.0
2012-09-20	ABAC-DELISTED	Stock	1.2301	1.31	1.078	1.2	15227.0
2012-09-20	ABAX-DELISTED	Stock	36.75	37.06	34.87	36.9	97536.0
2012-09-20	ABB-DELISTED	Stock	19.37	19.5301	19.3101	19.48	1538597.0
2012-09-20	ABBNY-DELISTED	Stock	19.37	19.5301	19.3101	19.48	1553165.0
2012-09-20	ABC-DELISTED	Stock	38.0	38.37	37.65	38.31	2218385.0
2012-09-20	ABCB	Stock	12.65	12.66	12.41	12.63	11100.0
2012-09-20	ABCD-DELISTED	Stock	1.06	1.1	1.06	1.09	19533.0
2012-09-20	ABCO-DELISTED	Stock	47.41	47.92	46.62	46.88	91373.0
2012-09-20	ABCW-DELISTED	Stock	0.39	0.42	0.38	0.38	24417.0
2012-09-20	ABE-DELISTED	Stock	20.25	20.63	20.22	20.5	118170.0
2012-09-20	ABEO	Stock	550.0	562.5	550.0	562.5	8.0
2012-09-20	ABFS-DELISTED	Stock	8.0	8.05	7.51	7.56	1012571.0
2012-09-20	ABG	Stock	27.99	28.38	27.92	28.12	197000.0
2012-09-20	ABM	Stock	18.8	18.96	18.66	18.67	260600.0
2012-09-20	ABMD-DELISTED	Stock	21.11	21.56	21.0722	21.48	483739.0
2012-09-20	ABR	Stock	6.37	6.47	6.23	6.34	52600.0
2012-09-20	ABT	Stock	33.1734	33.5188	33.0966	33.5188	11779491.0
2012-09-20	ABTL-DELISTED	Stock	3.56	3.61	3.5	3.6	16183.0
2012-09-20	ABUS	Stock	3.83	4.13	3.83	4.13	34900.0
2012-09-20	ABV-DELISTED	Stock	37.7	38.195	37.64	38.07	1975073.0
2012-09-20	ABVA-DELISTED	Stock	4.52	4.75	4.41	4.75	14872.0
2012-09-20	ABX-DELISTED	Stock	42.25	42.49	41.89	42.46	7684927.0
2012-09-20	ACAD	Stock	2.53	2.8	2.46	2.76	5465300.0
2012-09-20	ACAS-DELISTED	Stock	11.71	11.85	11.63	11.8499	1400823.0

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

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