PREVIEW / stock_daily / 2022-06-29

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-29.parquet
  size:    251 KB
  rows:    7,825
  symbols: 2,254

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-29	AAPL	Stock	137.46	140.67	136.67	139.23	66242400.0
2022-06-29	MSFT	Stock	257.59	261.97	255.76	260.26	20069800.0
2022-06-29	NVDA	Stock	15.814	15.82	15.17	15.542	482352000.0
2022-06-29	AMZN	Stock	107.38	110.99	106.91	108.92	66375300.0
2022-06-29	GOOGL	Stock	111.552	113.1602	110.8725	111.7015	24716820.0
2022-06-29	META	Stock	163.57	166.33	160.32	163.94	28595200.0
2022-06-29	TSLA	Stock	230.5	231.1733	222.2733	228.49	82897200.0
2022-06-29	TLT	Stock	112.38	113.9	112.17	113.87	12925357.0
2022-06-29	ES	Stock	83.72	84.01	83.19	83.48	1576400.0
2022-06-29	CL	Stock	79.22	79.99	78.98	79.67	2156900.0
2022-06-29	A	Stock	117.19	118.54	116.24	117.9	906600.0
2022-06-29	AA	Stock	49.74	49.75	46.88	47.62	4292100.0
2022-06-29	AAC-DELISTED	Stock	9.84	9.845	9.84	9.845	3007.0
2022-06-29	AACG	Stock	1.14	1.14	1.05	1.05	17900.0
2022-06-29	AACIW-DELISTED	Stock	0.2798	0.2798	0.2798	0.2798	101.0
2022-06-29	AAIC-DELISTED	Stock	3.18	3.24	3.175	3.24	24036.0
2022-06-29	AAL	Stock	13.23	13.24	12.77	13.03	34351000.0
2022-06-29	AAM.A-DELISTED	Stock	24.02	24.3	23.72	24.3	28490.0
2022-06-29	AAM.B-DELISTED	Stock	25.1	25.25	24.85	25.18	3738.0
2022-06-29	AAMC-DELISTED	Stock	3.0882	3.0882	2.5441	2.9412	71635.0
2022-06-29	AAME	Stock	2.64	2.74	2.6	2.62	5300.0
2022-06-29	AAMI	Stock	19.17	19.17	18.49	18.57	359800.0
2022-06-29	AAN-DELISTED	Stock	15.08	15.08	14.455	14.79	448200.0
2022-06-29	AAOI	Stock	1.75	1.75	1.65	1.66	116300.0
2022-06-29	AAON	Stock	34.94	35.1133	34.3667	35.0533	140100.0
2022-06-29	AAP	Stock	179.7	180.1	175.67	176.72	992600.0
2022-06-29	AAQC-DELISTED	Stock	9.81	9.81	9.8	9.8	600.0
2022-06-29	AAT	Stock	29.87	29.93	29.44	29.72	130100.0
2022-06-29	AATC	Stock	5.3	5.3558	5.3	5.3558	1657.0
2022-06-29	AAU-DELISTED	Stock	0.235	0.2466	0.2301	0.2301	199571.0
2022-06-29	AAUAF-DELISTED	Stock	0.235	0.2466	0.2301	0.235	201806.0
2022-06-29	AAWW-DELISTED	Stock	64.56	64.795	62.4	62.76	271108.0
2022-06-29	AAXJ	Stock	69.3	69.56	69.1	69.37	633784.0
2022-06-29	AB	Stock	42.51	43.03	41.35	41.78	365300.0
2022-06-29	ABB-DELISTED	Stock	27.07	27.1	26.82	26.88	2263397.0
2022-06-29	ABBNY-DELISTED	Stock	27.07	27.1	26.82	26.88	2584576.0
2022-06-29	ABBV	Stock	153.9	156.62	153.35	154.14	6140900.0
2022-06-29	ABC-DELISTED	Stock	143.89	144.45	142.84	143.57	863816.0
2022-06-29	ABCB	Stock	40.85	40.85	39.65	40.2	356500.0
2022-06-29	ABCL	Stock	10.17	10.41	9.855	10.11	3132500.0
2022-06-29	ABCM-DELISTED	Stock	14.48	14.54	14.31	14.39	61586.0
2022-06-29	ABEO	Stock	4.75	5.25	4.5	5.0	92404.0
2022-06-29	ABEV	Stock	2.53	2.6	2.5	2.58	95793400.0
2022-06-29	ABG	Stock	174.22	174.9	171.1	174.27	135700.0
2022-06-29	ABGI-DELISTED	Stock	9.8	9.8	9.8	9.8	301.0
2022-06-29	ABM	Stock	43.03	43.1	42.03	42.42	278500.0
2022-06-29	ABMD-DELISTED	Stock	248.0	257.5	243.78	256.68	199119.0
2022-06-29	ABNB	Stock	96.83	97.0	92.05	93.93	6522600.0
2022-06-29	ABOS	Stock	4.4	5.025	4.34	4.88	239700.0
2022-06-29	ABR	Stock	13.29	13.34	13.14	13.27	1693800.0

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

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