PREVIEW / stock_daily / 2018-04-30

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-30.parquet
  size:    216 KB
  rows:    6,492
  symbols: 2,828

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-04-30	AAPL	Stock	40.5325	41.815	40.46	41.315	169709600.0
2018-04-30	MSFT	Stock	96.33	96.4	93.15	93.52	41523600.0
2018-04-30	NVDA	Stock	5.6748	5.725	5.603	5.6225	327844000.0
2018-04-30	AMZN	Stock	79.125	79.8	78.047	78.3065	109282000.0
2018-04-30	GOOGL	Stock	51.721	51.9185	50.915	50.929	34492640.0
2018-04-30	META	Stock	173.79	175.72	171.71	172.0	20750500.0
2018-04-30	TSLA	Stock	19.574	19.9153	19.5	19.5933	63423000.0
2018-04-30	TLT	Stock	119.08	119.56	118.94	119.1	8321071.0
2018-04-30	ES	Stock	60.59	60.87	60.13	60.25	2872500.0
2018-04-30	CL	Stock	65.92	66.15	64.99	65.23	7395300.0
2018-04-30	A	Stock	66.49	66.66	65.73	65.74	2277700.0
2018-04-30	AA	Stock	51.4	51.87	51.05	51.2	2749800.0
2018-04-30	AABA-DELISTED	Stock	70.2	70.8	69.44	70.09	5094875.0
2018-04-30	AAC-DELISTED	Stock	11.1	11.39	10.82	11.315	95816.0
2018-04-30	AACG	Stock	5.18	5.18	5.18	5.18	300.0
2018-04-30	AAIC-DELISTED	Stock	11.5	11.52	11.43	11.44	582184.0
2018-04-30	AAL	Stock	43.5	43.81	42.76	42.93	6472900.0
2018-04-30	AAM.A-DELISTED	Stock	24.34	24.34	24.15	24.2399	25062.0
2018-04-30	AAM.B-DELISTED	Stock	24.24	24.25	24.17	24.2	151074.0
2018-04-30	AAMC-DELISTED	Stock	18.2353	19.7059	18.2353	19.4118	7864.0
2018-04-30	AAME	Stock	3.25	3.25	3.25	3.25	600.0
2018-04-30	AAMI	Stock	15.38	15.5	15.16	15.17	558000.0
2018-04-30	AAOI	Stock	33.76	33.9	31.5	31.96	1382200.0
2018-04-30	AAON	Stock	23.5333	23.9333	22.6667	22.6667	408450.0
2018-04-30	AAP	Stock	116.46	116.68	113.86	114.45	1057400.0
2018-04-30	AAT	Stock	34.11	34.2	33.55	33.57	241400.0
2018-04-30	AAU-DELISTED	Stock	0.81	0.83	0.81	0.8152	130525.0
2018-04-30	AAUAF-DELISTED	Stock	0.81	0.83	0.81	0.8152	132956.0
2018-04-30	AAV-DELISTED	Stock	3.2	3.2865	3.1695	3.175	125050.0
2018-04-30	AAWW-DELISTED	Stock	63.2	63.85	63.0	63.45	137475.0
2018-04-30	AAXJ	Stock	77.04	77.08	76.25	76.25	782714.0
2018-04-30	AAXN-DELISTED	Stock	41.79	42.44	41.6	41.97	364076.0
2018-04-30	AB	Stock	27.0	27.4	26.95	27.2	275600.0
2018-04-30	ABAC-DELISTED	Stock	2.2	2.38	2.2	2.24	7964.0
2018-04-30	ABAX-DELISTED	Stock	66.51	67.54	65.315	66.57	181242.0
2018-04-30	ABB-DELISTED	Stock	23.27	23.46	23.235	23.265	1444920.0
2018-04-30	ABBNY-DELISTED	Stock	23.27	23.46	23.235	23.27	1534196.0
2018-04-30	ABBV	Stock	99.05	99.42	96.52	96.55	7449400.0
2018-04-30	ABC-DELISTED	Stock	93.28	93.28	90.53	90.58	956286.0
2018-04-30	ABCB	Stock	52.65	52.9	51.7	51.7	118400.0
2018-04-30	ABCD-DELISTED	Stock	9.91	10.3	9.91	10.15	194319.0
2018-04-30	ABDC-DELISTED	Stock	6.205	6.205	6.15	6.16	29257.0
2018-04-30	ABEO	Stock	442.5	461.25	435.75	436.25	22564.0
2018-04-30	ABEV	Stock	6.67	6.72	6.61	6.62	11801500.0
2018-04-30	ABG	Stock	69.05	69.4	67.0	67.05	144400.0
2018-04-30	ABIL-DELISTED	Stock	2.68	2.86	2.55	2.63	64925.0
2018-04-30	ABLX-DELISTED	Stock	53.95	54.04	53.28	53.79	659583.0
2018-04-30	ABM	Stock	31.42	31.56	31.07	31.13	1942000.0
2018-04-30	ABMD-DELISTED	Stock	303.28	308.74	300.85	300.91	361929.0
2018-04-30	ABR	Stock	8.8	8.81	8.72	8.76	369200.0

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

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