PREVIEW / stock_daily / 2021-11-19

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-19.parquet
  size:    262 KB
  rows:    8,016
  symbols: 2,678

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-11-19	AAPL	Stock	157.65	161.02	156.53	160.55	117305600.0
2021-11-19	MSFT	Stock	342.64	345.1	342.2	343.11	21963400.0
2021-11-19	NVDA	Stock	32.243	33.088	31.905	32.985	533867000.0
2021-11-19	AMZN	Stock	185.6345	188.1075	183.786	183.8285	98734000.0
2021-11-19	GOOGL	Stock	149.9754	150.9665	148.899	148.9265	33699380.0
2021-11-19	META	Stock	342.2	352.1	339.9	345.3	26488500.0
2021-11-19	TSLA	Stock	366.29	379.5733	364.2333	379.02	64926900.0
2021-11-19	TLT	Stock	147.58	148.595	147.58	148.36	14022924.0
2021-11-19	ES	Stock	83.69	84.22	83.43	83.86	1065200.0
2021-11-19	CL	Stock	76.47	77.66	76.47	77.2	3978200.0
2021-11-19	A	Stock	163.01	165.07	162.67	164.3	1647600.0
2021-11-19	AA	Stock	47.31	48.08	46.69	47.6	5641400.0
2021-11-19	AAC-DELISTED	Stock	9.84	9.84	9.79	9.82	975318.0
2021-11-19	AACG	Stock	1.81	1.86	1.75	1.77	44300.0
2021-11-19	AACIU	Stock	10.05	10.05	10.03	10.03	10209.0
2021-11-19	AACIW-DELISTED	Stock	0.52	0.538	0.5	0.517	110862.0
2021-11-19	AAIC-DELISTED	Stock	3.7	3.74	3.7	3.71	107409.0
2021-11-19	AAIC.C-DELISTED	Stock	25.705	25.705	25.705	25.705	100.0
2021-11-19	AAL	Stock	19.14	19.44	18.94	19.28	31259800.0
2021-11-19	AAM.A-DELISTED	Stock	25.7	25.8488	25.69	25.7	4716.0
2021-11-19	AAM.B-DELISTED	Stock	26.8	26.85	26.71	26.8499	11733.0
2021-11-19	AAMC-DELISTED	Stock	6.6324	6.6353	6.3529	6.3529	18969.0
2021-11-19	AAME	Stock	4.05	4.2	4.02	4.11	5200.0
2021-11-19	AAMI	Stock	30.3	30.47	30.26	30.38	935500.0
2021-11-19	AAN-DELISTED	Stock	25.4	25.49	24.75	25.26	168900.0
2021-11-19	AAOI	Stock	5.99	6.24	5.99	6.16	484500.0
2021-11-19	AAON	Stock	51.08	52.06	50.78	51.6133	315300.0
2021-11-19	AAP	Stock	231.67	231.88	228.27	230.0	574400.0
2021-11-19	AAQC-DELISTED	Stock	9.78	9.78	9.76	9.76	6361.0
2021-11-19	AAT	Stock	37.5	37.91	37.5	37.77	221100.0
2021-11-19	AATC	Stock	7.08	7.08	6.88	6.9	13980.0
2021-11-19	AAU-DELISTED	Stock	0.37	0.3721	0.3669	0.369	499308.0
2021-11-19	AAUAF-DELISTED	Stock	0.37	0.372	0.3669	0.369	504191.0
2021-11-19	AAWW-DELISTED	Stock	89.46	90.205	88.59	89.67	420707.0
2021-11-19	AAXJ	Stock	86.67	87.09	86.59	86.64	588306.0
2021-11-19	AB	Stock	54.38	54.58	53.31	53.43	243500.0
2021-11-19	ABB-DELISTED	Stock	35.77	35.98	35.71	35.74	851666.0
2021-11-19	ABBNY-DELISTED	Stock	35.77	35.98	35.71	35.74	1065428.0
2021-11-19	ABBV	Stock	117.63	117.8	115.86	116.24	5885800.0
2021-11-19	ABC-DELISTED	Stock	125.49	126.15	120.39	120.54	807027.0
2021-11-19	ABCB	Stock	51.8	52.26	51.14	51.58	234300.0
2021-11-19	ABCL	Stock	15.57	15.9	15.13	15.8	1816100.0
2021-11-19	ABCM-DELISTED	Stock	23.03	23.03	22.6869	22.76	24054.0
2021-11-19	ABEO	Stock	19.0	19.5	18.25	18.5	35556.0
2021-11-19	ABEV	Stock	3.13	3.14	3.06	3.06	22472800.0
2021-11-19	ABG	Stock	168.9	168.95	162.28	162.99	428200.0
2021-11-19	ABGI-DELISTED	Stock	9.7905	9.7905	9.77	9.77	400.0
2021-11-19	ABM	Stock	46.49	47.88	46.45	47.38	393300.0
2021-11-19	ABMD-DELISTED	Stock	342.99	344.8	338.51	339.59	123086.0
2021-11-19	ABNB	Stock	196.6	199.36	190.5	196.42	8181900.0

> showing 50 of 8,016 rows — these rows as CSV

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