PREVIEW / stock_daily / 2020-10-05

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-05.parquet
  size:    228 KB
  rows:    6,952
  symbols: 2,477

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
2020-10-05	AAPL	Stock	113.91	116.65	113.55	116.5	106243800.0
2020-10-05	MSFT	Stock	207.22	210.41	206.98	210.38	21331600.0
2020-10-05	NVDA	Stock	13.236	13.6442	13.2228	13.6425	479820000.0
2020-10-05	AMZN	Stock	157.292	160.1265	157.0425	159.96	75506000.0
2020-10-05	GOOGL	Stock	73.1325	74.235	73.0045	74.1415	21601160.0
2020-10-05	META	Stock	262.2	264.87	260.84	264.65	12822300.0
2020-10-05	TSLA	Stock	141.1167	144.5467	139.7767	141.8933	134168400.0
2020-10-05	TLT	Stock	160.95	160.95	159.52	159.57	14726045.0
2020-10-05	ES	Stock	87.42	89.56	86.83	89.49	1842900.0
2020-10-05	CL	Stock	77.5	78.49	77.43	78.42	2768600.0
2020-10-05	A	Stock	100.99	103.46	100.96	103.12	803900.0
2020-10-05	AA	Stock	11.95	12.17	11.835	11.93	5387500.0
2020-10-05	AACG	Stock	1.1	1.13	1.09	1.11	11100.0
2020-10-05	AACQ-DELISTED	Stock	9.95	9.95	9.825	9.85	819518.0
2020-10-05	AACQU-DELISTED	Stock	10.405	10.405	10.32	10.33	105687.0
2020-10-05	AACQW-DELISTED	Stock	1.5	1.5404	1.49	1.54	57750.0
2020-10-05	AAIC-DELISTED	Stock	2.85	2.89	2.8174	2.86	143824.0
2020-10-05	AAIC.C-DELISTED	Stock	18.98	18.98	18.75	18.95	2236.0
2020-10-05	AAL	Stock	13.09	13.2	12.75	13.12	53465500.0
2020-10-05	AAM.A-DELISTED	Stock	26.155	26.26	26.127	26.23	13092.0
2020-10-05	AAM.B-DELISTED	Stock	27.02	27.35	27.01	27.2301	11084.0
2020-10-05	AAMC-DELISTED	Stock	6.1765	6.1765	5.7647	5.9382	18846.0
2020-10-05	AAME	Stock	2.02	2.02	2.02	2.02	600.0
2020-10-05	AAMI	Stock	13.33	13.63	13.22	13.58	408200.0
2020-10-05	AAOI	Stock	11.49	11.62	11.17	11.49	345900.0
2020-10-05	AAON	Stock	40.6933	41.5867	40.6933	41.3667	227400.0
2020-10-05	AAP	Stock	155.74	158.16	154.92	155.86	556700.0
2020-10-05	AAT	Stock	25.65	25.95	24.99	25.63	225800.0
2020-10-05	AAU-DELISTED	Stock	0.81	0.829	0.79	0.7927	259505.0
2020-10-05	AAUAF-DELISTED	Stock	0.81	0.829	0.79	0.7957	269474.0
2020-10-05	AAWW-DELISTED	Stock	64.29	66.35	63.7922	65.46	628103.0
2020-10-05	AAXJ	Stock	77.56	78.06	77.56	78.06	535877.0
2020-10-05	AAXN-DELISTED	Stock	92.22	93.45	90.1706	91.88	314446.0
2020-10-05	AB	Stock	26.99	27.42	26.95	27.34	371500.0
2020-10-05	ABB-DELISTED	Stock	26.06	26.395	26.06	26.37	1732034.0
2020-10-05	ABBNY-DELISTED	Stock	26.06	26.395	26.06	26.37	2114171.0
2020-10-05	ABBV	Stock	86.49	88.18	86.21	87.93	5984200.0
2020-10-05	ABC-DELISTED	Stock	95.77	97.01	94.8	96.39	531859.0
2020-10-05	ABCB	Stock	24.0	25.06	23.45	24.84	410900.0
2020-10-05	ABEO	Stock	26.25	27.75	26.25	27.25	91132.0
2020-10-05	ABEV	Stock	2.24	2.32	2.24	2.32	16158000.0
2020-10-05	ABG	Stock	104.26	110.37	104.26	109.88	119600.0
2020-10-05	ABM	Stock	36.9	37.1	36.58	36.83	377400.0
2020-10-05	ABMD-DELISTED	Stock	263.91	270.67	263.01	270.65	206775.0
2020-10-05	ABR	Stock	11.9	12.08	11.74	11.83	1023900.0
2020-10-05	ABR.A-DELISTED	Stock	25.19	25.4272	25.19	25.29	1600.0
2020-10-05	ABR.B-DELISTED	Stock	25.28	25.28	25.2	25.27	3198.0
2020-10-05	ABR.C-DELISTED	Stock	25.45	25.99	25.45	25.8088	3494.0
2020-10-05	ABT	Stock	107.18	108.65	107.18	108.56	3603400.0
2020-10-05	ABTC	Stock	121800.0	121950.0	116400.0	119100.0	3.7066666666666666

> showing 50 of 6,952 rows — these rows as CSV

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