PREVIEW / stock_daily / 2017-05-26

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-26.parquet
  size:    214 KB
  rows:    6,440
  symbols: 3,005

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-05-26	AAPL	Stock	38.5	38.56	38.3275	38.4025	87710400.0
2017-05-26	MSFT	Stock	69.8	70.22	69.52	69.96	19827900.0
2017-05-26	NVDA	Stock	3.4482	3.632	3.4278	3.546	779140000.0
2017-05-26	AMZN	Stock	49.75	49.9325	49.4625	49.789	69384000.0
2017-05-26	GOOGL	Stock	49.6	49.8195	49.368	49.6635	32728320.0
2017-05-26	META	Stock	152.23	152.25	151.15	152.13	14996200.0
2017-05-26	TSLA	Stock	21.152	21.6993	21.0873	21.676	117033000.0
2017-05-26	TLT	Stock	123.55	123.74	123.25	123.48	2963919.0
2017-05-26	ES	Stock	61.34	61.58	61.24	61.4	825500.0
2017-05-26	CL	Stock	75.18	75.63	75.11	75.45	2153800.0
2017-05-26	A	Stock	59.23	59.72	59.04	59.51	1534400.0
2017-05-26	AA	Stock	32.87	33.36	32.87	33.27	2410600.0
2017-05-26	AAAP-DELISTED	Stock	38.95	39.28	38.65	38.845	76843.0
2017-05-26	AABA-DELISTED	Stock	50.5	50.74	50.32	50.66	5002990.0
2017-05-26	AAC-DELISTED	Stock	6.53	6.75	6.32	6.75	175411.0
2017-05-26	AACG	Stock	3.52	3.57	3.46	3.55	14600.0
2017-05-26	AAIC-DELISTED	Stock	14.61	14.6551	14.29	14.4	535135.0
2017-05-26	AAL	Stock	47.79	48.82	47.73	48.74	5979300.0
2017-05-26	AAM.A-DELISTED	Stock	25.8	25.87	25.77	25.87	17717.0
2017-05-26	AAMC-DELISTED	Stock	27.0735	28.4412	26.0735	26.5441	60027.0
2017-05-26	AAME	Stock	3.75	3.8	3.75	3.8	1000.0
2017-05-26	AAMI	Stock	13.91	14.12	13.9	13.99	330600.0
2017-05-26	AAOI	Stock	67.37	72.95	67.116	71.51	3885000.0
2017-05-26	AAON	Stock	24.2	24.5	24.1667	24.3667	123900.0
2017-05-26	AAP	Stock	131.84	135.7	131.44	134.16	2250300.0
2017-05-26	AAT	Stock	39.5	39.61	39.04	39.43	179100.0
2017-05-26	AAU-DELISTED	Stock	1.43	1.48	1.412	1.46	314956.0
2017-05-26	AAUAF-DELISTED	Stock	1.43	1.48	1.412	1.45	318082.0
2017-05-26	AAV-DELISTED	Stock	6.35	6.5	6.3	6.4	43872.0
2017-05-26	AAWW-DELISTED	Stock	49.8	50.0	49.45	49.8	167343.0
2017-05-26	AAXJ	Stock	67.16	67.29	67.13	67.22	1670493.0
2017-05-26	AAXN-DELISTED	Stock	25.0	25.0336	24.62	24.89	393849.0
2017-05-26	AB	Stock	21.15	21.9	21.1	21.8	514500.0
2017-05-26	ABAC-DELISTED	Stock	2.03	2.06	2.02	2.039	7620.0
2017-05-26	ABAX-DELISTED	Stock	48.87	49.53	48.6	49.53	47201.0
2017-05-26	ABB-DELISTED	Stock	24.88	25.036	24.88	24.98	738313.0
2017-05-26	ABBNY-DELISTED	Stock	24.88	25.036	24.88	25.0	763770.0
2017-05-26	ABBV	Stock	66.14	66.41	65.85	66.06	4083000.0
2017-05-26	ABC-DELISTED	Stock	91.19	91.5	90.91	91.02	785408.0
2017-05-26	ABCB	Stock	45.2	45.2	44.63	44.75	84400.0
2017-05-26	ABCD-DELISTED	Stock	5.07	5.07	4.93	5.02	30999.0
2017-05-26	ABCO-DELISTED	Stock	51.4	51.45	50.9	51.1	147212.0
2017-05-26	ABDC-DELISTED	Stock	13.45	13.45	13.3	13.33	63443.0
2017-05-26	ABEO	Stock	143.75	143.75	136.25	138.75	5704.0
2017-05-26	ABEV	Stock	5.74	5.82	5.72	5.77	14947200.0
2017-05-26	ABG	Stock	55.75	56.25	54.7	56.2	175600.0
2017-05-26	ABIL-DELISTED	Stock	0.6385	0.6504	0.61	0.6504	42162.0
2017-05-26	ABM	Stock	42.3	42.38	42.02	42.19	189400.0
2017-05-26	ABMD-DELISTED	Stock	135.69	139.021	135.69	138.56	367582.0
2017-05-26	ABR	Stock	8.2	8.26	8.19	8.19	233500.0

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

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