PREVIEW / stock_daily / 2022-07-25

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-25.parquet
  size:    253 KB
  rows:    7,913
  symbols: 2,306

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-07-25	AAPL	Stock	154.01	155.04	152.28	152.95	53623900.0
2022-07-25	MSFT	Stock	261.0	261.5	256.81	258.83	21056000.0
2022-07-25	NVDA	Stock	17.019	17.124	16.649	17.024	480748000.0
2022-07-25	AMZN	Stock	122.7	123.64	120.03	121.14	50221300.0
2022-07-25	GOOGL	Stock	108.41	109.87	106.3	107.51	34690894.0
2022-07-25	META	Stock	169.0	170.57	164.81	166.65	26166300.0
2022-07-25	TSLA	Stock	272.2167	274.1467	267.4	268.4333	64073400.0
2022-07-25	TLT	Stock	116.71	117.54	116.47	117.39	24868134.0
2022-07-25	ES	Stock	83.76	84.94	83.53	84.88	724700.0
2022-07-25	CL	Stock	77.5	78.15	77.29	77.85	2427800.0
2022-07-25	A	Stock	125.05	125.41	123.19	124.26	1044000.0
2022-07-25	AA	Stock	46.8	47.725	46.2	46.8	6842100.0
2022-07-25	AAC-DELISTED	Stock	9.88	9.88	9.86	9.86	84404.0
2022-07-25	AACG	Stock	1.59	1.59	1.53	1.54	12100.0
2022-07-25	AAIC-DELISTED	Stock	3.21	3.255	3.1901	3.23	39170.0
2022-07-25	AAIC.C-DELISTED	Stock	20.3	20.38	20.2	20.38	2150.0
2022-07-25	AAL	Stock	13.62	13.8	13.3	13.75	28368500.0
2022-07-25	AAM.A-DELISTED	Stock	24.94	25.0	24.8	24.91	22255.0
2022-07-25	AAM.B-DELISTED	Stock	25.14	25.6	25.135	25.46	2835.0
2022-07-25	AAMC-DELISTED	Stock	4.2059	5.1029	3.9794	4.5588	173522.0
2022-07-25	AAME	Stock	3.0	3.06	2.91	3.0	4000.0
2022-07-25	AAMI	Stock	18.84	18.99	18.69	18.95	136500.0
2022-07-25	AAN-DELISTED	Stock	15.91	15.95	15.41	15.5	533400.0
2022-07-25	AAOI	Stock	1.66	1.71	1.64	1.65	108800.0
2022-07-25	AAON	Stock	38.0933	38.2	37.2267	37.6267	191850.0
2022-07-25	AAP	Stock	191.85	192.06	188.79	189.63	408500.0
2022-07-25	AAQC-DELISTED	Stock	9.81	9.81	9.81	9.81	200.0
2022-07-25	AAT	Stock	29.88	30.23	29.7	29.95	178100.0
2022-07-25	AATC	Stock	5.04	5.245	4.9498	5.04	22058.0
2022-07-25	AAU-DELISTED	Stock	0.2151	0.2295	0.2151	0.2202	160757.0
2022-07-25	AAUAF-DELISTED	Stock	0.2151	0.2295	0.2151	0.2202	163802.0
2022-07-25	AAWW-DELISTED	Stock	69.7	69.7	67.88	69.53	383527.0
2022-07-25	AAXJ	Stock	67.85	68.0	67.6	67.91	533787.0
2022-07-25	AB	Stock	42.25	42.25	41.2	41.8	196400.0
2022-07-25	ABB-DELISTED	Stock	28.465	28.62	28.33	28.53	1286568.0
2022-07-25	ABBNY-DELISTED	Stock	28.465	28.62	28.33	28.54	1423062.0
2022-07-25	ABBV	Stock	148.54	150.94	148.51	150.22	4347000.0
2022-07-25	ABC-DELISTED	Stock	143.09	145.76	142.88	144.12	406839.0
2022-07-25	ABCB	Stock	42.57	43.47	42.37	43.34	285300.0
2022-07-25	ABCL	Stock	10.08	10.225	9.91	10.1	1203600.0
2022-07-25	ABCM-DELISTED	Stock	14.49	14.64	14.3088	14.61	183375.0
2022-07-25	ABEO	Stock	4.77	4.77	4.27	4.29	85200.0
2022-07-25	ABEV	Stock	2.65	2.71	2.65	2.69	19529900.0
2022-07-25	ABG	Stock	168.23	168.39	163.53	164.47	115500.0
2022-07-25	ABGI-DELISTED	Stock	9.832	9.832	9.832	9.832	200.0
2022-07-25	ABM	Stock	43.25	43.74	43.05	43.54	239900.0
2022-07-25	ABMD-DELISTED	Stock	278.94	283.98	278.27	280.43	103548.0
2022-07-25	ABNB	Stock	103.78	105.26	101.479	104.95	3142900.0
2022-07-25	ABOS	Stock	6.28	6.28	5.03	5.27	71500.0
2022-07-25	ABR	Stock	15.25	15.55	15.22	15.52	1481000.0

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

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