PREVIEW / stock_daily / 2022-01-04

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-04.parquet
  size:    261 KB
  rows:    7,998
  symbols: 2,554

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-01-04	AAPL	Stock	182.63	182.94	179.12	179.7	99310400.0
2022-01-04	MSFT	Stock	334.83	335.2	326.12	329.01	32674300.0
2022-01-04	NVDA	Stock	30.277	30.468	28.349	29.29	527154000.0
2022-01-04	AMZN	Stock	170.438	171.4	166.3495	167.522	70726000.0
2022-01-04	GOOGL	Stock	145.396	146.4849	143.7162	144.3995	28399440.0
2022-01-04	META	Stock	339.95	343.09	331.87	336.53	15998000.0
2022-01-04	TSLA	Stock	396.5167	402.6667	374.35	383.1967	100248300.0
2022-01-04	TLT	Stock	143.61	144.13	142.74	143.7	21996350.0
2022-01-04	ES	Stock	88.9	90.33	88.35	88.39	1861700.0
2022-01-04	CL	Stock	84.43	85.29	84.18	84.87	4405100.0
2022-01-04	A	Stock	155.49	155.63	149.7	151.19	2234000.0
2022-01-04	AA	Stock	60.68	61.15	57.21	57.53	7980700.0
2022-01-04	AAC-DELISTED	Stock	9.77	9.78	9.745	9.78	1516401.0
2022-01-04	AACG	Stock	1.25	2.59	1.25	2.55	14934700.0
2022-01-04	AACIW-DELISTED	Stock	0.55485	0.55485	0.55	0.55	1075.0
2022-01-04	AAIC-DELISTED	Stock	3.55	3.61	3.55	3.6	59257.0
2022-01-04	AAIC.C-DELISTED	Stock	25.16	25.2	25.15	25.2	3211.0
2022-01-04	AAL	Stock	19.22	19.46	18.85	19.02	29266600.0
2022-01-04	AAM.A-DELISTED	Stock	25.4	25.58	25.11	25.27	6971.0
2022-01-04	AAM.B-DELISTED	Stock	26.72	26.72	26.15	26.5	10411.0
2022-01-04	AAME	Stock	2.7	2.97	2.49	2.8	93400.0
2022-01-04	AAMI	Stock	25.42	25.725	25.25	25.31	695400.0
2022-01-04	AAN-DELISTED	Stock	25.21	25.55	25.0	25.36	144400.0
2022-01-04	AAOI	Stock	5.3	5.375	5.2	5.29	549400.0
2022-01-04	AAON	Stock	52.1333	53.3333	52.1133	52.6333	536550.0
2022-01-04	AAP	Stock	236.79	240.02	236.52	237.05	736900.0
2022-01-04	AAQC-DELISTED	Stock	9.72	9.72	9.71	9.72	53075.0
2022-01-04	AAT	Stock	38.1	38.86	38.1	38.43	134900.0
2022-01-04	AATC	Stock	6.2811	6.39	6.25	6.39	10667.0
2022-01-04	AAU-DELISTED	Stock	0.3	0.305	0.2951	0.305	324408.0
2022-01-04	AAUAF-DELISTED	Stock	0.3	0.305	0.2951	0.3028	328315.0
2022-01-04	AAWW-DELISTED	Stock	96.24	97.13	94.74	95.8	320925.0
2022-01-04	AAXJ	Stock	83.32	83.43	82.77	82.95	1060557.0
2022-01-04	AB	Stock	48.44	49.06	48.12	48.18	356700.0
2022-01-04	ABB-DELISTED	Stock	38.82	39.105	38.76	39.02	1490470.0
2022-01-04	ABBNY-DELISTED	Stock	38.82	39.105	38.76	39.0	1641934.0
2022-01-04	ABBV	Stock	135.33	136.22	134.38	135.16	6298300.0
2022-01-04	ABC-DELISTED	Stock	132.78	133.28	130.5408	131.4	819393.0
2022-01-04	ABCB	Stock	51.99	52.94	51.75	52.68	439700.0
2022-01-04	ABCL	Stock	14.28	14.28	13.041	13.27	1943100.0
2022-01-04	ABCM-DELISTED	Stock	22.48	22.48	21.75	21.75	78976.0
2022-01-04	ABEO	Stock	9.25	9.75	8.25	8.75	106152.0
2022-01-04	ABEV	Stock	2.66	2.73	2.66	2.71	17761700.0
2022-01-04	ABG	Stock	176.2	181.51	175.96	177.11	234500.0
2022-01-04	ABGI-DELISTED	Stock	9.7702	9.79	9.77	9.78	48323.0
2022-01-04	ABM	Stock	41.12	42.29	41.12	41.85	454200.0
2022-01-04	ABMD-DELISTED	Stock	366.29	368.97	355.45	361.19	193399.0
2022-01-04	ABNB	Stock	174.154	175.9	167.2	170.8	4080000.0
2022-01-04	ABOS	Stock	6.76	6.88	6.3	6.37	221300.0
2022-01-04	ABR	Stock	18.71	18.88	18.62	18.74	1561200.0

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

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