PREVIEW / stock_daily / 2022-08-30

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-30.parquet
  size:    251 KB
  rows:    7,832
  symbols: 2,186

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-30	AAPL	Stock	162.13	162.56	157.72	158.91	77906200.0
2022-08-30	MSFT	Stock	266.67	267.05	260.66	262.97	22767100.0
2022-08-30	NVDA	Stock	15.96	16.039	15.182	15.468	530181000.0
2022-08-30	AMZN	Stock	131.25	132.07	126.85	128.73	49203000.0
2022-08-30	GOOGL	Stock	110.17	110.5	107.8	108.94	27513255.0
2022-08-30	META	Stock	160.35	161.66	155.91	157.16	19567900.0
2022-08-30	TSLA	Stock	287.87	288.48	272.65	277.7	50541800.0
2022-08-30	TLT	Stock	112.62	113.51	112.21	112.96	14346559.0
2022-08-30	ES	Stock	91.61	92.07	90.4	90.77	1210000.0
2022-08-30	CL	Stock	79.75	79.97	78.8	79.0	3095500.0
2022-08-30	A	Stock	128.51	129.02	127.16	128.28	1772400.0
2022-08-30	AA	Stock	54.89	54.89	50.03	50.79	7757500.0
2022-08-30	AAC-DELISTED	Stock	9.91	9.91	9.89	9.91	103436.0
2022-08-30	AACG	Stock	2.48	2.57	2.48	2.54	13500.0
2022-08-30	AACIW-DELISTED	Stock	0.1886	0.1889	0.13305	0.1599	1634.0
2022-08-30	AAIC-DELISTED	Stock	3.22	3.24	3.21	3.22	33185.0
2022-08-30	AAIC.C-DELISTED	Stock	21.95	22.09	21.4	21.93	5846.0
2022-08-30	AAL	Stock	13.61	13.68	13.2	13.33	25076800.0
2022-08-30	AAM.A-DELISTED	Stock	25.21	25.21	24.72	25.06	13656.0
2022-08-30	AAM.B-DELISTED	Stock	25.3	25.74	24.94	25.0	7248.0
2022-08-30	AAMC-DELISTED	Stock	5.2943	5.7794	5.2943	5.5059	30138.0
2022-08-30	AAME	Stock	3.07	3.07	3.07	3.07	600.0
2022-08-30	AAMI	Stock	17.65	17.93	17.44	17.84	217600.0
2022-08-30	AAN-DELISTED	Stock	13.13	13.13	12.51	12.7	213500.0
2022-08-30	AAOI	Stock	2.46	2.46	2.35	2.4	70600.0
2022-08-30	AAON	Stock	39.1733	39.3933	38.2667	38.6	161400.0
2022-08-30	AAP	Stock	171.0	171.45	168.04	170.47	892800.0
2022-08-30	AAQC-DELISTED	Stock	9.81	9.82	9.81	9.81	10700.0
2022-08-30	AAT	Stock	28.56	28.7	28.09	28.14	218900.0
2022-08-30	AATC	Stock	5.3	5.3	5.2	5.212	11500.0
2022-08-30	AAU-DELISTED	Stock	0.24	0.2407	0.2272	0.2332	164968.0
2022-08-30	AAUAF-DELISTED	Stock	0.24	0.2407	0.2272	0.2332	175721.0
2022-08-30	AAWW-DELISTED	Stock	99.82	100.07	99.52	99.81	585615.0
2022-08-30	AAXJ	Stock	67.21	67.26	66.13	66.34	703511.0
2022-08-30	AB	Stock	43.88	43.93	42.85	43.88	187300.0
2022-08-30	ABB-DELISTED	Stock	28.58	28.61	27.92	27.99	1284357.0
2022-08-30	ABBNY-DELISTED	Stock	28.58	28.61	27.92	27.97	1446049.0
2022-08-30	ABBV	Stock	135.14	136.49	134.89	135.55	4337100.0
2022-08-30	ABC-DELISTED	Stock	146.88	147.765	145.15	145.44	527081.0
2022-08-30	ABCB	Stock	47.07	47.22	46.59	47.02	171500.0
2022-08-30	ABCL	Stock	10.83	10.86	10.35	10.66	1591200.0
2022-08-30	ABCM-DELISTED	Stock	15.29	15.34	14.885	14.975	164855.0
2022-08-30	ABEO	Stock	4.08	4.08	3.77	3.83	106400.0
2022-08-30	ABEV	Stock	3.05	3.07	2.95	2.95	28691100.0
2022-08-30	ABG	Stock	185.0	185.0	179.98	180.43	72500.0
2022-08-30	ABGI-DELISTED	Stock	9.87	9.88	9.86	9.88	21445.0
2022-08-30	ABM	Stock	46.53	46.61	45.74	45.88	123200.0
2022-08-30	ABMD-DELISTED	Stock	260.17	265.59	256.6	258.52	96595.0
2022-08-30	ABNB	Stock	114.5	116.02	110.44	112.56	4507200.0
2022-08-30	ABOS	Stock	5.335	5.4	5.23	5.25	20500.0

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

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