PREVIEW / stock_daily / 2018-10-04

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-04.parquet
  size:    222 KB
  rows:    6,558
  symbols: 2,753

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-10-04	AAPL	Stock	57.695	58.0875	56.6825	56.9975	128168000.0
2018-10-04	MSFT	Stock	114.61	114.76	111.63	112.79	34821700.0
2018-10-04	NVDA	Stock	7.1318	7.1562	6.9045	6.9822	391220000.0
2018-10-04	AMZN	Stock	97.45	97.8	94.8285	95.471	145140000.0
2018-10-04	GOOGL	Stock	60.2515	60.295	58.1922	58.8535	46575560.0
2018-10-04	META	Stock	161.46	161.46	157.35	158.85	25739600.0
2018-10-04	TSLA	Stock	19.5967	19.6	18.5113	18.7887	147213000.0
2018-10-04	TLT	Stock	114.13	114.39	113.71	114.02	16207617.0
2018-10-04	ES	Stock	61.02	61.78	60.61	61.54	906800.0
2018-10-04	CL	Stock	65.44	65.46	64.52	64.92	3707900.0
2018-10-04	A	Stock	71.92	72.13	70.48	70.66	2961800.0
2018-10-04	AA	Stock	43.35	43.73	42.53	43.11	6420400.0
2018-10-04	AABA-DELISTED	Stock	66.81	66.81	64.39	65.26	5664709.0
2018-10-04	AAC-DELISTED	Stock	7.58	7.58	6.94	7.05	111573.0
2018-10-04	AACG	Stock	1.1	1.2	1.05	1.19	223600.0
2018-10-04	AAIC-DELISTED	Stock	8.95	9.11	8.87	9.08	943265.0
2018-10-04	AAL	Stock	38.8	39.01	37.48	37.92	5916500.0
2018-10-04	AAM.A-DELISTED	Stock	24.31	24.35	24.09	24.12	55828.0
2018-10-04	AAM.B-DELISTED	Stock	24.25	24.2705	23.9601	24.09	85693.0
2018-10-04	AAME	Stock	2.6	2.6	2.31	2.5	5600.0
2018-10-04	AAMI	Stock	12.19	12.32	12.08	12.15	371600.0
2018-10-04	AAOI	Stock	25.48	25.86	24.11	24.54	1533000.0
2018-10-04	AAON	Stock	23.8133	23.8133	23.22	23.28	219000.0
2018-10-04	AAP	Stock	167.7	167.7	165.08	165.71	769500.0
2018-10-04	AAT	Stock	36.23	36.58	35.95	36.35	202000.0
2018-10-04	AAU-DELISTED	Stock	0.585	0.5948	0.5752	0.59	98263.0
2018-10-04	AAUAF-DELISTED	Stock	0.585	0.5948	0.5752	0.59	99947.0
2018-10-04	AAWW-DELISTED	Stock	63.02	63.38	61.94	62.26	140118.0
2018-10-04	AAXJ	Stock	67.8	67.9863	66.72	66.95	911654.0
2018-10-04	AAXN-DELISTED	Stock	64.09	64.3457	62.3	62.8	358601.0
2018-10-04	AB	Stock	30.54	30.87	30.28	30.85	235100.0
2018-10-04	ABAC-DELISTED	Stock	1.85	1.97	1.85	1.97	200.0
2018-10-04	ABB-DELISTED	Stock	23.01	23.04	22.77	22.9	1466719.0
2018-10-04	ABBNY-DELISTED	Stock	23.01	23.04	22.77	22.91	1634698.0
2018-10-04	ABBV	Stock	95.81	95.81	93.26	93.84	4425400.0
2018-10-04	ABC-DELISTED	Stock	91.36	92.57	90.81	91.05	1114378.0
2018-10-04	ABCB	Stock	46.63	47.25	46.19	46.53	182100.0
2018-10-04	ABCD-DELISTED	Stock	11.36	11.4325	11.2	11.31	93404.0
2018-10-04	ABDC-DELISTED	Stock	6.09	6.11	6.02	6.0599	27609.0
2018-10-04	ABEO	Stock	297.0	298.25	282.5	285.75	21920.0
2018-10-04	ABEOW-DELISTED	Stock	6.6	6.62	6.6	6.62	3002.0
2018-10-04	ABEV	Stock	4.64	4.65	4.48	4.58	24470200.0
2018-10-04	ABG	Stock	65.65	65.71	64.18	64.27	267100.0
2018-10-04	ABIL-DELISTED	Stock	3.65	3.65	3.35	3.38	61967.0
2018-10-04	ABM	Stock	31.74	31.74	31.28	31.59	476200.0
2018-10-04	ABMD-DELISTED	Stock	424.81	424.97	407.616	416.79	431153.0
2018-10-04	ABR	Stock	11.52	11.52	11.39	11.42	808600.0
2018-10-04	ABR.A-DELISTED	Stock	25.35	25.5484	25.35	25.36	2200.0
2018-10-04	ABR.B-DELISTED	Stock	25.45	25.45	25.3	25.33	2768.0
2018-10-04	ABT	Stock	71.77	71.87	71.07	71.82	6166700.0

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

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