PREVIEW / stock_daily / 2015-09-23

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-23.parquet
  size:    220 KB
  rows:    6,617
  symbols: 3,418

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
2015-09-23	AAPL	Stock	28.4075	28.68	28.325	28.58	143026800.0
2015-09-23	MSFT	Stock	43.93	44.17	43.51	43.87	17145200.0
2015-09-23	NVDA	Stock	0.5728	0.5785	0.5705	0.575	161632000.0
2015-09-23	AMZN	Stock	26.915	27.0605	26.7	26.8035	44752000.0
2015-09-23	GOOGL	Stock	32.645	33.014	32.5365	32.6645	29159900.0
2015-09-23	META	Stock	93.4	94.32	92.8	93.97	21701400.0
2015-09-23	TSLA	Stock	17.4633	17.472	17.172	17.404	39012000.0
2015-09-23	TLT	Stock	121.62	122.07	120.99	121.77	6769859.0
2015-09-23	ES	Stock	47.48	47.88	47.28	47.72	1617100.0
2015-09-23	CL	Stock	62.04	62.32	61.75	62.1	4005600.0
2015-09-23	A	Stock	35.1	35.24	34.81	34.95	1962600.0
2015-09-23	AA.B-DELISTED	Stock	34.15	34.3622	33.25	33.25	85930.0
2015-09-23	AABA-DELISTED	Stock	30.56	30.57	29.625	29.74	12222023.0
2015-09-23	AAC-DELISTED	Stock	23.37	24.935	23.14	24.21	373939.0
2015-09-23	AACG	Stock	2.54	2.54	2.43	2.44	15400.0
2015-09-23	AAIC-DELISTED	Stock	15.87	15.9	15.67	15.79	445621.0
2015-09-23	AAL	Stock	41.32	41.5	40.5	41.24	8248800.0
2015-09-23	AAMC-DELISTED	Stock	7.3853	7.5147	6.8824	7.0	58725.0
2015-09-23	AAME	Stock	3.76	3.8	3.58	3.8	8000.0
2015-09-23	AAMI	Stock	15.84	15.935	15.47	15.61	260500.0
2015-09-23	AAOI	Stock	18.98	19.32	18.55	18.78	202700.0
2015-09-23	AAON	Stock	13.1667	13.22	12.94	13.0867	203850.0
2015-09-23	AAP	Stock	174.36	176.08	173.96	175.87	315700.0
2015-09-23	AAT	Stock	39.67	40.0	39.54	39.83	296300.0
2015-09-23	AAU-DELISTED	Stock	0.54	0.5499	0.5194	0.52	21777.0
2015-09-23	AAUAF-DELISTED	Stock	0.54	0.5499	0.5194	0.52	22285.0
2015-09-23	AAV-DELISTED	Stock	5.56	5.61	5.37	5.38	76295.0
2015-09-23	AAVL-DELISTED	Stock	10.24	10.25	9.79	9.82	542219.0
2015-09-23	AAWW-DELISTED	Stock	37.29	37.93	36.11	36.17	316260.0
2015-09-23	AAXJ	Stock	52.96	53.03	52.57	52.64	751549.0
2015-09-23	AAXN-DELISTED	Stock	23.41	23.89	23.14	23.22	1383887.0
2015-09-23	AB	Stock	26.67	26.79	26.49	26.5	101600.0
2015-09-23	ABAC-DELISTED	Stock	0.65	0.65	0.5784	0.65	51077.0
2015-09-23	ABAX-DELISTED	Stock	47.02	47.43	46.7	47.2	150132.0
2015-09-23	ABB-DELISTED	Stock	17.63	17.63	17.3	17.36	1765912.0
2015-09-23	ABBNY-DELISTED	Stock	17.63	17.63	17.3	17.36	1852959.0
2015-09-23	ABBV	Stock	57.9	58.4	57.15	57.43	9827000.0
2015-09-23	ABC-DELISTED	Stock	103.2	103.67	102.28	102.82	1912862.0
2015-09-23	ABCB	Stock	27.84	28.03	27.68	27.85	146700.0
2015-09-23	ABCD-DELISTED	Stock	4.81	4.94	4.78	4.93	24648.0
2015-09-23	ABCO-DELISTED	Stock	47.62	48.15	47.21	47.77	185840.0
2015-09-23	ABCW-DELISTED	Stock	39.84	40.0	39.75	39.9	75033.0
2015-09-23	ABDC-DELISTED	Stock	12.89	13.0	12.75	12.82	18861.0
2015-09-23	ABE-DELISTED	Stock	10.97	11.05	10.76	10.76	6934.0
2015-09-23	ABEO	Stock	120.25	126.25	120.0	122.0	5140.0
2015-09-23	ABEOW-DELISTED	Stock	1.71	1.9	1.71	1.7259	400.0
2015-09-23	ABEV	Stock	4.75	4.77	4.59	4.59	15132500.0
2015-09-23	ABG	Stock	83.9	84.39	82.82	83.64	141200.0
2015-09-23	ABGB-DELISTED	Stock	5.34	5.49	5.09	5.39	173881.0
2015-09-23	ABIL-DELISTED	Stock	10.0099	10.0099	10.0099	10.0099	250.0

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

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