PREVIEW / stock_daily / 2012-09-18

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-18.parquet
  size:    200 KB
  rows:    6,162
  symbols: 3,499

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-18	AAPL	Stock	24.9957	25.0832	24.8721	25.0682	373503200.0
2012-09-18	MSFT	Stock	31.1	31.21	31.03	31.18	34542700.0
2012-09-18	NVDA	Stock	0.3328	0.3428	0.3325	0.3388	359952000.0
2012-09-18	AMZN	Stock	12.924	13.025	12.85	12.9375	44300000.0
2012-09-18	META	Stock	21.6	21.98	21.37	21.87	36760500.0
2012-09-18	TSLA	Stock	2.1253	2.1267	2.0453	2.0893	26827500.0
2012-09-18	TLT	Stock	120.71	120.9	119.96	120.32	5366694.0
2012-09-18	ES	Stock	37.25	37.28	36.82	36.94	1954000.0
2012-09-18	CL	Stock	52.335	53.115	52.0	53.005	4507800.0
2012-09-18	A	Stock	28.2976	28.5122	28.2189	28.2904	5024272.0
2012-09-18	AABA-DELISTED	Stock	15.65	16.17	15.6	15.89	41829177.0
2012-09-18	AACC-DELISTED	Stock	7.02	7.09	6.83	7.05	27147.0
2012-09-18	AACG	Stock	4.43	4.43	4.41	4.42	1000.0
2012-09-18	AAIC-DELISTED	Stock	25.07	25.1	24.52	24.67	508751.0
2012-09-18	AAME	Stock	2.7	2.75	2.63	2.75	1100.0
2012-09-18	AAMRQ-DELISTED	Stock	0.4301	0.4312	0.4225	0.426	1362725.0
2012-09-18	AAON	Stock	5.8874	6.0622	5.8785	6.0504	179213.0
2012-09-18	AAP	Stock	67.63	67.72	66.91	67.69	1150400.0
2012-09-18	AAT	Stock	27.93	28.04	27.73	27.88	74500.0
2012-09-18	AAU-DELISTED	Stock	2.89	2.98	2.8201	2.95	177008.0
2012-09-18	AAUAF-DELISTED	Stock	2.89	2.98	2.8201	2.95	179633.0
2012-09-18	AAV-DELISTED	Stock	3.74	3.83	3.66	3.76	154859.0
2012-09-18	AAWW-DELISTED	Stock	55.58	55.67	53.91	55.255	261506.0
2012-09-18	AAXJ	Stock	56.14	56.54	56.14	56.35	128976.0
2012-09-18	AAXN-DELISTED	Stock	6.29	6.3999	5.9	5.955	1839009.0
2012-09-18	AB	Stock	15.54	15.94	15.41	15.55	918600.0
2012-09-18	ABAC-DELISTED	Stock	1.1513	1.22	1.12	1.22	10500.0
2012-09-18	ABAX-DELISTED	Stock	36.08	36.94	36.08	36.77	93794.0
2012-09-18	ABB-DELISTED	Stock	19.61	19.695	19.57	19.61	1985713.0
2012-09-18	ABBNY-DELISTED	Stock	19.61	19.695	19.57	19.61	2106297.0
2012-09-18	ABC-DELISTED	Stock	37.86	38.34	37.57	38.33	3004522.0
2012-09-18	ABCB	Stock	12.58	12.74	12.48	12.7	26700.0
2012-09-18	ABCD-DELISTED	Stock	1.0899	1.09	1.08	1.09	2566.0
2012-09-18	ABCO-DELISTED	Stock	46.81	47.21	46.52	47.21	94293.0
2012-09-18	ABCW-DELISTED	Stock	0.43	0.44	0.38	0.43	2561.0
2012-09-18	ABE-DELISTED	Stock	20.32	20.3311	20.23	20.29	15358.0
2012-09-18	ABEO	Stock	562.5	637.5	512.5	537.5	149.0
2012-09-18	ABFS-DELISTED	Stock	8.4	8.4098	8.18	8.27	398399.0
2012-09-18	ABG	Stock	28.98	28.98	27.99	28.23	309900.0
2012-09-18	ABM	Stock	18.75	19.0	18.64	18.98	264000.0
2012-09-18	ABMD-DELISTED	Stock	20.27	21.14	20.21	21.02	560778.0
2012-09-18	ABR	Stock	6.42	6.48	6.31	6.35	32900.0
2012-09-18	ABT	Stock	33.0054	33.1638	32.9191	33.063	10854940.0
2012-09-18	ABTL-DELISTED	Stock	3.62	3.69	3.543	3.558	47551.0
2012-09-18	ABUS	Stock	3.68	3.81	3.63	3.63	8100.0
2012-09-18	ABV-DELISTED	Stock	38.39	38.48	37.73	37.93	1540189.0
2012-09-18	ABVA-DELISTED	Stock	4.48	4.7	4.471	4.7	4982.0
2012-09-18	ABX-DELISTED	Stock	41.92	42.29	41.67	42.05	11532787.0
2012-09-18	ACAD	Stock	2.25	2.26	2.18	2.21	1159000.0
2012-09-18	ACAS-DELISTED	Stock	11.84	11.85	11.68	11.69	2077780.0

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

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