PREVIEW / stock_daily / 2017-08-09

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-09.parquet
  size:    215 KB
  rows:    6,448
  symbols: 2,965

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-08-09	AAPL	Stock	39.815	40.3175	39.7775	40.265	104526000.0
2017-08-09	MSFT	Stock	72.25	72.51	72.05	72.47	22213400.0
2017-08-09	NVDA	Stock	4.2108	4.3052	4.1918	4.3028	530784000.0
2017-08-09	AMZN	Stock	49.13	49.4	48.7635	49.1005	71394000.0
2017-08-09	GOOGL	Stock	46.9225	47.188	46.696	47.004	28017040.0
2017-08-09	META	Stock	169.98	171.45	169.56	171.18	10815000.0
2017-08-09	TSLA	Stock	24.0667	24.6667	23.93	24.2353	103381500.0
2017-08-09	TLT	Stock	125.925	125.95	125.2	125.3	9221830.0
2017-08-09	ES	Stock	62.54	62.54	61.63	61.73	1427600.0
2017-08-09	CL	Stock	71.57	71.93	71.48	71.57	2486500.0
2017-08-09	A	Stock	60.07	60.23	59.38	59.68	1965000.0
2017-08-09	AA	Stock	39.21	39.45	38.4	38.62	3729300.0
2017-08-09	AAAP-DELISTED	Stock	48.2	50.0	48.2	50.0	52896.0
2017-08-09	AABA-DELISTED	Stock	59.23	59.95	59.07	59.78	2581478.0
2017-08-09	AAC-DELISTED	Stock	8.2	8.23	7.9	8.22	112726.0
2017-08-09	AAIC-DELISTED	Stock	13.09	13.22	13.05	13.18	288562.0
2017-08-09	AAL	Stock	49.74	49.92	49.23	49.4	5020800.0
2017-08-09	AAM.A-DELISTED	Stock	26.1527	26.1864	26.05	26.08	32381.0
2017-08-09	AAMC-DELISTED	Stock	25.2941	25.2941	21.7647	24.1176	19992.0
2017-08-09	AAME	Stock	3.53	3.55	3.4	3.4	2300.0
2017-08-09	AAMI	Stock	14.16	14.2	13.86	14.0	766800.0
2017-08-09	AAOI	Stock	70.23	71.2	66.66	67.47	4086300.0
2017-08-09	AAON	Stock	23.1667	23.1667	22.4333	22.5333	213750.0
2017-08-09	AAP	Stock	109.24	110.28	108.41	109.18	938000.0
2017-08-09	AAT	Stock	39.97	40.4	39.85	40.12	193300.0
2017-08-09	AAU-DELISTED	Stock	1.11	1.14	1.11	1.12	114436.0
2017-08-09	AAUAF-DELISTED	Stock	1.11	1.14	1.11	1.12	120198.0
2017-08-09	AAV-DELISTED	Stock	6.65	6.75	6.6	6.65	105615.0
2017-08-09	AAWW-DELISTED	Stock	63.9	63.9	62.575	62.95	293932.0
2017-08-09	AAXJ	Stock	70.75	70.99	70.635	70.96	1036573.0
2017-08-09	AAXN-DELISTED	Stock	24.3	25.26	21.8001	23.015	2471572.0
2017-08-09	AB	Stock	24.5	24.8	24.35	24.4	214300.0
2017-08-09	ABAC-DELISTED	Stock	2.22	2.3	2.1821	2.25	11926.0
2017-08-09	ABAX-DELISTED	Stock	46.39	46.5	45.87	46.34	68530.0
2017-08-09	ABB-DELISTED	Stock	23.25	23.26	23.12	23.24	943841.0
2017-08-09	ABBNY-DELISTED	Stock	23.25	23.26	23.12	23.26	982490.0
2017-08-09	ABBV	Stock	71.26	72.14	71.1	72.02	4536300.0
2017-08-09	ABC-DELISTED	Stock	79.86	79.95	78.6	79.84	2223002.0
2017-08-09	ABCB	Stock	45.1	45.85	44.68	44.85	142700.0
2017-08-09	ABCD-DELISTED	Stock	4.8	4.95	4.8	4.9299	31077.0
2017-08-09	ABCO-DELISTED	Stock	50.8	54.0	50.35	50.95	1906631.0
2017-08-09	ABDC-DELISTED	Stock	10.25	10.78	10.21	10.6	151874.0
2017-08-09	ABE-DELISTED	Stock	14.12	14.12	13.83	13.83	2998.0
2017-08-09	ABEO	Stock	190.0	197.5	190.0	192.5	10276.0
2017-08-09	ABEOW-DELISTED	Stock	4.3001	4.313	4.2938	4.3129	2450.0
2017-08-09	ABEV	Stock	6.07	6.15	6.06	6.12	23677300.0
2017-08-09	ABG	Stock	52.7	53.6	52.05	53.0	128300.0
2017-08-09	ABIL-DELISTED	Stock	0.5849	0.6781	0.58	0.62	168269.0
2017-08-09	ABM	Stock	44.38	44.53	44.11	44.26	233800.0
2017-08-09	ABMD-DELISTED	Stock	155.1	156.89	154.71	155.84	304398.0

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

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