PREVIEW / stock_daily / 2012-08-17

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-17.parquet
  size:    199 KB
  rows:    6,139
  symbols: 3,497

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-08-17	AAPL	Stock	22.8571	23.1496	22.8146	23.1468	442761200.0
2012-08-17	MSFT	Stock	30.92	30.92	30.59	30.9	32589900.0
2012-08-17	NVDA	Stock	0.3695	0.3695	0.363	0.3662	309864000.0
2012-08-17	AMZN	Stock	12.03	12.1675	12.0235	12.0585	61716000.0
2012-08-17	META	Stock	20.01	20.08	19.0	19.05	129293400.0
2012-08-17	TSLA	Stock	2.0193	2.0473	1.9987	2.0007	7623000.0
2012-08-17	TLT	Stock	121.4	122.12	121.32	121.6	6341050.0
2012-08-17	ES	Stock	38.89	38.89	38.46	38.54	1257200.0
2012-08-17	CL	Stock	53.05	53.2	52.935	53.09	2992000.0
2012-08-17	A	Stock	26.6309	26.6738	26.3305	26.6237	7518025.0
2012-08-17	AABA-DELISTED	Stock	15.02	15.07	14.85	15.02	18703785.0
2012-08-17	AACC-DELISTED	Stock	5.85	6.04	5.8	6.03	51310.0
2012-08-17	AACG	Stock	4.66	4.75	4.62	4.62	1900.0
2012-08-17	AAIC-DELISTED	Stock	22.91	23.0399	22.91	23.02	37435.0
2012-08-17	AAME	Stock	2.61	2.63	2.55	2.63	2100.0
2012-08-17	AAMRQ-DELISTED	Stock	0.4915	0.498	0.4855	0.493	688042.0
2012-08-17	AAON	Stock	5.7126	5.7481	5.6978	5.6978	195413.0
2012-08-17	AAP	Stock	72.71	73.06	72.41	72.87	1102300.0
2012-08-17	AAT	Stock	25.93	26.46	25.67	26.32	335600.0
2012-08-17	AAU-DELISTED	Stock	2.2	2.21	2.06	2.19	99438.0
2012-08-17	AAUAF-DELISTED	Stock	2.2	2.21	2.06	2.19	100138.0
2012-08-17	AAV-DELISTED	Stock	3.27	3.36	3.2515	3.34	95266.0
2012-08-17	AAWW-DELISTED	Stock	52.61	53.832	52.61	53.645	181233.0
2012-08-17	AAXJ	Stock	54.4	54.43	54.15	54.29	180273.0
2012-08-17	AAXN-DELISTED	Stock	5.53	5.57	5.42	5.45	292329.0
2012-08-17	AB	Stock	12.87	12.93	12.8	12.86	301000.0
2012-08-17	ABAC-DELISTED	Stock	1.0	1.1	1.0	1.0499	31221.0
2012-08-17	ABAX-DELISTED	Stock	38.59	39.58	38.39	39.5	51838.0
2012-08-17	ABB-DELISTED	Stock	17.88	17.95	17.7905	17.94	1272966.0
2012-08-17	ABBNY-DELISTED	Stock	17.88	17.95	17.7905	17.95	1341210.0
2012-08-17	ABC-DELISTED	Stock	37.23	37.74	36.91	37.52	5360359.0
2012-08-17	ABCB	Stock	11.82	12.21	11.75	12.18	56400.0
2012-08-17	ABCD-DELISTED	Stock	0.98	1.0901	0.98	0.99	58645.0
2012-08-17	ABCO-DELISTED	Stock	42.01	42.21	41.66	42.04	219160.0
2012-08-17	ABCW-DELISTED	Stock	0.392	0.449	0.39	0.39	6097.0
2012-08-17	ABE-DELISTED	Stock	19.6	19.6	19.52	19.6	10096.0
2012-08-17	ABEO	Stock	612.5	625.0	525.0	587.5	13.0
2012-08-17	ABFS-DELISTED	Stock	10.42	10.48	10.32	10.46	178507.0
2012-08-17	ABG	Stock	26.84	27.3	26.67	27.08	208000.0
2012-08-17	ABM	Stock	20.03	20.49	19.94	20.39	352200.0
2012-08-17	ABMD-DELISTED	Stock	19.57	20.84	19.57	20.8	560016.0
2012-08-17	ABR	Stock	5.75	5.79	5.51	5.67	93000.0
2012-08-17	ABT	Stock	31.9499	31.9499	31.5181	31.6284	8464360.0
2012-08-17	ABTL-DELISTED	Stock	3.78	3.94	3.68	3.75	32190.0
2012-08-17	ABUS	Stock	3.8	3.8	3.75	3.75	6400.0
2012-08-17	ABV-DELISTED	Stock	38.16	38.26	37.85	38.03	1842934.0
2012-08-17	ABVA-DELISTED	Stock	4.41	4.49	4.41	4.47	5800.0
2012-08-17	ABX-DELISTED	Stock	36.23	36.41	35.5	35.99	7258766.0
2012-08-17	ACAD	Stock	1.62	1.7	1.57	1.69	236900.0
2012-08-17	ACAS-DELISTED	Stock	11.16	11.23	11.105	11.16	3049176.0

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

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