PREVIEW / stock_daily / 2022-11-28

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-28.parquet
  size:    251 KB
  rows:    7,852
  symbols: 2,093

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-11-28	AAPL	Stock	145.14	146.64	143.38	144.22	69246000.0
2022-11-28	MSFT	Stock	246.08	246.65	240.8	241.76	24778200.0
2022-11-28	NVDA	Stock	16.026	16.357	15.725	15.827	303741000.0
2022-11-28	AMZN	Stock	93.93	96.4	93.43	93.95	74943100.0
2022-11-28	GOOGL	Stock	97.0363	97.58	95.61	96.05	26252433.0
2022-11-28	META	Stock	110.78	112.04	108.38	108.78	23309400.0
2022-11-28	TSLA	Stock	179.96	188.5	179.0	182.92	92905200.0
2022-11-28	TLT	Stock	103.61	103.805	102.685	103.19	14569219.0
2022-11-28	ES	Stock	81.93	82.44	81.25	81.72	1263700.0
2022-11-28	CL	Stock	76.54	76.97	76.25	76.38	2511800.0
2022-11-28	A	Stock	155.87	156.85	151.73	152.3	1386300.0
2022-11-28	AA	Stock	46.92	47.34	45.57	46.43	4803700.0
2022-11-28	AAC-DELISTED	Stock	10.0	10.005	10.0	10.0	19373.0
2022-11-28	AACG	Stock	1.72	1.82	1.72	1.76	1600.0
2022-11-28	AACIW-DELISTED	Stock	0.1	0.1	0.08	0.08	11000.0
2022-11-28	AAIC-DELISTED	Stock	3.05	3.11	3.04	3.07	30519.0
2022-11-28	AAIC.C-DELISTED	Stock	21.7	21.7	21.63	21.7	1355.0
2022-11-28	AAL	Stock	14.34	14.44	13.82	13.83	21313800.0
2022-11-28	AAM.A-DELISTED	Stock	24.37	24.37	24.21	24.29	9774.0
2022-11-28	AAM.B-DELISTED	Stock	23.82	24.43	23.82	24.21	7624.0
2022-11-28	AAMC-DELISTED	Stock	5.8824	6.4559	5.8824	6.1765	33174.0
2022-11-28	AAME	Stock	2.89	2.89	2.77	2.82	1700.0
2022-11-28	AAMI	Stock	19.76	19.76	19.34	19.4	128600.0
2022-11-28	AAN-DELISTED	Stock	11.51	11.91	11.34	11.6	295300.0
2022-11-28	AAOI	Stock	2.18	2.24	2.1	2.11	148100.0
2022-11-28	AAON	Stock	52.04	52.04	50.1267	50.32	252900.0
2022-11-28	AAP	Stock	149.2	152.16	148.67	150.62	1074600.0
2022-11-28	AAQC-DELISTED	Stock	10.03	10.035	10.03	10.03	11239.0
2022-11-28	AAT	Stock	28.23	28.27	27.77	28.02	470000.0
2022-11-28	AATC	Stock	4.9226	4.983	4.82	4.85	29976.0
2022-11-28	AAU-DELISTED	Stock	0.24	0.2496	0.2316	0.2316	204700.0
2022-11-28	AAUAF-DELISTED	Stock	0.24	0.2496	0.2316	0.2316	208188.0
2022-11-28	AAWW-DELISTED	Stock	100.66	100.83	100.39	100.67	180903.0
2022-11-28	AAXJ	Stock	62.79	63.575	62.79	62.88	530721.0
2022-11-28	AB	Stock	40.54	41.1	39.82	40.01	214300.0
2022-11-28	ABB-DELISTED	Stock	31.39	31.47	30.865	30.925	915216.0
2022-11-28	ABBNY-DELISTED	Stock	31.39	31.47	30.865	30.92	1026960.0
2022-11-28	ABBV	Stock	160.0	160.73	157.83	158.43	3902800.0
2022-11-28	ABC-DELISTED	Stock	167.13	168.6	166.9	167.1	1118386.0
2022-11-28	ABCB	Stock	52.78	53.27	51.64	52.07	271300.0
2022-11-28	ABCL	Stock	13.5	13.73	13.36	13.56	1245500.0
2022-11-28	ABCM-DELISTED	Stock	17.21	17.63	16.72	16.91	314629.0
2022-11-28	ABEO	Stock	3.88	4.04	3.81	3.86	259000.0
2022-11-28	ABEV	Stock	2.93	2.95	2.91	2.93	13677400.0
2022-11-28	ABG	Stock	181.24	181.82	179.06	180.44	111700.0
2022-11-28	ABGI-DELISTED	Stock	10.01	10.01	10.01	10.01	86282.0
2022-11-28	ABLV	Stock	10.11	10.11	10.11	10.11	1042.0
2022-11-28	ABM	Stock	44.99	46.0	44.99	45.31	268900.0
2022-11-28	ABMD-DELISTED	Stock	377.51	378.18	377.005	377.28	567359.0
2022-11-28	ABNB	Stock	97.0	98.32	94.81	95.3	5133900.0

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

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