PREVIEW / stock_daily / 2020-09-08

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-08.parquet
  size:    225 KB
  rows:    6,847
  symbols: 2,441

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-09-08	AAPL	Stock	113.95	118.99	112.68	112.82	231366600.0
2020-09-08	MSFT	Stock	206.5	210.03	202.2	202.66	52924300.0
2020-09-08	NVDA	Stock	11.7345	12.55	11.7043	11.913	795728000.0
2020-09-08	AMZN	Stock	157.2	162.5425	156.5	157.492	121884000.0
2020-09-08	GOOGL	Stock	76.25	77.7775	75.825	76.18	54031720.0
2020-09-08	META	Stock	271.28	279.3	269.42	271.16	24864000.0
2020-09-08	TSLA	Stock	118.6667	122.9133	109.96	110.07	346397100.0
2020-09-08	TLT	Stock	164.37	165.26	163.74	163.74	13790421.0
2020-09-08	ES	Stock	86.17	86.37	84.87	85.26	1256800.0
2020-09-08	CL	Stock	77.2	77.32	75.57	75.64	4816200.0
2020-09-08	A	Stock	96.11	96.47	94.76	95.14	1225600.0
2020-09-08	AA	Stock	14.26	14.555	13.69	14.23	4901900.0
2020-09-08	AACG	Stock	1.09	1.14	1.07	1.14	17500.0
2020-09-08	AACQ-DELISTED	Stock	10.27	10.27	9.915	9.95	82469.0
2020-09-08	AACQU-DELISTED	Stock	10.09	10.41	10.09	10.3793	103148.0
2020-09-08	AACQW-DELISTED	Stock	1.81	1.81	1.59	1.65	45480.0
2020-09-08	AAIC-DELISTED	Stock	2.65	2.795	2.65	2.71	359037.0
2020-09-08	AAIC.C-DELISTED	Stock	19.32	19.395	19.32	19.395	1147.0
2020-09-08	AAL	Stock	13.36	14.16	13.15	13.63	72746000.0
2020-09-08	AAM.A-DELISTED	Stock	26.14	26.26	26.0	26.2	8461.0
2020-09-08	AAM.B-DELISTED	Stock	26.9	26.91	26.72	26.845	12302.0
2020-09-08	AAMC-DELISTED	Stock	5.6382	6.3529	5.6382	6.1765	48793.0
2020-09-08	AAME	Stock	2.0	2.08	1.96	2.05	3500.0
2020-09-08	AAMI	Stock	13.32	13.32	12.83	12.88	755900.0
2020-09-08	AAOI	Stock	10.17	10.46	9.93	9.94	607900.0
2020-09-08	AAON	Stock	37.26	37.5467	36.64	37.0	228600.0
2020-09-08	AAP	Stock	152.65	154.69	150.84	151.73	1198000.0
2020-09-08	AAT	Stock	25.99	26.18	25.48	25.92	253500.0
2020-09-08	AAU-DELISTED	Stock	0.68	0.697	0.65	0.6753	278324.0
2020-09-08	AAUAF-DELISTED	Stock	0.68	0.697	0.65	0.68	301703.0
2020-09-08	AAWW-DELISTED	Stock	54.67	55.05	52.68	53.79	410052.0
2020-09-08	AAXJ	Stock	76.1	76.68	75.84	76.0	845795.0
2020-09-08	AAXN-DELISTED	Stock	80.99	83.135	79.72	81.35	464472.0
2020-09-08	AB	Stock	27.74	27.74	26.86	26.98	371700.0
2020-09-08	ABB-DELISTED	Stock	25.6	26.07	25.54	25.78	2158229.0
2020-09-08	ABBNY-DELISTED	Stock	25.61	26.07	25.54	25.78	2268337.0
2020-09-08	ABBV	Stock	91.52	91.86	89.45	90.22	8563900.0
2020-09-08	ABC-DELISTED	Stock	96.51	96.72	94.9	95.37	730835.0
2020-09-08	ABCB	Stock	24.8	24.82	24.02	24.41	337600.0
2020-09-08	ABEO	Stock	49.75	52.5	47.75	52.0	28040.0
2020-09-08	ABEV	Stock	2.33	2.36	2.3	2.32	17269500.0
2020-09-08	ABG	Stock	104.84	109.53	103.16	107.65	254800.0
2020-09-08	ABM	Stock	37.91	37.91	36.61	36.65	313700.0
2020-09-08	ABMD-DELISTED	Stock	269.79	275.29	261.79	268.19	231481.0
2020-09-08	ABR	Stock	11.3	11.63	11.16	11.32	1080600.0
2020-09-08	ABR.A-DELISTED	Stock	25.2	25.26	25.2	25.26	500.0
2020-09-08	ABR.B-DELISTED	Stock	25.1	25.2475	25.0	25.2475	2444.0
2020-09-08	ABR.C-DELISTED	Stock	25.3318	25.5	25.1	25.4	2666.0
2020-09-08	ABT	Stock	103.17	103.82	102.43	102.84	5217700.0
2020-09-08	ABTC	Stock	141000.0	142500.0	136800.0	138300.0	3.0266666666666664

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

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