PREVIEW / stock_daily / 2014-11-21

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-21.parquet
  size:    223 KB
  rows:    6,680
  symbols: 3,579

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-11-21	AAPL	Stock	29.3775	29.3925	29.0075	29.1175	228717200.0
2014-11-21	MSFT	Stock	49.02	49.05	47.57	47.98	42884800.0
2014-11-21	NVDA	Stock	0.513	0.5138	0.507	0.5112	198976000.0
2014-11-21	AMZN	Stock	16.771	16.9165	16.5735	16.6315	89332000.0
2014-11-21	GOOGL	Stock	27.552	27.552	27.25	27.2945	50119760.0
2014-11-21	META	Stock	74.5	74.5	73.5	73.75	23060400.0
2014-11-21	TSLA	Stock	16.814	16.852	16.1447	16.1853	112276500.0
2014-11-21	TLT	Stock	119.57	120.16	119.52	120.1	3640144.0
2014-11-21	ES	Stock	50.37	50.46	49.78	50.36	1840100.0
2014-11-21	CL	Stock	68.63	68.86	68.33	68.34	3142700.0
2014-11-21	A	Stock	41.75	42.38	41.7	42.25	5306200.0
2014-11-21	AA.B-DELISTED	Stock	53.48	54.33	53.48	53.82	74921.0
2014-11-21	AABA-DELISTED	Stock	52.0	52.25	50.99	51.02	21506109.0
2014-11-21	AAC-DELISTED	Stock	27.34	27.58	25.268	26.03	120473.0
2014-11-21	AACG	Stock	3.91	3.91	3.71	3.87	16100.0
2014-11-21	AAIC-DELISTED	Stock	27.69	27.78	27.48	27.53	248011.0
2014-11-21	AAL	Stock	44.38	44.49	43.25	43.31	10866500.0
2014-11-21	AAMC-DELISTED	Stock	145.0	154.9853	145.0	148.5294	43744.0
2014-11-21	AAME	Stock	3.88	3.88	3.71	3.82	6100.0
2014-11-21	AAMI	Stock	15.6	15.67	15.4	15.46	118100.0
2014-11-21	AAOI	Stock	12.84	12.84	12.36	12.49	256300.0
2014-11-21	AAON	Stock	13.9067	13.9133	13.72	13.74	185250.0
2014-11-21	AAP	Stock	146.06	146.42	145.44	145.49	522400.0
2014-11-21	AAT	Stock	39.02	39.02	38.37	38.39	156400.0
2014-11-21	AAU-DELISTED	Stock	1.1	1.1313	1.06	1.06	208224.0
2014-11-21	AAUAF-DELISTED	Stock	1.1	1.11	1.04	1.06	214947.0
2014-11-21	AAV-DELISTED	Stock	5.07	5.21	5.04	5.15	352734.0
2014-11-21	AAVL-DELISTED	Stock	34.38	35.38	33.231	34.65	48637.0
2014-11-21	AAWW-DELISTED	Stock	43.8	44.2	43.11	44.0	285890.0
2014-11-21	AAXJ	Stock	63.01	63.04	62.72	62.95	567778.0
2014-11-21	AAXN-DELISTED	Stock	20.9	21.01	18.86	19.33	6145400.0
2014-11-21	AB	Stock	26.78	26.84	26.46	26.71	201800.0
2014-11-21	ABAC-DELISTED	Stock	2.27	2.27	2.18	2.2599	42665.0
2014-11-21	ABAX-DELISTED	Stock	53.83	54.91	53.65	53.79	159927.0
2014-11-21	ABB-DELISTED	Stock	22.81	22.8499	22.635	22.76	1344390.0
2014-11-21	ABBNY-DELISTED	Stock	22.81	22.8499	22.635	22.76	1431394.0
2014-11-21	ABBV	Stock	66.41	67.36	65.75	67.36	9165900.0
2014-11-21	ABC-DELISTED	Stock	89.0	89.03	88.1	88.72	1417850.0
2014-11-21	ABCB	Stock	25.59	25.82	24.98	25.3	222400.0
2014-11-21	ABCD-DELISTED	Stock	1.86	1.86	1.7	1.72	18952.0
2014-11-21	ABCO-DELISTED	Stock	41.85	42.33	40.91	41.3	276251.0
2014-11-21	ABCW-DELISTED	Stock	30.24	30.7448	29.54	30.0	6502.0
2014-11-21	ABDC-DELISTED	Stock	12.73	12.88	12.66	12.76	50046.0
2014-11-21	ABE-DELISTED	Stock	14.04	14.12	13.96	14.11	11235.0
2014-11-21	ABEO	Stock	179.75	179.75	179.75	179.75	4.0
2014-11-21	ABEV	Stock	6.59	6.86	6.55	6.75	22761000.0
2014-11-21	ABG	Stock	75.33	75.45	74.0	74.67	269600.0
2014-11-21	ABGB-DELISTED	Stock	14.5	14.57	13.59	13.7584	187231.0
2014-11-21	ABM	Stock	27.08	27.3	26.94	27.15	402000.0
2014-11-21	ABMD-DELISTED	Stock	35.56	35.74	34.7	35.08	356589.0

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

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