PREVIEW / stock_daily / 2020-08-24

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-24.parquet
  size:    224 KB
  rows:    6,802
  symbols: 2,414

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-24	AAPL	Stock	128.6975	128.785	123.9375	125.8575	345937600.0
2020-08-24	MSFT	Stock	214.79	215.52	212.43	213.69	25460100.0
2020-08-24	NVDA	Stock	12.8838	12.9125	12.5075	12.7202	490564000.0
2020-08-24	AMZN	Stock	165.5075	169.016	162.878	165.373	93326000.0
2020-08-24	GOOGL	Stock	79.6235	80.439	78.752	79.2575	25637860.0
2020-08-24	META	Stock	271.07	277.25	268.77	271.39	23685600.0
2020-08-24	TSLA	Stock	141.752	141.9333	128.5013	134.28	300954000.0
2020-08-24	TLT	Stock	166.32	166.97	165.86	165.93	6490666.0
2020-08-24	ES	Stock	85.79	86.45	84.4	85.88	1503400.0
2020-08-24	CL	Stock	78.81	79.19	78.63	79.13	2796800.0
2020-08-24	A	Stock	98.78	99.21	97.14	97.6	1154500.0
2020-08-24	AA	Stock	14.85	15.13	14.7	15.12	3171200.0
2020-08-24	AACG	Stock	1.1	1.17	1.08	1.08	27600.0
2020-08-24	AACQU-DELISTED	Stock	10.1	10.1	10.0	10.01	274684.0
2020-08-24	AAIC-DELISTED	Stock	2.74	2.83	2.7	2.81	185710.0
2020-08-24	AAIC.C-DELISTED	Stock	19.42	19.42	19.4	19.4	406.0
2020-08-24	AAL	Stock	12.44	13.48	12.27	13.44	102685700.0
2020-08-24	AAM.A-DELISTED	Stock	26.96	26.96	26.72	26.8	9836.0
2020-08-24	AAM.B-DELISTED	Stock	27.41	27.425	27.3	27.335	8901.0
2020-08-24	AAMC-DELISTED	Stock	5.6971	5.9294	5.4294	5.4294	29366.0
2020-08-24	AAME	Stock	2.03	2.03	1.87	2.0	41100.0
2020-08-24	AAMI	Stock	13.6	13.9	13.5	13.77	613300.0
2020-08-24	AAOI	Stock	11.74	12.08	11.64	11.65	827500.0
2020-08-24	AAON	Stock	39.5	39.5	38.7733	39.12	210900.0
2020-08-24	AAP	Stock	156.98	157.97	154.52	157.14	636500.0
2020-08-24	AAT	Stock	25.05	25.83	24.7	25.77	496500.0
2020-08-24	AAU-DELISTED	Stock	0.71	0.71	0.61	0.6618	751185.0
2020-08-24	AAUAF-DELISTED	Stock	0.71	0.71	0.61	0.6768	781047.0
2020-08-24	AAWW-DELISTED	Stock	58.24	58.49	56.96	57.43	347879.0
2020-08-24	AAXJ	Stock	78.1	78.23	77.58	77.91	1029693.0
2020-08-24	AAXN-DELISTED	Stock	83.66	84.14	81.68	83.24	618616.0
2020-08-24	AB	Stock	28.9	29.22	28.66	29.03	217100.0
2020-08-24	ABB-DELISTED	Stock	26.17	26.17	25.95	26.04	1011966.0
2020-08-24	ABBNY-DELISTED	Stock	26.16	26.17	25.95	26.05	1070286.0
2020-08-24	ABBV	Stock	94.9	95.24	94.18	94.51	4103600.0
2020-08-24	ABC-DELISTED	Stock	99.31	99.31	96.265	97.6	656701.0
2020-08-24	ABCB	Stock	24.02	25.16	23.73	25.04	222000.0
2020-08-24	ABEO	Stock	61.75	62.5	57.25	59.75	30924.0
2020-08-24	ABEV	Stock	2.33	2.35	2.3	2.33	11774200.0
2020-08-24	ABG	Stock	105.01	105.01	102.63	104.55	163000.0
2020-08-24	ABM	Stock	37.58	38.03	37.06	37.99	453800.0
2020-08-24	ABMD-DELISTED	Stock	308.99	313.095	303.15	304.45	188384.0
2020-08-24	ABR	Stock	11.17	11.55	11.06	11.49	1239800.0
2020-08-24	ABR.A-DELISTED	Stock	25.18	25.326	25.17	25.326	3540.0
2020-08-24	ABR.B-DELISTED	Stock	25.0	25.0	24.92	24.94	4270.0
2020-08-24	ABR.C-DELISTED	Stock	25.52	25.59	25.52	25.5459	2160.0
2020-08-24	ABT	Stock	102.7	103.23	100.7	101.39	3212700.0
2020-08-24	ABTC	Stock	177600.0	183150.0	174300.0	177900.0	1.2266666666666666
2020-08-24	ABTS	Stock	28.8	30.0	26.1	28.5	35460.0
2020-08-24	ABTX-DELISTED	Stock	25.02	26.03	24.27	25.94	36320.0

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

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