PREVIEW / stock_daily / 2017-08-07

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-07.parquet
  size:    215 KB
  rows:    6,450
  symbols: 2,958

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-07	AAPL	Stock	39.265	39.73	39.1675	39.7025	87481200.0
2017-08-07	MSFT	Stock	72.8	72.9	72.26	72.4	18705700.0
2017-08-07	NVDA	Stock	4.2098	4.3093	4.2	4.3088	717412000.0
2017-08-07	AMZN	Stock	49.5325	49.75	49.357	49.6135	53532000.0
2017-08-07	GOOGL	Stock	47.376	47.448	47.175	47.2875	28915080.0
2017-08-07	META	Stock	169.95	172.06	169.66	171.98	12787800.0
2017-08-07	TSLA	Stock	23.8233	23.9653	23.5167	23.678	94867500.0
2017-08-07	TLT	Stock	124.84	125.1	124.607	125.07	4684576.0
2017-08-07	ES	Stock	61.59	62.08	61.4	62.05	1525800.0
2017-08-07	CL	Stock	71.46	71.82	71.27	71.74	2049200.0
2017-08-07	A	Stock	60.16	60.89	60.01	60.87	975700.0
2017-08-07	AA	Stock	38.0	38.47	37.61	37.99	4921600.0
2017-08-07	AAAP-DELISTED	Stock	49.89	49.89	48.78	49.5	75552.0
2017-08-07	AABA-DELISTED	Stock	58.86	60.16	58.7563	60.06	5124781.0
2017-08-07	AAC-DELISTED	Stock	8.09	8.35	8.0	8.14	195920.0
2017-08-07	AACG	Stock	4.68	4.7	4.68	4.7	2200.0
2017-08-07	AAIC-DELISTED	Stock	13.09	13.16	12.97	13.11	287393.0
2017-08-07	AAL	Stock	50.82	51.13	50.46	50.58	3016700.0
2017-08-07	AAM.A-DELISTED	Stock	26.2923	26.42	26.12	26.13	45518.0
2017-08-07	AAMC-DELISTED	Stock	25.6471	26.4191	25.2941	26.1029	33187.0
2017-08-07	AAME	Stock	3.4	3.6	3.4	3.55	600.0
2017-08-07	AAMI	Stock	14.29	14.58	14.155	14.32	762100.0
2017-08-07	AAOI	Stock	64.14	73.01	63.1	69.69	10880500.0
2017-08-07	AAON	Stock	23.4	23.6333	22.9333	23.3	330150.0
2017-08-07	AAP	Stock	110.86	111.17	108.2	109.49	1435300.0
2017-08-07	AAT	Stock	40.39	40.53	40.16	40.38	264400.0
2017-08-07	AAU-DELISTED	Stock	1.09	1.11	1.088	1.105	131929.0
2017-08-07	AAUAF-DELISTED	Stock	1.09	1.11	1.088	1.11	137749.0
2017-08-07	AAV-DELISTED	Stock	6.5	6.55	6.4	6.5	28421.0
2017-08-07	AAWW-DELISTED	Stock	65.55	65.85	64.75	65.65	445466.0
2017-08-07	AAXJ	Stock	71.22	71.5	71.22	71.5	655253.0
2017-08-07	AAXN-DELISTED	Stock	25.26	25.8796	25.15	25.72	557699.0
2017-08-07	AB	Stock	24.2	24.75	24.15	24.65	324800.0
2017-08-07	ABAC-DELISTED	Stock	2.24	2.3	2.22	2.25	6926.0
2017-08-07	ABAX-DELISTED	Stock	46.58	46.815	46.33	46.34	63191.0
2017-08-07	ABB-DELISTED	Stock	23.26	23.37	23.19	23.37	2072176.0
2017-08-07	ABBNY-DELISTED	Stock	23.26	23.37	23.19	23.36	2132773.0
2017-08-07	ABBV	Stock	70.94	71.23	70.64	71.22	3551100.0
2017-08-07	ABC-DELISTED	Stock	80.8	81.03	79.24	80.572	1963499.0
2017-08-07	ABCB	Stock	46.3	46.3	45.25	45.35	195600.0
2017-08-07	ABCD-DELISTED	Stock	4.869	4.869	4.73	4.78	51376.0
2017-08-07	ABCO-DELISTED	Stock	54.25	54.5	51.85	53.35	802122.0
2017-08-07	ABDC-DELISTED	Stock	11.32	11.41	10.67	11.02	249062.0
2017-08-07	ABE-DELISTED	Stock	14.18	14.2	14.17	14.171	7663.0
2017-08-07	ABEO	Stock	200.0	218.75	200.0	206.25	14948.0
2017-08-07	ABEOW-DELISTED	Stock	4.25	4.89	4.1	4.74	3400.0
2017-08-07	ABEV	Stock	6.11	6.18	6.09	6.15	11337000.0
2017-08-07	ABG	Stock	54.25	54.55	53.85	54.2	111300.0
2017-08-07	ABIL-DELISTED	Stock	0.67	0.67	0.576	0.591	102842.0
2017-08-07	ABM	Stock	44.75	44.87	44.39	44.7	165900.0

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

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