PREVIEW / stock_daily / 2022-08-11

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-11.parquet
  size:    255 KB
  rows:    7,923
  symbols: 2,274

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-08-11	AAPL	Stock	170.06	170.99	168.19	168.49	57149200.0
2022-08-11	MSFT	Stock	290.85	291.21	286.51	287.02	20065900.0
2022-08-11	NVDA	Stock	18.131	18.707	17.876	17.942	509327000.0
2022-08-11	AMZN	Stock	143.86	144.49	139.76	140.64	44867300.0
2022-08-11	GOOGL	Stock	121.28	121.49	118.56	118.84	24293654.0
2022-08-11	META	Stock	179.71	183.1	176.37	177.49	24079100.0
2022-08-11	TSLA	Stock	296.5133	298.2367	285.8333	286.63	70155000.0
2022-08-11	TLT	Stock	116.87	117.06	114.09	114.39	20663783.0
2022-08-11	ES	Stock	91.61	92.45	90.95	91.61	1418600.0
2022-08-11	CL	Stock	80.3	80.62	79.35	79.5	4932800.0
2022-08-11	A	Stock	132.91	135.13	131.59	131.95	1162500.0
2022-08-11	AA	Stock	54.27	55.63	53.12	53.27	4924500.0
2022-08-11	AAC-DELISTED	Stock	9.89	9.89	9.87	9.88	148932.0
2022-08-11	AACG	Stock	1.94	2.03	1.84	1.91	88300.0
2022-08-11	AACIW-DELISTED	Stock	0.1545	0.1545	0.1545	0.1545	207.0
2022-08-11	AAIC-DELISTED	Stock	3.39	3.4499	3.38	3.38	92305.0
2022-08-11	AAIC.C-DELISTED	Stock	21.2888	21.2888	21.08	21.165	1595.0
2022-08-11	AAL	Stock	15.4	15.46	14.9	14.99	32357500.0
2022-08-11	AAM.A-DELISTED	Stock	25.36	25.65	25.27	25.29	11875.0
2022-08-11	AAM.B-DELISTED	Stock	25.71	25.71	25.39	25.39	3038.0
2022-08-11	AAMC-DELISTED	Stock	7.5618	7.5618	5.6441	5.7265	77976.0
2022-08-11	AAME	Stock	2.93	3.1	2.93	2.96	3300.0
2022-08-11	AAMI	Stock	19.31	19.45	19.14	19.35	192200.0
2022-08-11	AAN-DELISTED	Stock	14.67	15.09	14.43	14.55	209700.0
2022-08-11	AAOI	Stock	2.15	2.26	2.11	2.2	303500.0
2022-08-11	AAON	Stock	41.2667	41.5867	40.5533	40.7	296850.0
2022-08-11	AAP	Stock	196.79	197.97	196.06	197.42	374700.0
2022-08-11	AAQC-DELISTED	Stock	9.82	9.82	9.82	9.82	32111.0
2022-08-11	AAT	Stock	30.4	30.45	30.04	30.18	195500.0
2022-08-11	AATC	Stock	5.12	5.12	4.99	5.02	13269.0
2022-08-11	AAU-DELISTED	Stock	0.244	0.244	0.231	0.2411	279255.0
2022-08-11	AAUAF-DELISTED	Stock	0.244	0.244	0.231	0.2411	285884.0
2022-08-11	AAWW-DELISTED	Stock	100.79	101.2	99.99	100.18	838018.0
2022-08-11	AAXJ	Stock	68.93	69.59	68.57	68.67	599125.0
2022-08-11	AB	Stock	44.44	45.16	44.13	44.32	248600.0
2022-08-11	ABB-DELISTED	Stock	30.68	30.77	30.47	30.52	1153733.0
2022-08-11	ABBNY-DELISTED	Stock	30.68	30.77	30.47	30.51	1343978.0
2022-08-11	ABBV	Stock	140.23	142.87	139.66	142.08	5972800.0
2022-08-11	ABC-DELISTED	Stock	144.8	148.31	144.07	148.19	704529.0
2022-08-11	ABCB	Stock	48.37	48.99	48.23	48.93	156500.0
2022-08-11	ABCL	Stock	13.35	14.5	12.96	13.36	4235400.0
2022-08-11	ABCM-DELISTED	Stock	15.26	15.57	15.22	15.35	117447.0
2022-08-11	ABEO	Stock	3.97	5.29	3.97	4.66	1479200.0
2022-08-11	ABEV	Stock	2.94	2.96	2.87	2.9	20368900.0
2022-08-11	ABG	Stock	184.98	186.69	180.89	182.15	165900.0
2022-08-11	ABGI-DELISTED	Stock	9.84	9.85	9.84	9.85	200.0
2022-08-11	ABM	Stock	45.69	46.1	45.59	45.79	214200.0
2022-08-11	ABMD-DELISTED	Stock	295.85	301.23	289.5401	290.99	85382.0
2022-08-11	ABNB	Stock	121.3	127.09	120.96	121.5	8110100.0
2022-08-11	ABOS	Stock	5.31	5.45	5.15	5.29	34800.0

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

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