PREVIEW / stock_daily / 2019-04-03

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-03.parquet
  size:    220 KB
  rows:    6,525
  symbols: 2,590

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-04-03	AAPL	Stock	48.3125	49.125	48.2875	48.8375	93087200.0
2019-04-03	MSFT	Stock	119.86	120.43	119.15	119.97	22860700.0
2019-04-03	NVDA	Stock	4.625	4.775	4.62	4.7155	783504000.0
2019-04-03	AMZN	Stock	91.336	91.5	90.481	91.035	78522000.0
2019-04-03	GOOGL	Stock	60.635	61.03	60.2538	60.5405	22192280.0
2019-04-03	META	Stock	174.5	177.96	172.95	173.54	27391100.0
2019-04-03	TSLA	Stock	19.1547	19.7447	19.1447	19.454	118791000.0
2019-04-03	TLT	Stock	123.61	123.87	123.37	123.52	10407417.0
2019-04-03	ES	Stock	70.06	70.79	69.99	70.51	1577500.0
2019-04-03	CL	Stock	68.22	68.27	67.57	67.82	3791300.0
2019-04-03	A	Stock	81.54	82.02	81.46	81.94	2141000.0
2019-04-03	AA	Stock	28.45	28.87	28.31	28.69	4675900.0
2019-04-03	AABA-DELISTED	Stock	72.85	73.74	72.38	72.76	21501118.0
2019-04-03	AAC-DELISTED	Stock	2.04	2.09	2.0001	2.06	87112.0
2019-04-03	AACG	Stock	1.0	1.0	0.99	0.99	16100.0
2019-04-03	AAIC-DELISTED	Stock	7.9	7.9092	7.79	7.83	498111.0
2019-04-03	AAIC.C-DELISTED	Stock	23.38	23.38	23.23	23.29	12010.0
2019-04-03	AAL	Stock	33.22	33.99	33.21	33.71	10014300.0
2019-04-03	AAM.A-DELISTED	Stock	24.9	24.9681	24.79	24.79	44280.0
2019-04-03	AAM.B-DELISTED	Stock	24.7	24.74	24.55	24.64	75840.0
2019-04-03	AAME	Stock	2.59	2.71	2.46	2.59	20900.0
2019-04-03	AAMI	Stock	13.83	13.94	13.76	13.85	286400.0
2019-04-03	AAOI	Stock	12.31	12.91	12.306	12.46	886500.0
2019-04-03	AAON	Stock	30.46	30.5467	30.1533	30.5333	128100.0
2019-04-03	AAP	Stock	174.08	174.8	171.42	171.69	847200.0
2019-04-03	AAT	Stock	46.44	46.74	45.89	46.38	239700.0
2019-04-03	AAU-DELISTED	Stock	0.58	0.5944	0.572	0.5864	151286.0
2019-04-03	AAUAF-DELISTED	Stock	0.58	0.5944	0.572	0.5864	159415.0
2019-04-03	AAWW-DELISTED	Stock	51.04	51.97	50.3	50.45	252330.0
2019-04-03	AAXJ	Stock	72.21	72.71	72.1473	72.27	4247163.0
2019-04-03	AAXN-DELISTED	Stock	54.68	55.72	54.44	55.39	220062.0
2019-04-03	AB	Stock	29.0	29.34	28.83	29.12	146900.0
2019-04-03	ABB-DELISTED	Stock	19.71	19.745	19.55	19.62	2044065.0
2019-04-03	ABBNY-DELISTED	Stock	19.71	19.745	19.55	19.61	2130331.0
2019-04-03	ABBV	Stock	83.62	84.73	82.79	83.08	6083500.0
2019-04-03	ABC-DELISTED	Stock	75.07	76.26	74.13	75.06	1669785.0
2019-04-03	ABCB	Stock	35.59	35.81	34.82	35.04	313000.0
2019-04-03	ABDC-DELISTED	Stock	7.51	7.6	7.5	7.57	46594.0
2019-04-03	ABEO	Stock	188.5	191.5	185.75	189.75	8672.0
2019-04-03	ABEV	Stock	4.39	4.46	4.34	4.36	20970100.0
2019-04-03	ABG	Stock	70.72	71.89	70.46	71.36	159300.0
2019-04-03	ABIL-DELISTED	Stock	1.67	1.7	1.65	1.6787	55120.0
2019-04-03	ABM	Stock	37.38	37.43	36.59	36.97	382400.0
2019-04-03	ABMD-DELISTED	Stock	286.86	288.47	283.91	285.15	428755.0
2019-04-03	ABR	Stock	13.27	13.37	13.18	13.32	893000.0
2019-04-03	ABR.A-DELISTED	Stock	25.85	25.85	25.836	25.85	1620.0
2019-04-03	ABR.B-DELISTED	Stock	25.77	25.77	25.6166	25.7	900.0
2019-04-03	ABR.C-DELISTED	Stock	26.1178	26.2881	25.982	25.982	2204.0
2019-04-03	ABT	Stock	79.97	80.0	79.15	79.5	3973700.0
2019-04-03	ABTC	Stock	302400.0	303600.0	302250.0	303000.0	1.2

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

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