PREVIEW / stock_daily / 2020-09-03

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-03.parquet
  size:    226 KB
  rows:    6,834
  symbols: 2,435

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-09-03	AAPL	Stock	126.91	128.84	120.5	120.88	257599600.0
2020-09-03	MSFT	Stock	229.27	229.31	214.96	217.3	58400300.0
2020-09-03	NVDA	Stock	13.8288	13.8845	12.8788	13.0155	945128000.0
2020-09-03	AMZN	Stock	174.25	174.4205	165.15	168.4	163222000.0
2020-09-03	GOOGL	Stock	84.976	85.0	80.3855	81.4755	63725740.0
2020-09-03	META	Stock	295.99	297.6	283.63	291.12	32294100.0
2020-09-03	TSLA	Stock	135.7433	143.9333	134.0	135.6667	262788300.0
2020-09-03	TLT	Stock	165.75	167.24	165.44	165.89	16416624.0
2020-09-03	ES	Stock	86.63	87.66	85.24	86.08	1197300.0
2020-09-03	CL	Stock	79.62	80.1	77.08	77.67	4486600.0
2020-09-03	A	Stock	103.09	103.21	99.04	99.64	1992800.0
2020-09-03	AA	Stock	14.53	14.78	14.01	14.23	3930800.0
2020-09-03	AACG	Stock	1.13	1.15	1.06	1.11	32100.0
2020-09-03	AACQU-DELISTED	Stock	10.1574	10.2	10.06	10.06	199903.0
2020-09-03	AAIC-DELISTED	Stock	2.76	2.7827	2.69	2.72	170893.0
2020-09-03	AAIC.C-DELISTED	Stock	19.2753	19.31	19.2753	19.31	657.0
2020-09-03	AAL	Stock	13.4	14.07	13.03	13.36	86390800.0
2020-09-03	AAM.A-DELISTED	Stock	26.48	26.72	26.48	26.61	4827.0
2020-09-03	AAM.B-DELISTED	Stock	27.06	27.22	27.0	27.22	7343.0
2020-09-03	AAMC-DELISTED	Stock	6.3206	6.8838	5.2941	5.9029	154867.0
2020-09-03	AAME	Stock	2.03	2.03	2.0	2.0	2800.0
2020-09-03	AAMI	Stock	14.24	14.27	13.57	13.67	493300.0
2020-09-03	AAOI	Stock	12.41	12.41	10.51	10.95	1604400.0
2020-09-03	AAON	Stock	38.56	38.6667	37.6933	38.0	249300.0
2020-09-03	AAP	Stock	158.0	158.55	154.31	155.18	591100.0
2020-09-03	AAT	Stock	25.86	26.66	25.86	26.04	357700.0
2020-09-03	AAU-DELISTED	Stock	0.69	0.7	0.6538	0.6684	316030.0
2020-09-03	AAUAF-DELISTED	Stock	0.69	0.7	0.6538	0.6726	324069.0
2020-09-03	AAWW-DELISTED	Stock	56.67	56.85	55.05	55.3	190085.0
2020-09-03	AAXJ	Stock	78.45	78.45	76.875	77.37	1772717.0
2020-09-03	AAXN-DELISTED	Stock	87.52	87.5995	83.395	84.58	389030.0
2020-09-03	AB	Stock	28.8	28.97	28.17	28.34	356900.0
2020-09-03	ABB-DELISTED	Stock	25.74	25.7401	25.13	25.27	2849487.0
2020-09-03	ABBNY-DELISTED	Stock	25.74	25.7401	25.13	25.27	2977845.0
2020-09-03	ABBV	Stock	93.88	94.31	91.09	91.87	8921900.0
2020-09-03	ABC-DELISTED	Stock	98.77	100.09	96.69	97.58	923455.0
2020-09-03	ABCB	Stock	24.8	25.76	24.61	24.72	217500.0
2020-09-03	ABEO	Stock	54.25	55.75	50.5	51.25	40560.0
2020-09-03	ABEV	Stock	2.42	2.49	2.37	2.41	27628800.0
2020-09-03	ABG	Stock	109.23	110.31	104.15	105.98	190700.0
2020-09-03	ABM	Stock	38.47	39.62	37.61	37.76	242600.0
2020-09-03	ABMD-DELISTED	Stock	311.51	312.0	291.205	294.0	249237.0
2020-09-03	ABR	Stock	11.36	11.56	10.97	11.26	1357200.0
2020-09-03	ABR.A-DELISTED	Stock	25.18	25.18	25.02	25.04	2615.0
2020-09-03	ABR.B-DELISTED	Stock	25.48	25.51	25.0757	25.0757	1200.0
2020-09-03	ABR.C-DELISTED	Stock	25.43	25.52	25.43	25.47	1600.0
2020-09-03	ABT	Stock	108.7	108.94	104.3	105.53	6096900.0
2020-09-03	ABTC	Stock	153900.0	154200.0	145200.0	146400.0	2.6266666666666665
2020-09-03	ABTS	Stock	33.3	33.45	31.5	33.15	21460.0
2020-09-03	ABTX-DELISTED	Stock	25.58	25.95	25.03	25.31	45788.0

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

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