PREVIEW / stock_daily / 2018-05-18

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-18.parquet
  size:    217 KB
  rows:    6,492
  symbols: 2,810

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-18	AAPL	Stock	46.7975	46.9525	46.5325	46.5775	73190800.0
2018-05-18	MSFT	Stock	96.01	96.93	96.01	96.36	17865800.0
2018-05-18	NVDA	Stock	6.2453	6.3093	6.1435	6.1485	483716000.0
2018-05-18	AMZN	Stock	79.0665	79.1795	78.605	78.7185	52852000.0
2018-05-18	GOOGL	Stock	53.3	53.6865	53.234	53.482	35482980.0
2018-05-18	META	Stock	183.49	184.19	182.61	182.68	13130500.0
2018-05-18	TSLA	Stock	18.9767	18.9767	18.2667	18.4547	108778500.0
2018-05-18	TLT	Stock	116.51	117.29	116.51	117.21	9606468.0
2018-05-18	ES	Stock	57.06	57.62	56.92	57.32	1844600.0
2018-05-18	CL	Stock	62.32	62.36	61.8	62.22	5046000.0
2018-05-18	A	Stock	63.63	64.6	63.51	64.32	4163500.0
2018-05-18	AA	Stock	50.53	51.05	50.35	50.83	3011300.0
2018-05-18	AABA-DELISTED	Stock	76.44	77.06	75.86	75.92	3483655.0
2018-05-18	AAC-DELISTED	Stock	11.85	12.09	11.62	11.84	90194.0
2018-05-18	AACG	Stock	5.14	5.14	5.14	5.14	200.0
2018-05-18	AAIC-DELISTED	Stock	10.97	11.11	10.885	11.1	580931.0
2018-05-18	AAL	Stock	43.56	43.76	43.04	43.38	4216100.0
2018-05-18	AAM.A-DELISTED	Stock	25.12	25.15	25.091	25.12	21195.0
2018-05-18	AAM.B-DELISTED	Stock	24.79	24.8	24.711	24.8	36880.0
2018-05-18	AAMC-DELISTED	Stock	18.6839	19.1324	18.6839	19.1324	2938.0
2018-05-18	AAME	Stock	2.78	2.78	2.75	2.75	1500.0
2018-05-18	AAMI	Stock	15.74	15.74	15.545	15.59	450800.0
2018-05-18	AAOI	Stock	33.58	34.059	33.18	33.22	672800.0
2018-05-18	AAON	Stock	20.8667	21.4333	20.8	21.0333	550950.0
2018-05-18	AAP	Stock	119.37	119.86	118.21	118.32	1087000.0
2018-05-18	AAT	Stock	34.7	34.72	33.94	34.08	552300.0
2018-05-18	AAU-DELISTED	Stock	0.75	0.7733	0.75	0.76	139977.0
2018-05-18	AAUAF-DELISTED	Stock	0.75	0.7733	0.75	0.76	143910.0
2018-05-18	AAV-DELISTED	Stock	3.15	3.15	3.05	3.1	166096.0
2018-05-18	AAWW-DELISTED	Stock	69.25	69.75	68.9	69.2	90405.0
2018-05-18	AAXJ	Stock	76.04	76.16	75.85	75.99	341643.0
2018-05-18	AAXN-DELISTED	Stock	57.46	58.47	57.01	57.93	1299089.0
2018-05-18	AB	Stock	27.8	27.95	27.65	27.85	335400.0
2018-05-18	ABAC-DELISTED	Stock	2.24	2.24	2.15	2.15	1980.0
2018-05-18	ABAX-DELISTED	Stock	83.68	83.98	83.11	83.3	470478.0
2018-05-18	ABB-DELISTED	Stock	24.27	24.37	24.215	24.295	1297694.0
2018-05-18	ABBNY-DELISTED	Stock	24.27	24.37	24.215	24.3	1375754.0
2018-05-18	ABBV	Stock	105.27	106.78	105.11	105.98	5328000.0
2018-05-18	ABC-DELISTED	Stock	86.84	87.03	84.7	84.77	1123098.0
2018-05-18	ABCB	Stock	55.95	56.35	55.85	56.05	343100.0
2018-05-18	ABCD-DELISTED	Stock	9.91	10.13	9.88	10.02	114393.0
2018-05-18	ABDC-DELISTED	Stock	6.7	6.86	6.65	6.82	26014.0
2018-05-18	ABEO	Stock	536.25	536.25	397.5	472.0	155424.0
2018-05-18	ABEOW-DELISTED	Stock	15.0	15.0	13.75	13.75	6830.0
2018-05-18	ABEV	Stock	5.55	5.56	5.38	5.51	77447500.0
2018-05-18	ABG	Stock	69.85	70.65	68.4	69.7	189500.0
2018-05-18	ABIL-DELISTED	Stock	2.6	2.88	2.4836	2.69	56927.0
2018-05-18	ABLX-DELISTED	Stock	52.975	52.995	52.79	52.79	5409.0
2018-05-18	ABM	Stock	30.11	30.21	29.72	29.73	594000.0
2018-05-18	ABMD-DELISTED	Stock	381.15	388.75	380.025	384.36	660300.0

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

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