PREVIEW / stock_daily / 2017-05-23

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-23.parquet
  size:    215 KB
  rows:    6,463
  symbols: 3,017

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-05-23	AAPL	Stock	38.725	38.725	38.3275	38.45	79675600.0
2017-05-23	MSFT	Stock	68.72	68.75	68.38	68.68	15425800.0
2017-05-23	NVDA	Stock	3.4925	3.4948	3.3928	3.4258	681248000.0
2017-05-23	AMZN	Stock	48.751	48.76	48.3425	48.577	48312000.0
2017-05-23	GOOGL	Stock	48.498	48.7255	48.225	48.5275	30908420.0
2017-05-23	META	Stock	148.52	148.81	147.25	148.07	12817800.0
2017-05-23	TSLA	Stock	20.6973	20.7153	20.232	20.2573	64776000.0
2017-05-23	TLT	Stock	123.51	123.62	122.48	122.54	7901311.0
2017-05-23	ES	Stock	60.75	61.32	60.73	61.14	2430500.0
2017-05-23	CL	Stock	74.36	74.78	73.74	73.84	2799700.0
2017-05-23	A	Stock	59.8	59.98	58.0	58.66	7510600.0
2017-05-23	AA	Stock	32.98	33.36	32.56	33.26	2964200.0
2017-05-23	AAAP-DELISTED	Stock	36.94	38.48	36.57	38.44	86541.0
2017-05-23	AABA-DELISTED	Stock	50.66	50.9	50.26	50.31	6668446.0
2017-05-23	AAC-DELISTED	Stock	6.99	7.08	6.8	7.04	54560.0
2017-05-23	AACG	Stock	3.5	3.5	3.42	3.45	13200.0
2017-05-23	AAIC-DELISTED	Stock	14.34	14.45	14.2501	14.43	306410.0
2017-05-23	AAL	Stock	46.27	46.69	45.94	46.66	3008500.0
2017-05-23	AAM.A-DELISTED	Stock	25.72	25.82	25.66	25.75	49016.0
2017-05-23	AAMC-DELISTED	Stock	21.9559	24.4118	21.9559	23.1029	31712.0
2017-05-23	AAME	Stock	3.61	3.7	3.61	3.7	900.0
2017-05-23	AAMI	Stock	14.25	14.27	13.96	13.99	515600.0
2017-05-23	AAOI	Stock	71.6	71.7	67.06	69.15	3771600.0
2017-05-23	AAON	Stock	24.6333	24.6333	24.1667	24.4333	168750.0
2017-05-23	AAP	Stock	139.15	143.83	139.14	140.66	3897500.0
2017-05-23	AAT	Stock	39.49	39.57	38.96	39.04	356100.0
2017-05-23	AAU-DELISTED	Stock	1.33	1.33	1.25	1.255	229680.0
2017-05-23	AAUAF-DELISTED	Stock	1.33	1.33	1.25	1.27	239225.0
2017-05-23	AAV-DELISTED	Stock	6.6	6.725	6.6	6.7	74556.0
2017-05-23	AAWW-DELISTED	Stock	48.65	49.1	47.65	48.75	257749.0
2017-05-23	AAXJ	Stock	66.5	66.51	66.2752	66.29	727266.0
2017-05-23	AAXN-DELISTED	Stock	24.75	24.94	24.46	24.9	417606.0
2017-05-23	AB	Stock	21.05	21.35	20.93	21.1	856200.0
2017-05-23	ABAC-DELISTED	Stock	1.95	1.95	1.88	1.9499	8857.0
2017-05-23	ABAX-DELISTED	Stock	48.1	48.22	47.6893	48.12	30810.0
2017-05-23	ABB-DELISTED	Stock	24.93	25.03	24.81	24.84	1346037.0
2017-05-23	ABBNY-DELISTED	Stock	24.92	25.03	24.81	24.85	1392229.0
2017-05-23	ABBV	Stock	65.44	66.26	65.43	65.84	4676500.0
2017-05-23	ABC-DELISTED	Stock	89.73	89.85	89.03	89.24	1268192.0
2017-05-23	ABCB	Stock	44.4	45.6	44.03	45.25	197700.0
2017-05-23	ABCD-DELISTED	Stock	5.05	5.12	4.95	5.06	9181.0
2017-05-23	ABCO-DELISTED	Stock	51.15	51.15	50.45	51.025	129375.0
2017-05-23	ABDC-DELISTED	Stock	13.5	13.58	13.45	13.48	105350.0
2017-05-23	ABE-DELISTED	Stock	13.83	13.83	13.8	13.82	440.0
2017-05-23	ABEO	Stock	147.5	151.5	146.25	147.5	2688.0
2017-05-23	ABEV	Stock	5.69	5.78	5.68	5.76	23231600.0
2017-05-23	ABG	Stock	57.1	57.7	55.6	56.15	272600.0
2017-05-23	ABIL-DELISTED	Stock	0.71	0.71	0.67	0.691	32792.0
2017-05-23	ABM	Stock	41.92	42.21	41.36	42.07	158800.0
2017-05-23	ABMD-DELISTED	Stock	136.62	136.625	134.55	134.73	186489.0

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

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