PREVIEW / stock_daily / 2015-03-09

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-09.parquet
  size:    222 KB
  rows:    6,641
  symbols: 3,513

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-09	AAPL	Stock	31.99	32.3925	31.265	31.785	354114000.0
2015-03-09	MSFT	Stock	42.19	43.13	42.19	42.85	32108000.0
2015-03-09	NVDA	Stock	0.564	0.5695	0.5628	0.5652	222388000.0
2015-03-09	AMZN	Stock	18.92	18.9665	18.764	18.928	46228000.0
2015-03-09	GOOGL	Stock	28.546	28.7725	28.4525	28.705	23484880.0
2015-03-09	META	Stock	79.68	79.91	78.63	79.44	18925100.0
2015-03-09	TSLA	Stock	12.9593	12.966	12.55	12.7253	101050500.0
2015-03-09	TLT	Stock	124.68	124.87	124.13	124.64	8889065.0
2015-03-09	ES	Stock	49.23	49.33	48.69	48.86	965000.0
2015-03-09	CL	Stock	69.12	69.8	69.06	69.59	2564500.0
2015-03-09	A	Stock	41.54	41.89	41.44	41.74	1492400.0
2015-03-09	AA.B-DELISTED	Stock	46.11	46.78	44.9474	45.7	248715.0
2015-03-09	AABA-DELISTED	Stock	43.6	43.93	42.67	42.98	11238950.0
2015-03-09	AAC-DELISTED	Stock	28.75	28.95	26.0	26.19	378301.0
2015-03-09	AACG	Stock	3.96	4.25	3.85	4.25	8000.0
2015-03-09	AAIC-DELISTED	Stock	24.68	24.87	24.46	24.52	302790.0
2015-03-09	AAL	Stock	48.05	48.58	47.58	47.92	7460200.0
2015-03-09	AAMC-DELISTED	Stock	57.3529	60.7353	55.8765	60.7353	68534.0
2015-03-09	AAME	Stock	3.97	4.02	3.97	4.01	1400.0
2015-03-09	AAMI	Stock	17.65	17.79	17.41	17.48	111700.0
2015-03-09	AAOI	Stock	12.48	12.48	11.87	12.0	198100.0
2015-03-09	AAON	Stock	14.6267	14.7	14.5133	14.6133	94650.0
2015-03-09	AAP	Stock	149.0	149.51	147.75	148.29	839300.0
2015-03-09	AAT	Stock	40.4	40.81	40.09	40.54	94500.0
2015-03-09	AAU-DELISTED	Stock	0.96	0.9801	0.94	0.94	241533.0
2015-03-09	AAUAF-DELISTED	Stock	0.96	0.9801	0.94	0.94	245360.0
2015-03-09	AAV-DELISTED	Stock	5.29	5.32	5.11	5.12	138979.0
2015-03-09	AAVL-DELISTED	Stock	36.15	37.2	35.22	37.08	186315.0
2015-03-09	AAWW-DELISTED	Stock	46.02	47.01	46.02	46.44	145275.0
2015-03-09	AAXJ	Stock	62.59	62.63	62.415	62.46	520461.0
2015-03-09	AAXN-DELISTED	Stock	22.6	22.7999	21.94	22.02	1086278.0
2015-03-09	AB	Stock	28.47	28.6	27.88	28.2	381700.0
2015-03-09	ABAX-DELISTED	Stock	62.54	63.59	62.024	63.31	173667.0
2015-03-09	ABB-DELISTED	Stock	20.81	20.82	20.6	20.74	1887920.0
2015-03-09	ABBNY-DELISTED	Stock	20.81	20.82	20.6	20.75	2009177.0
2015-03-09	ABBV	Stock	55.93	56.03	55.26	55.54	14779900.0
2015-03-09	ABC-DELISTED	Stock	102.47	103.58	102.01	103.36	1157877.0
2015-03-09	ABCB	Stock	25.38	25.91	25.38	25.74	52400.0
2015-03-09	ABCD-DELISTED	Stock	2.97	3.17	2.97	3.017	66236.0
2015-03-09	ABCO-DELISTED	Stock	53.21	53.555	52.3	53.27	198421.0
2015-03-09	ABCW-DELISTED	Stock	33.74	34.96	33.74	33.88	1956.0
2015-03-09	ABDC-DELISTED	Stock	13.48	13.8	13.48	13.8	20365.0
2015-03-09	ABE-DELISTED	Stock	12.79	12.8299	12.78	12.8299	78210.0
2015-03-09	ABEO	Stock	88.75	88.75	85.5	87.25	1268.0
2015-03-09	ABEOW-DELISTED	Stock	0.98	1.05	0.94	1.05	5250.0
2015-03-09	ABEV	Stock	5.88	5.92	5.83	5.85	11591800.0
2015-03-09	ABG	Stock	76.29	76.79	74.74	75.81	423200.0
2015-03-09	ABGB-DELISTED	Stock	17.56	17.62	17.47	17.6	24916.0
2015-03-09	ABIL-DELISTED	Stock	9.9	9.91	9.87	9.87	500.0
2015-03-09	ABM	Stock	29.38	29.61	29.27	29.4	198100.0

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

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