PREVIEW / stock_daily / 2021-08-17

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-17.parquet
  size:    259 KB
  rows:    7,953
  symbols: 2,823

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
2021-08-17	AAPL	Stock	150.23	151.68	149.09	150.19	92229700.0
2021-08-17	MSFT	Stock	292.39	293.43	291.08	293.08	20075300.0
2021-08-17	NVDA	Stock	19.685	19.77	19.267	19.458	204585000.0
2021-08-17	AMZN	Stock	163.875	164.0245	161.284	162.098	67758000.0
2021-08-17	GOOGL	Stock	137.75	138.2655	136.082	136.6615	21715200.0
2021-08-17	META	Stock	362.98	364.67	355.07	358.45	12328700.0
2021-08-17	TSLA	Stock	224.22	224.86	216.28	221.9033	71163900.0
2021-08-17	TLT	Stock	148.88	149.47	148.67	148.85	14126883.0
2021-08-17	ES	Stock	90.59	90.88	89.79	90.84	1348500.0
2021-08-17	CL	Stock	79.54	80.72	79.52	80.03	3356600.0
2021-08-17	A	Stock	161.73	161.84	159.29	160.91	2614200.0
2021-08-17	AA	Stock	42.78	42.94	40.34	41.61	8015500.0
2021-08-17	AAC-DELISTED	Stock	9.72	9.72	9.68	9.72	127765.0
2021-08-17	AACG	Stock	2.6	2.64	2.5	2.59	84800.0
2021-08-17	AACIU	Stock	9.797	9.8	9.77	9.79	274099.0
2021-08-17	AAIC-DELISTED	Stock	3.78	3.8	3.7365	3.76	86212.0
2021-08-17	AAIC.C-DELISTED	Stock	25.0967	25.105	24.87	24.92	5660.0
2021-08-17	AAL	Stock	19.36	19.61	19.09	19.34	23686100.0
2021-08-17	AAM.A-DELISTED	Stock	26.28	26.35	26.25	26.35	7211.0
2021-08-17	AAM.B-DELISTED	Stock	26.96	27.0	26.95	27.0	12981.0
2021-08-17	AAMC-DELISTED	Stock	4.3824	4.3824	3.8206	4.1971	160123.0
2021-08-17	AAME	Stock	3.5	3.68	3.5	3.64	25800.0
2021-08-17	AAMI	Stock	26.78	26.86	26.4	26.57	433300.0
2021-08-17	AAN-DELISTED	Stock	27.61	28.22	27.31	27.8	381100.0
2021-08-17	AAOI	Stock	6.74	6.74	6.39	6.52	861800.0
2021-08-17	AAON	Stock	45.7733	45.8533	45.0533	45.38	141750.0
2021-08-17	AAP	Stock	210.33	210.48	206.08	207.77	513700.0
2021-08-17	AAQC-DELISTED	Stock	9.65	9.65	9.62	9.64	7192.0
2021-08-17	AAT	Stock	37.69	38.15	37.23	37.8	213000.0
2021-08-17	AATC	Stock	6.82	7.1671	6.7817	6.81	57417.0
2021-08-17	AAU-DELISTED	Stock	0.4075	0.4137	0.395	0.3969	467282.0
2021-08-17	AAUAF-DELISTED	Stock	0.4075	0.4137	0.395	0.3969	477459.0
2021-08-17	AAWW-DELISTED	Stock	77.38	78.04	75.22	77.58	267625.0
2021-08-17	AAXJ	Stock	85.11	85.575	84.8	85.05	2181818.0
2021-08-17	AB	Stock	49.99	50.73	48.83	48.96	449900.0
2021-08-17	ABB-DELISTED	Stock	37.82	37.88	37.3469	37.63	1002256.0
2021-08-17	ABBNY-DELISTED	Stock	37.82	37.88	37.3469	37.63	1117533.0
2021-08-17	ABBV	Stock	118.08	119.74	118.0	119.66	6551700.0
2021-08-17	ABC-DELISTED	Stock	119.99	121.18	119.42	120.93	448379.0
2021-08-17	ABCB	Stock	49.64	50.02	48.73	49.07	268500.0
2021-08-17	ABCL	Stock	16.66	17.22	15.5	16.59	3084100.0
2021-08-17	ABCM-DELISTED	Stock	20.53	20.77	20.465	20.59	25796.0
2021-08-17	ABEO	Stock	28.75	29.25	27.75	29.25	46424.0
2021-08-17	ABEV	Stock	3.04	3.08	3.0	3.06	20719200.0
2021-08-17	ABG	Stock	198.53	198.56	188.9	191.04	153500.0
2021-08-17	ABGI-DELISTED	Stock	9.63	9.64	9.63	9.64	400.0
2021-08-17	ABM	Stock	46.74	47.61	46.45	47.44	985200.0
2021-08-17	ABMD-DELISTED	Stock	322.77	329.12	321.14	329.03	88891.0
2021-08-17	ABNB	Stock	145.0	148.2	143.58	143.9	7855100.0
2021-08-17	ABOS	Stock	15.03	15.71	15.0	15.41	90900.0

> showing 50 of 7,953 rows — these rows as CSV

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