PREVIEW / stock_daily / 2021-11-22

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-22.parquet
  size:    262 KB
  rows:    8,036
  symbols: 2,686

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-22	AAPL	Stock	161.68	165.7	161.0	161.02	117467900.0
2021-11-22	MSFT	Stock	344.62	349.67	339.55	339.83	31031100.0
2021-11-22	NVDA	Stock	33.517	34.647	31.9	31.956	754335000.0
2021-11-22	AMZN	Stock	183.819	185.673	178.375	178.6285	96844000.0
2021-11-22	GOOGL	Stock	149.3325	149.8295	146.1475	146.302	30629200.0
2021-11-22	META	Stock	349.05	353.83	340.51	341.01	27116800.0
2021-11-22	TSLA	Stock	387.4433	400.65	377.4767	385.6233	99217500.0
2021-11-22	TLT	Stock	147.4	147.64	146.125	146.62	15267367.0
2021-11-22	ES	Stock	83.79	85.71	83.77	84.68	1161400.0
2021-11-22	CL	Stock	77.41	78.31	77.3	77.56	3601000.0
2021-11-22	A	Stock	165.0	165.68	162.78	162.78	2110400.0
2021-11-22	AA	Stock	47.8	49.7	47.3	48.51	6376900.0
2021-11-22	AAC-DELISTED	Stock	9.82	9.84	9.81	9.83	255834.0
2021-11-22	AACG	Stock	1.75	1.82	1.75	1.76	16800.0
2021-11-22	AACIU	Stock	10.03	10.07	10.03	10.04	6154.0
2021-11-22	AAIC-DELISTED	Stock	3.7	3.7194	3.67	3.68	205448.0
2021-11-22	AAIC.C-DELISTED	Stock	25.75	25.9527	25.7373	25.83	2378.0
2021-11-22	AAL	Stock	19.56	19.76	19.05	19.63	33220600.0
2021-11-22	AAM.A-DELISTED	Stock	25.7	25.7899	25.64	25.65	25477.0
2021-11-22	AAM.B-DELISTED	Stock	26.7047	26.751	26.54	26.73	4862.0
2021-11-22	AAMC-DELISTED	Stock	6.3529	6.5529	6.3529	6.4956	19448.0
2021-11-22	AAME	Stock	4.19	4.2	4.04	4.05	10800.0
2021-11-22	AAMI	Stock	30.51	30.58	30.25	30.27	935100.0
2021-11-22	AAN-DELISTED	Stock	25.5	26.36	25.04	25.43	298900.0
2021-11-22	AAOI	Stock	6.18	6.202	5.97	6.0	466000.0
2021-11-22	AAON	Stock	52.0267	52.3333	51.4267	51.9533	300300.0
2021-11-22	AAP	Stock	231.21	233.89	229.65	231.83	544900.0
2021-11-22	AAQC-DELISTED	Stock	9.77	9.77	9.7412	9.75	121010.0
2021-11-22	AAT	Stock	38.26	38.5	37.76	37.81	180500.0
2021-11-22	AATC	Stock	6.8	6.98	6.8	6.9291	9431.0
2021-11-22	AAU-DELISTED	Stock	0.3699	0.37	0.3521	0.3544	628647.0
2021-11-22	AAUAF-DELISTED	Stock	0.3699	0.37	0.3521	0.3534	636600.0
2021-11-22	AAWW-DELISTED	Stock	90.0	94.42	89.89	92.57	557645.0
2021-11-22	AAXJ	Stock	86.68	87.02	86.18	86.28	735006.0
2021-11-22	AB	Stock	53.69	54.49	53.36	53.86	233400.0
2021-11-22	ABB-DELISTED	Stock	35.9	36.08	35.615	35.62	1007161.0
2021-11-22	ABBNY-DELISTED	Stock	35.9	36.08	35.615	35.62	1129397.0
2021-11-22	ABBV	Stock	115.95	117.34	115.01	115.65	3975800.0
2021-11-22	ABC-DELISTED	Stock	120.34	122.59	119.79	121.1	585293.0
2021-11-22	ABCB	Stock	52.28	53.66	51.98	52.82	340600.0
2021-11-22	ABCL	Stock	15.78	15.79	14.32	14.42	1822600.0
2021-11-22	ABCM-DELISTED	Stock	22.56	22.6	22.06	22.08	35280.0
2021-11-22	ABEO	Stock	19.0	20.0	18.5	19.5	34324.0
2021-11-22	ABEV	Stock	3.08	3.1	3.04	3.04	28237000.0
2021-11-22	ABG	Stock	165.0	169.53	163.76	167.8	316200.0
2021-11-22	ABGI-DELISTED	Stock	9.7932	9.82	9.76	9.81	4706.0
2021-11-22	ABM	Stock	47.66	48.87	47.65	48.58	320300.0
2021-11-22	ABMD-DELISTED	Stock	340.06	343.54	335.0	335.32	103576.0
2021-11-22	ABNB	Stock	190.44	190.76	176.72	181.73	12619800.0
2021-11-22	ABOS	Stock	9.94	10.52	9.5	9.7	90300.0

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

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