PREVIEW / stock_daily / 2014-09-09

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-09.parquet
  size:    222 KB
  rows:    6,616
  symbols: 3,565

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-09-09	AAPL	Stock	24.77	25.77	24.035	24.4975	759385200.0
2014-09-09	MSFT	Stock	46.47	46.97	46.42	46.76	40302400.0
2014-09-09	NVDA	Stock	0.4925	0.4958	0.488	0.4885	198588000.0
2014-09-09	AMZN	Stock	17.0805	17.088	16.459	16.4875	92936000.0
2014-09-09	GOOGL	Stock	30.0135	30.03	29.524	29.5985	31491460.0
2014-09-09	META	Stock	77.59	78.17	76.2	76.67	28882000.0
2014-09-09	TSLA	Stock	18.866	19.0327	18.4667	18.5653	68382000.0
2014-09-09	TLT	Stock	115.49	115.89	115.45	115.69	5355366.0
2014-09-09	ES	Stock	46.2	46.24	45.8	45.83	2595300.0
2014-09-09	CL	Stock	63.5	63.72	63.37	63.43	3520600.0
2014-09-09	A	Stock	41.2661	41.3448	41.0944	41.0944	1797968.0
2014-09-09	AABA-DELISTED	Stock	42.05	42.06	40.6	40.78	50363083.0
2014-09-09	AACG	Stock	4.65	4.65	4.53	4.55	6500.0
2014-09-09	AAIC-DELISTED	Stock	27.77	27.78	27.61	27.7	307943.0
2014-09-09	AAL	Stock	37.63	38.68	37.38	37.96	9101100.0
2014-09-09	AAMC-DELISTED	Stock	209.1088	209.1088	205.8824	206.5	34989.0
2014-09-09	AAME	Stock	3.94	4.07	3.94	4.07	2600.0
2014-09-09	AAOI	Stock	19.95	20.005	19.0	19.1	214900.0
2014-09-09	AAON	Stock	12.7	12.7	12.34	12.4	242400.0
2014-09-09	AAP	Stock	136.39	137.09	135.55	135.88	354200.0
2014-09-09	AAT	Stock	35.34	35.48	35.12	35.27	140900.0
2014-09-09	AAU-DELISTED	Stock	1.53	1.53	1.46	1.5	151856.0
2014-09-09	AAUAF-DELISTED	Stock	1.53	1.53	1.46	1.5	153301.0
2014-09-09	AAV-DELISTED	Stock	5.61	5.78	5.61	5.72	345459.0
2014-09-09	AAVL-DELISTED	Stock	29.97	30.51	28.6	30.0	65051.0
2014-09-09	AAWW-DELISTED	Stock	34.59	34.59	33.79	33.935	153551.0
2014-09-09	AAXJ	Stock	65.86	65.92	65.24	65.45	675891.0
2014-09-09	AAXN-DELISTED	Stock	17.83	17.87	17.11	17.22	2659305.0
2014-09-09	AB	Stock	26.79	26.96	26.62	26.79	172500.0
2014-09-09	ABAC-DELISTED	Stock	1.3	1.3694	1.15	1.28	170854.0
2014-09-09	ABAX-DELISTED	Stock	48.52	49.2	48.31	48.82	90837.0
2014-09-09	ABB-DELISTED	Stock	23.32	23.34	23.01	23.08	1316197.0
2014-09-09	ABBNY-DELISTED	Stock	23.32	23.34	23.01	23.08	1379376.0
2014-09-09	ABBV	Stock	55.53	57.18	55.43	56.95	17558900.0
2014-09-09	ABC-DELISTED	Stock	78.22	78.33	77.83	77.98	942898.0
2014-09-09	ABCB	Stock	22.8	22.92	22.53	22.72	58500.0
2014-09-09	ABCD-DELISTED	Stock	1.6	1.61	1.55	1.57	13850.0
2014-09-09	ABCO-DELISTED	Stock	47.49	48.0	46.48	47.33	261038.0
2014-09-09	ABDC-DELISTED	Stock	13.72	13.96	13.6	13.75	46336.0
2014-09-09	ABE-DELISTED	Stock	14.7	14.74	14.64	14.68	25621.0
2014-09-09	ABEO	Stock	362.5	412.5	362.5	400.0	14.0
2014-09-09	ABEV	Stock	6.85	6.89	6.8	6.83	14842600.0
2014-09-09	ABG	Stock	71.25	71.64	69.46	69.52	310600.0
2014-09-09	ABGB-DELISTED	Stock	28.54	28.54	28.191	28.33	9393.0
2014-09-09	ABM	Stock	28.3	28.3	27.82	27.92	310200.0
2014-09-09	ABMD-DELISTED	Stock	25.3	25.37	24.84	24.94	95620.0
2014-09-09	ABR	Stock	6.93	6.93	6.87	6.87	57400.0
2014-09-09	ABR.A-DELISTED	Stock	24.83	24.88	24.83	24.88	1100.0
2014-09-09	ABR.B-DELISTED	Stock	24.1936	24.2199	24.15	24.1749	3808.0
2014-09-09	ABR.C-DELISTED	Stock	25.1401	25.26	25.1401	25.26	400.0

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

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