PREVIEW / stock_daily / 2022-06-16

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-16.parquet
  size:    256 KB
  rows:    8,008
  symbols: 2,402

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-06-16	AAPL	Stock	132.08	132.39	129.04	130.06	108123900.0
2022-06-16	MSFT	Stock	245.98	247.42	243.02	244.97	33169200.0
2022-06-16	NVDA	Stock	15.86	15.942	15.401	15.601	545749000.0
2022-06-16	AMZN	Stock	104.47	104.58	102.01	103.66	82186300.0
2022-06-16	GOOGL	Stock	107.221	108.6485	105.138	106.0335	51684960.0
2022-06-16	META	Stock	163.72	165.08	159.61	160.87	26944100.0
2022-06-16	TSLA	Stock	222.7367	225.1667	208.6933	213.1	107390700.0
2022-06-16	TLT	Stock	108.45	111.72	108.115	111.72	26067258.0
2022-06-16	ES	Stock	79.42	79.42	78.07	78.81	2214000.0
2022-06-16	CL	Stock	73.43	74.78	72.69	73.92	5342900.0
2022-06-16	A	Stock	113.8	115.08	113.36	114.96	1601600.0
2022-06-16	AA	Stock	48.46	51.86	48.45	49.68	8381300.0
2022-06-16	AAC-DELISTED	Stock	9.82	9.825	9.81	9.81	453103.0
2022-06-16	AACG	Stock	1.01	1.03	1.01	1.01	5900.0
2022-06-16	AACIW-DELISTED	Stock	0.2199	0.2199	0.18995	0.18995	750.0
2022-06-16	AAIC-DELISTED	Stock	3.13	3.13	2.92	3.0	98424.0
2022-06-16	AAIC.C-DELISTED	Stock	22.8	22.8	22.35	22.37	4736.0
2022-06-16	AAL	Stock	12.9	12.9	11.96	12.16	56545200.0
2022-06-16	AAM.A-DELISTED	Stock	23.74	23.74	23.2	23.385	10634.0
2022-06-16	AAM.B-DELISTED	Stock	24.04	25.105	23.87	24.62	19377.0
2022-06-16	AAMC-DELISTED	Stock	3.2353	3.2353	2.9412	2.9412	39705.0
2022-06-16	AAME	Stock	2.69	3.03	2.69	2.87	10300.0
2022-06-16	AAMI	Stock	18.56	18.56	17.69	18.16	710400.0
2022-06-16	AAN-DELISTED	Stock	15.65	15.78	14.83	15.61	543200.0
2022-06-16	AAOI	Stock	1.9	1.94	1.82	1.83	180900.0
2022-06-16	AAON	Stock	34.2	34.4267	33.36	34.1933	455250.0
2022-06-16	AAP	Stock	167.92	168.41	164.24	165.45	774200.0
2022-06-16	AAQC-DELISTED	Stock	9.7605	9.7605	9.7605	9.7605	210.0
2022-06-16	AAT	Stock	29.01	29.14	28.42	28.86	443300.0
2022-06-16	AATC	Stock	5.38	5.45	5.3	5.3813	10251.0
2022-06-16	AAU-DELISTED	Stock	0.24	0.2536	0.236	0.2405	331034.0
2022-06-16	AAUAF-DELISTED	Stock	0.24	0.2536	0.236	0.2405	335598.0
2022-06-16	AAWW-DELISTED	Stock	63.92	64.26	61.855	62.83	336357.0
2022-06-16	AAXJ	Stock	67.59	67.94	67.14	67.56	1474586.0
2022-06-16	AB	Stock	40.51	40.94	39.21	40.39	491400.0
2022-06-16	ABB-DELISTED	Stock	27.6	27.6507	27.2734	27.39	2583695.0
2022-06-16	ABBNY-DELISTED	Stock	27.6	27.6507	27.2734	27.38	2829388.0
2022-06-16	ABBV	Stock	136.54	139.29	135.76	139.15	6963400.0
2022-06-16	ABC-DELISTED	Stock	140.81	142.05	138.83	141.0	708090.0
2022-06-16	ABCB	Stock	41.19	41.24	39.59	39.73	463700.0
2022-06-16	ABCL	Stock	9.07	9.39	8.89	9.26	2715400.0
2022-06-16	ABCM-DELISTED	Stock	13.58	13.92	13.45	13.9	133915.0
2022-06-16	ABEO	Stock	4.0	4.0	3.75	4.0	43528.0
2022-06-16	ABEV	Stock	2.49	2.5	2.42	2.45	27465400.0
2022-06-16	ABG	Stock	170.0	170.0	153.12	157.08	307200.0
2022-06-16	ABGI-DELISTED	Stock	9.8	9.8	9.79	9.79	4324.0
2022-06-16	ABM	Stock	39.28	39.81	38.24	38.37	586700.0
2022-06-16	ABMD-DELISTED	Stock	226.36	227.14	219.845	224.81	210296.0
2022-06-16	ABNB	Stock	96.19	97.5	92.09	93.26	9435700.0
2022-06-16	ABOS	Stock	3.51	3.52	3.165	3.19	275900.0

> showing 50 of 8,008 rows — these rows as CSV

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