PREVIEW / stock_daily / 2022-05-09

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-09.parquet
  size:    261 KB
  rows:    8,117
  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-05-09	AAPL	Stock	154.93	155.83	151.49	152.06	131577900.0
2022-05-09	MSFT	Stock	270.06	272.36	263.32	264.58	47726000.0
2022-05-09	NVDA	Stock	18.034	18.255	16.827	16.95	644455000.0
2022-05-09	AMZN	Stock	111.3125	114.0	107.957	108.789	128124000.0
2022-05-09	GOOGL	Stock	113.25	115.0771	112.0005	112.511	40802860.0
2022-05-09	META	Stock	199.84	202.57	195.58	196.21	36303200.0
2022-05-09	TSLA	Stock	278.8167	281.8767	260.3833	262.37	90810300.0
2022-05-09	TLT	Stock	112.86	114.71	112.62	114.67	26773036.0
2022-05-09	ES	Stock	90.3	91.48	89.55	90.54	1595200.0
2022-05-09	CL	Stock	76.35	78.44	76.06	77.67	5666800.0
2022-05-09	A	Stock	119.13	119.13	112.64	113.11	1861700.0
2022-05-09	AA	Stock	58.5	58.573	53.73	54.21	12074900.0
2022-05-09	AAC-DELISTED	Stock	9.82	9.835	9.81	9.81	59597.0
2022-05-09	AACG	Stock	1.14	1.14	1.07	1.07	26800.0
2022-05-09	AACIU	Stock	9.98	9.98	9.98	9.98	400.0
2022-05-09	AACIW-DELISTED	Stock	0.2707	0.2707	0.2707	0.2707	100.0
2022-05-09	AAIC-DELISTED	Stock	3.085	3.1102	3.06	3.08	95457.0
2022-05-09	AAIC.C-DELISTED	Stock	24.4545	24.6	24.45	24.47	2769.0
2022-05-09	AAL	Stock	17.36	17.58	16.21	16.32	37938900.0
2022-05-09	AAM.A-DELISTED	Stock	24.6	24.6	24.1	24.18	17432.0
2022-05-09	AAM.B-DELISTED	Stock	24.95	24.95	24.33	24.4488	28111.0
2022-05-09	AAMC-DELISTED	Stock	2.8706	2.9985	2.8147	2.9407	12182.0
2022-05-09	AAME	Stock	2.92	2.99	2.92	2.92	800.0
2022-05-09	AAMI	Stock	19.8	20.45	19.78	20.02	823500.0
2022-05-09	AAN-DELISTED	Stock	19.9	20.38	19.85	20.09	226500.0
2022-05-09	AAOI	Stock	2.46	2.47	2.01	2.21	456600.0
2022-05-09	AAON	Stock	34.1933	36.3867	32.6667	36.0067	503850.0
2022-05-09	AAP	Stock	200.63	205.43	198.19	202.64	493500.0
2022-05-09	AAQC-DELISTED	Stock	9.7888	9.7888	9.78	9.78	27200.0
2022-05-09	AAT	Stock	34.12	34.21	32.93	33.15	294100.0
2022-05-09	AATC	Stock	6.25	6.25	6.04	6.21	23866.0
2022-05-09	AAU-DELISTED	Stock	0.2916	0.3019	0.27	0.2838	504516.0
2022-05-09	AAUAF-DELISTED	Stock	0.2916	0.3019	0.27	0.2749	511685.0
2022-05-09	AAWW-DELISTED	Stock	70.21	72.51	69.48	69.82	262236.0
2022-05-09	AAXJ	Stock	67.32	67.67	66.425	66.52	1994904.0
2022-05-09	AB	Stock	39.08	39.76	38.5	38.59	507300.0
2022-05-09	ABB-DELISTED	Stock	28.38	28.46	27.845	27.97	2433606.0
2022-05-09	ABBNY-DELISTED	Stock	28.38	28.46	27.845	27.96	2719831.0
2022-05-09	ABBV	Stock	151.62	153.54	148.93	150.96	6969000.0
2022-05-09	ABC-DELISTED	Stock	158.26	159.58	156.61	157.36	1317197.0
2022-05-09	ABCB	Stock	42.4	43.62	42.35	42.89	351700.0
2022-05-09	ABCL	Stock	7.17	7.215	6.49	6.5	2661000.0
2022-05-09	ABCM-DELISTED	Stock	13.4	13.45	12.58	12.68	180374.0
2022-05-09	ABEO	Stock	4.25	4.25	3.75	3.75	67536.0
2022-05-09	ABEV	Stock	2.6	2.67	2.59	2.61	38321400.0
2022-05-09	ABG	Stock	188.75	196.03	186.55	188.98	177600.0
2022-05-09	ABGI-DELISTED	Stock	9.82	9.82	9.8	9.8	35327.0
2022-05-09	ABM	Stock	45.64	46.38	45.36	45.58	493700.0
2022-05-09	ABMD-DELISTED	Stock	253.45	253.87	232.47	234.22	326664.0
2022-05-09	ABNB	Stock	131.76	131.885	118.83	119.37	14430900.0

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

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