PREVIEW / stock_daily / 2014-12-31

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-31.parquet
  size:    224 KB
  rows:    6,680
  symbols: 3,556

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-31	AAPL	Stock	28.205	28.2825	27.5525	27.595	165613600.0
2014-12-31	MSFT	Stock	46.73	47.44	46.45	46.45	21552500.0
2014-12-31	NVDA	Stock	0.51	0.5128	0.4998	0.5013	166300000.0
2014-12-31	AMZN	Stock	15.5775	15.649	15.5005	15.5175	40960000.0
2014-12-31	GOOGL	Stock	26.887	26.92	26.51	26.533	24728900.0
2014-12-31	META	Stock	79.54	79.8	77.86	78.02	19935400.0
2014-12-31	TSLA	Stock	14.8727	15.0453	14.8167	14.8273	34462500.0
2014-12-31	TLT	Stock	125.7	126.165	125.65	125.92	4993301.0
2014-12-31	ES	Stock	54.86	54.88	53.45	53.52	1965400.0
2014-12-31	CL	Stock	70.09	70.41	69.12	69.19	2202300.0
2014-12-31	A	Stock	41.39	41.79	40.9	40.94	1421100.0
2014-12-31	AA.B-DELISTED	Stock	50.71	51.49	50.6	50.6	30822.0
2014-12-31	AABA-DELISTED	Stock	51.54	51.68	50.46	50.52	8848340.0
2014-12-31	AAC-DELISTED	Stock	30.78	31.5	30.64	31.02	33130.0
2014-12-31	AACG	Stock	4.18	4.8	4.18	4.36	69300.0
2014-12-31	AAIC-DELISTED	Stock	27.01	27.09	26.6	26.61	202096.0
2014-12-31	AAL	Stock	53.9	54.64	53.32	53.63	10626000.0
2014-12-31	AAMC-DELISTED	Stock	100.0	100.0	87.6471	91.2118	66368.0
2014-12-31	AAME	Stock	3.95	4.05	3.95	4.03	6200.0
2014-12-31	AAMI	Stock	16.24	16.63	16.15	16.24	184100.0
2014-12-31	AAOI	Stock	11.05	11.48	10.843	11.22	248400.0
2014-12-31	AAON	Stock	14.9667	15.1667	14.9	14.9267	152550.0
2014-12-31	AAP	Stock	160.64	162.69	159.26	159.28	468100.0
2014-12-31	AAT	Stock	40.79	41.07	39.7	39.81	109500.0
2014-12-31	AAU-DELISTED	Stock	0.9	0.9589	0.9	0.94	133461.0
2014-12-31	AAUAF-DELISTED	Stock	0.95	1.01	0.94	0.94	127292.0
2014-12-31	AAV-DELISTED	Stock	4.62	4.82	4.54	4.78	244713.0
2014-12-31	AAVL-DELISTED	Stock	56.29	57.37	53.85	53.86	208361.0
2014-12-31	AAWW-DELISTED	Stock	49.15	50.12	48.95	49.3	148358.0
2014-12-31	AAXJ	Stock	61.17	61.27	60.885	60.93	595795.0
2014-12-31	AAXN-DELISTED	Stock	26.84	27.15	26.45	26.46	1604063.0
2014-12-31	AB	Stock	26.22	26.34	25.75	25.83	309000.0
2014-12-31	ABAC-DELISTED	Stock	1.88	1.91	1.71	1.73	17025.0
2014-12-31	ABAX-DELISTED	Stock	58.1	59.05	56.72	56.82	104694.0
2014-12-31	ABB-DELISTED	Stock	21.44	21.44	21.14	21.15	812499.0
2014-12-31	ABBNY-DELISTED	Stock	21.44	21.44	21.14	21.15	849393.0
2014-12-31	ABBV	Stock	66.72	67.1	65.35	65.44	3917300.0
2014-12-31	ABC-DELISTED	Stock	91.57	91.93	90.09	90.14	825708.0
2014-12-31	ABCB	Stock	26.0	26.09	25.6	25.64	79900.0
2014-12-31	ABCD-DELISTED	Stock	1.664	1.84	1.65	1.66	33254.0
2014-12-31	ABCO-DELISTED	Stock	49.99	50.2591	48.66	48.98	286354.0
2014-12-31	ABCW-DELISTED	Stock	35.0	35.0	33.2	33.2	19335.0
2014-12-31	ABDC-DELISTED	Stock	12.94	12.99	12.4	12.5	141330.0
2014-12-31	ABE-DELISTED	Stock	13.0	13.12	13.0	13.08	8950.0
2014-12-31	ABEO	Stock	88.0	93.75	86.25	86.25	1184.0
2014-12-31	ABEV	Stock	6.19	6.25	6.13	6.22	10207200.0
2014-12-31	ABG	Stock	77.05	77.68	75.88	75.92	340500.0
2014-12-31	ABGB-DELISTED	Stock	11.0	11.18	10.86	10.89	91699.0
2014-12-31	ABM	Stock	28.98	29.11	28.62	28.65	136600.0
2014-12-31	ABMD-DELISTED	Stock	38.51	39.0	38.0	38.05	181905.0

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

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