PREVIEW / stock_daily / 2022-02-24

all stock daily files

  file:    by_date/stock_daily/2022/2022-02-24.parquet
  size:    262 KB
  rows:    8,167
  symbols: 2,625

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-24	AAPL	Stock	152.58	162.85	152.0	162.74	141147500.0
2022-02-24	MSFT	Stock	272.51	295.16	271.52	294.59	56989700.0
2022-02-24	NVDA	Stock	21.015	23.8	20.89	23.748	735801000.0
2022-02-24	AMZN	Stock	139.8375	151.749	139.5	151.358	100786000.0
2022-02-24	GOOGL	Stock	124.9532	133.0	124.9532	132.691	54455080.0
2022-02-24	META	Stock	191.06	208.35	190.22	207.6	49957200.0
2022-02-24	TSLA	Stock	233.4633	267.4933	233.3333	266.9233	135322200.0
2022-02-24	TLT	Stock	139.1	139.37	136.25	136.77	28150362.0
2022-02-24	ES	Stock	79.65	80.02	78.63	79.72	2995400.0
2022-02-24	CL	Stock	78.14	78.42	75.46	75.58	7890900.0
2022-02-24	A	Stock	123.7	128.63	123.06	128.15	3430200.0
2022-02-24	AA	Stock	75.29	77.45	69.85	73.3	11610900.0
2022-02-24	AAC-DELISTED	Stock	9.73	9.76	9.73	9.75	58782.0
2022-02-24	AACG	Stock	1.2	1.34	1.18	1.34	33100.0
2022-02-24	AACIW-DELISTED	Stock	0.3	0.3	0.2899	0.29	101800.0
2022-02-24	AAIC-DELISTED	Stock	3.18	3.25	3.13	3.25	210645.0
2022-02-24	AAIC.C-DELISTED	Stock	24.9	24.9	24.51	24.7	3875.0
2022-02-24	AAL	Stock	15.66	17.0	15.48	16.96	56881500.0
2022-02-24	AAM.A-DELISTED	Stock	25.16	25.34	25.16	25.33	13374.0
2022-02-24	AAM.B-DELISTED	Stock	25.32	25.48	25.16	25.48	14384.0
2022-02-24	AAME	Stock	2.45	2.59	2.4	2.47	8000.0
2022-02-24	AAMI	Stock	22.95	23.89	22.58	23.8	569700.0
2022-02-24	AAN-DELISTED	Stock	19.42	20.62	18.258	20.23	784300.0
2022-02-24	AAOI	Stock	3.74	4.07	3.49	4.06	771900.0
2022-02-24	AAON	Stock	36.9533	38.4133	36.7667	38.2467	353250.0
2022-02-24	AAP	Stock	192.13	202.04	190.79	200.81	1265800.0
2022-02-24	AAQC-DELISTED	Stock	9.68	9.705	9.68	9.7	15201.0
2022-02-24	AAT	Stock	34.99	36.04	34.5	35.89	295800.0
2022-02-24	AATC	Stock	6.5	6.8683	6.44	6.56	20835.0
2022-02-24	AAU-DELISTED	Stock	0.285	0.3	0.2752	0.2976	942958.0
2022-02-24	AAUAF-DELISTED	Stock	0.285	0.3	0.2752	0.3	948006.0
2022-02-24	AAWW-DELISTED	Stock	73.78	75.85	73.18	75.35	398218.0
2022-02-24	AAXJ	Stock	75.89	78.25	75.83	78.15	3080627.0
2022-02-24	AB	Stock	40.14	43.91	39.74	43.88	743400.0
2022-02-24	ABB-DELISTED	Stock	31.74	33.155	31.69	33.085	4704478.0
2022-02-24	ABBNY-DELISTED	Stock	31.74	33.155	31.69	33.09	5142874.0
2022-02-24	ABBV	Stock	143.61	145.7	143.47	145.27	12070200.0
2022-02-24	ABC-DELISTED	Stock	137.57	137.93	134.7	137.86	1446534.0
2022-02-24	ABCB	Stock	46.75	48.03	45.8	47.71	427300.0
2022-02-24	ABCL	Stock	7.91	8.49	7.85	8.45	2960000.0
2022-02-24	ABCM-DELISTED	Stock	15.45	16.29	15.45	16.28	108334.0
2022-02-24	ABEO	Stock	5.75	6.0	5.25	6.0	72560.0
2022-02-24	ABEV	Stock	2.78	2.89	2.75	2.88	49896700.0
2022-02-24	ABG	Stock	178.85	186.61	176.88	186.31	374800.0
2022-02-24	ABGI-DELISTED	Stock	9.71	9.75	9.71	9.73	67141.0
2022-02-24	ABM	Stock	42.19	43.62	41.98	43.48	428100.0
2022-02-24	ABMD-DELISTED	Stock	283.21	306.9	281.0431	306.3	149229.0
2022-02-24	ABNB	Stock	141.3	158.96	141.18	158.26	10354600.0
2022-02-24	ABOS	Stock	5.55	5.59	5.16	5.38	126400.0
2022-02-24	ABR	Stock	16.93	17.7	16.75	17.59	2576900.0

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

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