PREVIEW / stock_daily / 2015-03-12

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-12.parquet
  size:    223 KB
  rows:    6,630
  symbols: 3,519

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-03-12	AAPL	Stock	30.5775	31.225	30.4075	31.1125	193450800.0
2015-03-12	MSFT	Stock	41.33	41.65	40.86	41.02	59992500.0
2015-03-12	NVDA	Stock	0.5665	0.5708	0.556	0.5668	406972000.0
2015-03-12	AMZN	Stock	18.441	18.775	18.376	18.712	56200000.0
2015-03-12	GOOGL	Stock	27.924	28.092	27.7765	28.0585	35601140.0
2015-03-12	META	Stock	78.1	79.05	77.91	78.93	16093300.0
2015-03-12	TSLA	Stock	12.9167	12.9633	12.65	12.738	62239500.0
2015-03-12	TLT	Stock	128.2	128.2	126.72	127.11	10295863.0
2015-03-12	ES	Stock	48.98	50.18	48.92	49.67	1187700.0
2015-03-12	CL	Stock	68.32	68.58	68.15	68.53	2456700.0
2015-03-12	A	Stock	40.99	41.24	40.97	41.1	2719900.0
2015-03-12	AA.B-DELISTED	Stock	45.33	45.772	45.11	45.68	48279.0
2015-03-12	AABA-DELISTED	Stock	42.69	43.36	42.58	42.94	7841859.0
2015-03-12	AAC-DELISTED	Stock	24.8	26.95	24.78	26.13	706298.0
2015-03-12	AACG	Stock	3.97	4.02	3.97	3.97	7600.0
2015-03-12	AAIC-DELISTED	Stock	24.66	25.04	24.64	25.02	342088.0
2015-03-12	AAL	Stock	47.57	48.72	47.56	48.68	7133500.0
2015-03-12	AAMC-DELISTED	Stock	61.2412	76.4088	61.0883	74.7176	96128.0
2015-03-12	AAME	Stock	4.02	4.02	3.98	3.99	4100.0
2015-03-12	AAMI	Stock	17.39	17.72	17.13	17.72	52600.0
2015-03-12	AAOI	Stock	12.39	12.98	12.33	12.95	237700.0
2015-03-12	AAON	Stock	14.7	15.0067	14.6333	14.9533	170400.0
2015-03-12	AAP	Stock	146.88	150.23	146.88	149.32	778500.0
2015-03-12	AAT	Stock	41.2	42.07	41.03	42.03	145200.0
2015-03-12	AAU-DELISTED	Stock	0.925	0.9612	0.92	0.94	159074.0
2015-03-12	AAUAF-DELISTED	Stock	0.905	0.94	0.9	0.94	164069.0
2015-03-12	AAV-DELISTED	Stock	5.13	5.16	4.983	5.02	178585.0
2015-03-12	AAVL-DELISTED	Stock	38.78	40.67	38.15	40.56	236576.0
2015-03-12	AAWW-DELISTED	Stock	45.43	46.39	45.34	46.16	143886.0
2015-03-12	AAXJ	Stock	62.1	62.2901	61.995	62.05	1025449.0
2015-03-12	AAXN-DELISTED	Stock	22.47	24.4	22.302	24.13	3098793.0
2015-03-12	AB	Stock	28.67	28.86	28.09	28.25	472900.0
2015-03-12	ABAX-DELISTED	Stock	62.32	63.25	62.14	62.99	112482.0
2015-03-12	ABB-DELISTED	Stock	20.17	20.23	20.07	20.19	1473423.0
2015-03-12	ABBNY-DELISTED	Stock	20.17	20.23	20.07	20.2	1615524.0
2015-03-12	ABBV	Stock	56.78	58.91	56.65	58.0	18227800.0
2015-03-12	ABC-DELISTED	Stock	104.0	105.515	103.95	105.39	1316255.0
2015-03-12	ABCB	Stock	26.02	26.65	26.01	26.55	70800.0
2015-03-12	ABCD-DELISTED	Stock	2.9691	3.03	2.9691	3.0101	17780.0
2015-03-12	ABCO-DELISTED	Stock	53.0	54.39	52.46	54.19	175417.0
2015-03-12	ABCW-DELISTED	Stock	34.34	34.71	34.29	34.33	7145.0
2015-03-12	ABDC-DELISTED	Stock	13.56	13.79	13.5	13.59	25112.0
2015-03-12	ABE-DELISTED	Stock	12.54	12.6799	12.52	12.56	14505.0
2015-03-12	ABEO	Stock	87.25	87.25	80.25	87.0	596.0
2015-03-12	ABEOW-DELISTED	Stock	0.99	1.0	0.9399	0.94	9300.0
2015-03-12	ABEV	Stock	5.84	5.88	5.66	5.72	12591300.0
2015-03-12	ABG	Stock	75.93	77.22	75.51	76.97	242900.0
2015-03-12	ABGB-DELISTED	Stock	16.4	16.55	16.33	16.47	17248.0
2015-03-12	ABIL-DELISTED	Stock	9.95	9.95	9.95	9.95	3000.0
2015-03-12	ABM	Stock	29.62	30.19	29.41	30.01	177500.0

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

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