PREVIEW / stock_daily / 2020-08-04

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-04.parquet
  size:    224 KB
  rows:    6,763
  symbols: 2,398

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-08-04	AAPL	Stock	109.1325	110.79	108.3875	109.665	173071600.0
2020-08-04	MSFT	Stock	214.17	214.77	210.31	213.29	49280100.0
2020-08-04	NVDA	Stock	11.05	11.2278	10.906	11.2278	310336000.0
2020-08-04	AMZN	Stock	155.0605	158.362	155.0605	156.9415	93886000.0
2020-08-04	GOOGL	Stock	74.3355	74.6555	73.2015	73.665	37212180.0
2020-08-04	META	Stock	251.56	252.8	247.43	249.83	17183500.0
2020-08-04	TSLA	Stock	99.6673	101.8273	97.4667	99.1333	126225000.0
2020-08-04	TLT	Stock	170.83	171.58	170.72	171.57	9878888.0
2020-08-04	ES	Stock	89.52	90.91	89.47	90.27	1120800.0
2020-08-04	CL	Stock	76.53	76.88	76.03	76.77	3410900.0
2020-08-04	A	Stock	98.71	98.99	96.89	97.53	779200.0
2020-08-04	AA	Stock	13.61	13.85	13.3	13.67	4871600.0
2020-08-04	AACG	Stock	1.39	1.39	1.21	1.27	82200.0
2020-08-04	AACQU-DELISTED	Stock	10.05	10.25	10.0416	10.11	371388.0
2020-08-04	AAIC-DELISTED	Stock	2.57	2.71	2.565	2.66	264688.0
2020-08-04	AAIC.C-DELISTED	Stock	19.1	19.1	19.0	19.0	364.0
2020-08-04	AAL	Stock	11.21	11.88	11.16	11.47	54824400.0
2020-08-04	AAM.A-DELISTED	Stock	27.0	27.01	26.8	27.01	854.0
2020-08-04	AAM.B-DELISTED	Stock	27.46	27.55	27.33	27.55	4877.0
2020-08-04	AAMC-DELISTED	Stock	3.9624	4.0324	3.8676	3.8676	4665.0
2020-08-04	AAME	Stock	1.8	1.84	1.69	1.8	14200.0
2020-08-04	AAMI	Stock	13.09	13.26	12.965	13.22	546400.0
2020-08-04	AAOI	Stock	15.96	16.54	15.43	16.36	1316400.0
2020-08-04	AAON	Stock	40.08	40.1667	39.32	39.7933	227550.0
2020-08-04	AAP	Stock	152.17	152.94	150.35	152.79	400000.0
2020-08-04	AAT	Stock	26.7	27.62	26.7	27.3	246900.0
2020-08-04	AAU-DELISTED	Stock	0.74	0.7698	0.7009	0.7666	1196554.0
2020-08-04	AAUAF-DELISTED	Stock	0.74	0.77	0.7009	0.77	1220414.0
2020-08-04	AAWW-DELISTED	Stock	53.2	56.49	53.2	55.77	530109.0
2020-08-04	AAXJ	Stock	75.95	76.61	75.95	76.57	1290410.0
2020-08-04	AAXN-DELISTED	Stock	88.02	89.57	87.5	89.5	491788.0
2020-08-04	AB	Stock	28.23	28.41	27.5	27.61	286500.0
2020-08-04	ABB-DELISTED	Stock	25.55	25.73	25.475	25.63	1576666.0
2020-08-04	ABBNY-DELISTED	Stock	25.55	25.73	25.475	25.64	1730585.0
2020-08-04	ABBV	Stock	95.92	96.03	94.06	94.29	7865100.0
2020-08-04	ABC-DELISTED	Stock	104.0	105.21	102.98	104.77	864789.0
2020-08-04	ABCB	Stock	23.46	23.52	22.8	23.24	233300.0
2020-08-04	ABEO	Stock	73.0	74.0	71.75	73.0	14428.0
2020-08-04	ABEV	Stock	2.56	2.59	2.5	2.53	39217300.0
2020-08-04	ABG	Stock	100.17	102.94	100.11	102.43	353000.0
2020-08-04	ABM	Stock	35.63	36.49	35.53	35.99	242000.0
2020-08-04	ABMD-DELISTED	Stock	308.93	310.969	302.83	305.73	247191.0
2020-08-04	ABR	Stock	10.81	10.91	10.68	10.72	2088700.0
2020-08-04	ABR.A-DELISTED	Stock	25.24	25.54	24.97	25.35	3142.0
2020-08-04	ABR.B-DELISTED	Stock	24.44	24.79	24.14	24.7225	16356.0
2020-08-04	ABR.C-DELISTED	Stock	25.75	25.9	25.37	25.85	4636.0
2020-08-04	ABT	Stock	100.16	100.68	99.28	99.93	2730600.0
2020-08-04	ABTC	Stock	201000.0	204000.0	198900.0	200400.0	1.4400000000000002
2020-08-04	ABTS	Stock	18.45	21.0	15.15	16.5	38447.0
2020-08-04	ABTX-DELISTED	Stock	23.93	24.22	23.62	24.0	25647.0

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

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