PREVIEW / stock_daily / 2023-06-12

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-12.parquet
  size:    243 KB
  rows:    7,569
  symbols: 1,641

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-12	AAPL	Stock	181.27	183.89	180.97	183.79	54274900.0
2023-06-12	MSFT	Stock	328.58	332.1	325.16	331.85	24260300.0
2023-06-12	NVDA	Stock	39.2	39.53	38.618	39.482	388701000.0
2023-06-12	AMZN	Stock	124.02	126.78	123.53	126.57	51338000.0
2023-06-12	GOOGL	Stock	122.785	124.05	121.66	123.64	28338743.0
2023-06-12	META	Stock	267.17	271.75	265.33	271.05	15442500.0
2023-06-12	TSLA	Stock	247.94	250.97	244.59	249.83	150337900.0
2023-06-12	TLT	Stock	102.24	102.3	101.12	102.22	19024132.0
2023-06-12	ES	Stock	70.57	70.57	69.67	70.23	1834200.0
2023-06-12	CL	Stock	76.19	76.29	75.18	75.72	3374700.0
2023-06-12	A	Stock	115.86	118.65	115.82	118.54	2747800.0
2023-06-12	AA	Stock	34.87	35.679	34.62	34.99	3856900.0
2023-06-12	AAC-DELISTED	Stock	10.51	10.51	10.49	10.5	61203.0
2023-06-12	AACG	Stock	1.27	1.34	1.26	1.26	10400.0
2023-06-12	AACIW-DELISTED	Stock	0.08	0.08	0.06	0.065	1827.0
2023-06-12	AACT	Stock	10.1	10.15	10.1	10.12	603102.0
2023-06-12	AAIC-DELISTED	Stock	4.28	4.39	4.28	4.37	265706.0
2023-06-12	AAIC.C-DELISTED	Stock	22.9	22.9	22.83	22.8999	2363.0
2023-06-12	AAL	Stock	15.74	16.37	15.73	16.02	28381900.0
2023-06-12	AAM.A-DELISTED	Stock	24.11	24.36	23.59	23.65	8234.0
2023-06-12	AAM.B-DELISTED	Stock	23.77	24.26	23.2	23.2	6757.0
2023-06-12	AAMC-DELISTED	Stock	25.0	26.2618	21.8588	21.8853	337008.0
2023-06-12	AAME	Stock	2.16	2.17	2.16	2.17	1300.0
2023-06-12	AAMI	Stock	22.73	22.955	22.35	22.36	165000.0
2023-06-12	AAN-DELISTED	Stock	13.99	14.33	13.59	14.24	270600.0
2023-06-12	AAOI	Stock	3.2	3.36	3.15	3.29	602100.0
2023-06-12	AAON	Stock	63.82	64.02	63.0933	63.4467	261150.0
2023-06-12	AAP	Stock	64.71	67.92	64.2	66.89	4244100.0
2023-06-12	AAT	Stock	19.8	19.98	19.54	19.69	341800.0
2023-06-12	AATC	Stock	4.2428	4.3	4.2428	4.3	914.0
2023-06-12	AAU-DELISTED	Stock	0.125	0.13	0.125	0.1289	186942.0
2023-06-12	AAUAF-DELISTED	Stock	0.125	0.13	0.125	0.1289	186099.0
2023-06-12	AAXJ	Stock	67.24	67.55	67.24	67.47	402533.0
2023-06-12	AB	Stock	34.28	34.32	33.66	33.7	256700.0
2023-06-12	ABBNY-DELISTED	Stock	38.15	38.39	38.0114	38.35	174956.0
2023-06-12	ABBV	Stock	139.58	139.67	136.91	137.73	4888500.0
2023-06-12	ABC-DELISTED	Stock	178.16	179.38	177.22	179.33	574471.0
2023-06-12	ABCB	Stock	35.66	36.32	35.03	35.18	435500.0
2023-06-12	ABCL	Stock	7.12	7.4	7.04	7.4	2451200.0
2023-06-12	ABCM-DELISTED	Stock	17.26	17.9	17.22	17.8	2254933.0
2023-06-12	ABEO	Stock	4.25	4.44	4.1	4.39	383600.0
2023-06-12	ABEV	Stock	3.07	3.1	3.03	3.08	17659300.0
2023-06-12	ABG	Stock	224.5	228.98	223.33	226.73	202400.0
2023-06-12	ABLV	Stock	10.59	10.6	10.59	10.6	2699.0
2023-06-12	ABM	Stock	46.28	46.57	43.32	44.62	1028300.0
2023-06-12	ABNB	Stock	119.365	125.0	118.88	124.59	7876600.0
2023-06-12	ABOS	Stock	4.91	5.2	4.79	5.19	113400.0
2023-06-12	ABR	Stock	14.14	14.27	13.98	14.03	2767600.0
2023-06-12	ABR.D	Stock	18.2991	18.43	18.2991	18.43	1535.0
2023-06-12	ABR.E	Stock	17.69	17.8	17.6	17.65	5863.0

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

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