PREVIEW / stock_daily / 2020-02-12

all stock daily files

  file:    by_date/stock_daily/2020/2020-02-12.parquet
  size:    221 KB
  rows:    6,564
  symbols: 2,372

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-12	AAPL	Stock	80.3675	81.805	80.3675	81.8	113730400.0
2020-02-12	MSFT	Stock	185.58	185.85	181.85	184.71	47062900.0
2020-02-12	NVDA	Stock	6.7502	6.82	6.7112	6.8135	374644000.0
2020-02-12	AMZN	Stock	108.16	109.0125	107.7645	108.0	66686000.0
2020-02-12	GOOGL	Stock	75.793	76.015	75.4335	75.9315	31042720.0
2020-02-12	META	Stock	207.85	211.22	207.4	210.76	13813700.0
2020-02-12	TSLA	Stock	51.858	52.65	50.8913	51.1527	180337500.0
2020-02-12	TLT	Stock	143.37	143.55	142.99	143.37	5595525.0
2020-02-12	ES	Stock	90.78	91.68	90.62	91.26	1267100.0
2020-02-12	CL	Stock	76.21	76.32	75.5	75.95	3735400.0
2020-02-12	A	Stock	85.4	86.06	85.29	85.43	1464200.0
2020-02-12	AA	Stock	15.96	16.205	15.61	15.76	3894700.0
2020-02-12	AACG	Stock	1.03	1.05	1.03	1.05	9500.0
2020-02-12	AAIC-DELISTED	Stock	5.84	5.93	5.81	5.83	335023.0
2020-02-12	AAIC.C-DELISTED	Stock	22.63	22.6482	22.56	22.5794	5441.0
2020-02-12	AAL	Stock	30.0	30.78	29.99	30.47	9315400.0
2020-02-12	AAM.A-DELISTED	Stock	27.04	27.05	26.94	26.94	10353.0
2020-02-12	AAM.B-DELISTED	Stock	27.7	27.7831	27.63	27.72	18442.0
2020-02-12	AAMC-DELISTED	Stock	3.7765	3.8176	3.7574	3.7882	58456.0
2020-02-12	AAME	Stock	1.98	1.98	1.98	1.98	200.0
2020-02-12	AAMI	Stock	10.41	10.56	10.09	10.22	409000.0
2020-02-12	AAOI	Stock	11.6	12.48	11.5	12.46	995200.0
2020-02-12	AAON	Stock	36.9667	37.3333	36.4	37.1133	205500.0
2020-02-12	AAP	Stock	132.89	134.79	132.54	134.32	595100.0
2020-02-12	AAT	Stock	45.34	46.18	44.64	46.18	808100.0
2020-02-12	AAU-DELISTED	Stock	0.45	0.45	0.433	0.433	188782.0
2020-02-12	AAUAF-DELISTED	Stock	0.45	0.45	0.433	0.433	195748.0
2020-02-12	AAWW-DELISTED	Stock	27.1	27.86	27.03	27.47	263044.0
2020-02-12	AAXJ	Stock	73.69	74.05	73.53	73.99	771260.0
2020-02-12	AAXN-DELISTED	Stock	87.77	88.23	86.435	87.98	525238.0
2020-02-12	AB	Stock	34.9	35.42	33.82	35.02	646200.0
2020-02-12	ABB-DELISTED	Stock	24.73	24.78	24.66	24.73	1434779.0
2020-02-12	ABBNY-DELISTED	Stock	24.73	24.78	24.66	24.74	1508772.0
2020-02-12	ABBV	Stock	95.98	97.86	95.71	97.79	10591000.0
2020-02-12	ABC-DELISTED	Stock	95.0	97.5	94.04	95.77	1041643.0
2020-02-12	ABCB	Stock	41.7	41.88	41.03	41.15	167600.0
2020-02-12	ABEO	Stock	81.0	86.25	73.0	79.25	92956.0
2020-02-12	ABEV	Stock	3.79	3.85	3.76	3.77	52346900.0
2020-02-12	ABG	Stock	100.49	100.91	92.9	97.01	323400.0
2020-02-12	ABM	Stock	39.35	39.35	38.71	39.19	222100.0
2020-02-12	ABMD-DELISTED	Stock	169.09	172.35	166.25	166.95	1298718.0
2020-02-12	ABR	Stock	14.91	15.03	14.87	14.9	614900.0
2020-02-12	ABR.A-DELISTED	Stock	26.5157	26.71	26.5157	26.6843	3600.0
2020-02-12	ABR.B-DELISTED	Stock	26.2426	26.34	26.2426	26.3272	1815.0
2020-02-12	ABR.C-DELISTED	Stock	26.7	27.15	26.7	27.15	2100.0
2020-02-12	ABT	Stock	89.56	89.59	88.58	88.79	3389400.0
2020-02-12	ABTC	Stock	236400.0	252000.0	230400.0	248700.0	7.066666666666666
2020-02-12	ABTS	Stock	27.3	29.88	27.3	29.055	200.0
2020-02-12	ABTX-DELISTED	Stock	38.45	38.5	38.09	38.24	77466.0
2020-02-12	ABUS	Stock	3.07	3.25	3.05	3.15	754300.0

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

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