PREVIEW / stock_daily / 2014-12-22

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-22.parquet
  size:    224 KB
  rows:    6,690
  symbols: 3,571

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-22	AAPL	Stock	28.04	28.3725	27.9925	28.235	180670000.0
2014-12-22	MSFT	Stock	47.78	48.12	47.71	47.98	26566000.0
2014-12-22	NVDA	Stock	0.51	0.5195	0.5082	0.5195	148976000.0
2014-12-22	AMZN	Stock	15.097	15.368	15.097	15.327	80076000.0
2014-12-22	GOOGL	Stock	26.0305	26.6485	26.0295	26.615	66389220.0
2014-12-22	META	Stock	80.08	81.89	80.0	81.45	31395800.0
2014-12-22	TSLA	Stock	14.6667	14.9373	14.5507	14.84	71991000.0
2014-12-22	TLT	Stock	125.45	126.19	125.32	126.04	4118783.0
2014-12-22	ES	Stock	52.78	53.1	52.55	53.06	1202100.0
2014-12-22	CL	Stock	69.96	70.49	69.8	70.26	2562700.0
2014-12-22	A	Stock	41.38	41.88	41.38	41.88	1585900.0
2014-12-22	AA.B-DELISTED	Stock	51.0	51.0	49.52	50.2	72513.0
2014-12-22	AABA-DELISTED	Stock	50.99	51.6	50.95	51.16	13492955.0
2014-12-22	AAC-DELISTED	Stock	29.5	30.01	29.34	29.61	39738.0
2014-12-22	AACG	Stock	3.54	3.59	3.13	3.5	40500.0
2014-12-22	AAIC-DELISTED	Stock	27.8	27.91	27.48	27.65	218929.0
2014-12-22	AAL	Stock	51.1	51.88	50.72	50.84	8872400.0
2014-12-22	AAMC-DELISTED	Stock	127.9415	127.9415	91.4706	104.8529	274734.0
2014-12-22	AAME	Stock	3.88	3.9	3.88	3.9	2900.0
2014-12-22	AAMI	Stock	16.76	16.76	16.0	16.44	450700.0
2014-12-22	AAOI	Stock	10.7	10.71	10.31	10.43	220100.0
2014-12-22	AAON	Stock	14.4267	14.6	14.2933	14.5933	209400.0
2014-12-22	AAP	Stock	160.22	160.66	158.79	159.44	507300.0
2014-12-22	AAT	Stock	39.52	40.02	39.32	39.98	181400.0
2014-12-22	AAU-DELISTED	Stock	0.95	0.9501	0.9211	0.93	112286.0
2014-12-22	AAUAF-DELISTED	Stock	0.93	0.93	0.9015	0.93	116031.0
2014-12-22	AAV-DELISTED	Stock	5.07	5.1	4.63	4.75	595296.0
2014-12-22	AAVL-DELISTED	Stock	51.35	52.23	50.58	51.61	120803.0
2014-12-22	AAWW-DELISTED	Stock	47.0	47.59	46.58	47.56	176742.0
2014-12-22	AAXJ	Stock	60.46	60.9455	60.46	60.88	690950.0
2014-12-22	AAXN-DELISTED	Stock	24.81	26.39	24.74	26.06	5743356.0
2014-12-22	AB	Stock	24.94	25.09	24.56	24.83	224600.0
2014-12-22	ABAC-DELISTED	Stock	1.95	1.95	1.84	1.8401	500.0
2014-12-22	ABAX-DELISTED	Stock	59.71	60.94	59.12	59.28	146143.0
2014-12-22	ABB-DELISTED	Stock	21.48	21.48	21.36	21.43	951636.0
2014-12-22	ABBNY-DELISTED	Stock	21.48	21.48	21.36	21.43	1035985.0
2014-12-22	ABBV	Stock	68.04	68.25	66.83	66.97	12876600.0
2014-12-22	ABC-DELISTED	Stock	92.26	92.56	91.48	91.96	1017414.0
2014-12-22	ABCB	Stock	25.56	25.76	25.45	25.58	138700.0
2014-12-22	ABCD-DELISTED	Stock	1.74	1.75	1.74	1.75	2197.0
2014-12-22	ABCO-DELISTED	Stock	47.21	49.26	47.21	49.1	296768.0
2014-12-22	ABCW-DELISTED	Stock	34.79	35.0	34.35	34.95	48162.0
2014-12-22	ABDC-DELISTED	Stock	12.81	12.81	12.55	12.78	41931.0
2014-12-22	ABE-DELISTED	Stock	13.09	13.2399	12.87	13.2116	28903.0
2014-12-22	ABEO	Stock	96.25	96.25	91.75	92.5	1080.0
2014-12-22	ABEOW-DELISTED	Stock	1.05	1.05	0.71	0.71	15275.0
2014-12-22	ABEV	Stock	6.02	6.14	6.02	6.08	10463600.0
2014-12-22	ABG	Stock	75.5	76.51	75.2	75.41	617500.0
2014-12-22	ABGB-DELISTED	Stock	12.09	12.26	11.9	12.15	18559.0
2014-12-22	ABM	Stock	28.0	28.54	28.0	28.49	174300.0

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

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