PREVIEW / stock_daily / 2018-05-02

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-02.parquet
  size:    217 KB
  rows:    6,482
  symbols: 2,813

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
2018-05-02	AAPL	Stock	43.8075	44.4375	43.45	44.1425	266157600.0
2018-05-02	MSFT	Stock	94.99	95.17	93.19	93.51	27471000.0
2018-05-02	NVDA	Stock	5.675	5.72	5.6313	5.6578	268248000.0
2018-05-02	AMZN	Stock	79.049	79.425	78.318	78.484	87206000.0
2018-05-02	GOOGL	Stock	51.7	52.199	51.158	51.3025	34697440.0
2018-05-02	META	Stock	174.25	178.08	174.2	176.07	30424500.0
2018-05-02	TSLA	Stock	19.9047	20.4567	19.852	20.0767	134556000.0
2018-05-02	TLT	Stock	118.64	118.8692	118.2599	118.28	4644051.0
2018-05-02	ES	Stock	59.71	59.99	59.34	59.69	1671400.0
2018-05-02	CL	Stock	64.74	64.85	63.02	63.14	7998900.0
2018-05-02	A	Stock	66.0	66.86	65.77	65.91	2240500.0
2018-05-02	AA	Stock	52.45	53.5	52.21	53.07	3375500.0
2018-05-02	AABA-DELISTED	Stock	70.12	71.39	70.03	70.2	5782246.0
2018-05-02	AAC-DELISTED	Stock	11.52	12.64	11.52	12.14	392911.0
2018-05-02	AACG	Stock	5.42	5.42	5.42	5.42	200.0
2018-05-02	AAIC-DELISTED	Stock	11.32	11.3866	11.21	11.28	454960.0
2018-05-02	AAL	Stock	43.23	43.41	42.19	42.24	6314400.0
2018-05-02	AAM.A-DELISTED	Stock	24.22	24.22	24.0601	24.14	14770.0
2018-05-02	AAM.B-DELISTED	Stock	24.1034	24.1355	24.02	24.12	60466.0
2018-05-02	AAMC-DELISTED	Stock	18.7794	18.7794	18.7794	18.7794	343.0
2018-05-02	AAME	Stock	3.18	3.3	3.18	3.3	1800.0
2018-05-02	AAMI	Stock	15.03	15.04	14.73	14.74	495200.0
2018-05-02	AAOI	Stock	32.04	32.4	30.217	30.75	1424600.0
2018-05-02	AAON	Stock	22.9	22.9	22.3667	22.5333	315900.0
2018-05-02	AAP	Stock	115.51	117.09	113.8	115.9	1113000.0
2018-05-02	AAT	Stock	33.29	33.59	32.54	33.03	265500.0
2018-05-02	AAU-DELISTED	Stock	0.83	0.83	0.81	0.82	44404.0
2018-05-02	AAUAF-DELISTED	Stock	0.83	0.83	0.81	0.82	46205.0
2018-05-02	AAV-DELISTED	Stock	3.1	3.3	3.1	3.25	138640.0
2018-05-02	AAWW-DELISTED	Stock	63.9	63.9	62.15	62.7	319389.0
2018-05-02	AAXJ	Stock	76.35	76.38	75.67	75.69	469086.0
2018-05-02	AAXN-DELISTED	Stock	41.77	42.8	41.77	41.99	1139941.0
2018-05-02	AB	Stock	27.15	27.28	26.9	27.0	337200.0
2018-05-02	ABAC-DELISTED	Stock	2.2565	2.36	2.23	2.36	1300.0
2018-05-02	ABAX-DELISTED	Stock	67.32	68.79	67.0	67.29	113530.0
2018-05-02	ABB-DELISTED	Stock	23.47	23.58	23.34	23.37	1286615.0
2018-05-02	ABBNY-DELISTED	Stock	23.47	23.58	23.34	23.38	1504902.0
2018-05-02	ABBV	Stock	101.17	101.76	99.96	100.37	7625600.0
2018-05-02	ABC-DELISTED	Stock	88.56	95.0	87.05	92.18	3069143.0
2018-05-02	ABCB	Stock	51.95	52.6	51.7	52.2	165300.0
2018-05-02	ABCD-DELISTED	Stock	10.0	10.14	9.79	10.08	267057.0
2018-05-02	ABDC-DELISTED	Stock	6.2	6.24	6.2	6.22	48734.0
2018-05-02	ABEO	Stock	427.5	480.0	426.25	466.25	32580.0
2018-05-02	ABEV	Stock	6.52	6.53	6.31	6.35	28087000.0
2018-05-02	ABG	Stock	68.5	70.05	67.9	69.2	158200.0
2018-05-02	ABIL-DELISTED	Stock	2.82	3.79	2.6781	3.0301	394738.0
2018-05-02	ABLX-DELISTED	Stock	53.67	53.67	53.33	53.38	183430.0
2018-05-02	ABM	Stock	30.63	30.66	30.39	30.49	854900.0
2018-05-02	ABMD-DELISTED	Stock	309.77	310.39	298.17	302.51	730569.0
2018-05-02	ABR	Stock	8.72	8.78	8.7	8.77	379300.0

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

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