PREVIEW / stock_daily / 2019-02-21

all stock daily files

  file:    by_date/stock_daily/2019/2019-02-21.parquet
  size:    220 KB
  rows:    6,524
  symbols: 2,612

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-02-21	AAPL	Stock	42.95	43.0925	42.575	42.765	68998800.0
2019-02-21	MSFT	Stock	106.9	109.48	106.87	109.41	29063200.0
2019-02-21	NVDA	Stock	3.9765	4.0013	3.8795	3.8943	448548000.0
2019-02-21	AMZN	Stock	80.9925	81.178	80.0455	80.972	69668000.0
2019-02-21	GOOGL	Stock	55.939	55.9575	54.899	55.2105	33279600.0
2019-02-21	META	Stock	161.93	162.24	159.59	160.04	15607800.0
2019-02-21	TSLA	Stock	20.1207	20.216	19.3667	19.4153	133638000.0
2019-02-21	TLT	Stock	121.07	121.16	120.7	120.85	7382942.0
2019-02-21	ES	Stock	70.0	70.57	69.48	70.53	3050100.0
2019-02-21	CL	Stock	66.47	66.93	66.25	66.7	3765600.0
2019-02-21	A	Stock	77.67	78.58	76.5	77.89	3570800.0
2019-02-21	AA	Stock	29.2	29.9	29.13	29.58	3983900.0
2019-02-21	AABA-DELISTED	Stock	69.58	70.03	69.17	69.81	4813644.0
2019-02-21	AAC-DELISTED	Stock	3.12	3.15	2.872	2.93	313574.0
2019-02-21	AACG	Stock	1.08	1.11	1.05	1.08	27700.0
2019-02-21	AAIC-DELISTED	Stock	8.11	8.27	8.1	8.2	1066424.0
2019-02-21	AAL	Stock	34.98	35.51	34.83	34.98	5900700.0
2019-02-21	AAM.A-DELISTED	Stock	24.95	24.9899	24.9	24.96	22254.0
2019-02-21	AAM.B-DELISTED	Stock	24.73	24.73	24.6	24.65	29607.0
2019-02-21	AAMC-DELISTED	Stock	10.025	10.4382	9.8441	10.2941	21009.0
2019-02-21	AAME	Stock	2.63	2.63	2.63	2.63	100.0
2019-02-21	AAMI	Stock	13.94	14.1	13.77	13.97	523900.0
2019-02-21	AAOI	Stock	14.78	15.1	14.24	14.6	2179700.0
2019-02-21	AAON	Stock	27.2333	27.6	26.8	27.6	140250.0
2019-02-21	AAP	Stock	166.21	166.21	160.2	161.31	1616300.0
2019-02-21	AAT	Stock	43.35	43.67	43.0	43.56	105700.0
2019-02-21	AAU-DELISTED	Stock	0.72	0.7432	0.702	0.72	110282.0
2019-02-21	AAUAF-DELISTED	Stock	0.72	0.7432	0.702	0.7259	114962.0
2019-02-21	AAWW-DELISTED	Stock	60.69	60.72	59.17	59.45	205504.0
2019-02-21	AAXJ	Stock	69.37	69.45	69.03	69.25	1464658.0
2019-02-21	AAXN-DELISTED	Stock	55.98	56.1799	55.25	55.51	237450.0
2019-02-21	AB	Stock	30.33	30.56	30.25	30.47	437700.0
2019-02-21	ABB-DELISTED	Stock	20.14	20.295	20.13	20.21	4931742.0
2019-02-21	ABBNY-DELISTED	Stock	20.14	20.295	20.13	20.22	5011085.0
2019-02-21	ABBV	Stock	79.74	79.91	78.1	78.75	6360800.0
2019-02-21	ABC-DELISTED	Stock	86.35	86.4	84.53	84.98	582323.0
2019-02-21	ABCB	Stock	41.2	41.2	40.21	40.67	224900.0
2019-02-21	ABDC-DELISTED	Stock	7.13	7.13	6.91	6.96	45164.0
2019-02-21	ABEO	Stock	163.75	164.0	158.75	159.5	7640.0
2019-02-21	ABEV	Stock	4.82	4.87	4.77	4.87	24121200.0
2019-02-21	ABG	Stock	72.95	73.09	70.5	71.0	158700.0
2019-02-21	ABIL-DELISTED	Stock	1.96	1.9799	1.87	1.9435	94890.0
2019-02-21	ABM	Stock	36.72	36.8	36.3	36.68	282100.0
2019-02-21	ABMD-DELISTED	Stock	362.02	362.02	356.67	358.46	188929.0
2019-02-21	ABR	Stock	12.8	12.91	12.72	12.91	1603500.0
2019-02-21	ABR.A-DELISTED	Stock	25.39	25.39	25.2601	25.2601	1060.0
2019-02-21	ABR.B-DELISTED	Stock	25.5494	25.75	25.24	25.24	900.0
2019-02-21	ABR.C-DELISTED	Stock	25.4	25.43	25.3978	25.42	3820.0
2019-02-21	ABT	Stock	75.11	75.47	74.66	75.14	5607000.0
2019-02-21	ABTC	Stock	304800.0	304800.0	303000.0	304170.0	0.9733333333333333

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

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