PREVIEW / stock_daily / 2022-12-01

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-01.parquet
  size:    251 KB
  rows:    7,813
  symbols: 2,065

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-12-01	AAPL	Stock	148.21	149.13	146.61	148.31	71250400.0
2022-12-01	MSFT	Stock	253.87	256.12	250.92	254.69	26041500.0
2022-12-01	NVDA	Stock	16.999	17.265	16.635	17.135	470977000.0
2022-12-01	AMZN	Stock	96.99	97.23	94.92	95.5	68488000.0
2022-12-01	GOOGL	Stock	101.02	102.25	100.25	100.99	28687096.0
2022-12-01	META	Stock	119.2	121.2	118.4	120.44	36551400.0
2022-12-01	TSLA	Stock	197.08	198.92	191.8	194.7	80046200.0
2022-12-01	TLT	Stock	103.15	105.81	103.1	105.76	53156786.0
2022-12-01	ES	Stock	83.8	85.68	83.23	83.91	2415000.0
2022-12-01	CL	Stock	77.77	78.45	77.68	77.75	3507100.0
2022-12-01	A	Stock	156.73	156.99	154.42	156.12	1372400.0
2022-12-01	AA	Stock	50.04	50.77	48.85	49.1	3848400.0
2022-12-01	AAC-DELISTED	Stock	10.02	10.035	10.02	10.03	85808.0
2022-12-01	AACG	Stock	1.72	1.83	1.57	1.62	12500.0
2022-12-01	AACIW-DELISTED	Stock	0.023	0.0252	0.02	0.02	242830.0
2022-12-01	AAIC-DELISTED	Stock	3.0733	3.097	3.06	3.09	76355.0
2022-12-01	AAL	Stock	14.46	14.57	13.93	13.98	26519600.0
2022-12-01	AAM.A-DELISTED	Stock	24.49	24.79	24.2672	24.4893	33927.0
2022-12-01	AAM.B-DELISTED	Stock	24.9	25.32	24.66	25.32	24460.0
2022-12-01	AAMC-DELISTED	Stock	5.5441	5.7941	5.4324	5.5882	13501.0
2022-12-01	AAME	Stock	2.87	2.95	2.87	2.95	1300.0
2022-12-01	AAMI	Stock	20.53	20.9	20.37	20.72	154100.0
2022-12-01	AAN-DELISTED	Stock	12.16	12.4	12.02	12.22	401800.0
2022-12-01	AAOI	Stock	2.18	2.33	2.121	2.23	75400.0
2022-12-01	AAON	Stock	53.0667	53.36	51.9533	52.4067	254550.0
2022-12-01	AAP	Stock	151.8	152.94	149.57	151.3	931900.0
2022-12-01	AAQC-DELISTED	Stock	10.065	10.07	10.06	10.065	186343.0
2022-12-01	AAT	Stock	29.43	29.67	28.19	28.4	421400.0
2022-12-01	AATC	Stock	5.0	5.0	4.9	4.95	5656.0
2022-12-01	AAU-DELISTED	Stock	0.2499	0.2499	0.24	0.2451	247284.0
2022-12-01	AAUAF-DELISTED	Stock	0.2499	0.2499	0.24	0.245	248767.0
2022-12-01	AAWW-DELISTED	Stock	100.77	100.92	100.22	100.5	158349.0
2022-12-01	AAXJ	Stock	66.86	67.12	66.4	66.64	760934.0
2022-12-01	AB	Stock	40.21	40.82	40.05	40.7	343700.0
2022-12-01	ABB-DELISTED	Stock	31.45	31.605	31.155	31.555	1141591.0
2022-12-01	ABBNY-DELISTED	Stock	31.45	31.605	31.155	31.56	1271488.0
2022-12-01	ABBV	Stock	161.0	163.2	159.98	161.63	5827800.0
2022-12-01	ABC-DELISTED	Stock	170.99	172.17	169.79	171.64	752946.0
2022-12-01	ABCB	Stock	53.02	53.02	52.01	52.65	263500.0
2022-12-01	ABCL	Stock	12.77	13.78	12.76	13.18	2009800.0
2022-12-01	ABCM-DELISTED	Stock	16.39	16.905	16.29	16.75	444214.0
2022-12-01	ABEO	Stock	3.66	3.95	3.66	3.88	231900.0
2022-12-01	ABEV	Stock	3.04	3.09	3.03	3.08	39390300.0
2022-12-01	ABG	Stock	187.62	189.66	181.25	182.74	119600.0
2022-12-01	ABGI-DELISTED	Stock	10.02	10.04	10.02	10.04	135551.0
2022-12-01	ABM	Stock	47.48	47.61	46.75	46.88	178400.0
2022-12-01	ABMD-DELISTED	Stock	377.85	377.95	376.5608	377.56	423934.0
2022-12-01	ABNB	Stock	101.49	102.76	99.55	101.27	5040300.0
2022-12-01	ABOS	Stock	5.72	6.0	5.67	5.82	147000.0
2022-12-01	ABR	Stock	14.98	15.23	14.78	14.81	1698300.0

> showing 50 of 7,813 rows — these rows as CSV

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