PREVIEW / stock_daily / 2016-09-22

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-22.parquet
  size:    219 KB
  rows:    6,554
  symbols: 3,223

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-09-22	AAPL	Stock	28.5875	28.735	28.5	28.655	124296000.0
2016-09-22	MSFT	Stock	57.92	58.0	57.63	57.82	19822200.0
2016-09-22	NVDA	Stock	1.631	1.636	1.6163	1.6255	308732000.0
2016-09-22	AMZN	Stock	39.7135	40.2945	39.7135	40.235	81578000.0
2016-09-22	GOOGL	Stock	40.5	40.953	40.3855	40.7975	35185800.0
2016-09-22	META	Stock	130.5	130.73	129.56	130.08	15538300.0
2016-09-22	TSLA	Stock	13.76	13.8187	13.5333	13.762	35743500.0
2016-09-22	TLT	Stock	136.67	137.29	136.5	136.95	12426243.0
2016-09-22	ES	Stock	55.78	56.06	55.45	55.82	1871900.0
2016-09-22	CL	Stock	73.2	73.63	73.15	73.53	2974200.0
2016-09-22	A	Stock	46.38	46.7	46.29	46.67	1306400.0
2016-09-22	AA.B-DELISTED	Stock	32.2	32.91	32.2	32.3743	26019.0
2016-09-22	AAAP-DELISTED	Stock	38.4	38.96	37.85	38.8799	56478.0
2016-09-22	AABA-DELISTED	Stock	43.94	44.87	43.74	44.14	31606701.0
2016-09-22	AAC-DELISTED	Stock	17.25	18.54	17.15	17.9	230802.0
2016-09-22	AACG	Stock	4.56	4.68	4.51	4.57	11400.0
2016-09-22	AAIC-DELISTED	Stock	15.46	15.52	15.17	15.46	328676.0
2016-09-22	AAL	Stock	34.96	36.03	34.85	35.25	7438700.0
2016-09-22	AAMC-DELISTED	Stock	4.8824	5.0676	4.7853	5.0294	38886.0
2016-09-22	AAME	Stock	3.3	3.41	3.3	3.3	1500.0
2016-09-22	AAMI	Stock	13.98	13.99	13.49	13.59	232200.0
2016-09-22	AAOI	Stock	22.0	22.47	20.63	20.84	757900.0
2016-09-22	AAON	Stock	19.0733	19.3067	19.0733	19.1933	196950.0
2016-09-22	AAP	Stock	147.62	149.74	147.0	149.15	1569300.0
2016-09-22	AAT	Stock	43.57	44.32	43.52	44.03	154100.0
2016-09-22	AAU-DELISTED	Stock	1.55	1.58	1.44	1.45	389116.0
2016-09-22	AAUAF-DELISTED	Stock	1.55	1.58	1.44	1.45	398596.0
2016-09-22	AAV-DELISTED	Stock	7.05	7.12	6.85	6.9	177331.0
2016-09-22	AAWW-DELISTED	Stock	39.67	41.11	39.58	40.75	377052.0
2016-09-22	AAXJ	Stock	61.38	61.63	61.29	61.43	2209590.0
2016-09-22	AAXN-DELISTED	Stock	28.22	28.5738	28.03	28.24	1143989.0
2016-09-22	AB	Stock	22.97	23.16	22.94	23.09	205800.0
2016-09-22	ABAC-DELISTED	Stock	2.32	2.32	2.2001	2.2409	12058.0
2016-09-22	ABAX-DELISTED	Stock	52.13	52.87	51.77	52.86	103698.0
2016-09-22	ABB-DELISTED	Stock	22.85	22.88	22.75	22.81	1077459.0
2016-09-22	ABBNY-DELISTED	Stock	22.85	22.88	22.75	22.81	1123251.0
2016-09-22	ABBV	Stock	64.12	65.2	64.08	65.08	5416100.0
2016-09-22	ABC-DELISTED	Stock	83.26	83.95	83.05	83.54	2087626.0
2016-09-22	ABCB	Stock	35.36	35.48	35.09	35.46	252600.0
2016-09-22	ABCD-DELISTED	Stock	5.4547	5.8552	5.4547	5.66	76109.0
2016-09-22	ABCO-DELISTED	Stock	44.77	45.31	44.14	44.19	283188.0
2016-09-22	ABDC-DELISTED	Stock	13.3	13.47	13.1	13.18	51541.0
2016-09-22	ABE-DELISTED	Stock	12.7	12.87	12.6801	12.87	6258.0
2016-09-22	ABEO	Stock	167.0	170.0	151.25	159.75	32696.0
2016-09-22	ABEOW-DELISTED	Stock	3.5	3.52	2.99	3.1	13343.0
2016-09-22	ABEV	Stock	6.1	6.16	6.07	6.09	8552100.0
2016-09-22	ABG	Stock	53.74	55.29	53.19	55.2	180900.0
2016-09-22	ABIL-DELISTED	Stock	3.9	3.9	3.819	3.9	12150.0
2016-09-22	ABM	Stock	39.5	40.03	39.36	40.0	259000.0
2016-09-22	ABMD-DELISTED	Stock	127.86	127.86	126.17	126.4	276391.0

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

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