PREVIEW / stock_daily / 2017-05-19

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-19.parquet
  size:    215 KB
  rows:    6,443
  symbols: 3,003

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-19	AAPL	Stock	38.345	38.495	38.1575	38.265	107843200.0
2017-05-19	MSFT	Stock	67.5	68.1	67.43	67.69	26961100.0
2017-05-19	NVDA	Stock	3.4258	3.4555	3.3805	3.4	1018372000.0
2017-05-19	AMZN	Stock	48.142	48.446	47.986	47.992	79442000.0
2017-05-19	GOOGL	Stock	47.641	47.978	47.6	47.7325	27205980.0
2017-05-19	META	Stock	148.45	149.39	147.96	148.06	16187900.0
2017-05-19	TSLA	Stock	21.0333	21.1	20.68	20.722	70314000.0
2017-05-19	TLT	Stock	123.36	123.775	123.01	123.71	11277436.0
2017-05-19	ES	Stock	60.17	60.21	59.73	60.11	1683400.0
2017-05-19	CL	Stock	74.27	75.9	74.01	74.82	6902700.0
2017-05-19	A	Stock	56.09	56.32	55.86	56.13	1654400.0
2017-05-19	AA	Stock	32.16	32.88	32.1	32.29	2625900.0
2017-05-19	AAAP-DELISTED	Stock	36.4093	36.98	35.86	36.56	32602.0
2017-05-19	AABA-DELISTED	Stock	50.04	51.23	50.01	50.18	10076941.0
2017-05-19	AAC-DELISTED	Stock	6.58	7.12	6.58	6.72	89066.0
2017-05-19	AACG	Stock	3.51	3.6	3.51	3.57	28500.0
2017-05-19	AAIC-DELISTED	Stock	14.1	14.2364	14.07	14.21	272559.0
2017-05-19	AAL	Stock	44.8	45.38	44.74	45.22	6736700.0
2017-05-19	AAM.A-DELISTED	Stock	25.64	25.74	25.64	25.68	34784.0
2017-05-19	AAMC-DELISTED	Stock	22.0588	22.0588	21.9853	21.9853	1727.0
2017-05-19	AAME	Stock	3.65	3.75	3.6	3.75	5000.0
2017-05-19	AAMI	Stock	14.21	14.5	14.141	14.34	704800.0
2017-05-19	AAOI	Stock	64.74	65.93	63.5	63.54	2271300.0
2017-05-19	AAON	Stock	23.7	24.6333	23.7	24.4333	295950.0
2017-05-19	AAP	Stock	148.85	151.72	147.91	151.47	1617200.0
2017-05-19	AAT	Stock	39.12	39.63	38.93	39.36	404800.0
2017-05-19	AAU-DELISTED	Stock	1.4	1.4	1.27	1.29	193648.0
2017-05-19	AAUAF-DELISTED	Stock	1.4	1.4	1.27	1.29	204415.0
2017-05-19	AAV-DELISTED	Stock	6.5	6.775	6.5	6.675	521841.0
2017-05-19	AAWW-DELISTED	Stock	46.3	49.15	46.3	47.6	871501.0
2017-05-19	AAXJ	Stock	66.07	66.48	65.9701	66.42	730136.0
2017-05-19	AAXN-DELISTED	Stock	24.13	24.84	24.13	24.61	490511.0
2017-05-19	AB	Stock	21.1	21.15	20.9	20.95	677300.0
2017-05-19	ABAC-DELISTED	Stock	1.9	2.27	1.9	2.0782	34251.0
2017-05-19	ABAX-DELISTED	Stock	46.51	47.4	46.18	47.15	51242.0
2017-05-19	ABB-DELISTED	Stock	24.92	25.15	24.92	25.08	1467174.0
2017-05-19	ABBNY-DELISTED	Stock	24.92	25.15	24.92	25.08	1505918.0
2017-05-19	ABBV	Stock	65.74	66.01	65.31	65.58	6731800.0
2017-05-19	ABC-DELISTED	Stock	87.62	89.79	87.05	89.17	1610802.0
2017-05-19	ABCB	Stock	44.0	45.15	43.85	43.95	303300.0
2017-05-19	ABCD-DELISTED	Stock	4.97	5.0277	4.81	4.85	66565.0
2017-05-19	ABCO-DELISTED	Stock	51.75	51.85	50.875	51.2	247660.0
2017-05-19	ABDC-DELISTED	Stock	13.54	13.601	13.45	13.45	93482.0
2017-05-19	ABE-DELISTED	Stock	13.69	13.93	13.69	13.8111	3755.0
2017-05-19	ABEO	Stock	148.75	155.0	143.75	153.75	8368.0
2017-05-19	ABEV	Stock	5.67	5.67	5.58	5.66	46475100.0
2017-05-19	ABG	Stock	56.5	57.6	56.0	57.3	397400.0
2017-05-19	ABIL-DELISTED	Stock	0.67	0.67	0.64	0.65	9840.0
2017-05-19	ABM	Stock	41.39	41.74	41.1	41.29	239100.0
2017-05-19	ABMD-DELISTED	Stock	134.0	134.9099	132.63	134.42	192285.0

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

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