PREVIEW / stock_daily / 2016-05-19

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-19.parquet
  size:    217 KB
  rows:    6,525
  symbols: 3,266

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
2016-05-19	AAPL	Stock	23.66	23.66	23.3925	23.55	121768400.0
2016-05-19	MSFT	Stock	50.47	50.62	49.82	50.32	23842400.0
2016-05-19	NVDA	Stock	1.0798	1.0965	1.0783	1.0887	398880000.0
2016-05-19	AMZN	Stock	34.594	34.97	34.478	34.926	60512000.0
2016-05-19	GOOGL	Stock	35.915	36.025	35.5152	35.7655	30598200.0
2016-05-19	META	Stock	117.05	117.49	115.88	116.81	20544100.0
2016-05-19	TSLA	Stock	14.2413	14.4527	13.82	14.3473	102994500.0
2016-05-19	TLT	Stock	129.68	130.33	129.65	130.05	6209379.0
2016-05-19	ES	Stock	54.51	55.32	54.28	55.29	1894200.0
2016-05-19	CL	Stock	69.96	70.45	69.53	70.43	2728300.0
2016-05-19	A	Stock	44.07	44.82	43.98	44.56	3659500.0
2016-05-19	AA.B-DELISTED	Stock	31.34	32.0287	30.99	32.0287	35612.0
2016-05-19	AAAP-DELISTED	Stock	27.91	28.11	27.61	27.64	26275.0
2016-05-19	AABA-DELISTED	Stock	36.97	37.23	36.67	37.02	6699644.0
2016-05-19	AAC-DELISTED	Stock	19.82	19.83	19.49	19.595	78479.0
2016-05-19	AACG	Stock	5.2	5.29	5.2	5.26	6300.0
2016-05-19	AAIC-DELISTED	Stock	12.31	12.34	12.08	12.26	195330.0
2016-05-19	AAL	Stock	32.28	32.59	31.69	32.15	8875400.0
2016-05-19	AAMC-DELISTED	Stock	3.7235	3.8529	3.6412	3.6941	86625.0
2016-05-19	AAME	Stock	3.35	3.35	3.35	3.35	500.0
2016-05-19	AAMI	Stock	13.79	13.93	13.57	13.68	149600.0
2016-05-19	AAOI	Stock	9.23	9.505	8.7	8.8	474500.0
2016-05-19	AAON	Stock	18.0133	18.2533	17.72	17.96	165900.0
2016-05-19	AAP	Stock	134.12	144.22	132.98	143.54	5397200.0
2016-05-19	AAT	Stock	38.98	39.09	38.6	38.73	189300.0
2016-05-19	AAU-DELISTED	Stock	1.1	1.13	1.05	1.1	394496.0
2016-05-19	AAUAF-DELISTED	Stock	1.1	1.13	1.05	1.1	395961.0
2016-05-19	AAV-DELISTED	Stock	5.57	5.73	5.49	5.72	57896.0
2016-05-19	AAWW-DELISTED	Stock	42.14	43.5	42.01	43.1	321286.0
2016-05-19	AAXJ	Stock	50.53	51.04	50.53	50.87	850137.0
2016-05-19	AAXN-DELISTED	Stock	20.6	21.2	20.3101	21.12	885555.0
2016-05-19	AB	Stock	22.81	22.89	22.37	22.64	233100.0
2016-05-19	ABAC-DELISTED	Stock	0.61	0.62	0.59	0.62	21186.0
2016-05-19	ABAX-DELISTED	Stock	44.56	45.2	43.62	44.0	84379.0
2016-05-19	ABB-DELISTED	Stock	20.18	20.255	20.1	20.225	1539116.0
2016-05-19	ABBNY-DELISTED	Stock	20.17	20.255	20.1	20.23	1591203.0
2016-05-19	ABBV	Stock	60.06	60.35	58.9	59.28	9917900.0
2016-05-19	ABC-DELISTED	Stock	74.46	75.31	74.34	75.04	2766726.0
2016-05-19	ABCB	Stock	30.95	31.02	30.3	30.57	137400.0
2016-05-19	ABCD-DELISTED	Stock	4.38	4.52	4.31	4.51	41098.0
2016-05-19	ABCO-DELISTED	Stock	31.84	32.24	31.09	31.26	400251.0
2016-05-19	ABDC-DELISTED	Stock	11.82	12.09	11.74	11.97	34368.0
2016-05-19	ABE-DELISTED	Stock	11.65	11.65	11.6	11.65	2034.0
2016-05-19	ABEO	Stock	61.5	64.75	61.0	61.25	816.0
2016-05-19	ABEV	Stock	5.1	5.2	5.09	5.19	18730100.0
2016-05-19	ABG	Stock	52.93	54.43	52.81	53.28	363300.0
2016-05-19	ABIL-DELISTED	Stock	2.8	2.848	2.76	2.76	24966.0
2016-05-19	ABM	Stock	32.51	32.8	32.29	32.76	160100.0
2016-05-19	ABMD-DELISTED	Stock	94.32	96.09	93.11	95.37	383221.0
2016-05-19	ABR	Stock	6.71	6.74	6.66	6.7	57800.0

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

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