PREVIEW / stock_daily / 2019-03-15

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-15.parquet
  size:    221 KB
  rows:    6,533
  symbols: 2,614

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
2019-03-15	AAPL	Stock	46.2125	46.8325	45.935	46.53	156171600.0
2019-03-15	MSFT	Stock	115.34	117.25	114.59	115.91	54681100.0
2019-03-15	NVDA	Stock	4.1825	4.2883	4.179	4.2453	661484000.0
2019-03-15	AMZN	Stock	85.15	85.94	84.6565	85.618	151018000.0
2019-03-15	GOOGL	Stock	59.9	60.0862	59.3505	59.515	51866760.0
2019-03-15	META	Stock	167.16	167.58	162.51	165.98	37135400.0
2019-03-15	TSLA	Stock	18.9007	18.9147	18.2933	18.362	221782500.0
2019-03-15	TLT	Stock	121.74	121.95	121.4	121.75	4302045.0
2019-03-15	ES	Stock	70.56	71.96	70.56	71.73	6916700.0
2019-03-15	CL	Stock	66.36	67.21	66.2	67.2	6641100.0
2019-03-15	A	Stock	80.86	81.43	80.83	81.1	1999100.0
2019-03-15	AA	Stock	27.87	28.53	27.74	27.84	2936800.0
2019-03-15	AABA-DELISTED	Stock	73.82	73.98	73.36	73.71	5357232.0
2019-03-15	AAC-DELISTED	Stock	2.64	2.6834	2.37	2.48	356707.0
2019-03-15	AACG	Stock	1.06	1.08	1.04	1.04	30900.0
2019-03-15	AAIC-DELISTED	Stock	8.26	8.31	8.215	8.23	1659963.0
2019-03-15	AAIC.C-DELISTED	Stock	23.4356	23.55	23.4356	23.4615	11815.0
2019-03-15	AAL	Stock	32.28	32.35	31.42	31.43	9645100.0
2019-03-15	AAM.A-DELISTED	Stock	25.07	25.16	25.0585	25.1	40373.0
2019-03-15	AAM.B-DELISTED	Stock	24.86	25.04	24.8185	25.0	141452.0
2019-03-15	AAMC-DELISTED	Stock	10.7382	11.0206	9.87	11.0206	37533.0
2019-03-15	AAME	Stock	2.7	2.92	2.7	2.92	9200.0
2019-03-15	AAMI	Stock	13.49	13.52	13.36	13.42	971800.0
2019-03-15	AAOI	Stock	13.94	14.38	13.87	14.0	1412100.0
2019-03-15	AAON	Stock	27.5133	28.1933	27.5133	27.9533	383850.0
2019-03-15	AAP	Stock	153.64	154.99	151.04	154.84	1714100.0
2019-03-15	AAT	Stock	46.23	46.46	45.57	45.69	443600.0
2019-03-15	AAU-DELISTED	Stock	0.591	0.5991	0.5762	0.5791	171628.0
2019-03-15	AAUAF-DELISTED	Stock	0.591	0.5991	0.5762	0.5925	174221.0
2019-03-15	AAWW-DELISTED	Stock	50.55	51.43	49.49	49.59	325248.0
2019-03-15	AAXJ	Stock	70.06	70.39	69.98	70.33	776589.0
2019-03-15	AAXN-DELISTED	Stock	47.05	47.99	46.85	47.98	1317950.0
2019-03-15	AB	Stock	29.1	29.32	29.02	29.22	271500.0
2019-03-15	ABB-DELISTED	Stock	19.28	19.33	19.18	19.27	2263299.0
2019-03-15	ABBNY-DELISTED	Stock	19.28	19.33	19.18	19.27	2342963.0
2019-03-15	ABBV	Stock	80.06	81.46	79.11	81.34	12751100.0
2019-03-15	ABC-DELISTED	Stock	79.49	80.59	79.49	80.16	1535969.0
2019-03-15	ABCB	Stock	38.05	38.41	37.79	37.92	689000.0
2019-03-15	ABDC-DELISTED	Stock	7.69	7.69	7.53	7.59	16475.0
2019-03-15	ABEO	Stock	187.5	203.5	187.25	202.5	26284.0
2019-03-15	ABEV	Stock	4.33	4.36	4.27	4.32	53353200.0
2019-03-15	ABG	Stock	68.37	69.28	67.99	68.29	280300.0
2019-03-15	ABIL-DELISTED	Stock	1.98	2.05	1.88	2.0275	445666.0
2019-03-15	ABM	Stock	33.94	34.66	33.74	34.42	1080800.0
2019-03-15	ABMD-DELISTED	Stock	326.89	335.02	326.89	333.29	400653.0
2019-03-15	ABR	Stock	12.75	12.86	12.68	12.86	1968100.0
2019-03-15	ABR.A-DELISTED	Stock	25.79	25.79	25.7	25.739	1300.0
2019-03-15	ABR.C-DELISTED	Stock	25.84	25.84	25.5836	25.6468	2283.0
2019-03-15	ABT	Stock	79.03	80.15	78.92	79.86	11989400.0
2019-03-15	ABTC	Stock	303600.0	304500.0	303000.0	304500.0	0.48

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

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