PREVIEW / stock_daily / 2021-07-29

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-29.parquet
  size:    257 KB
  rows:    7,874
  symbols: 2,806

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-07-29	AAPL	Stock	144.69	146.55	144.58	145.64	56699500.0
2021-07-29	MSFT	Stock	286.24	288.62	286.08	286.5	18168300.0
2021-07-29	NVDA	Stock	19.519	19.853	19.328	19.662	190781000.0
2021-07-29	AMZN	Stock	181.3875	181.8975	179.0005	179.996	110400000.0
2021-07-29	GOOGL	Stock	136.15	136.661	135.543	135.7775	31715720.0
2021-07-29	META	Stock	361.0	365.52	356.74	358.32	33413200.0
2021-07-29	TSLA	Stock	216.5967	227.8967	216.2667	225.7833	91183800.0
2021-07-29	TLT	Stock	148.78	149.22	148.53	148.82	11532032.0
2021-07-29	ES	Stock	86.59	86.69	85.61	86.39	1456100.0
2021-07-29	CL	Stock	83.48	83.83	83.03	83.52	3974400.0
2021-07-29	A	Stock	151.99	153.46	151.42	152.67	1527300.0
2021-07-29	AA	Stock	38.94	40.0	38.78	39.37	6648500.0
2021-07-29	AAC-DELISTED	Stock	9.77	9.78	9.7389	9.76	63835.0
2021-07-29	AACG	Stock	3.34	3.39	3.11	3.16	151600.0
2021-07-29	AAIC-DELISTED	Stock	3.96	4.06	3.91	3.98	102750.0
2021-07-29	AAL	Stock	21.78	21.78	21.17	21.17	19391300.0
2021-07-29	AAM.A-DELISTED	Stock	26.37	26.4	26.3623	26.4	8336.0
2021-07-29	AAM.B-DELISTED	Stock	26.96	27.12	26.9564	27.12	13298.0
2021-07-29	AAMC-DELISTED	Stock	4.4765	4.5706	4.3235	4.5147	84031.0
2021-07-29	AAME	Stock	4.17	4.17	4.05	4.12	8700.0
2021-07-29	AAMI	Stock	24.41	25.1	24.21	24.72	401800.0
2021-07-29	AAN-DELISTED	Stock	28.99	29.595	28.48	28.52	583600.0
2021-07-29	AAOI	Stock	7.61	7.805	7.6	7.77	320900.0
2021-07-29	AAON	Stock	40.76	41.46	40.44	41.4067	107400.0
2021-07-29	AAP	Stock	213.21	213.65	211.29	213.39	452700.0
2021-07-29	AAQC-DELISTED	Stock	9.669	9.676	9.66	9.66	4965.0
2021-07-29	AAT	Stock	37.36	37.91	37.19	37.22	375400.0
2021-07-29	AATC	Stock	7.05	7.3683	6.7691	7.0	74638.0
2021-07-29	AAU-DELISTED	Stock	0.45	0.45	0.4301	0.4487	792459.0
2021-07-29	AAUAF-DELISTED	Stock	0.45	0.45	0.4301	0.4487	805233.0
2021-07-29	AAWW-DELISTED	Stock	67.17	68.22	66.7649	67.69	121326.0
2021-07-29	AAXJ	Stock	88.63	88.66	87.955	88.27	1891520.0
2021-07-29	AB	Stock	47.5	48.28	46.52	48.18	421600.0
2021-07-29	ABB-DELISTED	Stock	36.88	37.04	36.855	37.0	982358.0
2021-07-29	ABBNY-DELISTED	Stock	36.88	37.04	36.855	37.01	1078067.0
2021-07-29	ABBV	Stock	119.03	119.13	118.15	118.87	4632200.0
2021-07-29	ABC-DELISTED	Stock	122.0	122.98	121.09	122.73	434094.0
2021-07-29	ABCB	Stock	49.48	49.91	48.9	49.13	416900.0
2021-07-29	ABCL	Stock	16.2	16.55	15.39	15.62	1302300.0
2021-07-29	ABCM-DELISTED	Stock	18.79	19.03	18.57	18.76	82222.0
2021-07-29	ABEO	Stock	32.25	32.25	30.25	31.0	59268.0
2021-07-29	ABEV	Stock	3.24	3.39	3.22	3.33	36874200.0
2021-07-29	ABG	Stock	196.5	203.78	195.8	202.62	124100.0
2021-07-29	ABGI-DELISTED	Stock	9.72	9.74	9.71	9.74	2130.0
2021-07-29	ABM	Stock	47.09	47.59	46.82	47.02	343900.0
2021-07-29	ABMD-DELISTED	Stock	324.34	325.4	320.5	324.4	48033.0
2021-07-29	ABNB	Stock	143.646	145.0	141.71	143.47	5005500.0
2021-07-29	ABOS	Stock	14.77	16.125	14.34	15.32	144500.0
2021-07-29	ABR	Stock	18.21	18.43	18.12	18.12	1797900.0
2021-07-29	ABR.D	Stock	25.5999	25.6162	25.55	25.57	8143.0

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

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