PREVIEW / stock_daily / 2018-02-06

all stock daily files

  file:    by_date/stock_daily/2018/2018-02-06.parquet
  size:    216 KB
  rows:    6,536
  symbols: 2,889

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-06	AAPL	Stock	38.7075	40.93	38.5	40.7575	272975200.0
2018-02-06	MSFT	Stock	86.89	91.48	85.25	91.33	67998600.0
2018-02-06	NVDA	Stock	5.11	5.6425	5.1	5.6395	1114800000.0
2018-02-06	AMZN	Stock	68.073	72.1995	67.5895	72.142	221336000.0
2018-02-06	GOOGL	Stock	51.699	54.3688	51.5005	54.2215	76630480.0
2018-02-06	META	Stock	178.57	185.77	177.74	185.31	37758500.0
2018-02-06	TSLA	Stock	21.6807	22.4147	21.5667	22.2647	76326000.0
2018-02-06	TLT	Stock	120.42	120.87	119.72	119.96	10935439.0
2018-02-06	ES	Stock	57.69	57.94	56.76	57.54	3545900.0
2018-02-06	CL	Stock	69.1	71.04	68.19	70.41	6903800.0
2018-02-06	A	Stock	66.96	68.83	66.13	68.45	4121200.0
2018-02-06	AA	Stock	47.44	50.2	47.28	49.43	3165800.0
2018-02-06	AAAP-DELISTED	Stock	80.75	81.7899	80.75	81.42	24203.0
2018-02-06	AABA-DELISTED	Stock	70.02	73.67	69.59	73.53	6239702.0
2018-02-06	AAC-DELISTED	Stock	7.96	8.35	7.9	8.29	73469.0
2018-02-06	AACG	Stock	4.8	6.19	4.78	6.19	138300.0
2018-02-06	AAIC-DELISTED	Stock	9.9	10.29	9.9	10.2	761589.0
2018-02-06	AAL	Stock	49.32	51.5	48.79	51.18	6782500.0
2018-02-06	AAM.A-DELISTED	Stock	25.22	25.48	25.22	25.46	57132.0
2018-02-06	AAME	Stock	3.35	3.35	3.35	3.35	600.0
2018-02-06	AAMI	Stock	16.0	16.57	15.96	16.55	1989800.0
2018-02-06	AAOI	Stock	32.0	33.8	31.23	33.42	1561500.0
2018-02-06	AAON	Stock	22.2667	22.9333	22.0333	22.4667	425250.0
2018-02-06	AAP	Stock	108.28	113.11	106.75	112.2	1240100.0
2018-02-06	AAT	Stock	32.76	33.37	32.3	32.91	268900.0
2018-02-06	AAU-DELISTED	Stock	0.95	0.95	0.901	0.9038	247497.0
2018-02-06	AAUAF-DELISTED	Stock	0.95	0.95	0.901	0.9038	266845.0
2018-02-06	AAV-DELISTED	Stock	3.3	3.4	3.2	3.25	357121.0
2018-02-06	AAWW-DELISTED	Stock	51.85	54.15	51.75	53.8	287279.0
2018-02-06	AAXJ	Stock	75.99	78.89	75.66	78.36	3980997.0
2018-02-06	AAXN-DELISTED	Stock	24.85	25.34	24.52	25.16	813058.0
2018-02-06	AB	Stock	24.65	26.0	24.55	25.75	353300.0
2018-02-06	ABAC-DELISTED	Stock	2.62	2.7	2.1944	2.65	10484.0
2018-02-06	ABAX-DELISTED	Stock	65.43	67.44	64.1001	65.58	287291.0
2018-02-06	ABB-DELISTED	Stock	25.9	26.48	25.78	26.38	3608884.0
2018-02-06	ABBNY-DELISTED	Stock	25.9	26.48	25.78	26.39	3767007.0
2018-02-06	ABBV	Stock	104.91	113.52	101.0	111.2	14107800.0
2018-02-06	ABC-DELISTED	Stock	92.58	93.37	86.9403	91.54	3986680.0
2018-02-06	ABCB	Stock	51.2	52.8	51.0	52.15	239700.0
2018-02-06	ABCD-DELISTED	Stock	6.53	6.94	6.5201	6.9	69433.0
2018-02-06	ABDC-DELISTED	Stock	7.5	7.6599	7.5	7.65	70852.0
2018-02-06	ABE-DELISTED	Stock	14.5	15.0696	14.5	15.05	5421.0
2018-02-06	ABEO	Stock	362.5	398.75	360.25	398.75	37152.0
2018-02-06	ABEOW-DELISTED	Stock	10.18	10.69	10.18	10.69	1250.0
2018-02-06	ABEV	Stock	6.54	6.7	6.52	6.66	28703400.0
2018-02-06	ABG	Stock	64.0	68.3	63.5	67.75	309900.0
2018-02-06	ABIL-DELISTED	Stock	0.43	0.43	0.3801	0.3851	116253.0
2018-02-06	ABLX-DELISTED	Stock	53.83	54.05	53.72	54.03	232798.0
2018-02-06	ABM	Stock	34.07	35.14	33.7	34.73	580900.0
2018-02-06	ABMD-DELISTED	Stock	232.46	242.365	227.2	232.08	697609.0

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

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