PREVIEW / stock_daily / 2018-01-26

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-26.parquet
  size:    218 KB
  rows:    6,498
  symbols: 2,878

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-01-26	AAPL	Stock	43.0	43.0	42.515	42.8775	156572000.0
2018-01-26	MSFT	Stock	93.12	94.06	92.58	94.06	29172200.0
2018-01-26	NVDA	Stock	5.953	6.0835	5.94	6.0833	516356000.0
2018-01-26	AMZN	Stock	69.6005	70.1265	69.0455	70.1025	97146000.0
2018-01-26	GOOGL	Stock	59.3765	59.378	58.4015	59.378	42170040.0
2018-01-26	META	Stock	187.75	190.0	186.81	190.0	17759200.0
2018-01-26	TSLA	Stock	22.7667	22.9333	22.3807	22.8567	68091000.0
2018-01-26	TLT	Stock	123.88	123.91	123.1	123.59	6462945.0
2018-01-26	ES	Stock	64.85	64.99	63.29	64.07	3695100.0
2018-01-26	CL	Stock	73.84	74.29	72.45	73.56	13162400.0
2018-01-26	A	Stock	74.3	74.83	73.59	74.82	2386900.0
2018-01-26	AA	Stock	53.55	54.4	53.28	54.0	2747900.0
2018-01-26	AAAP-DELISTED	Stock	81.95	82.05	81.95	82.01	20033.0
2018-01-26	AABA-DELISTED	Stock	79.21	80.45	79.0	80.32	15220596.0
2018-01-26	AAC-DELISTED	Stock	9.11	9.24	9.09	9.17	54148.0
2018-01-26	AACG	Stock	5.2	5.2	5.0	5.05	27400.0
2018-01-26	AAIC-DELISTED	Stock	11.33	11.36	11.12	11.17	578649.0
2018-01-26	AAL	Stock	53.65	53.9	52.34	53.07	7066100.0
2018-01-26	AAM.A-DELISTED	Stock	25.54	25.563	25.21	25.46	28721.0
2018-01-26	AAMC-DELISTED	Stock	19.9706	20.8529	19.9706	20.0441	7239.0
2018-01-26	AAMI	Stock	18.24	18.35	18.03	18.31	767000.0
2018-01-26	AAOI	Stock	34.91	36.29	34.91	35.99	1007000.0
2018-01-26	AAON	Stock	24.1333	24.6133	23.8	24.2	224550.0
2018-01-26	AAP	Stock	123.34	123.9	121.66	123.64	1488400.0
2018-01-26	AAT	Stock	36.25	36.4	35.52	35.59	201000.0
2018-01-26	AAU-DELISTED	Stock	0.9	0.9182	0.8902	0.91	370731.0
2018-01-26	AAUAF-DELISTED	Stock	0.9	0.9182	0.8902	0.91	383463.0
2018-01-26	AAV-DELISTED	Stock	3.55	3.7	3.55	3.625	240761.0
2018-01-26	AAWW-DELISTED	Stock	59.3	60.7	58.85	59.95	254090.0
2018-01-26	AAXJ	Stock	82.98	83.52	82.87	83.5	1794217.0
2018-01-26	AAXN-DELISTED	Stock	27.59	27.74	27.16	27.47	325387.0
2018-01-26	AB	Stock	27.35	27.95	27.35	27.85	176000.0
2018-01-26	ABAC-DELISTED	Stock	2.94	2.9731	2.87	2.9101	7183.0
2018-01-26	ABAX-DELISTED	Stock	65.73	78.15	65.73	75.71	851770.0
2018-01-26	ABB-DELISTED	Stock	28.4	28.6	28.33	28.6	1319034.0
2018-01-26	ABBNY-DELISTED	Stock	28.4	28.6	28.33	28.6	1390277.0
2018-01-26	ABBV	Stock	114.5	125.86	113.5	123.21	19614500.0
2018-01-26	ABC-DELISTED	Stock	104.56	105.73	104.11	105.43	1279088.0
2018-01-26	ABCB	Stock	56.85	56.85	52.85	54.85	296600.0
2018-01-26	ABCD-DELISTED	Stock	7.19	7.299	7.18	7.2	70749.0
2018-01-26	ABDC-DELISTED	Stock	8.25	8.39	8.24	8.31	22168.0
2018-01-26	ABE-DELISTED	Stock	15.57	15.82	15.57	15.82	19250.0
2018-01-26	ABEO	Stock	430.0	430.0	402.5	406.25	38588.0
2018-01-26	ABEOW-DELISTED	Stock	11.3	11.8	11.3	11.65	1447.0
2018-01-26	ABEV	Stock	6.85	6.94	6.84	6.9	24822200.0
2018-01-26	ABG	Stock	75.5	75.7	74.5	75.55	140000.0
2018-01-26	ABIL-DELISTED	Stock	0.4824	0.4879	0.451	0.4701	77424.0
2018-01-26	ABLX-DELISTED	Stock	46.35	47.92	45.905	47.89	300761.0
2018-01-26	ABM	Stock	39.52	39.76	38.6	38.75	598600.0
2018-01-26	ABMD-DELISTED	Stock	237.3	239.1	233.505	239.1	142406.0

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

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