PREVIEW / stock_daily / 2022-07-28

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-28.parquet
  size:    253 KB
  rows:    7,916
  symbols: 2,282

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-07-28	AAPL	Stock	156.98	157.64	154.41	157.35	81378700.0
2022-07-28	MSFT	Stock	269.75	277.84	267.87	276.41	33459300.0
2022-07-28	NVDA	Stock	17.975	18.14	17.44	17.984	474646000.0
2022-07-28	AMZN	Stock	121.57	122.84	118.08	122.28	82245500.0
2022-07-28	GOOGL	Stock	112.37	114.34	111.46	114.22	32816568.0
2022-07-28	META	Stock	161.06	161.51	154.85	160.72	73214300.0
2022-07-28	TSLA	Stock	280.0667	283.3	272.8	280.9	84723000.0
2022-07-28	TLT	Stock	118.045	118.92	117.32	117.75	16637914.0
2022-07-28	ES	Stock	85.98	88.35	85.63	88.26	1401000.0
2022-07-28	CL	Stock	79.03	79.7	78.51	79.19	5078100.0
2022-07-28	A	Stock	128.17	131.82	126.78	131.11	1861400.0
2022-07-28	AA	Stock	48.29	49.22	46.63	49.08	5081000.0
2022-07-28	AAC-DELISTED	Stock	9.86	9.88	9.86	9.86	497665.0
2022-07-28	AACG	Stock	1.59	1.63	1.55	1.55	18400.0
2022-07-28	AAIC-DELISTED	Stock	3.19	3.24	3.15	3.23	44094.0
2022-07-28	AAIC.C-DELISTED	Stock	20.4	20.7	20.4	20.42	1484.0
2022-07-28	AAL	Stock	13.69	14.04	13.29	13.76	35834400.0
2022-07-28	AAM.A-DELISTED	Stock	25.0	25.34	25.0	25.32	11562.0
2022-07-28	AAM.B-DELISTED	Stock	25.24	25.96	25.2006	25.96	13091.0
2022-07-28	AAMC-DELISTED	Stock	5.2353	5.6853	5.0612	5.2971	69860.0
2022-07-28	AAME	Stock	2.76	2.83	2.6	2.83	7600.0
2022-07-28	AAMI	Stock	19.0	19.25	18.3	19.02	201800.0
2022-07-28	AAN-DELISTED	Stock	12.64	13.02	11.98	12.84	1011500.0
2022-07-28	AAOI	Stock	1.74	1.821	1.68	1.71	120300.0
2022-07-28	AAON	Stock	38.6333	39.4333	38.2267	39.34	135300.0
2022-07-28	AAP	Stock	185.33	191.44	182.57	191.03	774900.0
2022-07-28	AAQC-DELISTED	Stock	9.83	9.83	9.81	9.81	1200.0
2022-07-28	AAT	Stock	29.98	30.32	29.89	30.27	201200.0
2022-07-28	AATC	Stock	5.19	5.19	5.05	5.115	8703.0
2022-07-28	AAU-DELISTED	Stock	0.221	0.2317	0.2202	0.2301	283553.0
2022-07-28	AAUAF-DELISTED	Stock	0.221	0.2317	0.2202	0.2301	299488.0
2022-07-28	AAWW-DELISTED	Stock	71.67	73.54	71.19	73.2	403141.0
2022-07-28	AAXJ	Stock	68.49	68.65	67.73	68.55	758859.0
2022-07-28	AB	Stock	42.17	42.85	41.5	42.52	311500.0
2022-07-28	ABB-DELISTED	Stock	29.22	29.575	29.13	29.54	1944739.0
2022-07-28	ABBNY-DELISTED	Stock	29.22	29.575	29.13	29.55	2158594.0
2022-07-28	ABBV	Stock	151.44	152.41	146.62	149.75	6572300.0
2022-07-28	ABC-DELISTED	Stock	144.89	146.04	143.19	145.53	376912.0
2022-07-28	ABCB	Stock	45.55	46.39	45.15	46.35	511900.0
2022-07-28	ABCL	Stock	10.56	10.64	10.2	10.43	946500.0
2022-07-28	ABCM-DELISTED	Stock	14.77	15.295	14.72	15.04	259139.0
2022-07-28	ABEO	Stock	3.91	4.27	3.91	4.14	112300.0
2022-07-28	ABEV	Stock	2.87	2.9	2.78	2.88	41008300.0
2022-07-28	ABG	Stock	165.16	172.07	159.05	171.96	252700.0
2022-07-28	ABGI-DELISTED	Stock	9.84	9.84	9.84	9.84	270.0
2022-07-28	ABM	Stock	43.77	44.61	43.67	44.46	198900.0
2022-07-28	ABMD-DELISTED	Stock	287.05	292.6	280.4367	292.19	88331.0
2022-07-28	ABNB	Stock	108.17	110.06	104.68	108.84	4471900.0
2022-07-28	ABOS	Stock	5.75	5.97	5.46	5.53	26200.0
2022-07-28	ABR	Stock	15.95	16.44	15.95	16.42	2402100.0

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

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