PREVIEW / stock_daily / 2020-08-11

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-11.parquet
  size:    225 KB
  rows:    6,772
  symbols: 2,403

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-11	AAPL	Stock	111.97	112.4825	109.1075	109.375	187902400.0
2020-08-11	MSFT	Stock	207.16	207.65	203.14	203.38	36446500.0
2020-08-11	NVDA	Stock	11.0738	11.1368	10.7958	10.85	354512000.0
2020-08-11	AMZN	Stock	155.66	157.961	153.65	154.0335	74362000.0
2020-08-11	GOOGL	Stock	74.7	75.522	73.9095	74.027	31097060.0
2020-08-11	META	Stock	260.19	265.92	255.13	256.13	28238300.0
2020-08-11	TSLA	Stock	93.0667	94.6667	91.0	91.626	129387000.0
2020-08-11	TLT	Stock	167.17	167.49	165.875	167.105	19234202.0
2020-08-11	ES	Stock	88.48	88.69	85.9	86.09	1323900.0
2020-08-11	CL	Stock	76.71	76.95	75.81	75.96	3398400.0
2020-08-11	A	Stock	97.22	97.63	96.2	96.3	1137000.0
2020-08-11	AA	Stock	16.02	16.07	14.83	14.89	7744500.0
2020-08-11	AACG	Stock	1.16	1.28	1.15	1.15	34200.0
2020-08-11	AACQU-DELISTED	Stock	10.1	10.15	10.0699	10.15	303679.0
2020-08-11	AAIC-DELISTED	Stock	2.85	2.97	2.805	2.81	335868.0
2020-08-11	AAIC.C-DELISTED	Stock	19.05	19.31	19.0	19.01	4940.0
2020-08-11	AAL	Stock	15.02	15.1	13.55	13.73	127879300.0
2020-08-11	AAM.A-DELISTED	Stock	26.8755	27.01	26.8755	26.9872	2675.0
2020-08-11	AAM.B-DELISTED	Stock	27.47	27.526	27.31	27.32	15781.0
2020-08-11	AAMC-DELISTED	Stock	3.6912	4.1912	3.6912	4.1912	30641.0
2020-08-11	AAME	Stock	1.76	2.6	1.76	1.9	94500.0
2020-08-11	AAMI	Stock	13.77	13.915	13.52	13.58	499600.0
2020-08-11	AAOI	Stock	14.0	14.54	13.45	13.57	1293000.0
2020-08-11	AAON	Stock	40.0	40.64	39.8667	40.0133	343650.0
2020-08-11	AAP	Stock	155.0	155.44	151.79	151.94	764800.0
2020-08-11	AAT	Stock	28.43	28.71	27.8	27.84	548200.0
2020-08-11	AAU-DELISTED	Stock	0.7	0.7102	0.6682	0.6701	739028.0
2020-08-11	AAUAF-DELISTED	Stock	0.7	0.7102	0.6682	0.685	780456.0
2020-08-11	AAWW-DELISTED	Stock	59.9	61.2	59.29	59.83	383235.0
2020-08-11	AAXJ	Stock	76.7	76.88	75.975	76.03	1507493.0
2020-08-11	AAXN-DELISTED	Stock	83.5	83.5	79.12	79.14	697843.0
2020-08-11	AB	Stock	28.51	28.83	28.43	28.54	239200.0
2020-08-11	ABB-DELISTED	Stock	26.28	26.43	25.96	25.97	1181823.0
2020-08-11	ABBNY-DELISTED	Stock	26.28	26.43	25.96	25.97	1264573.0
2020-08-11	ABBV	Stock	92.31	93.29	92.13	92.67	7208400.0
2020-08-11	ABC-DELISTED	Stock	103.45	103.9	101.06	101.39	501403.0
2020-08-11	ABCB	Stock	27.0	27.81	26.46	26.78	327200.0
2020-08-11	ABEO	Stock	75.25	78.75	71.75	72.75	38404.0
2020-08-11	ABEV	Stock	2.47	2.53	2.46	2.48	33715100.0
2020-08-11	ABG	Stock	103.13	108.08	102.12	105.46	261600.0
2020-08-11	ABM	Stock	39.81	40.21	38.89	39.08	398400.0
2020-08-11	ABMD-DELISTED	Stock	300.01	302.05	294.09	294.91	298391.0
2020-08-11	ABR	Stock	12.0	12.04	11.62	11.66	1912600.0
2020-08-11	ABR.A-DELISTED	Stock	26.02	26.22	25.56	26.21	3385.0
2020-08-11	ABR.B-DELISTED	Stock	25.325	25.3768	25.225	25.3768	1639.0
2020-08-11	ABR.C-DELISTED	Stock	26.4	26.675	26.265	26.265	8580.0
2020-08-11	ABT	Stock	100.43	100.43	98.67	99.06	4823000.0
2020-08-11	ABTC	Stock	195900.0	198000.0	185400.0	186300.0	1.3066666666666666
2020-08-11	ABTS	Stock	18.75	22.95	18.75	22.5	75927.0
2020-08-11	ABTX-DELISTED	Stock	27.68	27.81	26.98	27.25	29787.0

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

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