PREVIEW / stock_daily / 2022-01-05

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-05.parquet
  size:    262 KB
  rows:    8,048
  symbols: 2,598

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-05	AAPL	Stock	179.61	180.17	174.64	174.92	94537600.0
2022-01-05	MSFT	Stock	325.86	326.07	315.98	316.38	40054300.0
2022-01-05	NVDA	Stock	28.949	29.416	27.533	27.604	498064000.0
2022-01-05	AMZN	Stock	166.883	167.1265	164.357	164.357	64302000.0
2022-01-05	GOOGL	Stock	144.42	144.4994	137.688	137.775	54618280.0
2022-01-05	META	Stock	333.02	335.76	323.84	324.17	20564500.0
2022-01-05	TSLA	Stock	382.2167	390.1133	360.3367	362.7067	80119800.0
2022-01-05	TLT	Stock	144.14	144.16	142.71	142.92	20911677.0
2022-01-05	ES	Stock	88.16	90.39	88.16	89.23	1180200.0
2022-01-05	CL	Stock	84.71	85.61	84.71	85.22	4445900.0
2022-01-05	A	Stock	150.83	153.1	148.53	148.6	2370500.0
2022-01-05	AA	Stock	58.95	61.79	58.445	58.55	7599800.0
2022-01-05	AAC-DELISTED	Stock	9.75	9.79	9.75	9.79	89502.0
2022-01-05	AACG	Stock	1.8	2.64	1.72	2.3	8067400.0
2022-01-05	AACIU	Stock	10.087	10.087	10.087	10.087	110.0
2022-01-05	AACIW-DELISTED	Stock	0.5501	0.5501	0.55	0.55	1350.0
2022-01-05	AAIC-DELISTED	Stock	3.58	3.635	3.53	3.53	75969.0
2022-01-05	AAIC.C-DELISTED	Stock	25.2	25.2	25.13	25.17	4902.0
2022-01-05	AAL	Stock	19.13	19.39	18.51	18.68	34447900.0
2022-01-05	AAM.A-DELISTED	Stock	25.52	25.52	25.27	25.28	14203.0
2022-01-05	AAM.B-DELISTED	Stock	26.5	26.68	26.02	26.47	12643.0
2022-01-05	AAME	Stock	2.9	3.1	2.7	2.98	52200.0
2022-01-05	AAMI	Stock	25.41	25.44	24.3	24.3	590400.0
2022-01-05	AAN-DELISTED	Stock	25.45	25.96	24.091	24.29	239600.0
2022-01-05	AAOI	Stock	5.26	5.34	5.01	5.03	465100.0
2022-01-05	AAON	Stock	52.68	52.68	50.4933	50.5533	184200.0
2022-01-05	AAP	Stock	237.45	244.55	236.35	236.45	711700.0
2022-01-05	AAQC-DELISTED	Stock	9.72	9.79	9.71	9.76	234974.0
2022-01-05	AAT	Stock	38.39	38.72	37.9	38.04	166900.0
2022-01-05	AATC	Stock	6.37	6.39	6.25	6.31	18005.0
2022-01-05	AAU-DELISTED	Stock	0.3014	0.31	0.297	0.2986	222774.0
2022-01-05	AAUAF-DELISTED	Stock	0.3014	0.31	0.297	0.2986	226610.0
2022-01-05	AAWW-DELISTED	Stock	95.76	97.0	91.47	91.54	531193.0
2022-01-05	AAXJ	Stock	82.29	82.93	81.55	81.57	1613234.0
2022-01-05	AB	Stock	48.12	48.62	46.65	46.82	369100.0
2022-01-05	ABB-DELISTED	Stock	38.94	39.11	38.42	38.43	1233779.0
2022-01-05	ABBNY-DELISTED	Stock	38.94	39.11	38.42	38.43	1583151.0
2022-01-05	ABBV	Stock	135.0	138.15	135.0	135.87	7724900.0
2022-01-05	ABC-DELISTED	Stock	131.69	135.1	131.69	132.5	660838.0
2022-01-05	ABCB	Stock	53.05	53.67	52.14	52.22	290200.0
2022-01-05	ABCL	Stock	13.32	13.56	12.23	12.26	1952100.0
2022-01-05	ABCM-DELISTED	Stock	21.96	22.05	21.43	21.53	67740.0
2022-01-05	ABEO	Stock	8.75	9.0	8.0	8.0	94492.0
2022-01-05	ABEV	Stock	2.67	2.71	2.62	2.63	20800300.0
2022-01-05	ABG	Stock	178.79	179.45	171.8	172.02	205500.0
2022-01-05	ABGI-DELISTED	Stock	9.77	9.78	9.75	9.78	27122.0
2022-01-05	ABM	Stock	41.85	43.12	41.47	42.76	547400.0
2022-01-05	ABMD-DELISTED	Stock	359.43	364.105	337.48	337.74	211873.0
2022-01-05	ABNB	Stock	169.883	175.107	162.24	162.25	4804600.0
2022-01-05	ABOS	Stock	6.36	6.57	6.0	6.01	198000.0

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

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