PREVIEW / stock_daily / 2023-05-02

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-02.parquet
  size:    242 KB
  rows:    7,547
  symbols: 1,651

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-05-02	AAPL	Stock	170.09	170.35	167.54	168.54	48425700.0
2023-05-02	MSFT	Stock	307.76	309.18	303.91	305.41	26404400.0
2023-05-02	NVDA	Stock	28.68	28.836	28.083	28.21	402730000.0
2023-05-02	AMZN	Stock	101.47	103.9	101.15	103.63	73469400.0
2023-05-02	GOOGL	Stock	107.14	107.2	103.71	105.32	30997245.0
2023-05-02	META	Stock	243.18	244.92	238.99	239.24	24350100.0
2023-05-02	TSLA	Stock	161.88	165.49	158.93	160.31	128259700.0
2023-05-02	TLT	Stock	104.0	105.7	103.89	105.7	30057756.0
2023-05-02	ES	Stock	77.59	77.71	76.16	76.44	1555600.0
2023-05-02	CL	Stock	80.8	81.06	80.26	80.85	5963300.0
2023-05-02	A	Stock	135.02	137.16	134.26	134.52	1629600.0
2023-05-02	AA	Stock	36.46	36.72	35.14	35.68	3927200.0
2023-05-02	AAC-DELISTED	Stock	10.38	10.38	10.37	10.37	47177.0
2023-05-02	AACG	Stock	1.94	2.07	1.8	1.88	74900.0
2023-05-02	AACIW-DELISTED	Stock	0.0888	0.11	0.0601	0.1	2114.0
2023-05-02	AAIC-DELISTED	Stock	2.6	2.6	2.55	2.59	44445.0
2023-05-02	AAIC.C-DELISTED	Stock	21.0	21.0	20.85	21.0	2699.0
2023-05-02	AAL	Stock	13.83	13.87	13.52	13.77	22469800.0
2023-05-02	AAM.A-DELISTED	Stock	24.5	24.64	24.385	24.53	19114.0
2023-05-02	AAM.B-DELISTED	Stock	25.02	25.22	24.8101	24.86	18696.0
2023-05-02	AAMC-DELISTED	Stock	25.5191	26.7912	25.0	26.5324	44914.0
2023-05-02	AAME	Stock	2.2	2.2	2.2	2.2	500.0
2023-05-02	AAMI	Stock	22.05	22.71	21.52	21.99	161400.0
2023-05-02	AAN-DELISTED	Stock	13.17	13.17	12.07	12.24	417900.0
2023-05-02	AAOI	Stock	1.82	1.87	1.8	1.85	75100.0
2023-05-02	AAON	Stock	65.34	65.7067	64.42	65.4267	407550.0
2023-05-02	AAP	Stock	125.78	125.78	121.68	124.12	858300.0
2023-05-02	AAT	Stock	17.77	17.85	17.06	17.71	719100.0
2023-05-02	AATC	Stock	3.92	3.92	3.81	3.86	14068.0
2023-05-02	AAU-DELISTED	Stock	0.128	0.128	0.1161	0.1201	694767.0
2023-05-02	AAUAF-DELISTED	Stock	0.128	0.128	0.1161	0.12	679286.0
2023-05-02	AAXJ	Stock	66.24	66.25	65.66	65.84	338205.0
2023-05-02	AB	Stock	34.31	34.51	33.67	33.7	310000.0
2023-05-02	ABB-DELISTED	Stock	35.78	36.04	35.57	36.01	1302192.0
2023-05-02	ABBNY-DELISTED	Stock	35.78	36.04	35.57	36.01	1461769.0
2023-05-02	ABBV	Stock	153.55	155.02	151.2	151.62	5135600.0
2023-05-02	ABC-DELISTED	Stock	168.5	171.09	166.44	169.19	1219867.0
2023-05-02	ABCB	Stock	32.49	32.49	29.91	30.73	633400.0
2023-05-02	ABCL	Stock	6.75	6.76	6.405	6.46	1955000.0
2023-05-02	ABCM-DELISTED	Stock	17.21	18.07	17.21	17.47	730313.0
2023-05-02	ABEO	Stock	3.17	3.31	3.16	3.28	47100.0
2023-05-02	ABEV	Stock	2.8	2.81	2.76	2.8	20977800.0
2023-05-02	ABG	Stock	196.43	196.77	190.15	196.07	255200.0
2023-05-02	ABM	Stock	42.33	42.33	41.48	42.03	211800.0
2023-05-02	ABNB	Stock	120.24	121.7	117.94	120.58	4861800.0
2023-05-02	ABOS	Stock	3.91	4.0	3.58	3.7	54300.0
2023-05-02	ABR	Stock	11.15	11.3	10.79	11.28	5505900.0
2023-05-02	ABR.D	Stock	17.71	18.05	17.52	17.7	18347.0
2023-05-02	ABR.E	Stock	17.755	17.755	17.61	17.62	7425.0
2023-05-02	ABR.F	Stock	18.2135	18.3347	17.99	18.15	24354.0

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

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