PREVIEW / stock_daily / 2016-01-06

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-06.parquet
  size:    220 KB
  rows:    6,629
  symbols: 3,391

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-01-06	AAPL	Stock	25.14	25.5925	24.9675	25.175	273829600.0
2016-01-06	MSFT	Stock	54.32	54.4	53.64	54.05	39518900.0
2016-01-06	NVDA	Stock	0.8088	0.8125	0.779	0.7883	449344000.0
2016-01-06	AMZN	Stock	31.1	31.9895	31.0155	31.6325	106584000.0
2016-01-06	GOOGL	Stock	37.5185	38.2865	37.4	37.9665	48206020.0
2016-01-06	META	Stock	101.13	103.77	100.9	102.97	25096200.0
2016-01-06	TSLA	Stock	14.6667	14.67	14.3987	14.6027	56686500.0
2016-01-06	TLT	Stock	122.3	122.62	122.05	122.59	8916942.0
2016-01-06	ES	Stock	51.04	51.65	50.73	51.46	1265500.0
2016-01-06	CL	Stock	64.21	64.64	63.96	64.14	4407600.0
2016-01-06	A	Stock	40.24	40.99	40.05	40.73	2103600.0
2016-01-06	AA.B-DELISTED	Stock	30.8	30.8	29.6026	30.19	110762.0
2016-01-06	AAAP-DELISTED	Stock	30.58	30.58	29.21	29.99	9931.0
2016-01-06	AABA-DELISTED	Stock	31.69	32.455	31.6	32.16	15158641.0
2016-01-06	AAC-DELISTED	Stock	19.5	19.535	18.76	19.0	110834.0
2016-01-06	AACG	Stock	6.61	7.32	6.51	7.19	140400.0
2016-01-06	AAIC-DELISTED	Stock	13.27	13.48	13.27	13.4	252933.0
2016-01-06	AAL	Stock	40.05	41.7	40.0	41.23	12393800.0
2016-01-06	AAMC-DELISTED	Stock	5.7941	6.1412	5.5544	5.8735	173587.0
2016-01-06	AAME	Stock	4.7	4.7	4.65	4.7	1900.0
2016-01-06	AAMI	Stock	14.63	14.8	14.19	14.37	200500.0
2016-01-06	AAOI	Stock	15.7	16.11	15.688	16.05	258700.0
2016-01-06	AAON	Stock	14.5733	14.6733	14.4	14.46	143550.0
2016-01-06	AAP	Stock	149.68	150.05	145.78	147.2	1048400.0
2016-01-06	AAT	Stock	38.45	38.83	38.3	38.73	212400.0
2016-01-06	AAU-DELISTED	Stock	0.65	0.6501	0.6021	0.63	57707.0
2016-01-06	AAUAF-DELISTED	Stock	0.65	0.6501	0.6021	0.63	57991.0
2016-01-06	AAV-DELISTED	Stock	4.76	4.88	4.74	4.77	43075.0
2016-01-06	AAVL-DELISTED	Stock	8.64	8.64	7.82	7.94	273583.0
2016-01-06	AAWW-DELISTED	Stock	39.7	40.33	39.0	39.08	211031.0
2016-01-06	AAXJ	Stock	51.02	51.27	50.81	50.94	1022506.0
2016-01-06	AAXN-DELISTED	Stock	17.92	18.37	17.4	17.64	2914243.0
2016-01-06	AB	Stock	22.8	23.17	22.52	22.97	182600.0
2016-01-06	ABAC-DELISTED	Stock	0.8999	0.9	0.76	0.76	1266.0
2016-01-06	ABAX-DELISTED	Stock	54.45	55.25	54.08	55.02	144449.0
2016-01-06	ABB-DELISTED	Stock	16.95	17.04	16.83	16.91	2514046.0
2016-01-06	ABBNY-DELISTED	Stock	16.96	17.04	16.83	16.92	2570098.0
2016-01-06	ABBV	Stock	56.37	57.56	56.18	57.38	8952700.0
2016-01-06	ABC-DELISTED	Stock	101.46	102.64	101.31	101.78	2026550.0
2016-01-06	ABCB	Stock	32.14	32.43	32.06	32.14	510400.0
2016-01-06	ABCD-DELISTED	Stock	4.92	5.06	4.87	4.91	23845.0
2016-01-06	ABCO-DELISTED	Stock	46.76	47.53	46.39	46.95	150378.0
2016-01-06	ABCW-DELISTED	Stock	43.11	43.95	43.11	43.78	31109.0
2016-01-06	ABDC-DELISTED	Stock	11.34	11.9	11.26	11.82	57319.0
2016-01-06	ABE-DELISTED	Stock	10.6	10.6	10.57	10.5761	2059.0
2016-01-06	ABEO	Stock	85.75	87.0	80.75	80.75	4452.0
2016-01-06	ABEV	Stock	4.28	4.34	4.25	4.28	11505800.0
2016-01-06	ABG	Stock	63.82	63.82	56.99	57.34	1002100.0
2016-01-06	ABGB-DELISTED	Stock	1.154	1.29	1.15	1.23	21515.0
2016-01-06	ABIL-DELISTED	Stock	10.11	10.11	9.65	9.7	45963.0

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

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