PREVIEW / stock_daily / 2020-02-06

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-06.parquet
  size:    221 KB
  rows:    6,567
  symbols: 2,373

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-02-06	AAPL	Stock	80.6425	81.305	80.065	81.3025	105425600.0
2020-02-06	MSFT	Stock	180.97	183.82	180.06	183.63	27751400.0
2020-02-06	NVDA	Stock	6.3035	6.3562	6.222	6.3562	218284000.0
2020-02-06	AMZN	Stock	102.051	102.815	101.24	102.5115	63660000.0
2020-02-06	GOOGL	Stock	72.599	74.078	72.524	73.7985	37821580.0
2020-02-06	META	Stock	210.47	211.19	209.34	210.85	10567500.0
2020-02-06	TSLA	Stock	46.6613	53.0553	45.8	49.9307	598212000.0
2020-02-06	TLT	Stock	142.18	142.88	142.0	142.65	6683128.0
2020-02-06	ES	Stock	90.82	91.33	90.6	90.87	1286200.0
2020-02-06	CL	Stock	75.97	76.6	75.83	76.31	4663900.0
2020-02-06	A	Stock	85.31	85.39	84.58	84.82	835500.0
2020-02-06	AA	Stock	16.1	16.1	15.64	15.92	6281600.0
2020-02-06	AACG	Stock	1.16	1.16	1.13	1.14	12900.0
2020-02-06	AAIC-DELISTED	Stock	5.75	5.815	5.73	5.78	277716.0
2020-02-06	AAIC.C-DELISTED	Stock	22.8	22.8	22.55	22.55	12921.0
2020-02-06	AAL	Stock	29.26	29.45	28.14	28.3	8335800.0
2020-02-06	AAM.A-DELISTED	Stock	26.9	27.005	26.9	26.94	20571.0
2020-02-06	AAM.B-DELISTED	Stock	27.5	27.62	27.5	27.6	8611.0
2020-02-06	AAMC-DELISTED	Stock	3.8147	3.8147	3.8147	3.8147	850.0
2020-02-06	AAME	Stock	2.23	2.23	2.19	2.19	800.0
2020-02-06	AAMI	Stock	10.31	10.45	10.09	10.31	347600.0
2020-02-06	AAOI	Stock	12.11	12.14	11.58	11.58	668200.0
2020-02-06	AAON	Stock	36.26	36.4067	35.88	36.24	176550.0
2020-02-06	AAP	Stock	137.13	137.34	133.97	134.37	873000.0
2020-02-06	AAT	Stock	46.69	46.88	46.36	46.75	210400.0
2020-02-06	AAU-DELISTED	Stock	0.465	0.472	0.4644	0.4675	99261.0
2020-02-06	AAUAF-DELISTED	Stock	0.465	0.472	0.464	0.464	103616.0
2020-02-06	AAWW-DELISTED	Stock	25.01	25.56	24.5	24.64	364965.0
2020-02-06	AAXJ	Stock	72.79	72.95	72.365	72.45	805111.0
2020-02-06	AAXN-DELISTED	Stock	82.22	83.9	81.25	83.56	379096.0
2020-02-06	AB	Stock	34.45	34.58	34.22	34.36	273200.0
2020-02-06	ABB-DELISTED	Stock	24.9	24.96	24.69	24.72	2994756.0
2020-02-06	ABBNY-DELISTED	Stock	24.9	24.96	24.69	24.74	3137396.0
2020-02-06	ABBV	Stock	87.89	87.96	86.22	87.18	7769700.0
2020-02-06	ABC-DELISTED	Stock	92.12	93.76	91.55	92.49	1020669.0
2020-02-06	ABCB	Stock	42.56	42.66	41.6	41.69	205600.0
2020-02-06	ABEO	Stock	66.5	67.75	63.75	66.0	23724.0
2020-02-06	ABEV	Stock	4.07	4.07	3.89	3.89	27358200.0
2020-02-06	ABG	Stock	96.6	97.1	93.89	94.14	169300.0
2020-02-06	ABM	Stock	40.74	40.74	39.42	39.52	216900.0
2020-02-06	ABMD-DELISTED	Stock	175.33	199.26	171.15	196.01	1267049.0
2020-02-06	ABR	Stock	15.28	15.32	15.11	15.18	759900.0
2020-02-06	ABR.A-DELISTED	Stock	26.4689	26.47	26.3377	26.37	8168.0
2020-02-06	ABR.B-DELISTED	Stock	26.1295	26.18	26.12	26.18	1100.0
2020-02-06	ABR.C-DELISTED	Stock	26.78	26.8	26.7696	26.8	2741.0
2020-02-06	ABT	Stock	90.0	90.08	89.25	89.47	4270700.0
2020-02-06	ABTC	Stock	235800.0	236100.0	219300.0	219600.0	1.9333333333333333
2020-02-06	ABTS	Stock	33.75	34.35	27.3	28.44	1153.0
2020-02-06	ABTX-DELISTED	Stock	38.44	38.95	38.42	38.69	144488.0
2020-02-06	ABUS	Stock	3.31	3.34	3.1	3.2	607800.0

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

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