PREVIEW / stock_daily / 2018-02-23

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-23.parquet
  size:    216 KB
  rows:    6,453
  symbols: 2,839

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-02-23	AAPL	Stock	43.4175	43.9125	43.385	43.875	135249600.0
2018-02-23	MSFT	Stock	93.6	94.07	92.36	94.06	26329200.0
2018-02-23	NVDA	Stock	6.1142	6.1483	6.063	6.1483	415300000.0
2018-02-23	AMZN	Stock	74.767	75.0	74.325	75.0	88362000.0
2018-02-23	GOOGL	Stock	55.933	56.45	55.4219	56.4045	25292760.0
2018-02-23	META	Stock	179.9	183.39	179.51	183.29	19007300.0
2018-02-23	TSLA	Stock	23.1887	23.666	23.14	23.47	87261000.0
2018-02-23	TLT	Stock	117.88	118.31	117.72	118.13	9072850.0
2018-02-23	ES	Stock	57.6	59.59	57.48	59.47	2514200.0
2018-02-23	CL	Stock	69.76	70.3	69.4	70.3	2398500.0
2018-02-23	A	Stock	71.15	71.37	70.06	70.7	4227000.0
2018-02-23	AA	Stock	48.06	48.14	46.584	46.7	3098000.0
2018-02-23	AABA-DELISTED	Stock	76.5	77.78	76.1	77.76	14594544.0
2018-02-23	AAC-DELISTED	Stock	9.05	9.6	9.05	9.49	249249.0
2018-02-23	AACG	Stock	5.09	5.41	5.09	5.35	17700.0
2018-02-23	AAIC-DELISTED	Stock	11.24	11.35	11.24	11.32	351548.0
2018-02-23	AAL	Stock	53.3	53.48	52.72	53.39	3394700.0
2018-02-23	AAM.A-DELISTED	Stock	25.52	25.6	25.51	25.55	81928.0
2018-02-23	AAMC-DELISTED	Stock	19.7059	20.0	19.7059	20.0	2727.0
2018-02-23	AAME	Stock	3.51	3.51	3.51	3.51	500.0
2018-02-23	AAMI	Stock	15.61	15.78	15.5	15.59	592100.0
2018-02-23	AAOI	Stock	27.0	28.09	26.68	28.02	1885100.0
2018-02-23	AAON	Stock	23.4	23.6333	23.1333	23.6	144000.0
2018-02-23	AAP	Stock	111.15	117.07	111.08	116.32	1504200.0
2018-02-23	AAT	Stock	32.79	32.99	32.5	32.71	395000.0
2018-02-23	AAU-DELISTED	Stock	0.91	0.92	0.9	0.9	68054.0
2018-02-23	AAUAF-DELISTED	Stock	0.91	0.92	0.9	0.9021	70002.0
2018-02-23	AAV-DELISTED	Stock	2.9	3.025	2.9	3.0	135539.0
2018-02-23	AAWW-DELISTED	Stock	64.4	66.9	63.5	63.9	362148.0
2018-02-23	AAXJ	Stock	78.61	79.09	78.34	79.09	957487.0
2018-02-23	AAXN-DELISTED	Stock	28.38	28.6	28.07	28.58	276282.0
2018-02-23	AB	Stock	27.3	27.35	27.0	27.1	251400.0
2018-02-23	ABAC-DELISTED	Stock	2.38	2.49	2.38	2.49	5107.0
2018-02-23	ABAX-DELISTED	Stock	66.91	68.74	66.57	68.69	109949.0
2018-02-23	ABB-DELISTED	Stock	24.95	25.07	24.91	25.06	1092584.0
2018-02-23	ABBNY-DELISTED	Stock	24.95	25.07	24.91	25.05	1154631.0
2018-02-23	ABBV	Stock	118.41	119.31	116.89	118.75	4685700.0
2018-02-23	ABC-DELISTED	Stock	97.57	98.49	96.67	98.43	937374.0
2018-02-23	ABCB	Stock	54.1	54.85	53.85	54.85	114500.0
2018-02-23	ABCD-DELISTED	Stock	7.1	7.28	7.07	7.22	56877.0
2018-02-23	ABDC-DELISTED	Stock	7.48	7.61	7.45	7.46	25199.0
2018-02-23	ABE-DELISTED	Stock	15.18	15.25	15.15	15.17	11588.0
2018-02-23	ABEO	Stock	333.75	346.25	318.75	336.25	41436.0
2018-02-23	ABEOW-DELISTED	Stock	9.19	9.2	7.95	8.92	6420.0
2018-02-23	ABEV	Stock	6.86	6.89	6.7	6.72	22718500.0
2018-02-23	ABG	Stock	68.0	69.0	67.7	68.9	189400.0
2018-02-23	ABIL-DELISTED	Stock	0.389	0.3987	0.3822	0.395	24547.0
2018-02-23	ABLX-DELISTED	Stock	53.92	54.13	53.85	54.0	57644.0
2018-02-23	ABM	Stock	36.34	36.88	36.0	36.75	417600.0
2018-02-23	ABMD-DELISTED	Stock	265.01	268.57	261.24	268.45	259839.0

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

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