PREVIEW / stock_daily / 2021-12-10

all stock daily files

  file:    by_date/stock_daily/2021/2021-12-10.parquet
  size:    260 KB
  rows:    8,010
  symbols: 2,648

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
2021-12-10	AAPL	Stock	175.21	179.63	174.69	179.45	115402700.0
2021-12-10	MSFT	Stock	334.98	343.0	334.79	342.54	38095700.0
2021-12-10	NVDA	Stock	31.15	31.305	29.861	30.198	488825000.0
2021-12-10	AMZN	Stock	175.417	175.927	170.5	172.212	60690000.0
2021-12-10	GOOGL	Stock	148.7	148.9775	146.7037	148.0015	24462760.0
2021-12-10	META	Stock	332.56	335.03	326.37	329.75	14528000.0
2021-12-10	TSLA	Stock	336.25	340.3267	327.51	339.01	59664300.0
2021-12-10	TLT	Stock	149.92	150.24	148.81	148.86	14298740.0
2021-12-10	ES	Stock	87.75	88.16	87.17	87.88	973200.0
2021-12-10	CL	Stock	78.5	79.6	78.19	79.47	4294500.0
2021-12-10	A	Stock	154.53	156.34	154.08	156.26	1463900.0
2021-12-10	AA	Stock	49.97	50.15	47.84	48.8	5525400.0
2021-12-10	AAC-DELISTED	Stock	9.79	9.8	9.78	9.8	9064.0
2021-12-10	AACG	Stock	1.65	1.65	1.5	1.57	10400.0
2021-12-10	AAIC-DELISTED	Stock	3.72	3.72	3.68	3.69	103640.0
2021-12-10	AAIC.C-DELISTED	Stock	25.48	25.58	25.48	25.5	1300.0
2021-12-10	AAL	Stock	18.07	18.13	17.63	18.01	28696100.0
2021-12-10	AAM.A-DELISTED	Stock	25.34	25.34	25.28	25.31	12340.0
2021-12-10	AAM.B-DELISTED	Stock	26.08	26.18	26.045	26.15	11838.0
2021-12-10	AAME	Stock	3.71	3.89	3.62	3.72	11700.0
2021-12-10	AAMI	Stock	30.34	30.435	28.59	29.34	1607500.0
2021-12-10	AAN-DELISTED	Stock	24.4	24.62	23.98	24.35	213600.0
2021-12-10	AAOI	Stock	6.0	6.07	5.76	5.78	435400.0
2021-12-10	AAON	Stock	53.3867	54.6	52.5533	53.4533	144600.0
2021-12-10	AAP	Stock	235.42	240.24	234.84	240.04	716800.0
2021-12-10	AAQC-DELISTED	Stock	9.72	9.74	9.72	9.74	11638.0
2021-12-10	AAT	Stock	36.0	36.02	35.5	35.76	395500.0
2021-12-10	AATC	Stock	6.56	6.7	6.56	6.69	15100.0
2021-12-10	AAU-DELISTED	Stock	0.318	0.318	0.305	0.3051	266533.0
2021-12-10	AAUAF-DELISTED	Stock	0.318	0.318	0.305	0.3051	271202.0
2021-12-10	AAWW-DELISTED	Stock	87.0	88.32	86.56	87.11	144983.0
2021-12-10	AAXJ	Stock	85.3	85.55	85.15	85.37	810331.0
2021-12-10	AB	Stock	49.56	51.24	49.56	50.94	381600.0
2021-12-10	ABB-DELISTED	Stock	36.7	36.805	36.6	36.72	1184149.0
2021-12-10	ABBNY-DELISTED	Stock	36.7	36.805	36.6	36.73	1312336.0
2021-12-10	ABBV	Stock	123.72	126.01	123.72	125.47	7059500.0
2021-12-10	ABC-DELISTED	Stock	122.3	123.4994	121.75	123.15	959328.0
2021-12-10	ABCB	Stock	49.49	49.49	48.1	49.2	199400.0
2021-12-10	ABCL	Stock	14.45	14.93	13.81	13.97	2007300.0
2021-12-10	ABCM-DELISTED	Stock	22.55	22.96	22.55	22.9	91393.0
2021-12-10	ABEO	Stock	15.5	15.75	15.0	15.5	11552.0
2021-12-10	ABEV	Stock	2.82	2.85	2.8	2.81	14363500.0
2021-12-10	ABG	Stock	169.7	173.03	167.16	172.45	301200.0
2021-12-10	ABGI-DELISTED	Stock	9.72	9.75	9.71	9.74	28490.0
2021-12-10	ABM	Stock	45.56	45.9	45.22	45.58	279400.0
2021-12-10	ABMD-DELISTED	Stock	313.78	314.96	305.93	306.0	154159.0
2021-12-10	ABNB	Stock	178.15	181.1	175.854	180.42	3980400.0
2021-12-10	ABOS	Stock	7.35	7.35	6.935	7.04	97000.0
2021-12-10	ABR	Stock	18.27	18.45	18.08	18.16	1336400.0
2021-12-10	ABR.D	Stock	25.1637	25.2	25.12	25.2	11622.0

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

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