PREVIEW / stock_daily / 2022-09-28

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-28.parquet
  size:    252 KB
  rows:    7,908
  symbols: 2,205

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
2022-09-28	AAPL	Stock	147.64	150.64	144.84	149.84	146691400.0
2022-09-28	MSFT	Stock	236.81	242.33	234.73	241.07	29029700.0
2022-09-28	NVDA	Stock	12.41	12.823	12.354	12.736	542414000.0
2022-09-28	AMZN	Stock	114.38	118.7	113.8	118.01	55763800.0
2022-09-28	GOOGL	Stock	97.65	100.7	97.11	100.05	32466323.0
2022-09-28	META	Stock	134.62	142.03	134.27	141.61	32658500.0
2022-09-28	TSLA	Stock	283.08	289.0	277.57	287.81	54664800.0
2022-09-28	TLT	Stock	103.13	104.45	102.48	104.33	39283095.0
2022-09-28	ES	Stock	83.48	84.06	82.2	83.16	1905800.0
2022-09-28	CL	Stock	73.15	73.41	72.2	72.91	6450900.0
2022-09-28	A	Stock	122.77	124.43	121.6	123.72	1361200.0
2022-09-28	AA	Stock	34.68	35.53	33.7	35.23	9904800.0
2022-09-28	AAC-DELISTED	Stock	9.94	9.94	9.92	9.925	15781.0
2022-09-28	AACG	Stock	1.76	1.78	1.73	1.78	5200.0
2022-09-28	AAIC-DELISTED	Stock	2.85	2.85	2.73	2.8	38059.0
2022-09-28	AAIC.C-DELISTED	Stock	19.45	19.45	19.0	19.0	6183.0
2022-09-28	AAL	Stock	12.24	12.8	12.08	12.75	34069300.0
2022-09-28	AAM.A-DELISTED	Stock	23.7	24.18	23.25	23.54	47100.0
2022-09-28	AAM.B-DELISTED	Stock	23.74	23.93	23.5301	23.665	30823.0
2022-09-28	AAMC-DELISTED	Stock	5.0	5.0588	5.0	5.0	7242.0
2022-09-28	AAME	Stock	2.87	3.01	2.87	2.88	1500.0
2022-09-28	AAMI	Stock	15.48	15.71	15.35	15.6	318000.0
2022-09-28	AAN-DELISTED	Stock	10.62	10.88	10.54	10.77	226200.0
2022-09-28	AAOI	Stock	2.83	2.98	2.804	2.95	459600.0
2022-09-28	AAON	Stock	36.8267	37.5267	36.36	37.1333	273750.0
2022-09-28	AAP	Stock	161.08	164.44	159.49	163.32	673300.0
2022-09-28	AAQC-DELISTED	Stock	9.8105	9.82	9.81	9.81	5700.0
2022-09-28	AAT	Stock	24.42	25.63	24.01	25.57	380300.0
2022-09-28	AATC	Stock	4.47	4.5794	4.463	4.56	9611.0
2022-09-28	AAU-DELISTED	Stock	0.2026	0.2148	0.2	0.2104	253072.0
2022-09-28	AAUAF-DELISTED	Stock	0.2026	0.2148	0.2	0.2104	256187.0
2022-09-28	AAWW-DELISTED	Stock	95.71	96.91	95.28	96.1	712959.0
2022-09-28	AAXJ	Stock	59.28	60.495	59.14	60.34	820099.0
2022-09-28	AB	Stock	37.17	37.41	36.78	36.91	277000.0
2022-09-28	ABB-DELISTED	Stock	25.87	26.4	25.78	26.295	2423516.0
2022-09-28	ABBNY-DELISTED	Stock	25.87	26.4	25.78	26.3	2657678.0
2022-09-28	ABBV	Stock	144.22	145.32	142.62	144.6	5226700.0
2022-09-28	ABC-DELISTED	Stock	137.11	139.2	135.83	138.32	701308.0
2022-09-28	ABCB	Stock	45.4	46.39	45.27	45.84	443900.0
2022-09-28	ABCL	Stock	9.54	10.05	9.525	9.97	2268600.0
2022-09-28	ABCM-DELISTED	Stock	14.25	15.025	14.15	14.86	173608.0
2022-09-28	ABEO	Stock	3.0	3.24	2.94	3.08	144200.0
2022-09-28	ABEV	Stock	2.85	2.92	2.83	2.9	38927500.0
2022-09-28	ABG	Stock	152.63	158.97	152.01	157.53	162400.0
2022-09-28	ABGI-DELISTED	Stock	9.89	9.9	9.89	9.9	109100.0
2022-09-28	ABLV	Stock	9.97	9.97	9.96	9.96	301.0
2022-09-28	ABM	Stock	38.08	39.26	37.97	38.97	340800.0
2022-09-28	ABMD-DELISTED	Stock	245.99	251.58	243.4	250.04	142958.0
2022-09-28	ABNB	Stock	106.701	111.13	105.78	110.69	4518200.0
2022-09-28	ABOS	Stock	8.1	10.23	7.28	9.58	65285000.0

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

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