PREVIEW / stock_daily / 2020-07-31

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-31.parquet
  size:    224 KB
  rows:    6,785
  symbols: 2,423

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-31	AAPL	Stock	102.885	106.415	100.825	106.26	374336800.0
2020-07-31	MSFT	Stock	204.4	205.1	199.01	205.01	51044000.0
2020-07-31	NVDA	Stock	10.5632	10.7665	10.433	10.6148	386080000.0
2020-07-31	AMZN	Stock	162.2	162.341	157.55	158.234	161710000.0
2020-07-31	GOOGL	Stock	74.8525	75.251	72.7	74.3975	91527640.0
2020-07-31	META	Stock	255.82	255.85	249.0	253.67	53005100.0
2020-07-31	TSLA	Stock	101.0	101.1367	94.732	95.384	183123000.0
2020-07-31	TLT	Stock	170.15	171.4554	169.94	171.0	8886264.0
2020-07-31	ES	Stock	90.38	91.96	88.41	90.07	2588700.0
2020-07-31	CL	Stock	76.61	77.46	75.81	77.2	4346700.0
2020-07-31	A	Stock	95.94	96.41	94.73	96.33	1551800.0
2020-07-31	AA	Stock	12.92	13.13	12.48	13.0	10357300.0
2020-07-31	AACG	Stock	1.06	1.09	1.01	1.06	26800.0
2020-07-31	AACQU-DELISTED	Stock	10.28	10.28	10.1	10.12	682265.0
2020-07-31	AAIC-DELISTED	Stock	2.86	2.91	2.72	2.72	430556.0
2020-07-31	AAIC.C-DELISTED	Stock	19.47	19.48	19.22	19.34	2933.0
2020-07-31	AAL	Stock	11.16	11.25	10.8	11.12	51691400.0
2020-07-31	AAM.A-DELISTED	Stock	26.8	26.92	26.7	26.88	47597.0
2020-07-31	AAM.B-DELISTED	Stock	27.5	27.53	27.18	27.53	54893.0
2020-07-31	AAMC-DELISTED	Stock	4.3103	4.3103	4.2588	4.3	2026.0
2020-07-31	AAME	Stock	1.88	1.92	1.85	1.85	2300.0
2020-07-31	AAMI	Stock	13.69	13.69	12.356	13.44	1358600.0
2020-07-31	AAOI	Stock	14.07	14.8	13.72	14.21	1207300.0
2020-07-31	AAON	Stock	38.4467	39.5333	38.4467	39.5	391650.0
2020-07-31	AAP	Stock	152.66	153.35	147.55	150.14	829000.0
2020-07-31	AAT	Stock	26.12	27.0	25.88	27.0	447200.0
2020-07-31	AAU-DELISTED	Stock	0.7177	0.72	0.69	0.6971	622607.0
2020-07-31	AAUAF-DELISTED	Stock	0.7177	0.72	0.69	0.7	657278.0
2020-07-31	AAWW-DELISTED	Stock	51.14	52.08	50.78	52.07	371363.0
2020-07-31	AAXJ	Stock	75.15	75.21	74.17	74.84	569639.0
2020-07-31	AAXN-DELISTED	Stock	85.67	86.05	82.45	83.12	478471.0
2020-07-31	AB	Stock	28.66	28.8	27.79	28.41	320100.0
2020-07-31	ABB-DELISTED	Stock	25.47	25.48	24.8301	24.99	1816767.0
2020-07-31	ABBNY-DELISTED	Stock	25.47	25.48	24.8301	24.99	2019602.0
2020-07-31	ABBV	Stock	95.54	97.25	93.55	94.91	14613000.0
2020-07-31	ABC-DELISTED	Stock	102.01	102.015	98.69	100.17	626172.0
2020-07-31	ABCB	Stock	23.03	23.11	22.44	23.08	418000.0
2020-07-31	ABEO	Stock	72.0	72.5	68.75	71.25	26052.0
2020-07-31	ABEV	Stock	2.79	2.79	2.66	2.68	26132400.0
2020-07-31	ABG	Stock	101.05	102.28	97.88	100.15	298200.0
2020-07-31	ABM	Stock	34.95	35.95	34.78	35.9	1278100.0
2020-07-31	ABMD-DELISTED	Stock	300.2	302.97	294.22	299.63	150740.0
2020-07-31	ABR	Stock	9.96	10.19	9.63	10.19	2981000.0
2020-07-31	ABR.A-DELISTED	Stock	25.0	25.49	24.8364	25.02	10784.0
2020-07-31	ABR.B-DELISTED	Stock	24.01	24.99	23.56	24.0	27592.0
2020-07-31	ABR.C-DELISTED	Stock	25.1	25.7899	25.01	25.6086	8368.0
2020-07-31	ABT	Stock	101.21	101.37	99.12	100.64	4604000.0
2020-07-31	ABTC	Stock	189300.0	196800.0	187650.0	195900.0	1.0133333333333332
2020-07-31	ABTS	Stock	13.38	13.65	12.165	13.35	1827.0
2020-07-31	ABTX-DELISTED	Stock	24.88	24.98	23.81	24.38	39737.0

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

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