PREVIEW / stock_daily / 2018-05-14

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-14.parquet
  size:    218 KB
  rows:    6,528
  symbols: 2,824

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
2018-05-14	AAPL	Stock	47.2525	47.3825	46.965	47.0375	83115200.0
2018-05-14	MSFT	Stock	97.92	98.69	97.31	98.03	19454100.0
2018-05-14	NVDA	Stock	6.4018	6.4623	6.36	6.384	523140000.0
2018-05-14	AMZN	Stock	80.2	80.559	80.0025	80.077	50190000.0
2018-05-14	GOOGL	Stock	55.2785	55.9075	55.24	55.33	39337860.0
2018-05-14	META	Stock	187.71	187.86	186.2	186.64	15646700.0
2018-05-14	TSLA	Stock	20.2213	20.3293	19.4413	19.4647	109302000.0
2018-05-14	TLT	Stock	118.8	118.99	118.59	118.6	4996183.0
2018-05-14	ES	Stock	58.06	58.28	57.28	57.53	2212700.0
2018-05-14	CL	Stock	62.7	62.84	61.87	62.04	5345200.0
2018-05-14	A	Stock	69.73	70.45	69.0	69.21	3322600.0
2018-05-14	AA	Stock	54.38	54.515	51.92	52.33	4377300.0
2018-05-14	AABA-DELISTED	Stock	75.75	77.62	75.75	76.79	4056465.0
2018-05-14	AAC-DELISTED	Stock	11.95	12.145	11.35	11.38	107503.0
2018-05-14	AAIC-DELISTED	Stock	10.98	11.01	10.9	10.94	396826.0
2018-05-14	AAL	Stock	42.75	43.09	42.2	42.46	4201600.0
2018-05-14	AAM.A-DELISTED	Stock	25.07	25.15	25.0	25.09	65216.0
2018-05-14	AAM.B-DELISTED	Stock	24.8	24.8	24.75	24.76	34628.0
2018-05-14	AAMC-DELISTED	Stock	18.8824	18.8824	18.8824	18.8824	1210.0
2018-05-14	AAME	Stock	3.0	3.0	2.7	2.75	4800.0
2018-05-14	AAMI	Stock	15.62	15.77	15.49	15.5	469100.0
2018-05-14	AAOI	Stock	32.6	33.33	31.861	32.19	907100.0
2018-05-14	AAON	Stock	19.7	19.8333	19.3667	19.6667	512700.0
2018-05-14	AAP	Stock	119.88	121.9	119.26	121.61	939200.0
2018-05-14	AAT	Stock	35.26	35.31	34.79	35.23	544500.0
2018-05-14	AAU-DELISTED	Stock	0.773	0.79	0.763	0.763	161671.0
2018-05-14	AAUAF-DELISTED	Stock	0.773	0.79	0.763	0.763	178726.0
2018-05-14	AAV-DELISTED	Stock	2.8	3.0	2.8	2.95	202557.0
2018-05-14	AAWW-DELISTED	Stock	67.9	68.65	67.15	67.6	122606.0
2018-05-14	AAXJ	Stock	77.85	78.14	77.61	77.7	598944.0
2018-05-14	AAXN-DELISTED	Stock	57.43	58.1778	56.505	57.02	960785.0
2018-05-14	AB	Stock	27.0	27.1	26.81	26.95	464500.0
2018-05-14	ABAC-DELISTED	Stock	2.1618	2.3	2.15	2.15	4555.0
2018-05-14	ABAX-DELISTED	Stock	70.95	72.44	70.95	72.205	187838.0
2018-05-14	ABB-DELISTED	Stock	23.86	23.99	23.8338	23.9	1019874.0
2018-05-14	ABBNY-DELISTED	Stock	23.86	23.99	23.8338	23.9	1201446.0
2018-05-14	ABBV	Stock	104.4	106.3	104.33	105.89	8471700.0
2018-05-14	ABC-DELISTED	Stock	87.43	88.475	86.91	87.28	850513.0
2018-05-14	ABCB	Stock	55.2	55.4	54.6	54.8	202400.0
2018-05-14	ABCD-DELISTED	Stock	10.05	10.9929	9.04	10.495	600244.0
2018-05-14	ABDC-DELISTED	Stock	6.42	6.64	6.36	6.55	78784.0
2018-05-14	ABEO	Stock	490.0	528.75	488.75	522.5	39176.0
2018-05-14	ABEOW-DELISTED	Stock	15.64	15.96	15.64	15.96	1400.0
2018-05-14	ABEV	Stock	6.07	6.07	5.94	5.95	18360000.0
2018-05-14	ABG	Stock	70.35	71.1	69.75	70.4	178500.0
2018-05-14	ABIL-DELISTED	Stock	2.72	2.72	2.61	2.67	18436.0
2018-05-14	ABLX-DELISTED	Stock	54.16	54.47	53.81	53.93	5524.0
2018-05-14	ABM	Stock	30.5	30.6	30.26	30.29	523600.0
2018-05-14	ABMD-DELISTED	Stock	370.87	383.325	370.0136	375.7	312263.0
2018-05-14	ABR	Stock	9.3	9.39	9.27	9.28	968400.0

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

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