PREVIEW / stock_daily / 2018-02-27

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-27.parquet
  size:    215 KB
  rows:    6,476
  symbols: 2,853

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-27	AAPL	Stock	44.775	45.12	44.54	44.5975	155712400.0
2018-02-27	MSFT	Stock	95.74	95.84	94.2	94.2	25869100.0
2018-02-27	NVDA	Stock	6.1375	6.2228	6.1283	6.1515	455436000.0
2018-02-27	AMZN	Stock	76.225	76.339	75.3605	75.599	96176000.0
2018-02-27	GOOGL	Stock	57.185	57.2125	55.8395	55.8755	42963180.0
2018-02-27	META	Stock	184.45	184.7	181.46	181.46	15849800.0
2018-02-27	TSLA	Stock	23.75	23.9993	23.334	23.3993	71961000.0
2018-02-27	TLT	Stock	118.52	118.66	117.26	118.0	12525659.0
2018-02-27	ES	Stock	58.96	59.15	57.38	57.39	1776900.0
2018-02-27	CL	Stock	71.18	71.29	69.92	69.92	3071100.0
2018-02-27	A	Stock	70.75	70.92	69.0	69.0	3370500.0
2018-02-27	AA	Stock	46.5	47.17	45.657	46.22	3247700.0
2018-02-27	AABA-DELISTED	Stock	77.86	78.0	75.7717	76.12	10691300.0
2018-02-27	AAC-DELISTED	Stock	9.61	10.24	9.51	9.54	196614.0
2018-02-27	AAIC-DELISTED	Stock	11.38	11.42	10.9698	10.98	504635.0
2018-02-27	AAL	Stock	54.89	55.6	54.24	54.26	4878400.0
2018-02-27	AAM.A-DELISTED	Stock	25.63	25.6484	25.485	25.62	21954.0
2018-02-27	AAMI	Stock	15.74	15.96	15.66	15.68	969900.0
2018-02-27	AAOI	Stock	28.0	28.28	27.18	27.33	942800.0
2018-02-27	AAON	Stock	23.7667	25.9667	22.54	25.7667	1276350.0
2018-02-27	AAP	Stock	113.26	113.91	108.9	109.8	2161000.0
2018-02-27	AAT	Stock	32.94	33.12	31.82	31.84	253700.0
2018-02-27	AAU-DELISTED	Stock	0.89	0.8979	0.8508	0.8673	82091.0
2018-02-27	AAUAF-DELISTED	Stock	0.89	0.8979	0.8508	0.8673	88291.0
2018-02-27	AAV-DELISTED	Stock	2.95	3.05	2.9	2.925	288705.0
2018-02-27	AAWW-DELISTED	Stock	63.2	63.75	61.425	61.75	166102.0
2018-02-27	AAXJ	Stock	79.02	79.02	77.72	77.72	670813.0
2018-02-27	AAXN-DELISTED	Stock	28.1	28.11	27.19	27.26	758689.0
2018-02-27	AB	Stock	27.05	27.2	26.4	26.45	180200.0
2018-02-27	ABAC-DELISTED	Stock	2.4899	2.4899	2.48	2.48	1500.0
2018-02-27	ABAX-DELISTED	Stock	69.31	69.45	67.93	68.38	144797.0
2018-02-27	ABB-DELISTED	Stock	24.98	25.09	24.79	24.79	1556164.0
2018-02-27	ABBNY-DELISTED	Stock	24.98	25.09	24.79	24.8	1646375.0
2018-02-27	ABBV	Stock	121.21	122.0	118.16	118.26	4754300.0
2018-02-27	ABC-DELISTED	Stock	101.01	101.56	93.16	97.64	4371270.0
2018-02-27	ABCB	Stock	54.9	55.55	53.8	53.85	192400.0
2018-02-27	ABCD-DELISTED	Stock	7.48	7.68	7.48	7.61	55170.0
2018-02-27	ABDC-DELISTED	Stock	7.47	7.5872	7.2	7.32	69226.0
2018-02-27	ABE-DELISTED	Stock	15.08	15.16	15.01	15.109	8198.0
2018-02-27	ABEO	Stock	352.5	367.5	347.5	348.75	34984.0
2018-02-27	ABEOW-DELISTED	Stock	9.5	9.5001	9.5	9.5001	1400.0
2018-02-27	ABEV	Stock	6.82	6.84	6.73	6.78	11054400.0
2018-02-27	ABG	Stock	69.4	69.9	67.35	67.8	250700.0
2018-02-27	ABIL-DELISTED	Stock	0.4038	0.4394	0.4038	0.4077	203406.0
2018-02-27	ABLX-DELISTED	Stock	53.88	53.89	53.25	53.3	61859.0
2018-02-27	ABM	Stock	36.96	37.09	35.79	35.85	570500.0
2018-02-27	ABMD-DELISTED	Stock	273.6	273.6	269.39	271.13	144897.0
2018-02-27	ABR	Stock	8.64	8.66	8.54	8.57	749100.0
2018-02-27	ABR.A-DELISTED	Stock	25.25	25.38	25.24	25.3345	1874.0
2018-02-27	ABR.B-DELISTED	Stock	25.12	25.12	25.12	25.12	210.0

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

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