PREVIEW / stock_daily / 2023-06-07

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-07.parquet
  size:    243 KB
  rows:    7,517
  symbols: 1,603

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
2023-06-07	AAPL	Stock	178.44	181.21	177.32	177.82	61944600.0
2023-06-07	MSFT	Stock	331.65	334.49	322.5	323.38	40717100.0
2023-06-07	NVDA	Stock	38.915	39.499	37.356	37.475	511998000.0
2023-06-07	AMZN	Stock	127.01	127.37	120.63	121.23	95663300.0
2023-06-07	GOOGL	Stock	126.97	129.04	122.12	122.5	52538986.0
2023-06-07	META	Stock	271.67	274.25	262.8	263.6	26163600.0
2023-06-07	TSLA	Stock	228.0	230.83	223.2	224.57	185710800.0
2023-06-07	TLT	Stock	102.17	102.43	100.78	100.88	25251099.0
2023-06-07	ES	Stock	70.06	72.0	69.2	71.73	2659900.0
2023-06-07	CL	Stock	75.22	75.43	74.43	75.2	3879600.0
2023-06-07	A	Stock	117.17	117.37	115.14	116.59	3643500.0
2023-06-07	AA	Stock	34.93	36.34	34.55	35.35	5266200.0
2023-06-07	AAC-DELISTED	Stock	10.5	10.5	10.4827	10.5	63855.0
2023-06-07	AACG	Stock	1.41	1.41	1.35	1.35	9000.0
2023-06-07	AACIW-DELISTED	Stock	0.07	0.0802	0.0127	0.0799	17667.0
2023-06-07	AAIC-DELISTED	Stock	4.25	4.32	4.24	4.29	300915.0
2023-06-07	AAIC.C-DELISTED	Stock	22.3	22.9	22.3	22.8569	4620.0
2023-06-07	AAL	Stock	15.0	15.27	14.9	15.16	19871400.0
2023-06-07	AAM.A-DELISTED	Stock	24.03	24.23	24.03	24.035	19808.0
2023-06-07	AAM.B-DELISTED	Stock	24.5	24.6999	24.41	24.6	7520.0
2023-06-07	AAMC-DELISTED	Stock	27.0588	28.1765	27.0544	27.2353	39573.0
2023-06-07	AAME	Stock	2.16	2.17	2.15	2.17	1300.0
2023-06-07	AAMI	Stock	22.54	23.02	22.3	22.84	243900.0
2023-06-07	AAN-DELISTED	Stock	14.01	14.875	13.904	14.63	400700.0
2023-06-07	AAOI	Stock	2.76	2.78	2.639	2.72	400300.0
2023-06-07	AAON	Stock	62.0333	64.0667	62.0333	63.72	381900.0
2023-06-07	AAP	Stock	66.62	66.69	65.35	65.54	3613500.0
2023-06-07	AAT	Stock	19.49	20.53	19.46	20.38	549600.0
2023-06-07	AATC	Stock	4.265	4.32	4.265	4.32	2095.0
2023-06-07	AAU-DELISTED	Stock	0.1252	0.1283	0.1225	0.1255	145611.0
2023-06-07	AAUAF-DELISTED	Stock	0.1252	0.1283	0.1225	0.1226	149107.0
2023-06-07	AAXJ	Stock	66.78	67.24	66.47	66.59	318200.0
2023-06-07	AB	Stock	34.89	35.05	34.44	34.59	191200.0
2023-06-07	ABBNY-DELISTED	Stock	37.51	37.65	37.31	37.34	528640.0
2023-06-07	ABBV	Stock	134.9	137.06	134.26	136.5	4645200.0
2023-06-07	ABC-DELISTED	Stock	174.1	175.41	173.02	173.58	627882.0
2023-06-07	ABCB	Stock	36.2	37.18	35.71	36.75	591600.0
2023-06-07	ABCL	Stock	6.97	7.4	6.94	7.31	4583500.0
2023-06-07	ABCM-DELISTED	Stock	17.21	17.49	16.74	16.87	1159642.0
2023-06-07	ABEO	Stock	4.01	4.19	3.9	4.0	74700.0
2023-06-07	ABEV	Stock	3.0	3.03	2.96	2.99	13914600.0
2023-06-07	ABG	Stock	223.41	230.91	222.29	230.1	297300.0
2023-06-07	ABM	Stock	48.54	49.26	47.93	48.15	584000.0
2023-06-07	ABNB	Stock	118.14	120.16	115.92	116.55	4637600.0
2023-06-07	ABOS	Stock	5.22	5.28	5.02	5.02	77000.0
2023-06-07	ABR	Stock	13.98	14.22	13.9	14.19	3135200.0
2023-06-07	ABR.D	Stock	18.44	18.49	18.1593	18.47	5346.0
2023-06-07	ABR.E	Stock	18.0	18.05	17.8	17.96	11922.0
2023-06-07	ABR.F	Stock	18.99	19.07	18.69	18.76	28315.0
2023-06-07	ABSI	Stock	1.78	1.885	1.78	1.81	544900.0

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

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