PREVIEW / stock_daily / 2021-11-29

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-29.parquet
  size:    261 KB
  rows:    8,003
  symbols: 2,659

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-29	AAPL	Stock	159.37	161.19	158.79	160.24	88748200.0
2021-11-29	MSFT	Stock	334.94	339.03	334.74	336.63	28563500.0
2021-11-29	NVDA	Stock	32.366	33.412	32.036	33.376	454964000.0
2021-11-29	AMZN	Stock	177.382	179.8	176.575	178.0785	65312000.0
2021-11-29	GOOGL	Stock	144.0	146.2975	143.8935	145.5305	32595040.0
2021-11-29	META	Stock	336.89	340.67	335.31	338.03	16650900.0
2021-11-29	TSLA	Stock	366.9967	380.89	366.73	378.9967	58393500.0
2021-11-29	TLT	Stock	148.31	149.635	148.17	149.32	23234231.0
2021-11-29	ES	Stock	84.72	85.55	83.97	85.27	1121000.0
2021-11-29	CL	Stock	77.08	78.08	76.94	77.71	3923000.0
2021-11-29	A	Stock	153.06	155.38	151.56	153.42	1734600.0
2021-11-29	AA	Stock	49.22	49.935	47.779	49.14	6546700.0
2021-11-29	AAC-DELISTED	Stock	9.8	9.82	9.78	9.78	283828.0
2021-11-29	AACG	Stock	1.71	1.77	1.7	1.7	11900.0
2021-11-29	AACIW-DELISTED	Stock	0.5001	0.5498	0.49255	0.50938	76965.0
2021-11-29	AAIC-DELISTED	Stock	3.7	3.7286	3.65	3.67	259308.0
2021-11-29	AAIC.C-DELISTED	Stock	25.69	25.85	25.69	25.85	292.0
2021-11-29	AAL	Stock	18.15	18.26	17.42	17.74	42940300.0
2021-11-29	AAM.A-DELISTED	Stock	25.74	25.74	25.5984	25.61	6038.0
2021-11-29	AAM.B-DELISTED	Stock	26.69	26.7	26.39	26.52	9675.0
2021-11-29	AAMC-DELISTED	Stock	5.4412	5.7353	5.4412	5.7353	46315.0
2021-11-29	AAME	Stock	3.91	4.03	3.8	3.82	31800.0
2021-11-29	AAMI	Stock	30.39	30.65	30.05	30.44	2801200.0
2021-11-29	AAN-DELISTED	Stock	24.36	24.73	23.94	24.1	348900.0
2021-11-29	AAOI	Stock	6.04	6.065	5.81	5.95	409500.0
2021-11-29	AAON	Stock	52.3533	52.3533	51.3333	51.7	272550.0
2021-11-29	AAP	Stock	228.36	230.19	226.37	227.27	376800.0
2021-11-29	AAQC-DELISTED	Stock	9.74	9.74	9.71	9.73	39937.0
2021-11-29	AAT	Stock	36.34	36.34	34.85	35.22	296000.0
2021-11-29	AATC	Stock	7.0	7.06	6.8994	7.0	17073.0
2021-11-29	AAU-DELISTED	Stock	0.34	0.345	0.3309	0.3362	484167.0
2021-11-29	AAUAF-DELISTED	Stock	0.34	0.345	0.3309	0.3362	488973.0
2021-11-29	AAWW-DELISTED	Stock	93.62	93.62	90.31	90.56	252163.0
2021-11-29	AAXJ	Stock	83.93	83.95	83.23	83.52	2881836.0
2021-11-29	AB	Stock	54.32	54.6	52.55	53.12	355800.0
2021-11-29	ABB-DELISTED	Stock	34.69	34.88	34.4436	34.74	1075631.0
2021-11-29	ABBNY-DELISTED	Stock	34.69	34.88	34.4436	34.74	1212867.0
2021-11-29	ABBV	Stock	116.83	117.92	116.58	116.89	4372500.0
2021-11-29	ABC-DELISTED	Stock	120.75	121.63	119.64	120.23	460315.0
2021-11-29	ABCB	Stock	51.35	51.35	49.38	49.85	332400.0
2021-11-29	ABCL	Stock	14.22	14.27	13.73	14.1	1376000.0
2021-11-29	ABCM-DELISTED	Stock	22.65	22.945	22.59	22.72	45359.0
2021-11-29	ABEO	Stock	20.5	20.75	16.0	16.25	123404.0
2021-11-29	ABEV	Stock	2.96	2.97	2.87	2.9	26682000.0
2021-11-29	ABG	Stock	162.13	164.91	158.8	163.51	342100.0
2021-11-29	ABGI-DELISTED	Stock	9.77	9.82	9.77	9.82	50804.0
2021-11-29	ABM	Stock	47.13	47.13	46.26	46.38	226700.0
2021-11-29	ABMD-DELISTED	Stock	327.69	331.615	318.64	318.65	117607.0
2021-11-29	ABNB	Stock	176.88	180.7	175.9	180.08	5317400.0
2021-11-29	ABOS	Stock	8.52	9.105	7.95	8.12	64700.0

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

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