PREVIEW / stock_daily / 2022-12-07

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-07.parquet
  size:    248 KB
  rows:    7,688
  symbols: 2,013

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-07	AAPL	Stock	142.19	143.37	140.0	140.94	69721100.0
2022-12-07	MSFT	Stock	244.83	246.16	242.21	244.37	20481500.0
2022-12-07	NVDA	Stock	15.772	16.186	15.667	16.12	372388000.0
2022-12-07	AMZN	Stock	88.34	89.89	87.48	88.46	68086900.0
2022-12-07	GOOGL	Stock	96.41	96.8811	94.715	94.94	31045449.0
2022-12-07	META	Stock	113.76	115.88	112.88	113.93	29461100.0
2022-12-07	TSLA	Stock	175.03	179.38	172.22	174.04	84213300.0
2022-12-07	TLT	Stock	108.37	109.68	108.2	109.47	30546679.0
2022-12-07	ES	Stock	84.28	84.54	83.23	83.76	1991400.0
2022-12-07	CL	Stock	77.26	77.68	77.0	77.55	4032600.0
2022-12-07	A	Stock	151.23	154.35	151.13	153.73	1011100.0
2022-12-07	AA	Stock	47.58	48.64	46.57	46.6	3152400.0
2022-12-07	AAC-DELISTED	Stock	10.07	10.08	10.05	10.06	928146.0
2022-12-07	AACG	Stock	1.47	1.73	1.41	1.41	4800.0
2022-12-07	AACIW-DELISTED	Stock	0.025	0.025	0.025	0.025	50000.0
2022-12-07	AAIC-DELISTED	Stock	2.95	3.01	2.95	3.01	30512.0
2022-12-07	AAL	Stock	14.24	14.24	13.53	13.55	28161400.0
2022-12-07	AAM.A-DELISTED	Stock	23.8969	24.14	23.63	24.0	11784.0
2022-12-07	AAM.B-DELISTED	Stock	24.76	25.1318	24.6	25.1	5496.0
2022-12-07	AAMC-DELISTED	Stock	7.2647	7.2647	6.7794	6.8235	34173.0
2022-12-07	AAME	Stock	2.73	2.73	2.7	2.7	700.0
2022-12-07	AAMI	Stock	20.22	20.305	19.61	19.65	106200.0
2022-12-07	AAN-DELISTED	Stock	12.17	12.225	11.94	12.01	201100.0
2022-12-07	AAOI	Stock	2.1	2.17	2.05	2.1	178800.0
2022-12-07	AAON	Stock	51.5667	52.5733	51.0467	52.1133	260700.0
2022-12-07	AAP	Stock	145.15	148.14	144.75	146.65	1516900.0
2022-12-07	AAQC-DELISTED	Stock	10.075	10.08	10.075	10.075	220282.0
2022-12-07	AAT	Stock	26.77	27.5	26.77	26.98	227800.0
2022-12-07	AATC	Stock	5.14	5.1995	5.05	5.05	14782.0
2022-12-07	AAU-DELISTED	Stock	0.2394	0.2468	0.235	0.2455	454726.0
2022-12-07	AAUAF-DELISTED	Stock	0.2394	0.2468	0.235	0.24	448328.0
2022-12-07	AAWW-DELISTED	Stock	100.31	100.784	100.305	100.71	102406.0
2022-12-07	AAXJ	Stock	65.71	65.99	65.5	65.84	1160874.0
2022-12-07	AB	Stock	38.61	39.38	38.41	39.36	484100.0
2022-12-07	ABB-DELISTED	Stock	30.91	31.06	30.785	30.91	726854.0
2022-12-07	ABBNY-DELISTED	Stock	30.91	31.06	30.785	30.9	844420.0
2022-12-07	ABBV	Stock	163.69	165.53	163.26	165.4	4637800.0
2022-12-07	ABC-DELISTED	Stock	170.01	171.78	169.76	170.29	751325.0
2022-12-07	ABCB	Stock	50.07	50.76	49.72	50.36	221900.0
2022-12-07	ABCL	Stock	11.38	11.47	11.08	11.14	2655500.0
2022-12-07	ABCM-DELISTED	Stock	15.34	15.66	15.26	15.44	276613.0
2022-12-07	ABEO	Stock	3.44	3.5	3.18	3.24	351700.0
2022-12-07	ABEV	Stock	3.03	3.06	3.01	3.03	8996800.0
2022-12-07	ABG	Stock	179.84	183.07	178.77	178.96	111200.0
2022-12-07	ABGI-DELISTED	Stock	10.05	10.06	10.05	10.05	8234.0
2022-12-07	ABLV	Stock	10.1499	10.1499	10.1499	10.1499	141.0
2022-12-07	ABM	Stock	45.6	45.96	45.27	45.46	283000.0
2022-12-07	ABMD-DELISTED	Stock	377.41	378.09	377.25	377.76	762322.0
2022-12-07	ABNB	Stock	88.805	91.67	86.88	91.5	12640500.0
2022-12-07	ABOS	Stock	5.41	5.41	5.28	5.33	144300.0

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

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