PREVIEW / stock_daily / 2019-12-26

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-26.parquet
  size:    220 KB
  rows:    6,563
  symbols: 2,410

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
2019-12-26	AAPL	Stock	71.205	72.495	71.175	72.4775	93121200.0
2019-12-26	MSFT	Stock	157.56	158.73	157.4	158.67	14520600.0
2019-12-26	NVDA	Stock	5.969	6.008	5.95	5.9798	182852000.0
2019-12-26	AMZN	Stock	90.0505	93.523	89.975	93.4385	120108000.0
2019-12-26	GOOGL	Stock	67.3275	68.16	67.2755	68.1235	23676000.0
2019-12-26	META	Stock	205.57	207.82	205.31	207.79	9350700.0
2019-12-26	TSLA	Stock	28.5273	28.8987	28.4233	28.7293	159508500.0
2019-12-26	TLT	Stock	136.91	137.22	136.51	137.17	5290981.0
2019-12-26	ES	Stock	84.04	84.34	83.58	84.3	838800.0
2019-12-26	CL	Stock	68.8	68.98	68.43	68.58	2493600.0
2019-12-26	A	Stock	85.31	85.64	85.09	85.45	649100.0
2019-12-26	AA	Stock	21.5	21.7	21.245	21.45	4729200.0
2019-12-26	AACG	Stock	1.47	1.48	1.45	1.47	6200.0
2019-12-26	AAIC-DELISTED	Stock	5.95	5.99	5.91	5.94	403335.0
2019-12-26	AAIC.C-DELISTED	Stock	21.36	21.4	21.36	21.4	11457.0
2019-12-26	AAL	Stock	29.32	29.71	29.26	29.67	4746500.0
2019-12-26	AAM.A-DELISTED	Stock	26.62	26.62	26.57	26.6	15069.0
2019-12-26	AAM.B-DELISTED	Stock	27.38	27.38	27.38	27.38	291.0
2019-12-26	AAMC-DELISTED	Stock	3.8795	3.8795	3.8795	3.8795	1102.0
2019-12-26	AAME	Stock	1.77	1.9	1.77	1.9	5900.0
2019-12-26	AAMI	Stock	10.16	10.2	10.105	10.19	126500.0
2019-12-26	AAOI	Stock	11.11	11.75	11.04	11.61	579400.0
2019-12-26	AAON	Stock	33.2733	33.36	32.9067	33.2667	86550.0
2019-12-26	AAP	Stock	160.53	161.07	158.44	159.27	482300.0
2019-12-26	AAT	Stock	44.8	44.94	44.59	44.94	95000.0
2019-12-26	AAU-DELISTED	Stock	0.564	0.62	0.564	0.62	535262.0
2019-12-26	AAUAF-DELISTED	Stock	0.564	0.62	0.564	0.62	542958.0
2019-12-26	AAWW-DELISTED	Stock	27.37	27.8	27.16	27.72	101221.0
2019-12-26	AAXJ	Stock	73.1	73.31	72.94	73.26	182229.0
2019-12-26	AAXN-DELISTED	Stock	73.16	73.72	72.39	72.86	187872.0
2019-12-26	AB	Stock	30.2	30.43	30.16	30.23	180200.0
2019-12-26	ABB-DELISTED	Stock	23.93	24.08	23.9	24.06	907730.0
2019-12-26	ABBNY-DELISTED	Stock	23.93	24.08	23.9	24.06	984913.0
2019-12-26	ABBV	Stock	90.2	90.72	89.45	89.83	4066700.0
2019-12-26	ABC-DELISTED	Stock	85.54	85.67	84.9377	85.06	391075.0
2019-12-26	ABCB	Stock	43.32	43.33	43.01	43.12	95200.0
2019-12-26	ABDC-DELISTED	Stock	9.17	9.25	9.17	9.25	19870.0
2019-12-26	ABEO	Stock	91.25	98.75	88.75	90.0	61124.0
2019-12-26	ABEV	Stock	4.62	4.71	4.61	4.71	6616200.0
2019-12-26	ABG	Stock	114.91	114.91	113.01	114.05	42600.0
2019-12-26	ABIL-DELISTED	Stock	0.39	0.42	0.36	0.36	334677.0
2019-12-26	ABM	Stock	38.21	38.66	37.95	38.62	357500.0
2019-12-26	ABMD-DELISTED	Stock	172.58	175.25	169.41	171.12	316596.0
2019-12-26	ABR	Stock	14.54	14.6	14.46	14.51	568400.0
2019-12-26	ABR.A-DELISTED	Stock	26.28	26.3156	26.28	26.3047	1045.0
2019-12-26	ABR.B-DELISTED	Stock	25.71	25.77	25.69	25.7	3006.0
2019-12-26	ABR.C-DELISTED	Stock	26.88	26.88	26.398	26.5321	1675.0
2019-12-26	ABT	Stock	87.21	87.52	86.88	87.28	2033100.0
2019-12-26	ABTC	Stock	240000.0	269400.0	234000.0	263700.0	7.333333333333333
2019-12-26	ABTS	Stock	29.55	29.55	29.55	29.55	140.0

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

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