PREVIEW / stock_daily / 2022-08-08

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-08.parquet
  size:    256 KB
  rows:    7,939
  symbols: 2,295

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-08	AAPL	Stock	166.37	167.81	164.2	164.87	60276900.0
2022-08-08	MSFT	Stock	284.05	285.92	279.32	280.32	18739200.0
2022-08-08	NVDA	Stock	17.502	18.239	17.242	17.793	981859000.0
2022-08-08	AMZN	Stock	142.05	144.23	138.29	139.41	52229000.0
2022-08-08	GOOGL	Stock	118.39	120.15	116.88	117.3	19169479.0
2022-08-08	META	Stock	168.0	177.51	167.13	170.25	27299100.0
2022-08-08	TSLA	Stock	295.0	305.2	289.0867	290.4233	98994000.0
2022-08-08	TLT	Stock	117.64	118.53	117.56	118.35	17477736.0
2022-08-08	ES	Stock	91.04	91.8	90.51	90.93	1391200.0
2022-08-08	CL	Stock	80.74	81.02	80.44	80.81	5039700.0
2022-08-08	A	Stock	134.2	134.42	132.14	132.52	1257100.0
2022-08-08	AA	Stock	49.65	50.4	48.47	48.65	4228800.0
2022-08-08	AAC-DELISTED	Stock	9.89	9.89	9.87	9.88	63086.0
2022-08-08	AACG	Stock	1.93	1.94	1.82	1.85	36800.0
2022-08-08	AACIW-DELISTED	Stock	0.1898	0.25	0.17	0.17	6257.0
2022-08-08	AAIC-DELISTED	Stock	3.15	3.31	3.15	3.3	66839.0
2022-08-08	AAIC.C-DELISTED	Stock	20.62	20.7	20.62	20.7	1100.0
2022-08-08	AAL	Stock	14.87	15.28	14.82	15.02	23643500.0
2022-08-08	AAM.A-DELISTED	Stock	25.39	25.445	25.32	25.33	9015.0
2022-08-08	AAM.B-DELISTED	Stock	26.29	26.29	25.75	25.78	12833.0
2022-08-08	AAMC-DELISTED	Stock	6.1618	7.5735	6.1618	7.4706	322031.0
2022-08-08	AAME	Stock	3.0	3.0	2.81	2.93	2000.0
2022-08-08	AAMI	Stock	18.86	19.14	18.82	19.01	135200.0
2022-08-08	AAN-DELISTED	Stock	13.64	15.1	13.38	14.6	401200.0
2022-08-08	AAOI	Stock	1.87	1.99	1.861	1.92	201500.0
2022-08-08	AAON	Stock	41.0667	42.1067	40.9	41.1867	229950.0
2022-08-08	AAP	Stock	194.64	197.0	193.88	194.29	492600.0
2022-08-08	AAQC-DELISTED	Stock	9.82	9.82	9.82	9.82	6024.0
2022-08-08	AAT	Stock	29.67	30.02	29.51	29.61	211000.0
2022-08-08	AATC	Stock	5.14	5.14	5.0	5.03	13373.0
2022-08-08	AAU-DELISTED	Stock	0.2484	0.2499	0.2354	0.2473	210006.0
2022-08-08	AAUAF-DELISTED	Stock	0.2484	0.2499	0.2354	0.2407	226592.0
2022-08-08	AAWW-DELISTED	Stock	99.65	99.99	99.6	99.98	1656142.0
2022-08-08	AAXJ	Stock	68.13	68.435	67.85	67.94	582792.0
2022-08-08	AB	Stock	44.17	44.6	43.42	44.22	264000.0
2022-08-08	ABB-DELISTED	Stock	29.9	30.09	29.605	29.71	1190176.0
2022-08-08	ABBNY-DELISTED	Stock	29.9	30.09	29.605	29.71	1332284.0
2022-08-08	ABBV	Stock	138.04	140.8	137.77	140.34	4854600.0
2022-08-08	ABC-DELISTED	Stock	141.55	142.28	140.36	140.57	767855.0
2022-08-08	ABCB	Stock	47.25	47.89	46.92	47.18	209500.0
2022-08-08	ABCL	Stock	11.65	11.92	11.045	11.76	3015900.0
2022-08-08	ABCM-DELISTED	Stock	15.06	15.17	14.82	14.94	132981.0
2022-08-08	ABEO	Stock	4.25	4.39	3.97	4.02	349000.0
2022-08-08	ABEV	Stock	2.81	2.86	2.79	2.85	22449600.0
2022-08-08	ABG	Stock	179.63	185.44	178.08	180.61	99800.0
2022-08-08	ABGI-DELISTED	Stock	9.85	9.85	9.85	9.85	710.0
2022-08-08	ABM	Stock	44.65	45.37	44.43	44.7	234600.0
2022-08-08	ABMD-DELISTED	Stock	291.16	295.87	290.93	293.95	73178.0
2022-08-08	ABNB	Stock	118.155	119.64	115.43	115.82	5382900.0
2022-08-08	ABOS	Stock	5.3	5.558	5.05	5.27	33800.0

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

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