PREVIEW / stock_daily / 2016-10-06

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-06.parquet
  size:    217 KB
  rows:    6,458
  symbols: 3,161

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-10-06	AAPL	Stock	28.425	28.585	28.2825	28.4725	115117200.0
2016-10-06	MSFT	Stock	57.74	57.86	57.28	57.74	16212600.0
2016-10-06	NVDA	Stock	1.6852	1.6958	1.6565	1.6835	360212000.0
2016-10-06	AMZN	Stock	42.185	42.3605	42.03	42.083	53680000.0
2016-10-06	GOOGL	Stock	40.204	40.3472	40.0255	40.154	21998180.0
2016-10-06	META	Stock	128.43	129.06	128.08	128.74	11682700.0
2016-10-06	TSLA	Stock	13.4973	13.614	13.3473	13.4	70551000.0
2016-10-06	TLT	Stock	133.97	134.69	133.68	133.83	7839909.0
2016-10-06	ES	Stock	52.53	52.82	51.99	52.72	1808700.0
2016-10-06	CL	Stock	72.87	73.52	72.67	73.28	2561700.0
2016-10-06	A	Stock	47.01	47.43	46.88	47.3	1772800.0
2016-10-06	AA.B-DELISTED	Stock	33.77	34.14	33.6	34.06	61109.0
2016-10-06	AAAP-DELISTED	Stock	39.6	39.6	37.25	38.65	2150338.0
2016-10-06	AABA-DELISTED	Stock	43.65	43.82	43.37	43.68	5960206.0
2016-10-06	AAC-DELISTED	Stock	17.17	17.3	17.045	17.17	142258.0
2016-10-06	AACG	Stock	4.58	4.58	4.19	4.2	1400.0
2016-10-06	AAIC-DELISTED	Stock	14.38	14.39	14.24	14.33	271460.0
2016-10-06	AAL	Stock	37.83	38.22	37.57	38.17	5160200.0
2016-10-06	AAMC-DELISTED	Stock	6.1088	6.6941	5.945	6.5441	46587.0
2016-10-06	AAME	Stock	3.36	3.4	3.27	3.27	2400.0
2016-10-06	AAMI	Stock	14.18	14.3	14.06	14.14	126400.0
2016-10-06	AAOI	Stock	23.02	23.4	22.91	23.05	317200.0
2016-10-06	AAON	Stock	20.34	20.5	20.14	20.4867	200550.0
2016-10-06	AAP	Stock	148.67	149.09	147.42	148.71	608400.0
2016-10-06	AAT	Stock	40.52	40.92	40.13	40.71	230200.0
2016-10-06	AAU-DELISTED	Stock	1.27	1.29	1.19	1.225	547264.0
2016-10-06	AAUAF-DELISTED	Stock	1.27	1.29	1.19	1.225	552337.0
2016-10-06	AAV-DELISTED	Stock	7.3	7.47	7.12	7.46	137231.0
2016-10-06	AAWW-DELISTED	Stock	43.07	43.2	42.2	42.62	111651.0
2016-10-06	AAXJ	Stock	60.77	61.1	60.62	61.1	578375.0
2016-10-06	AAXN-DELISTED	Stock	23.09	23.42	22.81	23.3	1832948.0
2016-10-06	AB	Stock	22.45	22.65	22.23	22.58	98900.0
2016-10-06	ABAC-DELISTED	Stock	2.088	2.15	2.0222	2.11	2899.0
2016-10-06	ABAX-DELISTED	Stock	52.54	52.54	51.81	52.24	75731.0
2016-10-06	ABB-DELISTED	Stock	22.88	22.92	22.79	22.88	1216152.0
2016-10-06	ABBNY-DELISTED	Stock	22.88	22.92	22.79	22.88	1263961.0
2016-10-06	ABBV	Stock	63.16	63.21	62.56	62.83	4446100.0
2016-10-06	ABC-DELISTED	Stock	79.58	80.29	78.9	80.15	1946066.0
2016-10-06	ABCB	Stock	35.59	35.95	35.39	35.69	171900.0
2016-10-06	ABCD-DELISTED	Stock	5.44	5.44	5.37	5.43	3730.0
2016-10-06	ABCO-DELISTED	Stock	42.2	43.23	41.97	43.04	261134.0
2016-10-06	ABDC-DELISTED	Stock	12.81	13.13	12.67	12.68	24582.0
2016-10-06	ABE-DELISTED	Stock	12.631	12.6668	12.62	12.62	12626.0
2016-10-06	ABEO	Stock	167.0	168.0	157.5	164.0	15552.0
2016-10-06	ABEV	Stock	6.02	6.1	6.0	6.08	6245400.0
2016-10-06	ABG	Stock	55.87	55.87	54.54	54.9	173800.0
2016-10-06	ABIL-DELISTED	Stock	3.83	3.86	3.83	3.84	9655.0
2016-10-06	ABM	Stock	38.98	39.4	38.76	39.26	149500.0
2016-10-06	ABMD-DELISTED	Stock	127.5	128.79	126.02	128.51	335819.0
2016-10-06	ABR	Stock	7.17	7.27	7.05	7.21	98900.0

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

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