PREVIEW / stock_daily / 2022-02-22

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-22.parquet
  size:    260 KB
  rows:    8,063
  symbols: 2,537

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
2022-02-22	AAPL	Stock	164.98	166.69	162.15	164.32	91162800.0
2022-02-22	MSFT	Stock	285.0	291.54	284.5	287.72	41736100.0
2022-02-22	NVDA	Stock	23.035	24.064	23.0	23.39	633422000.0
2022-02-22	AMZN	Stock	150.4785	152.9825	148.4855	150.1975	66128000.0
2022-02-22	GOOGL	Stock	129.8381	132.1802	128.2232	129.8135	44990740.0
2022-02-22	META	Stock	202.34	207.48	200.06	202.08	39852400.0
2022-02-22	TSLA	Stock	278.0433	285.5767	267.0333	273.8433	83288100.0
2022-02-22	TLT	Stock	137.69	138.67	137.47	138.59	19534043.0
2022-02-22	ES	Stock	82.97	83.18	81.92	82.41	1785000.0
2022-02-22	CL	Stock	79.36	79.8	78.55	78.85	4752300.0
2022-02-22	A	Stock	130.87	132.69	129.26	130.49	3054800.0
2022-02-22	AA	Stock	80.0	80.08	73.11	74.09	8994000.0
2022-02-22	AAC-DELISTED	Stock	9.74	9.7457	9.73	9.739	25700.0
2022-02-22	AACG	Stock	1.47	1.47	1.21	1.26	57400.0
2022-02-22	AACIW-DELISTED	Stock	0.29	0.31119	0.28027	0.31119	1401.0
2022-02-22	AAIC-DELISTED	Stock	3.35	3.4	3.29	3.29	106584.0
2022-02-22	AAIC.C-DELISTED	Stock	24.76	24.8	24.76	24.8	319.0
2022-02-22	AAL	Stock	17.44	17.95	17.29	17.43	32432700.0
2022-02-22	AAM.A-DELISTED	Stock	25.26	25.29	25.23	25.29	18368.0
2022-02-22	AAM.B-DELISTED	Stock	25.47	25.56	25.43	25.4899	11659.0
2022-02-22	AAME	Stock	2.75	2.8	2.61	2.7	3000.0
2022-02-22	AAMI	Stock	24.32	24.48	23.99	24.25	551200.0
2022-02-22	AAN-DELISTED	Stock	20.94	21.69	20.58	20.62	217300.0
2022-02-22	AAOI	Stock	4.2	4.33	3.93	3.96	788700.0
2022-02-22	AAON	Stock	38.6267	38.82	38.0267	38.3667	269550.0
2022-02-22	AAP	Stock	217.9	217.95	204.97	206.76	1313300.0
2022-02-22	AAQC-DELISTED	Stock	9.7	9.7	9.69	9.7	7963.0
2022-02-22	AAT	Stock	36.67	36.67	35.53	36.14	248400.0
2022-02-22	AATC	Stock	7.12	7.1498	6.78	7.0	31336.0
2022-02-22	AAU-DELISTED	Stock	0.28	0.2849	0.271	0.275	495259.0
2022-02-22	AAUAF-DELISTED	Stock	0.28	0.2849	0.271	0.275	498920.0
2022-02-22	AAWW-DELISTED	Stock	77.28	78.4	73.475	74.49	805192.0
2022-02-22	AAXJ	Stock	80.23	80.67	79.65	80.06	968128.0
2022-02-22	AB	Stock	44.2	44.74	41.37	42.22	1032500.0
2022-02-22	ABB-DELISTED	Stock	33.79	34.115	33.435	33.79	1701901.0
2022-02-22	ABBNY-DELISTED	Stock	33.79	34.115	33.435	33.78	1915830.0
2022-02-22	ABBV	Stock	141.25	146.35	141.25	145.56	11576800.0
2022-02-22	ABC-DELISTED	Stock	141.64	141.995	139.15	140.56	558255.0
2022-02-22	ABCB	Stock	49.98	50.3	48.86	49.1	290900.0
2022-02-22	ABCL	Stock	9.04	9.28	8.7	8.81	2066600.0
2022-02-22	ABCM-DELISTED	Stock	16.22	16.5188	16.22	16.34	108928.0
2022-02-22	ABEO	Stock	6.25	6.25	5.75	6.0	45708.0
2022-02-22	ABEV	Stock	2.9	2.93	2.88	2.89	19762200.0
2022-02-22	ABG	Stock	187.0	189.94	182.33	184.85	374000.0
2022-02-22	ABGI-DELISTED	Stock	9.71	9.72	9.71	9.72	41152.0
2022-02-22	ABM	Stock	43.35	43.6	42.52	42.71	314700.0
2022-02-22	ABMD-DELISTED	Stock	295.85	301.18	293.04	296.629	141334.0
2022-02-22	ABNB	Stock	172.13	176.38	161.32	165.24	8392600.0
2022-02-22	ABOS	Stock	5.93	6.13	5.59	5.7	213200.0
2022-02-22	ABR	Stock	17.35	17.58	17.15	17.41	2584800.0

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

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