PREVIEW / stock_daily / 2020-02-14

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-14.parquet
  size:    221 KB
  rows:    6,554
  symbols: 2,365

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-14	AAPL	Stock	81.185	81.495	80.7125	81.2375	80113600.0
2020-02-14	MSFT	Stock	183.25	185.41	182.65	185.35	23149500.0
2020-02-14	NVDA	Stock	7.1815	7.3743	7.15	7.2448	1041924000.0
2020-02-14	AMZN	Stock	107.784	107.952	106.2945	106.7435	52124000.0
2020-02-14	GOOGL	Stock	75.7265	76.0025	75.2775	75.9365	23197140.0
2020-02-14	META	Stock	214.0	214.93	212.65	214.18	10741700.0
2020-02-14	TSLA	Stock	52.4813	54.198	52.3667	53.3353	235405500.0
2020-02-14	TLT	Stock	144.76	145.08	144.45	144.55	7137363.0
2020-02-14	ES	Stock	92.79	93.81	92.79	93.66	1160300.0
2020-02-14	CL	Stock	76.36	76.7	76.11	76.69	2820400.0
2020-02-14	A	Stock	85.72	85.86	85.12	85.82	1965400.0
2020-02-14	AA	Stock	15.8	15.93	15.42	15.67	4292100.0
2020-02-14	AACG	Stock	1.1	1.24	1.06	1.15	77100.0
2020-02-14	AAIC-DELISTED	Stock	5.88	5.98	5.85	5.85	518369.0
2020-02-14	AAIC.C-DELISTED	Stock	22.56	22.6	22.49	22.6	6527.0
2020-02-14	AAL	Stock	30.01	30.27	29.14	29.2	5524800.0
2020-02-14	AAM.A-DELISTED	Stock	27.0144	27.09	26.98	26.98	5424.0
2020-02-14	AAM.B-DELISTED	Stock	27.7	27.8948	27.7	27.8948	13197.0
2020-02-14	AAMC-DELISTED	Stock	3.85	3.877	3.85	3.875	4410.0
2020-02-14	AAMI	Stock	10.23	10.45	10.2	10.24	292900.0
2020-02-14	AAOI	Stock	12.7	12.73	11.81	11.9	1006400.0
2020-02-14	AAON	Stock	37.6133	38.2267	37.54	38.0533	165300.0
2020-02-14	AAP	Stock	134.75	134.75	131.56	133.59	1122500.0
2020-02-14	AAT	Stock	46.15	46.68	45.93	46.67	859600.0
2020-02-14	AAU-DELISTED	Stock	0.4555	0.4599	0.4439	0.445	254352.0
2020-02-14	AAUAF-DELISTED	Stock	0.4555	0.4599	0.4439	0.445	265157.0
2020-02-14	AAWW-DELISTED	Stock	26.39	27.41	26.39	27.31	370355.0
2020-02-14	AAXJ	Stock	73.4	73.45	72.87	73.11	366997.0
2020-02-14	AAXN-DELISTED	Stock	87.86	88.44	86.7	87.1	503850.0
2020-02-14	AB	Stock	34.28	34.7	34.21	34.42	393000.0
2020-02-14	ABB-DELISTED	Stock	24.24	24.28	24.12	24.19	1246151.0
2020-02-14	ABBNY-DELISTED	Stock	24.24	24.28	24.12	24.19	1330653.0
2020-02-14	ABBV	Stock	95.23	95.3	93.77	94.05	11175800.0
2020-02-14	ABC-DELISTED	Stock	94.16	94.74	90.23	94.35	1323754.0
2020-02-14	ABCB	Stock	41.51	41.51	40.92	41.03	227800.0
2020-02-14	ABEO	Stock	77.25	80.0	75.5	79.25	35524.0
2020-02-14	ABEV	Stock	3.74	3.82	3.7	3.79	22475100.0
2020-02-14	ABG	Stock	97.28	97.4	95.15	95.7	133000.0
2020-02-14	ABM	Stock	39.2	39.3	38.74	38.87	199200.0
2020-02-14	ABMD-DELISTED	Stock	165.0	168.09	163.2	167.29	435808.0
2020-02-14	ABR	Stock	15.0	15.01	14.41	14.78	1592500.0
2020-02-14	ABR.A-DELISTED	Stock	26.14	26.4463	26.12	26.22	12490.0
2020-02-14	ABR.B-DELISTED	Stock	25.93	25.93	25.93	25.93	2300.0
2020-02-14	ABR.C-DELISTED	Stock	26.47	26.769	26.47	26.52	10546.0
2020-02-14	ABT	Stock	88.87	89.71	88.31	89.66	3919800.0
2020-02-14	ABTC	Stock	213900.0	224400.0	204900.0	212700.0	6.133333333333333
2020-02-14	ABTS	Stock	27.3	27.6	27.3	27.3	167.0
2020-02-14	ABTX-DELISTED	Stock	38.49	38.76	38.17	38.44	57538.0
2020-02-14	ABUS	Stock	3.32	3.43	3.28	3.35	1256400.0
2020-02-14	ACA	Stock	47.73	47.73	46.74	46.99	242373.0

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

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