PREVIEW / stock_daily / 2014-12-23

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-23.parquet
  size:    223 KB
  rows:    6,680
  symbols: 3,570

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
2014-12-23	AAPL	Stock	28.3075	28.3325	28.115	28.135	104113600.0
2014-12-23	MSFT	Stock	48.37	48.8	48.13	48.45	23648100.0
2014-12-23	NVDA	Stock	0.5235	0.526	0.5158	0.5162	109280000.0
2014-12-23	AMZN	Stock	15.349	15.3745	15.1625	15.3145	54274000.0
2014-12-23	GOOGL	Stock	26.7255	27.115	26.686	26.9385	57544440.0
2014-12-23	META	Stock	82.02	82.17	80.4	80.61	19865800.0
2014-12-23	TSLA	Stock	14.9207	14.9547	14.6347	14.7313	67585500.0
2014-12-23	TLT	Stock	125.45	125.6	123.49	123.54	7406146.0
2014-12-23	ES	Stock	53.16	53.82	52.99	53.75	2470300.0
2014-12-23	CL	Stock	70.38	71.21	70.3	71.0	2251200.0
2014-12-23	A	Stock	41.98	42.01	41.36	41.37	1867200.0
2014-12-23	AA.B-DELISTED	Stock	50.41	50.74	50.15	50.28	409836.0
2014-12-23	AABA-DELISTED	Stock	51.46	51.46	49.931	50.025	14660484.0
2014-12-23	AAC-DELISTED	Stock	29.56	29.9	28.62	29.49	89742.0
2014-12-23	AACG	Stock	3.5	3.62	3.5	3.52	6000.0
2014-12-23	AAIC-DELISTED	Stock	27.72	27.89	27.67	27.82	177642.0
2014-12-23	AAL	Stock	50.95	51.14	49.84	50.21	7166300.0
2014-12-23	AAMC-DELISTED	Stock	100.1471	102.2441	95.5912	99.9971	98729.0
2014-12-23	AAME	Stock	3.84	3.9	3.8	3.9	3600.0
2014-12-23	AAMI	Stock	16.5	16.71	16.17	16.23	195900.0
2014-12-23	AAOI	Stock	10.56	10.84	10.45	10.8	276600.0
2014-12-23	AAON	Stock	14.74	14.8467	14.64	14.78	106650.0
2014-12-23	AAP	Stock	160.51	162.52	160.27	161.19	524900.0
2014-12-23	AAT	Stock	40.19	40.28	39.69	40.15	144000.0
2014-12-23	AAU-DELISTED	Stock	0.91	0.9276	0.8951	0.91	155597.0
2014-12-23	AAUAF-DELISTED	Stock	0.91	0.9276	0.8951	0.9119	156614.0
2014-12-23	AAV-DELISTED	Stock	4.69	4.79	4.51	4.69	284602.0
2014-12-23	AAVL-DELISTED	Stock	51.73	52.0	48.34	48.5	115950.0
2014-12-23	AAWW-DELISTED	Stock	47.8	48.6495	47.09	48.35	137269.0
2014-12-23	AAXJ	Stock	60.53	60.57	60.19	60.26	1036021.0
2014-12-23	AAXN-DELISTED	Stock	26.69	27.1	25.65	26.02	3839027.0
2014-12-23	AB	Stock	24.91	25.47	24.8	25.19	408700.0
2014-12-23	ABAC-DELISTED	Stock	1.92	1.9399	1.8501	1.8748	8575.0
2014-12-23	ABAX-DELISTED	Stock	59.5	60.05	57.85	58.41	141502.0
2014-12-23	ABB-DELISTED	Stock	21.49	21.62	21.47	21.57	1022046.0
2014-12-23	ABBNY-DELISTED	Stock	21.48	21.62	21.47	21.57	1121860.0
2014-12-23	ABBV	Stock	67.23	67.32	64.02	64.35	12123000.0
2014-12-23	ABC-DELISTED	Stock	92.4	92.65	90.69	91.4	962861.0
2014-12-23	ABCB	Stock	25.62	25.82	25.35	25.71	74000.0
2014-12-23	ABCD-DELISTED	Stock	1.66	1.74	1.65	1.69	10438.0
2014-12-23	ABCO-DELISTED	Stock	49.25	50.36	48.85	49.88	269815.0
2014-12-23	ABCW-DELISTED	Stock	34.99	35.0	34.53	35.0	22727.0
2014-12-23	ABDC-DELISTED	Stock	12.78	13.0	12.2701	13.0	46193.0
2014-12-23	ABE-DELISTED	Stock	13.05	13.13	13.05	13.13	10661.0
2014-12-23	ABEO	Stock	92.5	92.5	83.25	91.25	236.0
2014-12-23	ABEOW-DELISTED	Stock	0.7	0.74	0.68	0.7	8200.0
2014-12-23	ABEV	Stock	6.08	6.1	5.97	6.07	7350400.0
2014-12-23	ABG	Stock	76.23	77.72	75.93	76.69	718300.0
2014-12-23	ABGB-DELISTED	Stock	12.04	12.0683	11.91	11.94	77635.0
2014-12-23	ABIL-DELISTED	Stock	9.83	9.9	9.83	9.9	200.0

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

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