PREVIEW / stock_daily / 2017-06-08

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-08.parquet
  size:    214 KB
  rows:    6,440
  symbols: 2,998

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-06-08	AAPL	Stock	38.8125	38.885	38.6	38.7475	85003200.0
2017-06-08	MSFT	Stock	72.51	72.52	71.5	71.95	24588300.0
2017-06-08	NVDA	Stock	3.8365	4.0	3.7948	3.9985	1161744000.0
2017-06-08	AMZN	Stock	50.603	50.6805	50.3055	50.5135	55358000.0
2017-06-08	GOOGL	Stock	50.2115	50.28	49.831	50.214	33758500.0
2017-06-08	META	Stock	154.08	154.73	153.1	154.71	17799400.0
2017-06-08	TSLA	Stock	24.25	24.7933	24.0147	24.6667	135922500.0
2017-06-08	TLT	Stock	124.88	124.88	124.3	124.59	8758621.0
2017-06-08	ES	Stock	62.55	62.55	61.49	62.11	1507100.0
2017-06-08	CL	Stock	77.16	77.16	75.52	75.79	3361600.0
2017-06-08	A	Stock	60.63	60.73	59.71	60.15	3486600.0
2017-06-08	AA	Stock	32.6	33.65	32.59	33.5	3286500.0
2017-06-08	AAAP-DELISTED	Stock	36.43	36.82	35.54	36.17	35550.0
2017-06-08	AABA-DELISTED	Stock	55.33	55.94	53.49	55.72	55456329.0
2017-06-08	AAC-DELISTED	Stock	6.01	6.46	6.01	6.37	90951.0
2017-06-08	AACG	Stock	3.72	4.0	3.61	3.98	129600.0
2017-06-08	AAIC-DELISTED	Stock	14.27	14.43	14.27	14.29	425258.0
2017-06-08	AAL	Stock	50.86	51.87	50.41	51.43	6544300.0
2017-06-08	AAM.A-DELISTED	Stock	25.57	25.6	25.45	25.53	75479.0
2017-06-08	AAMC-DELISTED	Stock	24.5	25.0735	24.5	24.9706	2275.0
2017-06-08	AAME	Stock	3.85	3.85	3.85	3.85	100.0
2017-06-08	AAMI	Stock	14.5	14.6	14.47	14.51	773600.0
2017-06-08	AAOI	Stock	71.73	73.17	70.71	73.14	2063600.0
2017-06-08	AAON	Stock	24.1	24.6333	24.0	24.5	137850.0
2017-06-08	AAP	Stock	130.62	131.38	125.82	125.92	2226100.0
2017-06-08	AAT	Stock	40.35	40.35	39.84	40.05	202600.0
2017-06-08	AAU-DELISTED	Stock	1.4	1.4138	1.34	1.4	309861.0
2017-06-08	AAUAF-DELISTED	Stock	1.4	1.4138	1.34	1.38	312154.0
2017-06-08	AAV-DELISTED	Stock	6.0	6.125	5.975	6.0	59090.0
2017-06-08	AAWW-DELISTED	Stock	52.3	53.05	51.85	52.55	259403.0
2017-06-08	AAXJ	Stock	68.47	68.47	68.1	68.41	360816.0
2017-06-08	AAXN-DELISTED	Stock	24.25	24.58	24.18	24.44	400483.0
2017-06-08	AB	Stock	22.85	23.2	22.85	23.0	305300.0
2017-06-08	ABAC-DELISTED	Stock	2.16	2.2	2.1101	2.1101	6861.0
2017-06-08	ABAX-DELISTED	Stock	51.0	51.025	49.68	50.44	72646.0
2017-06-08	ABB-DELISTED	Stock	25.28	25.36	25.215	25.34	1214058.0
2017-06-08	ABBNY-DELISTED	Stock	25.28	25.36	25.215	25.34	1350808.0
2017-06-08	ABBV	Stock	68.75	69.05	68.33	68.76	6082500.0
2017-06-08	ABC-DELISTED	Stock	92.19	92.19	91.21	91.59	935724.0
2017-06-08	ABCB	Stock	44.6	46.9	44.4	46.15	217000.0
2017-06-08	ABCD-DELISTED	Stock	5.04	5.04	4.96	4.98	22430.0
2017-06-08	ABCO-DELISTED	Stock	51.3	51.55	51.0	51.0	610261.0
2017-06-08	ABDC-DELISTED	Stock	13.17	13.25	13.15	13.15	32770.0
2017-06-08	ABE-DELISTED	Stock	13.9	13.9299	13.81	13.9299	2510.0
2017-06-08	ABEO	Stock	123.75	126.5	122.5	125.0	6084.0
2017-06-08	ABEV	Stock	5.66	5.67	5.59	5.63	28609500.0
2017-06-08	ABG	Stock	56.5	56.7	53.95	54.15	281100.0
2017-06-08	ABIL-DELISTED	Stock	0.83	1.69	0.8	1.41	10407943.0
2017-06-08	ABM	Stock	43.88	44.46	41.46	43.99	753700.0
2017-06-08	ABMD-DELISTED	Stock	143.0	143.75	141.59	142.79	525660.0

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

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