PREVIEW / stock_daily / 2018-05-11

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-11.parquet
  size:    217 KB
  rows:    6,502
  symbols: 2,822

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-11	AAPL	Stock	47.3725	47.515	46.8625	47.1475	104848800.0
2018-05-11	MSFT	Stock	97.8	97.87	97.04	97.7	16778300.0
2018-05-11	NVDA	Stock	6.3195	6.4948	6.2635	6.3633	1214456000.0
2018-05-11	AMZN	Stock	80.5495	80.555	79.8945	80.1455	45278000.0
2018-05-11	GOOGL	Stock	55.0205	55.4505	54.861	55.169	30504360.0
2018-05-11	META	Stock	184.85	188.32	184.18	186.99	21207800.0
2018-05-11	TSLA	Stock	20.5133	20.592	19.9387	20.0707	70194000.0
2018-05-11	TLT	Stock	119.32	119.36	118.82	119.23	4273364.0
2018-05-11	ES	Stock	58.0	58.09	57.71	58.04	945000.0
2018-05-11	CL	Stock	62.81	63.5	62.5	62.71	4014400.0
2018-05-11	A	Stock	69.19	69.6	68.91	69.45	1524200.0
2018-05-11	AA	Stock	53.79	54.25	53.37	53.96	3978800.0
2018-05-11	AABA-DELISTED	Stock	75.95	76.36	75.3	75.65	2787808.0
2018-05-11	AAC-DELISTED	Stock	11.66	12.3	11.66	11.975	178660.0
2018-05-11	AACG	Stock	5.3	5.3	5.3	5.3	1100.0
2018-05-11	AAIC-DELISTED	Stock	10.98	11.055	10.94	10.95	499454.0
2018-05-11	AAL	Stock	42.08	42.66	42.02	42.6	6066700.0
2018-05-11	AAM.A-DELISTED	Stock	25.03	25.07	24.9	25.07	44573.0
2018-05-11	AAM.B-DELISTED	Stock	24.75	24.75	24.694	24.74	29534.0
2018-05-11	AAMC-DELISTED	Stock	19.2353	19.2353	18.7059	18.7059	1023.0
2018-05-11	AAME	Stock	3.0	3.0	2.85	3.0	30700.0
2018-05-11	AAMI	Stock	15.58	15.69	15.55	15.66	326300.0
2018-05-11	AAOI	Stock	32.09	32.47	31.61	31.78	620000.0
2018-05-11	AAON	Stock	19.8667	19.9333	19.5667	19.7	152700.0
2018-05-11	AAP	Stock	118.31	122.3	117.59	119.94	1354700.0
2018-05-11	AAT	Stock	35.26	35.42	35.1	35.25	215900.0
2018-05-11	AAU-DELISTED	Stock	0.838	0.838	0.773	0.782	429130.0
2018-05-11	AAUAF-DELISTED	Stock	0.838	0.838	0.773	0.782	435309.0
2018-05-11	AAV-DELISTED	Stock	2.9	2.94	2.8	2.825	275938.0
2018-05-11	AAWW-DELISTED	Stock	68.6	69.2	67.25	68.05	112065.0
2018-05-11	AAXJ	Stock	77.74	77.75	77.28	77.49	168934.0
2018-05-11	AAXN-DELISTED	Stock	55.44	57.44	55.16	57.29	980133.0
2018-05-11	AB	Stock	26.75	27.05	26.55	26.95	701700.0
2018-05-11	ABAC-DELISTED	Stock	2.3885	2.3885	2.14	2.2393	16586.0
2018-05-11	ABAX-DELISTED	Stock	69.87	72.9523	69.87	70.85	91476.0
2018-05-11	ABB-DELISTED	Stock	24.07	24.13	23.955	23.995	881537.0
2018-05-11	ABBNY-DELISTED	Stock	24.07	24.13	23.955	23.99	1023588.0
2018-05-11	ABBV	Stock	103.46	104.69	102.04	104.18	6358900.0
2018-05-11	ABC-DELISTED	Stock	85.6	87.5	84.64	86.88	1652200.0
2018-05-11	ABCB	Stock	55.3	55.7	55.0	55.15	148700.0
2018-05-11	ABCD-DELISTED	Stock	10.03	10.25	9.8	10.2	123437.0
2018-05-11	ABDC-DELISTED	Stock	6.42	6.65	6.41	6.42	98395.0
2018-05-11	ABEO	Stock	467.5	492.5	467.5	491.25	23172.0
2018-05-11	ABEV	Stock	6.06	6.1	5.99	6.02	13597700.0
2018-05-11	ABG	Stock	68.85	70.1	68.75	70.0	164400.0
2018-05-11	ABIL-DELISTED	Stock	2.7057	2.8	2.7	2.71	13090.0
2018-05-11	ABLX-DELISTED	Stock	53.65	53.7	53.42	53.58	5912.0
2018-05-11	ABM	Stock	30.36	30.56	30.21	30.41	518400.0
2018-05-11	ABMD-DELISTED	Stock	368.71	374.75	367.79	372.56	440672.0
2018-05-11	ABR	Stock	9.45	9.48	9.41	9.45	777200.0

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

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