PREVIEW / stock_daily / 2015-09-17

all stock daily files

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

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-09-17	AAPL	Stock	28.915	29.1225	28.43	28.48	256450400.0
2015-09-17	MSFT	Stock	44.29	45.0	44.08	44.25	32768200.0
2015-09-17	NVDA	Stock	0.5875	0.5928	0.5815	0.5828	268712000.0
2015-09-17	AMZN	Stock	26.349	27.3485	26.3285	26.9435	83390000.0
2015-09-17	GOOGL	Stock	33.3745	34.0995	33.25	33.5835	47752100.0
2015-09-17	META	Stock	93.37	95.51	92.9	94.34	27841800.0
2015-09-17	TSLA	Stock	17.5973	17.7	17.3793	17.4713	53787000.0
2015-09-17	TLT	Stock	118.88	120.37	118.73	120.25	19843582.0
2015-09-17	ES	Stock	46.81	48.33	46.57	47.66	2985700.0
2015-09-17	CL	Stock	63.01	64.09	62.98	63.27	4595500.0
2015-09-17	A	Stock	36.63	36.99	36.29	36.4	1819100.0
2015-09-17	AA.B-DELISTED	Stock	35.6	36.17	35.19	35.52	54822.0
2015-09-17	AABA-DELISTED	Stock	31.3	31.33	30.81	30.94	15814808.0
2015-09-17	AAC-DELISTED	Stock	23.8	24.1899	23.04	23.65	215950.0
2015-09-17	AACG	Stock	2.5	2.5	2.37	2.47	18000.0
2015-09-17	AAIC-DELISTED	Stock	15.84	16.07	15.72	15.9	260709.0
2015-09-17	AAL	Stock	43.11	44.59	42.99	43.99	12835700.0
2015-09-17	AAMC-DELISTED	Stock	7.8353	8.5647	7.8088	8.0029	27598.0
2015-09-17	AAME	Stock	3.49	3.52	3.3	3.36	20700.0
2015-09-17	AAMI	Stock	16.22	16.68	16.22	16.45	120800.0
2015-09-17	AAOI	Stock	19.82	20.09	19.53	19.57	239200.0
2015-09-17	AAON	Stock	13.6867	13.8867	13.6	13.68	122550.0
2015-09-17	AAP	Stock	178.39	181.03	177.53	178.28	768200.0
2015-09-17	AAT	Stock	39.16	40.46	39.09	40.03	242300.0
2015-09-17	AAU-DELISTED	Stock	0.5374	0.55	0.52	0.5316	76141.0
2015-09-17	AAUAF-DELISTED	Stock	0.5374	0.55	0.52	0.5316	76849.0
2015-09-17	AAV-DELISTED	Stock	5.56	5.69	5.48	5.53	90010.0
2015-09-17	AAVL-DELISTED	Stock	10.98	11.5	10.8885	11.31	610084.0
2015-09-17	AAWW-DELISTED	Stock	39.61	40.08	38.955	38.99	266380.0
2015-09-17	AAXJ	Stock	54.52	56.03	54.52	54.94	716810.0
2015-09-17	AAXN-DELISTED	Stock	23.94	24.5	23.94	24.18	1103436.0
2015-09-17	AB	Stock	27.15	27.92	27.15	27.52	112500.0
2015-09-17	ABAC-DELISTED	Stock	0.7299	0.7299	0.6884	0.6884	8006.0
2015-09-17	ABAX-DELISTED	Stock	47.84	49.12	47.7	48.85	87583.0
2015-09-17	ABB-DELISTED	Stock	18.52	18.875	18.52	18.69	2851289.0
2015-09-17	ABBNY-DELISTED	Stock	18.52	18.875	18.52	18.67	2931528.0
2015-09-17	ABBV	Stock	59.56	60.92	59.39	59.86	10281700.0
2015-09-17	ABC-DELISTED	Stock	106.44	108.18	105.63	106.79	1362387.0
2015-09-17	ABCB	Stock	28.6	28.99	28.22	28.31	150800.0
2015-09-17	ABCD-DELISTED	Stock	4.91	5.03	4.9	4.97	74849.0
2015-09-17	ABCO-DELISTED	Stock	48.29	49.51	48.21	48.43	118311.0
2015-09-17	ABCW-DELISTED	Stock	40.72	41.19	40.05	40.35	66156.0
2015-09-17	ABDC-DELISTED	Stock	12.9	12.99	12.63	12.78	25618.0
2015-09-17	ABE-DELISTED	Stock	11.22	11.4499	11.165	11.4499	3160.0
2015-09-17	ABEO	Stock	124.0	130.75	121.25	129.5	3228.0
2015-09-17	ABEV	Stock	4.97	5.13	4.94	5.01	21157100.0
2015-09-17	ABG	Stock	83.39	86.13	83.39	84.89	372400.0
2015-09-17	ABGB-DELISTED	Stock	5.77	5.77	5.45	5.545	95397.0
2015-09-17	ABM	Stock	30.04	30.25	29.86	29.89	331700.0
2015-09-17	ABMD-DELISTED	Stock	98.58	107.88	98.4	104.08	702061.0

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

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