PREVIEW / stock_daily / 2022-03-09

all stock daily files

  file:    by_date/stock_daily/2022/2022-03-09.parquet
  size:    260 KB
  rows:    8,042
  symbols: 2,513

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-09	AAPL	Stock	161.48	163.41	159.41	162.95	91454900.0
2022-03-09	MSFT	Stock	283.44	289.6	280.78	288.5	35204500.0
2022-03-09	NVDA	Stock	22.387	23.22	22.247	23.014	492742000.0
2022-03-09	AMZN	Stock	139.5	140.25	136.828	139.279	82656000.0
2022-03-09	GOOGL	Stock	131.25	133.7355	129.9005	133.42	37025400.0
2022-03-09	META	Stock	195.74	199.1	193.92	198.5	31894700.0
2022-03-09	TSLA	Stock	279.8267	286.8533	277.3367	286.3233	59184000.0
2022-03-09	TLT	Stock	137.065	137.3403	136.13	136.42	18819154.0
2022-03-09	ES	Stock	84.78	85.14	84.01	84.19	2721000.0
2022-03-09	CL	Stock	76.18	76.64	75.44	75.54	7013200.0
2022-03-09	A	Stock	132.85	133.94	131.19	133.26	1805500.0
2022-03-09	AA	Stock	79.8	80.81	77.0	79.52	11917700.0
2022-03-09	AAC-DELISTED	Stock	9.76	9.76	9.75	9.75	111058.0
2022-03-09	AACG	Stock	1.26	1.33	1.26	1.3	16100.0
2022-03-09	AACIW-DELISTED	Stock	0.3399	0.3399	0.3398	0.3398	800.0
2022-03-09	AAIC-DELISTED	Stock	3.55	3.58	3.48	3.5	105140.0
2022-03-09	AAIC.C-DELISTED	Stock	24.705	24.89	24.59	24.8899	4556.0
2022-03-09	AAL	Stock	14.44	14.75	14.05	14.3	88884200.0
2022-03-09	AAM.A-DELISTED	Stock	25.0	25.125	25.0	25.07	129179.0
2022-03-09	AAM.B-DELISTED	Stock	25.2	25.29	25.17	25.29	27881.0
2022-03-09	AAME	Stock	2.41	2.41	2.23	2.38	11700.0
2022-03-09	AAMI	Stock	22.45	23.545	22.45	23.25	843100.0
2022-03-09	AAN-DELISTED	Stock	22.49	22.65	22.04	22.3	202500.0
2022-03-09	AAOI	Stock	3.78	3.89	3.7	3.72	218100.0
2022-03-09	AAON	Stock	36.18	36.8133	35.5	36.7067	312600.0
2022-03-09	AAP	Stock	205.49	207.11	202.43	204.88	776800.0
2022-03-09	AAQC-DELISTED	Stock	9.72	9.73	9.71	9.71	14101.0
2022-03-09	AAT	Stock	37.02	37.51	36.48	36.53	408700.0
2022-03-09	AATC	Stock	6.4757	6.99	6.4757	6.95	11061.0
2022-03-09	AAU-DELISTED	Stock	0.34	0.365	0.32	0.3368	1941967.0
2022-03-09	AAUAF-DELISTED	Stock	0.34	0.365	0.32	0.337	1961519.0
2022-03-09	AAWW-DELISTED	Stock	81.78	83.12	80.51	82.24	329299.0
2022-03-09	AAXJ	Stock	73.6	74.52	73.13	74.4	1901518.0
2022-03-09	AB	Stock	44.19	45.21	44.05	44.88	413900.0
2022-03-09	ABB-DELISTED	Stock	33.08	33.575	32.605	33.31	3514949.0
2022-03-09	ABBNY-DELISTED	Stock	33.08	33.575	32.605	33.31	3877202.0
2022-03-09	ABBV	Stock	148.26	150.11	147.76	148.84	5368900.0
2022-03-09	ABC-DELISTED	Stock	146.45	147.17	145.0	145.83	1111298.0
2022-03-09	ABCB	Stock	45.95	46.56	45.55	46.3	630700.0
2022-03-09	ABCL	Stock	8.38	8.699	8.31	8.54	1555600.0
2022-03-09	ABCM-DELISTED	Stock	15.72	16.34	15.65	16.31	136364.0
2022-03-09	ABEO	Stock	7.75	8.0	7.0	8.0	110992.0
2022-03-09	ABEV	Stock	2.73	2.79	2.71	2.77	17745400.0
2022-03-09	ABG	Stock	191.13	192.61	184.07	185.15	418300.0
2022-03-09	ABGI-DELISTED	Stock	9.77	9.77	9.75	9.77	21297.0
2022-03-09	ABM	Stock	47.04	47.86	45.72	46.79	755200.0
2022-03-09	ABMD-DELISTED	Stock	298.62	307.855	298.62	306.6	81418.0
2022-03-09	ABNB	Stock	145.43	150.99	145.33	148.31	7023900.0
2022-03-09	ABOS	Stock	5.39	6.11	5.38	5.93	185600.0
2022-03-09	ABR	Stock	17.83	17.91	17.46	17.48	1739200.0

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

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