PREVIEW / stock_daily / 2023-06-14

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-14.parquet
  size:    243 KB
  rows:    7,545
  symbols: 1,616

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-14	AAPL	Stock	183.37	184.39	182.02	183.95	57462900.0
2023-06-14	MSFT	Stock	334.34	339.04	332.81	337.34	26003800.0
2023-06-14	NVDA	Stock	40.824	43.0	40.552	42.997	740465000.0
2023-06-14	AMZN	Stock	126.7	126.95	124.12	126.42	52422500.0
2023-06-14	GOOGL	Stock	123.1	124.05	121.45	123.67	30592297.0
2023-06-14	META	Stock	271.89	274.99	268.32	273.35	19175100.0
2023-06-14	TSLA	Stock	260.17	261.57	250.5	256.79	170575500.0
2023-06-14	TLT	Stock	101.63	102.29	101.46	102.02	29094244.0
2023-06-14	ES	Stock	70.36	71.04	69.81	69.9	1660500.0
2023-06-14	CL	Stock	75.23	75.82	74.99	75.42	2979000.0
2023-06-14	A	Stock	119.99	120.97	118.9	119.4	2662900.0
2023-06-14	AA	Stock	37.74	37.74	35.66	36.13	4615100.0
2023-06-14	AAC-DELISTED	Stock	10.5	10.51	10.49	10.5	19346.0
2023-06-14	AACG	Stock	1.29	1.36	1.29	1.32	14700.0
2023-06-14	AACIW-DELISTED	Stock	0.0718	0.08	0.0718	0.08	958.0
2023-06-14	AACT	Stock	10.11	10.13	10.095	10.0998	143889.0
2023-06-14	AAIC-DELISTED	Stock	4.4	4.43	4.34	4.37	238847.0
2023-06-14	AAIC.C-DELISTED	Stock	22.889	22.9	22.76	22.9	2650.0
2023-06-14	AAL	Stock	16.4	16.7	16.32	16.59	22866000.0
2023-06-14	AAM.A-DELISTED	Stock	23.45	23.8127	23.03	23.03	33847.0
2023-06-14	AAM.B-DELISTED	Stock	23.2	23.75	22.68	22.71	31176.0
2023-06-14	AAMC-DELISTED	Stock	18.8265	19.4124	13.2353	16.7647	662497.0
2023-06-14	AAME	Stock	2.19	2.19	2.19	2.19	300.0
2023-06-14	AAMI	Stock	22.64	23.009	22.45	22.68	309400.0
2023-06-14	AAN-DELISTED	Stock	14.15	14.23	13.13	13.16	359900.0
2023-06-14	AAOI	Stock	3.7	4.11	3.65	3.76	2136200.0
2023-06-14	AAON	Stock	64.7333	65.02	62.76	63.0667	453150.0
2023-06-14	AAP	Stock	69.24	70.94	69.04	70.2	4784800.0
2023-06-14	AAT	Stock	19.75	19.98	19.34	19.49	319400.0
2023-06-14	AATC	Stock	4.2	4.29	4.175	4.29	2511.0
2023-06-14	AAU-DELISTED	Stock	0.128	0.1295	0.128	0.128	121325.0
2023-06-14	AAUAF-DELISTED	Stock	0.128	0.1295	0.128	0.128	124325.0
2023-06-14	AAXJ	Stock	68.04	68.76	68.04	68.61	548497.0
2023-06-14	AB	Stock	34.15	34.5	33.77	33.98	160100.0
2023-06-14	ABBNY-DELISTED	Stock	39.31	39.5	39.04	39.27	386169.0
2023-06-14	ABBV	Stock	138.81	139.27	136.08	136.23	6128300.0
2023-06-14	ABC-DELISTED	Stock	179.17	180.29	177.16	179.01	777766.0
2023-06-14	ABCB	Stock	36.1	36.44	34.55	34.91	453100.0
2023-06-14	ABCL	Stock	7.5	7.58	7.3	7.39	2462300.0
2023-06-14	ABCM-DELISTED	Stock	19.0	19.14	18.67	18.85	2248560.0
2023-06-14	ABEO	Stock	4.62	4.75	4.45	4.62	179600.0
2023-06-14	ABEV	Stock	3.12	3.16	3.07	3.14	17622200.0
2023-06-14	ABG	Stock	227.95	230.06	219.5	221.84	289600.0
2023-06-14	ABLV	Stock	10.6	10.6	10.6	10.6	101.0
2023-06-14	ABM	Stock	43.68	44.07	42.77	43.01	548300.0
2023-06-14	ABNB	Stock	125.39	126.386	122.765	125.14	5696700.0
2023-06-14	ABOS	Stock	6.0	6.13	5.62	5.91	215100.0
2023-06-14	ABR	Stock	14.24	14.38	14.04	14.12	3013800.0
2023-06-14	ABR.D	Stock	18.55	18.55	17.91	18.24	12506.0
2023-06-14	ABR.E	Stock	17.8601	18.01	17.7031	17.7031	4317.0

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

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