PREVIEW / stock_daily / 2020-07-29

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-29.parquet
  size:    223 KB
  rows:    6,745
  symbols: 2,401

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-07-29	AAPL	Stock	93.75	95.23	93.7125	95.04	90329200.0
2020-07-29	MSFT	Stock	202.5	204.65	202.01	204.06	19632600.0
2020-07-29	NVDA	Stock	10.3908	10.5162	10.347	10.4655	284508000.0
2020-07-29	AMZN	Stock	151.5495	151.958	149.8385	151.6765	59482000.0
2020-07-29	GOOGL	Stock	75.25	76.6665	75.1505	76.1755	22675460.0
2020-07-29	META	Stock	231.14	233.7	230.31	233.29	13588300.0
2020-07-29	TSLA	Stock	100.0667	102.3207	99.1333	99.9407	141403500.0
2020-07-29	TLT	Stock	170.05	170.39	168.98	169.99	6733733.0
2020-07-29	ES	Stock	90.56	91.38	89.99	90.49	1028100.0
2020-07-29	CL	Stock	75.58	76.48	75.53	76.2	3186700.0
2020-07-29	A	Stock	95.81	97.66	95.52	97.1	1125300.0
2020-07-29	AA	Stock	13.0	13.36	12.81	13.18	4758500.0
2020-07-29	AACG	Stock	1.14	1.14	1.04	1.07	69600.0
2020-07-29	AACQU-DELISTED	Stock	10.45	10.45	10.34	10.35	99730.0
2020-07-29	AAIC-DELISTED	Stock	2.94	3.0	2.91	2.96	372286.0
2020-07-29	AAIC.C-DELISTED	Stock	19.0	19.0	18.88	19.0	725.0
2020-07-29	AAL	Stock	11.8	11.92	11.3	11.4	52214600.0
2020-07-29	AAM.A-DELISTED	Stock	26.69	26.82	26.69	26.79	13913.0
2020-07-29	AAM.B-DELISTED	Stock	27.25	27.5	27.25	27.49	11717.0
2020-07-29	AAMC-DELISTED	Stock	4.3971	4.3971	4.2544	4.2544	1064.0
2020-07-29	AAME	Stock	1.77	1.87	1.77	1.87	10600.0
2020-07-29	AAMI	Stock	14.46	14.61	13.69	14.04	770800.0
2020-07-29	AAOI	Stock	13.29	13.75	13.2	13.53	761100.0
2020-07-29	AAON	Stock	38.22	39.72	38.22	39.4	316050.0
2020-07-29	AAP	Stock	146.61	148.81	146.13	148.21	1249400.0
2020-07-29	AAT	Stock	27.0	27.66	26.1	27.0	282700.0
2020-07-29	AAU-DELISTED	Stock	0.75	0.75	0.69	0.7085	1489705.0
2020-07-29	AAUAF-DELISTED	Stock	0.75	0.75	0.69	0.7221	1606769.0
2020-07-29	AAWW-DELISTED	Stock	48.97	51.3153	48.97	51.14	374305.0
2020-07-29	AAXJ	Stock	75.21	75.97	75.21	75.82	681846.0
2020-07-29	AAXN-DELISTED	Stock	86.07	86.79	84.73	84.83	302033.0
2020-07-29	AB	Stock	28.87	29.31	28.77	29.27	298900.0
2020-07-29	ABB-DELISTED	Stock	25.82	26.16	25.79	26.11	1777440.0
2020-07-29	ABBNY-DELISTED	Stock	25.82	26.16	25.79	26.12	1944520.0
2020-07-29	ABBV	Stock	96.87	97.4	96.64	97.01	5512000.0
2020-07-29	ABC-DELISTED	Stock	102.6	103.82	101.3	103.32	447095.0
2020-07-29	ABCB	Stock	23.73	24.11	23.12	24.09	357100.0
2020-07-29	ABEO	Stock	72.25	72.25	67.75	69.25	27580.0
2020-07-29	ABEV	Stock	2.99	3.01	2.9	2.9	32567600.0
2020-07-29	ABG	Stock	104.11	105.3	101.68	104.05	257300.0
2020-07-29	ABM	Stock	35.22	35.9	35.17	35.84	416900.0
2020-07-29	ABMD-DELISTED	Stock	294.91	301.48	294.91	299.0	199813.0
2020-07-29	ABR	Stock	9.37	9.44	9.19	9.36	875800.0
2020-07-29	ABR.A-DELISTED	Stock	25.0	25.18	24.93	25.18	6827.0
2020-07-29	ABR.B-DELISTED	Stock	24.26	24.45	23.61	23.7	13781.0
2020-07-29	ABR.C-DELISTED	Stock	24.84	25.06	24.84	25.0599	3481.0
2020-07-29	ABT	Stock	100.18	102.89	100.09	102.52	4744200.0
2020-07-29	ABTC	Stock	199800.0	203100.0	189300.0	192900.0	1.4933333333333332
2020-07-29	ABTS	Stock	13.8	13.905	12.75	13.17	4140.0
2020-07-29	ABTX-DELISTED	Stock	23.52	24.5	23.41	24.46	32481.0

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

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