PREVIEW / stock_daily / 2015-09-16

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-16.parquet
  size:    222 KB
  rows:    6,659
  symbols: 3,459

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-16	AAPL	Stock	29.0625	29.135	28.86	29.1025	148694000.0
2015-09-16	MSFT	Stock	43.97	44.38	43.84	44.3	23372200.0
2015-09-16	NVDA	Stock	0.5725	0.5808	0.5682	0.5775	173508000.0
2015-09-16	AMZN	Stock	26.099	26.415	25.926	26.3695	45056000.0
2015-09-16	GOOGL	Stock	33.2775	33.4035	33.11	33.276	26251960.0
2015-09-16	META	Stock	92.9	93.6	92.63	93.45	16321200.0
2015-09-16	TSLA	Stock	16.8693	17.5253	16.8587	17.4833	66256500.0
2015-09-16	TLT	Stock	118.96	119.44	118.55	118.8	6949781.0
2015-09-16	ES	Stock	46.65	46.93	46.46	46.71	1929500.0
2015-09-16	CL	Stock	62.6	63.23	62.5	63.07	2889600.0
2015-09-16	A	Stock	36.15	36.87	36.06	36.52	2130100.0
2015-09-16	AA.B-DELISTED	Stock	34.54	35.675	34.54	35.675	76225.0
2015-09-16	AABA-DELISTED	Stock	31.16	31.77	30.99	31.4	21188525.0
2015-09-16	AAC-DELISTED	Stock	22.66	24.14	22.38	23.91	145047.0
2015-09-16	AACG	Stock	2.43	2.5	2.35	2.48	41400.0
2015-09-16	AAIC-DELISTED	Stock	15.77	15.99	15.75	15.85	176532.0
2015-09-16	AAL	Stock	42.4	43.25	42.24	43.06	7703100.0
2015-09-16	AAMC-DELISTED	Stock	7.8088	8.0088	7.3471	7.8353	33072.0
2015-09-16	AAME	Stock	3.55	3.57	3.34	3.39	7200.0
2015-09-16	AAMI	Stock	16.39	16.43	15.99	16.26	235300.0
2015-09-16	AAOI	Stock	19.17	20.3	19.13	19.89	313400.0
2015-09-16	AAON	Stock	13.5933	13.7733	13.52	13.7267	118800.0
2015-09-16	AAP	Stock	175.92	178.99	175.41	178.59	600900.0
2015-09-16	AAT	Stock	39.05	39.37	39.0	39.25	165500.0
2015-09-16	AAU-DELISTED	Stock	0.5124	0.5338	0.5124	0.5141	18495.0
2015-09-16	AAUAF-DELISTED	Stock	0.5124	0.5338	0.5124	0.5141	18595.0
2015-09-16	AAV-DELISTED	Stock	5.41	5.61	5.37	5.55	69916.0
2015-09-16	AAVL-DELISTED	Stock	10.71	11.17	10.55	11.01	302888.0
2015-09-16	AAWW-DELISTED	Stock	39.83	40.3	39.3	39.79	165356.0
2015-09-16	AAXJ	Stock	54.73	55.2	54.61	55.09	804138.0
2015-09-16	AAXN-DELISTED	Stock	24.17	24.32	23.95	24.01	1042172.0
2015-09-16	AB	Stock	27.26	27.43	26.46	27.25	251100.0
2015-09-16	ABAC-DELISTED	Stock	0.72	0.738	0.675	0.69	11685.0
2015-09-16	ABAX-DELISTED	Stock	48.91	49.06	47.86	47.97	259205.0
2015-09-16	ABB-DELISTED	Stock	18.7	18.83	18.69	18.82	1925405.0
2015-09-16	ABBNY-DELISTED	Stock	18.7	18.83	18.69	18.82	1981863.0
2015-09-16	ABBV	Stock	59.5	59.64	58.63	59.51	8044200.0
2015-09-16	ABC-DELISTED	Stock	105.51	106.45	104.82	106.28	1260592.0
2015-09-16	ABCB	Stock	28.57	28.59	28.21	28.58	263900.0
2015-09-16	ABCD-DELISTED	Stock	4.93	4.96	4.85	4.92	50049.0
2015-09-16	ABCO-DELISTED	Stock	48.5	48.83	48.05	48.22	110637.0
2015-09-16	ABCW-DELISTED	Stock	40.85	41.43	40.5	40.85	67766.0
2015-09-16	ABDC-DELISTED	Stock	12.81	13.035	12.64	12.9299	31296.0
2015-09-16	ABE-DELISTED	Stock	11.15	11.4	11.15	11.272	2787.0
2015-09-16	ABEO	Stock	129.25	131.25	120.5	124.75	8048.0
2015-09-16	ABEOW-DELISTED	Stock	1.76	2.12	1.76	1.86	6200.0
2015-09-16	ABEV	Stock	5.0	5.1	4.99	5.04	47464700.0
2015-09-16	ABG	Stock	82.15	83.23	81.81	83.16	159700.0
2015-09-16	ABGB-DELISTED	Stock	5.68	5.84	5.68	5.8	164269.0
2015-09-16	ABM	Stock	29.96	30.1	29.83	29.99	508200.0

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

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