PREVIEW / stock_daily / 2020-06-16

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-16.parquet
  size:    221 KB
  rows:    6,690
  symbols: 2,380

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
2020-06-16	AAPL	Stock	87.865	88.3	86.18	88.02	165428800.0
2020-06-16	MSFT	Stock	192.89	195.58	191.46	193.57	42556700.0
2020-06-16	NVDA	Stock	9.225	9.2668	8.8388	9.0685	535716000.0
2020-06-16	AMZN	Stock	131.0	131.0	128.8	130.7635	71712000.0
2020-06-16	GOOGL	Stock	72.45	72.8585	71.4495	72.3235	30696520.0
2020-06-16	META	Stock	237.14	238.46	233.0	235.65	15236700.0
2020-06-16	TSLA	Stock	67.4567	67.5253	64.1593	65.4753	210766500.0
2020-06-16	TLT	Stock	159.41	161.23	158.7	159.9	13701298.0
2020-06-16	ES	Stock	86.01	86.73	83.96	84.18	1771400.0
2020-06-16	CL	Stock	73.73	74.38	72.74	73.53	3034200.0
2020-06-16	A	Stock	88.88	89.24	86.51	87.44	1049200.0
2020-06-16	AA	Stock	12.02	12.14	11.38	11.55	9383200.0
2020-06-16	AACG	Stock	1.33	1.8	1.12	1.12	1621800.0
2020-06-16	AAIC-DELISTED	Stock	3.21	3.23	2.95	3.05	378909.0
2020-06-16	AAIC.C-DELISTED	Stock	20.34	20.34	19.99	20.1	2150.0
2020-06-16	AAL	Stock	18.36	18.44	16.55	17.03	127369700.0
2020-06-16	AAM.A-DELISTED	Stock	26.29	26.29	25.07	26.21	40021.0
2020-06-16	AAM.B-DELISTED	Stock	25.8956	26.2	25.8871	25.98	20408.0
2020-06-16	AAMC-DELISTED	Stock	4.9009	5.3235	4.7324	4.7529	19237.0
2020-06-16	AAME	Stock	1.83	1.85	1.81	1.81	3300.0
2020-06-16	AAMI	Stock	10.93	11.055	10.53	10.89	2020400.0
2020-06-16	AAOI	Stock	9.3	9.46	9.06	9.19	466400.0
2020-06-16	AAON	Stock	36.2667	36.5667	35.3133	35.86	208950.0
2020-06-16	AAP	Stock	143.04	144.01	138.24	142.66	1018900.0
2020-06-16	AAT	Stock	31.8	31.97	30.88	31.2	378100.0
2020-06-16	AAU-DELISTED	Stock	0.52	0.5279	0.48	0.4895	320575.0
2020-06-16	AAUAF-DELISTED	Stock	0.52	0.52	0.48	0.49	329240.0
2020-06-16	AAWW-DELISTED	Stock	41.47	42.35	39.97	41.22	253092.0
2020-06-16	AAXJ	Stock	69.02	69.055	67.59	68.14	1517481.0
2020-06-16	AAXN-DELISTED	Stock	100.485	100.52	91.8	93.63	1906625.0
2020-06-16	AB	Stock	27.0	27.0	26.04	26.65	304900.0
2020-06-16	ABB-DELISTED	Stock	21.55	21.6	21.05	21.25	2150021.0
2020-06-16	ABBNY-DELISTED	Stock	21.55	21.6	21.05	21.24	2292174.0
2020-06-16	ABBV	Stock	94.86	96.2	93.48	96.06	9366100.0
2020-06-16	ABC-DELISTED	Stock	98.49	99.52	96.63	99.12	901753.0
2020-06-16	ABCB	Stock	25.82	25.92	24.49	25.53	527300.0
2020-06-16	ABEO	Stock	79.5	80.25	75.25	78.25	24360.0
2020-06-16	ABEV	Stock	2.7	2.71	2.54	2.56	40495500.0
2020-06-16	ABG	Stock	82.63	83.48	78.46	79.74	125000.0
2020-06-16	ABM	Stock	33.8	34.75	32.76	34.12	589500.0
2020-06-16	ABMD-DELISTED	Stock	252.49	252.49	246.295	249.14	276042.0
2020-06-16	ABR	Stock	10.19	10.23	9.6	9.78	2473000.0
2020-06-16	ABR.A-DELISTED	Stock	25.18	25.18	25.05	25.05	300.0
2020-06-16	ABR.B-DELISTED	Stock	23.3262	23.625	23.2	23.38	3000.0
2020-06-16	ABR.C-DELISTED	Stock	24.2696	25.06	24.2696	24.9042	3500.0
2020-06-16	ABT	Stock	90.62	91.76	89.14	89.74	6143400.0
2020-06-16	ABTC	Stock	327300.0	336000.0	300000.0	322200.0	7.933333333333334
2020-06-16	ABTS	Stock	15.15	16.65	14.55	14.925	8000.0
2020-06-16	ABTX-DELISTED	Stock	26.99	27.08	25.95	26.5	61438.0
2020-06-16	ABUS	Stock	1.94	2.0	1.87	1.98	792600.0

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

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