PREVIEW / stock_daily / 2021-08-31

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-31.parquet
  size:    259 KB
  rows:    7,899
  symbols: 2,749

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-08-31	AAPL	Stock	152.66	152.8	151.29	151.83	86453100.0
2021-08-31	MSFT	Stock	304.42	304.5	301.5	301.88	26285300.0
2021-08-31	NVDA	Stock	22.695	22.695	22.12	22.385	259850000.0
2021-08-31	AMZN	Stock	171.24	173.629	169.7795	173.5395	87128000.0
2021-08-31	GOOGL	Stock	145.147	145.1713	144.281	144.6975	22448760.0
2021-08-31	META	Stock	379.95	382.76	378.8	379.38	12345400.0
2021-08-31	TSLA	Stock	244.3333	246.7967	242.1467	245.24	62566200.0
2021-08-31	TLT	Stock	149.67	150.09	148.5	148.83	15262401.0
2021-08-31	ES	Stock	91.05	91.32	90.3	90.73	1662900.0
2021-08-31	CL	Stock	77.65	78.28	77.52	77.95	3786900.0
2021-08-31	A	Stock	177.1	177.19	174.83	175.47	1733200.0
2021-08-31	AA	Stock	44.26	44.95	42.96	44.37	6152600.0
2021-08-31	AAC-DELISTED	Stock	9.68	9.71	9.67	9.71	417110.0
2021-08-31	AACG	Stock	2.75	2.79	2.66	2.78	31700.0
2021-08-31	AAIC-DELISTED	Stock	3.76	3.83	3.73	3.73	111031.0
2021-08-31	AAIC.C-DELISTED	Stock	25.39	25.4	25.2935	25.39	3008.0
2021-08-31	AAL	Stock	19.47	20.02	19.36	19.94	24993200.0
2021-08-31	AAM.A-DELISTED	Stock	25.79	26.17	25.79	26.11	42589.0
2021-08-31	AAM.B-DELISTED	Stock	26.9	27.04	26.9	27.03	38430.0
2021-08-31	AAMC-DELISTED	Stock	5.2088	7.9412	4.95	6.3824	3453139.0
2021-08-31	AAME	Stock	3.87	4.07	3.81	3.97	79400.0
2021-08-31	AAMI	Stock	27.35	27.48	27.0	27.19	319400.0
2021-08-31	AAN-DELISTED	Stock	27.82	28.01	26.37	26.52	309300.0
2021-08-31	AAOI	Stock	7.26	7.41	7.15	7.33	328300.0
2021-08-31	AAON	Stock	46.0	46.0	45.3467	45.4067	174300.0
2021-08-31	AAP	Stock	201.25	203.8	200.29	202.85	660400.0
2021-08-31	AAQC-DELISTED	Stock	9.65	9.67	9.65	9.67	3291.0
2021-08-31	AAT	Stock	39.22	40.23	39.22	39.82	346300.0
2021-08-31	AATC	Stock	7.78	8.0	7.5	7.55	72047.0
2021-08-31	AAU-DELISTED	Stock	0.4235	0.4235	0.4055	0.4101	321308.0
2021-08-31	AAUAF-DELISTED	Stock	0.4235	0.4235	0.4055	0.4101	328822.0
2021-08-31	AAWW-DELISTED	Stock	73.64	73.89	72.94	73.17	226513.0
2021-08-31	AAXJ	Stock	88.72	88.85	88.5	88.76	1146390.0
2021-08-31	AB	Stock	52.41	52.52	52.0	52.37	138300.0
2021-08-31	ABB-DELISTED	Stock	37.39	37.4	36.96	36.99	1274325.0
2021-08-31	ABBNY-DELISTED	Stock	37.39	37.4	36.96	36.99	1442585.0
2021-08-31	ABBV	Stock	120.83	121.17	120.03	120.78	6021800.0
2021-08-31	ABC-DELISTED	Stock	119.3	122.8489	119.3	122.25	584654.0
2021-08-31	ABCB	Stock	48.38	50.11	48.38	49.24	290600.0
2021-08-31	ABCL	Stock	17.5	17.605	16.62	16.78	1710700.0
2021-08-31	ABCM-DELISTED	Stock	21.02	21.2982	21.02	21.15	36915.0
2021-08-31	ABEO	Stock	32.5	33.25	32.25	33.0	17760.0
2021-08-31	ABEV	Stock	3.26	3.29	3.21	3.26	18410200.0
2021-08-31	ABG	Stock	186.08	187.18	183.5	186.24	140700.0
2021-08-31	ABGI-DELISTED	Stock	9.68	9.68	9.62	9.68	400.0
2021-08-31	ABM	Stock	49.09	49.65	48.94	49.52	731900.0
2021-08-31	ABMD-DELISTED	Stock	362.92	364.24	359.82	363.98	136991.0
2021-08-31	ABNB	Stock	155.94	158.15	153.58	154.99	7404000.0
2021-08-31	ABOS	Stock	18.96	19.13	17.5	17.92	80500.0
2021-08-31	ABR	Stock	18.21	18.45	18.11	18.28	1860400.0

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

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