PREVIEW / stock_daily / 2017-08-18

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-18.parquet
  size:    213 KB
  rows:    6,416
  symbols: 2,930

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-08-18	AAPL	Stock	39.465	39.875	39.18	39.375	109712400.0
2017-08-18	MSFT	Stock	72.27	72.84	71.93	72.49	18761500.0
2017-08-18	NVDA	Stock	4.0918	4.109	3.991	4.0375	601204000.0
2017-08-18	AMZN	Stock	48.07	48.2715	47.7325	47.9235	65696000.0
2017-08-18	GOOGL	Stock	46.349	46.551	46.1725	46.309	26748080.0
2017-08-18	META	Stock	166.84	168.67	166.21	167.41	15093600.0
2017-08-18	TSLA	Stock	23.5273	23.6	23.0533	23.164	81123000.0
2017-08-18	TLT	Stock	126.98	127.15	126.26	126.62	8382502.0
2017-08-18	ES	Stock	62.37	63.18	62.06	63.06	1481000.0
2017-08-18	CL	Stock	71.34	71.52	71.01	71.02	3317600.0
2017-08-18	A	Stock	60.76	61.72	60.28	61.25	2357900.0
2017-08-18	AA	Stock	37.88	38.21	37.34	37.76	2118700.0
2017-08-18	AAAP-DELISTED	Stock	49.07	49.54	47.8	47.91	37266.0
2017-08-18	AABA-DELISTED	Stock	62.36	63.7	62.055	63.13	7081214.0
2017-08-18	AAC-DELISTED	Stock	8.74	9.11	8.7	9.05	49303.0
2017-08-18	AACG	Stock	4.58	4.7	4.58	4.68	1500.0
2017-08-18	AAIC-DELISTED	Stock	12.95	12.98	12.68	12.94	413267.0
2017-08-18	AAL	Stock	46.3	46.3	45.44	45.55	6242800.0
2017-08-18	AAM.A-DELISTED	Stock	25.952	26.15	25.9499	26.15	14708.0
2017-08-18	AAMC-DELISTED	Stock	22.2647	24.2941	21.8738	24.2941	9452.0
2017-08-18	AAME	Stock	3.45	3.45	3.45	3.45	200.0
2017-08-18	AAMI	Stock	13.25	13.45	13.2	13.34	370100.0
2017-08-18	AAOI	Stock	64.16	65.55	62.56	64.1	1952300.0
2017-08-18	AAON	Stock	20.8667	21.3667	20.8667	21.1	178050.0
2017-08-18	AAP	Stock	92.84	95.0	92.13	93.26	3073800.0
2017-08-18	AAT	Stock	39.86	40.16	39.66	39.85	365400.0
2017-08-18	AAU-DELISTED	Stock	1.1	1.13	1.1	1.12	63419.0
2017-08-18	AAUAF-DELISTED	Stock	1.1	1.13	1.1	1.12	67654.0
2017-08-18	AAV-DELISTED	Stock	6.3	6.45	6.2	6.4	84989.0
2017-08-18	AAWW-DELISTED	Stock	60.1	62.1	60.0	61.75	183389.0
2017-08-18	AAXJ	Stock	70.15	70.5	69.84	70.16	777114.0
2017-08-18	AAXN-DELISTED	Stock	21.36	22.15	21.25	22.08	989914.0
2017-08-18	AB	Stock	23.0	23.35	22.55	23.1	256600.0
2017-08-18	ABAC-DELISTED	Stock	2.02	2.0989	2.02	2.0625	4623.0
2017-08-18	ABAX-DELISTED	Stock	47.43	48.0	46.5	46.51	80971.0
2017-08-18	ABB-DELISTED	Stock	22.87	22.89	22.71	22.71	1549333.0
2017-08-18	ABBNY-DELISTED	Stock	22.87	22.89	22.71	22.71	1723073.0
2017-08-18	ABBV	Stock	69.52	70.44	69.47	69.96	4016400.0
2017-08-18	ABC-DELISTED	Stock	79.69	79.89	78.46	78.61	1681886.0
2017-08-18	ABCB	Stock	43.25	43.7	43.15	43.35	638800.0
2017-08-18	ABCD-DELISTED	Stock	5.07	5.19	5.07	5.14	146303.0
2017-08-18	ABCO-DELISTED	Stock	50.65	51.65	50.6	51.6	344522.0
2017-08-18	ABDC-DELISTED	Stock	10.62	10.95	10.46	10.7	48481.0
2017-08-18	ABE-DELISTED	Stock	13.78	13.8288	13.7	13.821	4200.0
2017-08-18	ABEO	Stock	201.25	215.0	186.25	195.0	30112.0
2017-08-18	ABEOW-DELISTED	Stock	4.25	4.2619	4.25	4.2619	400.0
2017-08-18	ABEV	Stock	6.21	6.25	6.15	6.23	15536600.0
2017-08-18	ABG	Stock	49.65	50.75	49.1	50.65	157600.0
2017-08-18	ABIL-DELISTED	Stock	0.65	0.695	0.65	0.675	17210.0
2017-08-18	ABM	Stock	42.79	43.15	42.6	42.94	165300.0

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

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