PREVIEW / stock_daily / 2022-04-21

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-21.parquet
  size:    260 KB
  rows:    7,991
  symbols: 2,445

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-04-21	AAPL	Stock	168.91	171.53	165.91	166.42	87227800.0
2022-04-21	MSFT	Stock	288.58	293.3	280.06	280.81	29454600.0
2022-04-21	NVDA	Stock	21.709	22.392	20.0	20.183	656209000.0
2022-04-21	AMZN	Stock	154.714	156.738	147.5895	148.296	63970000.0
2022-04-21	GOOGL	Stock	129.25	130.0985	124.5265	124.8145	36445160.0
2022-04-21	META	Stock	201.6	202.97	185.58	188.07	49954100.0
2022-04-21	TSLA	Stock	358.2433	364.0733	332.14	336.26	105416400.0
2022-04-21	TLT	Stock	120.83	120.91	119.17	120.75	23323244.0
2022-04-21	ES	Stock	93.15	94.63	92.64	93.1	1032200.0
2022-04-21	CL	Stock	81.6	82.52	81.49	82.1	4661100.0
2022-04-21	A	Stock	130.36	131.03	124.85	125.29	2177700.0
2022-04-21	AA	Stock	80.65	81.4	71.32	72.2	21971300.0
2022-04-21	AAC-DELISTED	Stock	9.84	9.85	9.84	9.84	89799.0
2022-04-21	AACG	Stock	1.16	1.2	1.16	1.17	10200.0
2022-04-21	AAIC-DELISTED	Stock	3.51	3.53	3.42	3.42	30654.0
2022-04-21	AAIC.C-DELISTED	Stock	24.55	24.58	24.54	24.56	2700.0
2022-04-21	AAL	Stock	21.26	21.42	20.11	20.22	84042900.0
2022-04-21	AAM.A-DELISTED	Stock	25.0	25.0501	25.0	25.001	12824.0
2022-04-21	AAM.B-DELISTED	Stock	25.16	25.2	25.0945	25.15	23580.0
2022-04-21	AAMC-DELISTED	Stock	3.1878	3.2434	3.0618	3.1706	5515.0
2022-04-21	AAME	Stock	3.18	3.33	3.14	3.15	2700.0
2022-04-21	AAMI	Stock	22.68	22.85	21.615	21.75	640100.0
2022-04-21	AAN-DELISTED	Stock	21.75	21.75	20.95	21.05	219100.0
2022-04-21	AAOI	Stock	3.15	3.15	2.95	2.96	309800.0
2022-04-21	AAON	Stock	36.2333	37.66	36.2333	37.4933	537150.0
2022-04-21	AAP	Stock	230.55	231.43	225.25	225.56	412200.0
2022-04-21	AAQC-DELISTED	Stock	9.77	9.77	9.77	9.77	5101.0
2022-04-21	AAT	Stock	37.11	37.18	36.83	36.86	270500.0
2022-04-21	AATC	Stock	6.825	6.88	6.8	6.8	6497.0
2022-04-21	AAU-DELISTED	Stock	0.37	0.3703	0.35	0.358	652372.0
2022-04-21	AAUAF-DELISTED	Stock	0.37	0.3703	0.35	0.358	656533.0
2022-04-21	AAWW-DELISTED	Stock	70.57	71.26	68.86	69.6	246625.0
2022-04-21	AAXJ	Stock	72.18	72.4	70.74	70.92	1248648.0
2022-04-21	AB	Stock	44.68	44.8	43.01	43.07	316000.0
2022-04-21	ABB-DELISTED	Stock	33.63	33.65	32.61	32.6968	2449410.0
2022-04-21	ABBNY-DELISTED	Stock	33.63	33.65	32.61	32.7	2767061.0
2022-04-21	ABBV	Stock	157.0	160.38	155.35	158.52	7903300.0
2022-04-21	ABC-DELISTED	Stock	165.69	167.19	164.107	165.05	597797.0
2022-04-21	ABCB	Stock	43.2	43.56	42.03	42.44	607900.0
2022-04-21	ABCL	Stock	8.54	8.68	8.13	8.17	1395300.0
2022-04-21	ABCM-DELISTED	Stock	17.16	17.53	17.16	17.39	122043.0
2022-04-21	ABEO	Stock	6.25	6.5	5.75	6.25	41944.0
2022-04-21	ABEV	Stock	3.19	3.23	3.11	3.11	14511700.0
2022-04-21	ABG	Stock	162.95	165.5	156.97	158.52	248000.0
2022-04-21	ABGI-DELISTED	Stock	9.82	9.82	9.82	9.82	55869.0
2022-04-21	ABM	Stock	53.3	53.4	52.48	52.76	619100.0
2022-04-21	ABMD-DELISTED	Stock	332.58	332.58	315.025	315.41	104740.0
2022-04-21	ABNB	Stock	168.98	170.93	156.68	157.91	4714600.0
2022-04-21	ABOS	Stock	4.06	4.15	3.96	4.05	178600.0
2022-04-21	ABR	Stock	17.6	17.79	17.51	17.54	1477300.0

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

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