PREVIEW / stock_daily / 2022-01-18

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-18.parquet
  size:    262 KB
  rows:    8,076
  symbols: 2,616

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-18	AAPL	Stock	171.51	172.54	169.41	169.8	90956700.0
2022-01-18	MSFT	Stock	304.07	309.8	301.74	302.65	42333200.0
2022-01-18	NVDA	Stock	26.26	26.638	25.77	25.903	424270000.0
2022-01-18	AMZN	Stock	159.105	159.7345	157.6645	158.9175	67292000.0
2022-01-18	GOOGL	Stock	136.175	137.1315	135.4382	135.998	34888100.0
2022-01-18	META	Stock	323.29	324.21	317.64	318.15	22645600.0
2022-01-18	TSLA	Stock	342.2033	356.93	338.6867	343.5033	66743400.0
2022-01-18	TLT	Stock	140.96	141.31	140.02	140.1	21173750.0
2022-01-18	ES	Stock	86.85	87.1	84.92	86.8	1538200.0
2022-01-18	CL	Stock	82.78	83.17	81.98	83.12	6746200.0
2022-01-18	A	Stock	142.42	143.24	140.34	140.47	1907400.0
2022-01-18	AA	Stock	60.5	61.56	58.8	60.05	5991100.0
2022-01-18	AAC-DELISTED	Stock	9.73	9.75	9.7	9.73	213176.0
2022-01-18	AACG	Stock	1.82	1.89	1.7	1.76	184400.0
2022-01-18	AACIU	Stock	9.98	10.18	9.98	10.06	14762.0
2022-01-18	AACIW-DELISTED	Stock	0.4801	0.4803	0.48	0.4803	1525.0
2022-01-18	AAIC-DELISTED	Stock	3.53	3.586	3.52	3.52	36239.0
2022-01-18	AAL	Stock	18.23	18.61	17.77	17.9	39736900.0
2022-01-18	AAM.A-DELISTED	Stock	25.39	25.54	25.37	25.45	18327.0
2022-01-18	AAM.B-DELISTED	Stock	26.53	26.63	26.22	26.5	32133.0
2022-01-18	AAME	Stock	2.4	2.74	2.38	2.51	47400.0
2022-01-18	AAMI	Stock	24.08	24.11	23.59	23.87	498400.0
2022-01-18	AAN-DELISTED	Stock	22.76	23.005	21.96	22.01	202000.0
2022-01-18	AAOI	Stock	4.08	4.15	3.96	3.97	470200.0
2022-01-18	AAON	Stock	47.0533	47.4733	45.8333	45.8667	271050.0
2022-01-18	AAP	Stock	238.17	239.42	234.37	237.91	1077300.0
2022-01-18	AAQC-DELISTED	Stock	9.71	9.71	9.69	9.69	245192.0
2022-01-18	AAT	Stock	38.76	38.95	38.37	38.51	248800.0
2022-01-18	AATC	Stock	6.31	6.31	6.15	6.29	13567.0
2022-01-18	AAU-DELISTED	Stock	0.2707	0.2925	0.2707	0.29	592590.0
2022-01-18	AAUAF-DELISTED	Stock	0.2707	0.2925	0.2707	0.2828	598308.0
2022-01-18	AAWW-DELISTED	Stock	81.165	81.96	80.03	81.4	383440.0
2022-01-18	AAXJ	Stock	82.86	83.48	82.86	83.03	1062894.0
2022-01-18	AB	Stock	50.39	51.5	49.95	50.51	306100.0
2022-01-18	ABB-DELISTED	Stock	36.72	36.76	36.455	36.61	1472479.0
2022-01-18	ABBNY-DELISTED	Stock	36.72	36.76	36.455	36.62	1651022.0
2022-01-18	ABBV	Stock	135.51	137.98	135.28	136.78	12341900.0
2022-01-18	ABC-DELISTED	Stock	135.93	135.95	132.8	133.79	654328.0
2022-01-18	ABCB	Stock	55.27	55.5	54.01	54.12	371500.0
2022-01-18	ABCL	Stock	9.96	10.03	9.6	9.71	3792800.0
2022-01-18	ABCM-DELISTED	Stock	17.83	17.87	17.5	17.68	218599.0
2022-01-18	ABEO	Stock	6.5	6.75	6.5	6.5	117548.0
2022-01-18	ABEV	Stock	2.64	2.65	2.6	2.61	17332700.0
2022-01-18	ABG	Stock	167.21	172.31	165.6	168.27	205700.0
2022-01-18	ABGI-DELISTED	Stock	9.73	9.73	9.72	9.72	75454.0
2022-01-18	ABM	Stock	44.96	45.17	43.26	43.32	385700.0
2022-01-18	ABMD-DELISTED	Stock	296.38	296.38	287.15	292.82	244430.0
2022-01-18	ABNB	Stock	156.91	160.79	153.87	154.69	5775400.0
2022-01-18	ABOS	Stock	5.27	5.8	5.04	5.04	126000.0
2022-01-18	ABR	Stock	18.38	18.49	18.22	18.25	1034400.0

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

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