PREVIEW / stock_daily / 2018-06-05

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-05.parquet
  size:    218 KB
  rows:    6,521
  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-06-05	AAPL	Stock	48.2675	48.485	48.09	48.3275	86264000.0
2018-06-05	MSFT	Stock	102.0	102.33	101.53	102.19	23514400.0
2018-06-05	NVDA	Stock	6.6245	6.6648	6.5793	6.6268	391712000.0
2018-06-05	AMZN	Stock	83.6495	84.95	83.503	84.8175	95644000.0
2018-06-05	GOOGL	Stock	57.733	58.0548	57.373	57.551	32964440.0
2018-06-05	META	Stock	194.3	195.0	192.62	192.94	15544300.0
2018-06-05	TSLA	Stock	19.8467	19.8533	19.116	19.4087	89928000.0
2018-06-05	TLT	Stock	119.96	120.16	119.62	119.71	5635865.0
2018-06-05	ES	Stock	55.52	55.67	54.89	54.99	1444800.0
2018-06-05	CL	Stock	62.75	62.81	62.24	62.29	3334800.0
2018-06-05	A	Stock	63.46	63.87	63.09	63.52	1889500.0
2018-06-05	AA	Stock	48.62	49.5	48.42	49.45	2434000.0
2018-06-05	AABA-DELISTED	Stock	80.32	81.25	79.72	80.31	2412766.0
2018-06-05	AAC-DELISTED	Stock	10.09	10.21	9.96	10.15	122597.0
2018-06-05	AACG	Stock	5.27	5.27	5.11	5.22	600.0
2018-06-05	AAIC-DELISTED	Stock	11.75	11.75	11.46	11.5	645885.0
2018-06-05	AAL	Stock	44.78	45.02	43.81	44.18	4975300.0
2018-06-05	AAM.A-DELISTED	Stock	25.05	25.17	25.01	25.15	48641.0
2018-06-05	AAM.B-DELISTED	Stock	24.47	24.59	24.45	24.57	117892.0
2018-06-05	AAMC-DELISTED	Stock	20.0	21.4706	20.0	20.1618	4393.0
2018-06-05	AAME	Stock	2.75	2.95	2.75	2.9	2000.0
2018-06-05	AAMI	Stock	15.82	15.88	15.56	15.64	312700.0
2018-06-05	AAOI	Stock	46.83	48.03	46.005	47.04	1212300.0
2018-06-05	AAON	Stock	21.2667	21.4667	21.0333	21.4	220650.0
2018-06-05	AAP	Stock	129.77	130.86	129.24	129.95	881200.0
2018-06-05	AAT	Stock	36.78	37.2	36.67	37.04	298700.0
2018-06-05	AAU-DELISTED	Stock	0.73	0.73	0.706	0.73	154511.0
2018-06-05	AAUAF-DELISTED	Stock	0.73	0.73	0.706	0.73	156455.0
2018-06-05	AAV-DELISTED	Stock	2.95	3.0	2.875	3.0	142792.0
2018-06-05	AAWW-DELISTED	Stock	70.3	72.0	70.15	71.8	182565.0
2018-06-05	AAXJ	Stock	77.62	77.6799	77.3	77.47	386343.0
2018-06-05	AAXN-DELISTED	Stock	66.07	67.45	65.33	67.06	1112629.0
2018-06-05	AB	Stock	28.85	28.95	28.45	28.7	257400.0
2018-06-05	ABAC-DELISTED	Stock	2.26	2.46	2.26	2.3	62756.0
2018-06-05	ABAX-DELISTED	Stock	82.95	83.43	82.68	83.17	379535.0
2018-06-05	ABB-DELISTED	Stock	23.12	23.18	23.0101	23.105	965965.0
2018-06-05	ABBNY-DELISTED	Stock	23.13	23.18	23.0101	23.11	1118580.0
2018-06-05	ABBV	Stock	99.11	100.34	98.76	99.24	10199000.0
2018-06-05	ABC-DELISTED	Stock	84.4	85.45	84.07	84.78	839672.0
2018-06-05	ABCB	Stock	56.9	57.2	56.45	57.05	132600.0
2018-06-05	ABCD-DELISTED	Stock	10.13	10.4	10.12	10.37	102214.0
2018-06-05	ABDC-DELISTED	Stock	6.72	6.79	6.69	6.75	35999.0
2018-06-05	ABEO	Stock	400.0	458.75	395.0	415.0	75036.0
2018-06-05	ABEOW-DELISTED	Stock	11.74	12.81	11.74	12.81	2100.0
2018-06-05	ABEV	Stock	5.3	5.32	5.16	5.17	31645900.0
2018-06-05	ABG	Stock	70.8	72.65	70.8	72.25	159900.0
2018-06-05	ABIL-DELISTED	Stock	2.3884	2.53	2.31	2.43	23360.0
2018-06-05	ABLX-DELISTED	Stock	52.37	52.3875	52.3	52.3	2073.0
2018-06-05	ABM	Stock	28.78	29.03	28.17	28.71	870700.0
2018-06-05	ABMD-DELISTED	Stock	407.52	415.0	402.7516	405.36	526365.0

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

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