PREVIEW / stock_daily / 2018-05-08

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-08.parquet
  size:    218 KB
  rows:    6,489
  symbols: 2,815

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-08	AAPL	Stock	46.2475	46.555	45.9175	46.5125	113611200.0
2018-05-08	MSFT	Stock	95.85	96.16	95.06	95.81	23484600.0
2018-05-08	NVDA	Stock	6.2172	6.2628	6.1678	6.26	506616000.0
2018-05-08	AMZN	Stock	79.75	79.844	79.1255	79.6195	61358000.0
2018-05-08	GOOGL	Stock	53.231	53.2615	52.5821	52.9295	26030480.0
2018-05-08	META	Stock	178.25	179.04	177.11	178.92	15577200.0
2018-05-08	TSLA	Stock	20.0533	20.5167	19.9333	20.1313	88950000.0
2018-05-08	TLT	Stock	118.55	119.0	118.3	118.69	6091243.0
2018-05-08	ES	Stock	58.59	58.71	57.22	57.32	2113900.0
2018-05-08	CL	Stock	63.01	63.27	62.23	62.28	5336100.0
2018-05-08	A	Stock	67.08	67.44	66.84	67.37	1916100.0
2018-05-08	AA	Stock	54.26	54.65	53.44	53.76	2756100.0
2018-05-08	AABA-DELISTED	Stock	75.21	76.39	75.04	76.04	3247001.0
2018-05-08	AAC-DELISTED	Stock	11.79	11.85	11.62	11.67	103093.0
2018-05-08	AACG	Stock	5.18	5.33	5.17	5.32	4200.0
2018-05-08	AAIC-DELISTED	Stock	11.25	11.33	11.06	11.09	823398.0
2018-05-08	AAL	Stock	42.33	44.01	42.33	43.0	7766600.0
2018-05-08	AAM.A-DELISTED	Stock	24.8	25.0	24.75	24.93	109456.0
2018-05-08	AAM.B-DELISTED	Stock	24.64	24.83	24.6035	24.81	79908.0
2018-05-08	AAME	Stock	3.25	3.25	3.15	3.15	1200.0
2018-05-08	AAMI	Stock	15.41	15.57	15.3	15.37	240100.0
2018-05-08	AAOI	Stock	33.89	35.74	33.766	35.13	2567600.0
2018-05-08	AAON	Stock	19.8333	20.5	19.3667	20.3333	411450.0
2018-05-08	AAP	Stock	118.81	118.97	116.31	116.8	1084900.0
2018-05-08	AAT	Stock	34.92	35.07	34.64	34.95	333300.0
2018-05-08	AAU-DELISTED	Stock	0.85	0.85	0.803	0.8033	57546.0
2018-05-08	AAUAF-DELISTED	Stock	0.85	0.85	0.803	0.8033	70682.0
2018-05-08	AAV-DELISTED	Stock	2.9	3.1	2.85	3.05	309121.0
2018-05-08	AAWW-DELISTED	Stock	67.4	68.55	67.25	68.1	324344.0
2018-05-08	AAXJ	Stock	75.8	76.08	75.47	76.04	610211.0
2018-05-08	AAXN-DELISTED	Stock	44.73	45.25	44.25	44.65	1330748.0
2018-05-08	AB	Stock	27.05	27.25	26.8	26.9	291200.0
2018-05-08	ABAC-DELISTED	Stock	2.4	2.4	2.23	2.36	12111.0
2018-05-08	ABAX-DELISTED	Stock	68.71	68.71	65.51	68.25	122257.0
2018-05-08	ABB-DELISTED	Stock	23.83	23.955	23.765	23.915	1448065.0
2018-05-08	ABBNY-DELISTED	Stock	23.83	23.955	23.765	23.92	1503706.0
2018-05-08	ABBV	Stock	99.13	99.78	98.7	99.4	7620900.0
2018-05-08	ABC-DELISTED	Stock	84.58	85.47	83.765	84.69	1320727.0
2018-05-08	ABCB	Stock	53.7	55.2	53.7	55.2	259800.0
2018-05-08	ABCD-DELISTED	Stock	9.96	10.1	9.76	9.995	171508.0
2018-05-08	ABDC-DELISTED	Stock	6.42	6.6	6.4	6.47	69848.0
2018-05-08	ABEO	Stock	475.0	482.5	467.5	480.0	11376.0
2018-05-08	ABEOW-DELISTED	Stock	14.09	14.1	14.09	14.1	1100.0
2018-05-08	ABEV	Stock	6.29	6.35	6.22	6.26	29036300.0
2018-05-08	ABG	Stock	69.05	70.25	68.95	69.65	131200.0
2018-05-08	ABIL-DELISTED	Stock	2.67	2.98	2.59	2.8418	117486.0
2018-05-08	ABLX-DELISTED	Stock	53.01	53.34	52.91	53.34	3623.0
2018-05-08	ABM	Stock	30.0	30.49	30.0	30.42	1152400.0
2018-05-08	ABMD-DELISTED	Stock	341.84	347.6	339.75	347.41	342528.0
2018-05-08	ABR	Stock	9.4	9.44	9.36	9.41	1094400.0

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

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