PREVIEW / stock_daily / 2017-09-08

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-08.parquet
  size:    214 KB
  rows:    6,447
  symbols: 2,932

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
2017-09-08	AAPL	Stock	40.215	40.2875	39.6325	39.6575	114446000.0
2017-09-08	MSFT	Stock	74.33	74.44	73.84	73.98	14703800.0
2017-09-08	NVDA	Stock	4.1528	4.1678	4.0678	4.0922	498856000.0
2017-09-08	AMZN	Stock	48.955	48.994	48.1735	48.295	52106000.0
2017-09-08	GOOGL	Stock	47.485	47.535	47.0005	47.0705	19998320.0
2017-09-08	META	Stock	173.09	173.49	170.8	170.95	10998500.0
2017-09-08	TSLA	Stock	23.266	23.3187	22.82	22.8933	48952500.0
2017-09-08	TLT	Stock	129.11	129.16	128.57	129.0	9808531.0
2017-09-08	ES	Stock	63.1	63.66	62.96	63.49	1127800.0
2017-09-08	CL	Stock	71.32	72.29	71.11	71.82	2952600.0
2017-09-08	A	Stock	65.15	65.68	64.83	65.02	1587700.0
2017-09-08	AA	Stock	44.37	44.37	42.24	42.61	7297600.0
2017-09-08	AAAP-DELISTED	Stock	50.0	50.01	49.25	49.99	130636.0
2017-09-08	AABA-DELISTED	Stock	63.72	64.3395	63.5	63.56	2789803.0
2017-09-08	AAC-DELISTED	Stock	10.13	10.43	10.13	10.36	38582.0
2017-09-08	AACG	Stock	4.64	4.73	4.6	4.62	10100.0
2017-09-08	AAIC-DELISTED	Stock	12.81	12.863	12.79	12.84	161130.0
2017-09-08	AAL	Stock	43.81	44.11	43.49	43.6	4684600.0
2017-09-08	AAM.A-DELISTED	Stock	26.03	26.12	25.98	26.05	14123.0
2017-09-08	AAMC-DELISTED	Stock	31.1765	31.1765	28.7257	29.4118	19295.0
2017-09-08	AAME	Stock	3.35	3.45	3.35	3.45	1600.0
2017-09-08	AAMI	Stock	13.51	13.6	13.445	13.52	361200.0
2017-09-08	AAOI	Stock	55.98	57.82	55.88	56.76	1726300.0
2017-09-08	AAON	Stock	21.1667	21.52	21.0667	21.2333	342450.0
2017-09-08	AAP	Stock	93.59	95.03	92.48	94.03	1823800.0
2017-09-08	AAT	Stock	40.66	41.1	40.55	40.72	167000.0
2017-09-08	AAU-DELISTED	Stock	1.28	1.3001	1.25	1.25	208704.0
2017-09-08	AAUAF-DELISTED	Stock	1.28	1.3001	1.25	1.25	223876.0
2017-09-08	AAV-DELISTED	Stock	6.4	6.4	6.16	6.25	88743.0
2017-09-08	AAWW-DELISTED	Stock	66.15	66.55	65.1	65.55	95621.0
2017-09-08	AAXJ	Stock	72.21	72.2653	71.84	71.95	545592.0
2017-09-08	AAXN-DELISTED	Stock	21.51	21.96	21.46	21.64	473179.0
2017-09-08	AB	Stock	23.25	23.7	23.25	23.4	156100.0
2017-09-08	ABAC-DELISTED	Stock	2.0901	2.1243	2.0901	2.1243	500.0
2017-09-08	ABAX-DELISTED	Stock	45.2	45.67	44.44	45.14	98008.0
2017-09-08	ABB-DELISTED	Stock	23.98	24.07	23.95	24.03	897825.0
2017-09-08	ABBNY-DELISTED	Stock	23.98	24.07	23.95	24.03	959239.0
2017-09-08	ABBV	Stock	81.29	86.09	81.11	85.34	14809100.0
2017-09-08	ABC-DELISTED	Stock	82.54	83.94	82.33	82.5	1680989.0
2017-09-08	ABCB	Stock	41.6	42.55	41.25	41.95	129900.0
2017-09-08	ABCD-DELISTED	Stock	6.2	6.2124	6.05	6.11	39296.0
2017-09-08	ABCO-DELISTED	Stock	53.3	53.45	53.3	53.4	1112235.0
2017-09-08	ABDC-DELISTED	Stock	10.95	11.1498	10.95	11.07	53867.0
2017-09-08	ABE-DELISTED	Stock	14.3	14.36	14.2561	14.35	9028.0
2017-09-08	ABEO	Stock	348.75	355.0	335.0	346.25	24264.0
2017-09-08	ABEOW-DELISTED	Stock	8.7632	8.8	8.7632	8.8	500.0
2017-09-08	ABEV	Stock	6.46	6.48	6.38	6.43	16151600.0
2017-09-08	ABG	Stock	54.65	56.15	54.55	56.0	216900.0
2017-09-08	ABIL-DELISTED	Stock	0.76	0.798	0.73	0.7692	62002.0
2017-09-08	ABM	Stock	39.34	40.49	39.2	40.21	500900.0

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

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