PREVIEW / stock_daily / 2023-07-10

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-10.parquet
  size:    240 KB
  rows:    7,490
  symbols: 1,544

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-07-10	AAPL	Stock	189.26	189.99	187.04	188.61	59922200.0
2023-07-10	MSFT	Stock	334.6	335.23	327.59	331.83	32791400.0
2023-07-10	NVDA	Stock	42.657	42.811	41.649	42.18	353908000.0
2023-07-10	AMZN	Stock	129.07	129.28	125.92	127.13	61889300.0
2023-07-10	GOOGL	Stock	118.3	118.305	116.135	116.45	35315235.0
2023-07-10	META	Stock	295.55	298.13	287.05	294.1	37058300.0
2023-07-10	TSLA	Stock	276.47	277.52	265.1	269.61	119425400.0
2023-07-10	TLT	Stock	98.86	99.53	98.85	99.21	24665198.0
2023-07-10	ES	Stock	70.64	70.95	69.7	70.38	1310100.0
2023-07-10	CL	Stock	75.79	76.51	75.58	75.89	3724900.0
2023-07-10	A	Stock	116.73	119.52	116.56	118.36	1889200.0
2023-07-10	AA	Stock	33.7	34.57	33.6	34.14	3891400.0
2023-07-10	AAC-DELISTED	Stock	10.56	10.57	10.56	10.57	238856.0
2023-07-10	AACG	Stock	1.35	1.41	1.35	1.41	3200.0
2023-07-10	AACIW-DELISTED	Stock	0.0652	0.075	0.0638	0.065	1186.0
2023-07-10	AACT	Stock	10.15	10.17	10.15	10.15	57500.0
2023-07-10	AAIC-DELISTED	Stock	4.51	4.6	4.49	4.585	350603.0
2023-07-10	AAIC.C-DELISTED	Stock	22.95	23.0002	22.925	22.95	1869.0
2023-07-10	AAL	Stock	18.32	18.72	18.29	18.57	21371900.0
2023-07-10	AAM.A-DELISTED	Stock	22.72	22.91	22.72	22.78	9865.0
2023-07-10	AAM.B-DELISTED	Stock	22.55	22.89	22.55	22.82	11431.0
2023-07-10	AAMC-DELISTED	Stock	33.2353	34.9706	31.6765	33.1794	54230.0
2023-07-10	AAME	Stock	1.92	1.96	1.9	1.9	8200.0
2023-07-10	AAMI	Stock	19.91	20.3	19.885	20.15	225300.0
2023-07-10	AAN-DELISTED	Stock	14.53	14.73	13.07	13.78	611100.0
2023-07-10	AAOI	Stock	7.4	8.37	7.31	8.34	4763200.0
2023-07-10	AAON	Stock	63.08	64.2133	62.64	63.4533	317550.0
2023-07-10	AAP	Stock	67.15	70.04	66.9	68.8	2981600.0
2023-07-10	AAT	Stock	19.7	20.01	19.6	19.96	267500.0
2023-07-10	AATC	Stock	4.4175	4.44	4.36	4.36	8316.0
2023-07-10	AAU-DELISTED	Stock	0.13	0.1449	0.13	0.1365	510490.0
2023-07-10	AAUAF-DELISTED	Stock	0.13	0.1449	0.13	0.1365	491635.0
2023-07-10	AAXJ	Stock	65.7	66.23	65.69	66.16	2025961.0
2023-07-10	AB	Stock	31.36	31.84	31.29	31.68	682300.0
2023-07-10	ABBNY-DELISTED	Stock	37.49	37.89	37.49	37.8	133640.0
2023-07-10	ABBV	Stock	135.41	136.09	134.06	134.49	5153300.0
2023-07-10	ABC-DELISTED	Stock	191.42	192.9	191.05	192.83	613176.0
2023-07-10	ABCB	Stock	34.13	35.35	33.94	34.48	269500.0
2023-07-10	ABCL	Stock	6.53	6.895	6.49	6.79	1653600.0
2023-07-10	ABCM-DELISTED	Stock	24.51	24.67	24.16	24.29	890188.0
2023-07-10	ABEO	Stock	4.09	4.16	4.02	4.06	150300.0
2023-07-10	ABEV	Stock	3.12	3.14	3.03	3.05	13328300.0
2023-07-10	ABG	Stock	242.75	248.0	241.1	243.11	351100.0
2023-07-10	ABLLW	Stock	0.2999	0.3713	0.28	0.295	168173.0
2023-07-10	ABLV	Stock	10.61	10.61	10.61	10.61	6167.0
2023-07-10	ABM	Stock	41.56	42.15	41.49	41.8	603000.0
2023-07-10	ABNB	Stock	130.18	133.339	129.61	131.71	4052000.0
2023-07-10	ABOS	Stock	5.09	5.16	4.88	4.96	279200.0
2023-07-10	ABR	Stock	14.7	15.33	14.67	15.29	3390200.0
2023-07-10	ABR.D	Stock	18.6	18.65	18.5	18.56	21181.0

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

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