PREVIEW / stock_daily / 2022-03-01

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-01.parquet
  size:    261 KB
  rows:    8,085
  symbols: 2,538

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-03-01	AAPL	Stock	164.7	166.6	161.97	163.2	83474400.0
2022-03-01	MSFT	Stock	296.4	299.97	292.15	294.95	31217800.0
2022-03-01	NVDA	Stock	24.291	24.377	23.132	23.477	412056000.0
2022-03-01	AMZN	Stock	152.7325	154.099	149.977	151.142	44874000.0
2022-03-01	GOOGL	Stock	134.8785	136.2555	133.2185	134.0615	26495360.0
2022-03-01	META	Stock	209.87	211.75	202.22	203.49	27094900.0
2022-03-01	TSLA	Stock	289.8933	296.6267	284.5933	288.1233	74766900.0
2022-03-01	TLT	Stock	140.36	142.33	140.0	141.3	35664355.0
2022-03-01	ES	Stock	81.89	82.4	79.76	80.44	2787800.0
2022-03-01	CL	Stock	77.0	77.18	75.73	76.04	3966500.0
2022-03-01	A	Stock	130.83	132.92	130.09	131.93	2634100.0
2022-03-01	AA	Stock	77.89	85.73	77.06	79.78	15303400.0
2022-03-01	AAC-DELISTED	Stock	9.76	9.76	9.75	9.75	231429.0
2022-03-01	AACG	Stock	1.27	1.33	1.25	1.32	10500.0
2022-03-01	AACIU	Stock	9.9	9.9	9.9	9.9	2989.0
2022-03-01	AACIW-DELISTED	Stock	0.22	0.2499	0.22	0.2401	3521.0
2022-03-01	AAIC-DELISTED	Stock	3.195	3.28	3.15	3.21	93182.0
2022-03-01	AAIC.C-DELISTED	Stock	24.3	24.7	24.3	24.7	747.0
2022-03-01	AAL	Stock	16.97	17.07	16.08	16.29	50513700.0
2022-03-01	AAM.A-DELISTED	Stock	24.95	25.05	24.95	24.99	13191.0
2022-03-01	AAM.B-DELISTED	Stock	25.34	25.58	25.3	25.36	48203.0
2022-03-01	AAME	Stock	2.47	2.65	2.47	2.55	3400.0
2022-03-01	AAMI	Stock	23.77	23.84	22.88	23.1	783200.0
2022-03-01	AAN-DELISTED	Stock	20.95	21.08	20.31	20.72	267300.0
2022-03-01	AAOI	Stock	3.6	3.65	3.49	3.62	301800.0
2022-03-01	AAON	Stock	36.8133	38.8533	36.4933	38.12	533100.0
2022-03-01	AAP	Stock	204.23	209.65	198.45	201.17	1051100.0
2022-03-01	AAQC-DELISTED	Stock	9.71	9.715	9.7	9.715	57960.0
2022-03-01	AAT	Stock	36.43	36.73	36.0	36.25	319600.0
2022-03-01	AATC	Stock	6.65	6.8089	6.65	6.68	14025.0
2022-03-01	AAU-DELISTED	Stock	0.3011	0.31	0.3001	0.3077	190346.0
2022-03-01	AAUAF-DELISTED	Stock	0.3011	0.31	0.3001	0.3077	193488.0
2022-03-01	AAWW-DELISTED	Stock	78.3	80.86	77.8	80.39	541929.0
2022-03-01	AAXJ	Stock	78.42	78.88	77.56	77.91	3037265.0
2022-03-01	AB	Stock	44.31	44.79	43.11	43.38	289500.0
2022-03-01	ABB-DELISTED	Stock	33.99	34.11	32.76	32.92	2819159.0
2022-03-01	ABBNY-DELISTED	Stock	33.99	34.11	32.76	32.91	3057636.0
2022-03-01	ABBV	Stock	147.67	149.5	146.21	147.69	7489900.0
2022-03-01	ABC-DELISTED	Stock	142.44	143.33	140.3401	141.97	695240.0
2022-03-01	ABCB	Stock	49.02	49.66	45.97	46.74	487200.0
2022-03-01	ABCL	Stock	8.6	9.3	8.6	9.04	1944900.0
2022-03-01	ABCM-DELISTED	Stock	16.57	16.67	16.235	16.36	54846.0
2022-03-01	ABEO	Stock	6.5	7.25	6.5	7.0	206608.0
2022-03-01	ABEV	Stock	2.91	2.94	2.82	2.82	28290800.0
2022-03-01	ABG	Stock	192.14	195.19	188.2	191.47	345400.0
2022-03-01	ABGI-DELISTED	Stock	9.73	9.765	9.73	9.75	66940.0
2022-03-01	ABM	Stock	44.46	45.2	44.08	44.93	407300.0
2022-03-01	ABMD-DELISTED	Stock	311.07	315.34	306.32	313.55	142207.0
2022-03-01	ABNB	Stock	150.53	154.22	149.95	151.01	5165800.0
2022-03-01	ABOS	Stock	5.88	6.43	5.88	6.11	160300.0

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

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