PREVIEW / stock_daily / 2022-08-29

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-29.parquet
  size:    251 KB
  rows:    7,835
  symbols: 2,216

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-29	AAPL	Stock	161.15	162.9	159.82	161.38	73314000.0
2022-08-29	MSFT	Stock	265.85	267.4	263.85	265.23	20338500.0
2022-08-29	NVDA	Stock	16.02	16.338	15.767	15.801	496132000.0
2022-08-29	AMZN	Stock	129.9	131.95	128.77	129.79	48101600.0
2022-08-29	GOOGL	Stock	109.99	110.95	108.8	109.42	21191157.0
2022-08-29	META	Stock	160.66	163.05	159.01	159.17	20052700.0
2022-08-29	TSLA	Stock	282.83	287.74	280.7	284.82	41864700.0
2022-08-29	TLT	Stock	112.94	113.01	112.1324	112.68	14278261.0
2022-08-29	ES	Stock	91.28	92.73	90.67	91.89	1099900.0
2022-08-29	CL	Stock	78.97	79.86	78.44	79.59	2273600.0
2022-08-29	A	Stock	128.43	129.35	127.18	128.11	926000.0
2022-08-29	AA	Stock	55.17	56.884	54.67	55.5	5515800.0
2022-08-29	AAC-DELISTED	Stock	9.91	9.915	9.89	9.9	589668.0
2022-08-29	AACG	Stock	2.41	2.55	2.4	2.45	13700.0
2022-08-29	AAIC-DELISTED	Stock	3.23	3.27	3.2117	3.25	36942.0
2022-08-29	AAIC.C-DELISTED	Stock	21.87	21.87	21.7	21.7	1941.0
2022-08-29	AAL	Stock	13.51	13.71	13.45	13.51	21391200.0
2022-08-29	AAM.A-DELISTED	Stock	25.1	25.3789	25.1	25.18	2554.0
2022-08-29	AAM.B-DELISTED	Stock	25.7383	26.28	25.24	25.3	12296.0
2022-08-29	AAMC-DELISTED	Stock	6.2	6.2	5.1765	5.35	71023.0
2022-08-29	AAME	Stock	3.0	3.09	2.93	2.93	15400.0
2022-08-29	AAMI	Stock	18.02	18.03	17.7	17.75	103700.0
2022-08-29	AAN-DELISTED	Stock	12.66	13.07	12.6	12.98	305000.0
2022-08-29	AAOI	Stock	2.5	2.55	2.41	2.44	154500.0
2022-08-29	AAON	Stock	39.1733	39.5933	38.74	39.12	157800.0
2022-08-29	AAP	Stock	171.69	173.1	169.25	170.54	1006400.0
2022-08-29	AAQC-DELISTED	Stock	9.82	9.82	9.82	9.82	300.0
2022-08-29	AAT	Stock	29.24	29.25	28.43	28.45	273500.0
2022-08-29	AATC	Stock	5.3	5.3	5.22	5.25	14230.0
2022-08-29	AAU-DELISTED	Stock	0.2282	0.2388	0.2282	0.2379	125034.0
2022-08-29	AAUAF-DELISTED	Stock	0.2282	0.2388	0.2282	0.2379	127124.0
2022-08-29	AAWW-DELISTED	Stock	99.87	99.97	99.635	99.71	1000503.0
2022-08-29	AAXJ	Stock	67.16	67.55	66.94	66.94	547947.0
2022-08-29	AB	Stock	43.01	43.75	42.88	43.56	264500.0
2022-08-29	ABB-DELISTED	Stock	28.19	28.495	28.16	28.34	1098975.0
2022-08-29	ABBNY-DELISTED	Stock	28.19	28.495	28.16	28.33	1232835.0
2022-08-29	ABBV	Stock	136.2	136.72	134.76	135.71	3835800.0
2022-08-29	ABC-DELISTED	Stock	145.01	148.7889	144.4	147.51	523244.0
2022-08-29	ABCB	Stock	47.91	47.97	47.03	47.07	178900.0
2022-08-29	ABCL	Stock	11.07	11.35	10.59	10.63	1643400.0
2022-08-29	ABCM-DELISTED	Stock	15.13	15.23	14.85	15.0	106080.0
2022-08-29	ABEO	Stock	4.0	4.25	4.0	4.08	75300.0
2022-08-29	ABEV	Stock	3.02	3.08	3.01	3.04	23343700.0
2022-08-29	ABG	Stock	181.96	185.35	180.66	184.27	95700.0
2022-08-29	ABGI-DELISTED	Stock	9.875	9.875	9.875	9.875	679.0
2022-08-29	ABM	Stock	46.57	46.88	46.07	46.61	122800.0
2022-08-29	ABMD-DELISTED	Stock	255.95	259.15	255.32	257.06	124999.0
2022-08-29	ABNB	Stock	111.77	115.8	111.53	113.54	4620600.0
2022-08-29	ABOS	Stock	5.51	5.52	5.23	5.25	10700.0
2022-08-29	ABR	Stock	15.1	15.39	14.98	15.26	1629800.0

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

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