PREVIEW / stock_daily / 2022-06-17

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-17.parquet
  size:    256 KB
  rows:    7,960
  symbols: 2,375

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-06-17	AAPL	Stock	130.07	133.08	129.81	131.56	134520300.0
2022-06-17	MSFT	Stock	244.7	250.5	244.03	247.65	43084800.0
2022-06-17	NVDA	Stock	15.648	15.995	15.328	15.88	630334000.0
2022-06-17	AMZN	Stock	102.8	106.98	102.51	106.22	99772100.0
2022-06-17	GOOGL	Stock	106.0335	108.6995	105.046	107.1435	51376520.0
2022-06-17	META	Stock	161.68	165.9	159.9	163.74	31374200.0
2022-06-17	TSLA	Stock	213.4333	220.97	213.1967	216.76	92641800.0
2022-06-17	TLT	Stock	112.01	112.83	110.96	112.08	21614262.0
2022-06-17	ES	Stock	79.19	79.57	77.07	77.98	3451500.0
2022-06-17	CL	Stock	73.66	74.43	73.01	74.04	11016400.0
2022-06-17	A	Stock	114.77	116.73	112.67	112.71	2681500.0
2022-06-17	AA	Stock	49.47	50.2	47.64	49.28	8593400.0
2022-06-17	AAC-DELISTED	Stock	9.84	9.84	9.81	9.825	546857.0
2022-06-17	AACG	Stock	1.01	1.03	1.01	1.02	7500.0
2022-06-17	AAIC-DELISTED	Stock	2.99	3.13	2.93	3.06	151348.0
2022-06-17	AAIC.C-DELISTED	Stock	22.09	22.79	22.07	22.78	1068.0
2022-06-17	AAL	Stock	12.2	13.07	11.93	12.94	52537800.0
2022-06-17	AAM.A-DELISTED	Stock	23.44	23.87	23.44	23.66	47845.0
2022-06-17	AAM.B-DELISTED	Stock	24.7	25.37	24.39	25.32	150149.0
2022-06-17	AAMC-DELISTED	Stock	2.9647	3.0882	2.8735	3.0882	32994.0
2022-06-17	AAME	Stock	2.72	3.1	2.72	2.91	8000.0
2022-06-17	AAMI	Stock	18.33	18.67	18.25	18.62	918600.0
2022-06-17	AAN-DELISTED	Stock	15.75	16.02	15.45	15.68	664700.0
2022-06-17	AAOI	Stock	1.87	1.96	1.81	1.86	226200.0
2022-06-17	AAON	Stock	34.6267	35.04	33.9667	33.9733	508350.0
2022-06-17	AAP	Stock	165.21	169.58	164.0	167.81	1217900.0
2022-06-17	AAQC-DELISTED	Stock	9.77	9.77	9.76	9.76	1160.0
2022-06-17	AAT	Stock	29.11	29.79	28.78	29.51	503300.0
2022-06-17	AATC	Stock	5.3723	5.39	5.315	5.38	6950.0
2022-06-17	AAU-DELISTED	Stock	0.24	0.2451	0.2323	0.2401	276354.0
2022-06-17	AAUAF-DELISTED	Stock	0.24	0.2451	0.2323	0.24	278710.0
2022-06-17	AAWW-DELISTED	Stock	63.43	63.635	62.11	62.65	493821.0
2022-06-17	AAXJ	Stock	68.27	68.52	67.46	67.96	2793288.0
2022-06-17	AB	Stock	40.19	41.23	40.07	40.07	268300.0
2022-06-17	ABB-DELISTED	Stock	27.01	27.2065	26.62	26.66	4378056.0
2022-06-17	ABBNY-DELISTED	Stock	27.01	27.2065	26.62	26.65	4632638.0
2022-06-17	ABBV	Stock	137.6	139.53	137.19	138.28	10429900.0
2022-06-17	ABC-DELISTED	Stock	141.53	142.76	139.87	140.64	1787789.0
2022-06-17	ABCB	Stock	40.55	40.97	39.74	40.03	750600.0
2022-06-17	ABCL	Stock	9.32	10.45	9.3	10.12	4625200.0
2022-06-17	ABCM-DELISTED	Stock	13.9	14.3	13.84	14.2	128935.0
2022-06-17	ABEO	Stock	4.0	4.25	3.75	4.0	63684.0
2022-06-17	ABEV	Stock	2.46	2.52	2.44	2.49	33630000.0
2022-06-17	ABG	Stock	156.33	164.52	151.56	164.11	543700.0
2022-06-17	ABGI-DELISTED	Stock	9.79	9.79	9.75	9.78	65396.0
2022-06-17	ABM	Stock	38.52	39.53	38.22	39.01	811800.0
2022-06-17	ABMD-DELISTED	Stock	226.59	234.74	226.59	229.68	330904.0
2022-06-17	ABNB	Stock	93.53	100.61	93.53	99.49	11293100.0
2022-06-17	ABOS	Stock	3.24	3.48	3.19	3.3	252100.0
2022-06-17	ABR	Stock	12.35	12.87	12.18	12.86	5817800.0

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

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