PREVIEW / stock_daily / 2018-04-23

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-23.parquet
  size:    215 KB
  rows:    6,470
  symbols: 2,822

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-23	AAPL	Stock	41.7075	41.73	41.0225	41.31	146062000.0
2018-04-23	MSFT	Stock	95.74	96.29	94.63	95.35	22331800.0
2018-04-23	NVDA	Stock	5.7358	5.7875	5.5708	5.597	427508000.0
2018-04-23	AMZN	Stock	77.3345	77.4	75.1705	75.893	89308000.0
2018-04-23	GOOGL	Stock	54.149	54.4	53.334	53.6905	69589920.0
2018-04-23	META	Stock	167.27	168.45	165.09	165.84	23088100.0
2018-04-23	TSLA	Stock	19.4193	19.4413	18.822	18.8913	73401000.0
2018-04-23	TLT	Stock	118.33	118.62	118.08	118.49	7073216.0
2018-04-23	ES	Stock	59.37	59.79	58.91	59.21	1288000.0
2018-04-23	CL	Stock	67.2	67.35	66.01	66.37	7617300.0
2018-04-23	A	Stock	67.71	68.67	67.53	68.07	2260600.0
2018-04-23	AA	Stock	54.56	54.91	51.5	51.9	13132500.0
2018-04-23	AABA-DELISTED	Stock	71.14	71.19	69.68	69.84	15584007.0
2018-04-23	AAC-DELISTED	Stock	11.07	11.31	10.86	11.1	57953.0
2018-04-23	AACG	Stock	5.25	5.44	5.15	5.19	9400.0
2018-04-23	AAIC-DELISTED	Stock	11.16	11.279	11.07	11.13	432919.0
2018-04-23	AAL	Stock	46.85	47.19	46.12	46.68	4221700.0
2018-04-23	AAM.A-DELISTED	Stock	24.44	24.499	24.21	24.36	41691.0
2018-04-23	AAM.B-DELISTED	Stock	24.34	24.47	24.23	24.28	51485.0
2018-04-23	AAMC-DELISTED	Stock	17.2059	17.6471	16.7647	17.0294	36468.0
2018-04-23	AAME	Stock	3.15	3.25	3.15	3.25	1800.0
2018-04-23	AAMI	Stock	15.03	15.03	14.85	14.92	428600.0
2018-04-23	AAOI	Stock	32.84	33.47	31.37	32.46	1880200.0
2018-04-23	AAON	Stock	24.0333	24.4333	24.0333	24.1667	239250.0
2018-04-23	AAP	Stock	103.26	105.6	102.15	105.52	1029500.0
2018-04-23	AAT	Stock	32.9	32.9	32.33	32.45	226800.0
2018-04-23	AAU-DELISTED	Stock	0.83	0.8497	0.81	0.8149	58874.0
2018-04-23	AAUAF-DELISTED	Stock	0.83	0.8497	0.81	0.8197	62967.0
2018-04-23	AAV-DELISTED	Stock	3.1	3.25	3.0	3.2	165566.0
2018-04-23	AAWW-DELISTED	Stock	64.0	64.15	63.1852	63.65	69776.0
2018-04-23	AAXJ	Stock	76.19	76.38	75.69	75.89	446787.0
2018-04-23	AAXN-DELISTED	Stock	43.06	43.43	42.45	42.73	868835.0
2018-04-23	AB	Stock	26.2	26.45	26.0	26.25	263800.0
2018-04-23	ABAX-DELISTED	Stock	72.8	73.4125	72.16	72.46	97763.0
2018-04-23	ABB-DELISTED	Stock	24.26	24.3	24.12	24.165	2086657.0
2018-04-23	ABBNY-DELISTED	Stock	24.25	24.3	24.12	24.16	2186857.0
2018-04-23	ABBV	Stock	92.93	93.8	92.73	93.17	4716300.0
2018-04-23	ABC-DELISTED	Stock	90.15	90.82	89.84	90.75	811131.0
2018-04-23	ABCB	Stock	52.1	52.55	51.2	52.1	202600.0
2018-04-23	ABCD-DELISTED	Stock	10.5	11.98	10.5	11.11	973047.0
2018-04-23	ABDC-DELISTED	Stock	6.62	6.719	6.44	6.55	58054.0
2018-04-23	ABE-DELISTED	Stock	15.0	15.11	14.757	14.88	10758.0
2018-04-23	ABEO	Stock	550.0	550.0	493.75	500.0	63988.0
2018-04-23	ABEOW-DELISTED	Stock	15.5	15.5	15.5	15.5	200.0
2018-04-23	ABEV	Stock	6.76	6.79	6.69	6.75	10947600.0
2018-04-23	ABG	Stock	66.4	67.8	66.1	67.65	135900.0
2018-04-23	ABIL-DELISTED	Stock	3.04	3.04	2.66	2.86	12069.0
2018-04-23	ABLX-DELISTED	Stock	54.49	54.68	54.42	54.51	25578.0
2018-04-23	ABM	Stock	31.78	32.11	31.7	31.95	1353000.0
2018-04-23	ABMD-DELISTED	Stock	305.9	306.55	300.61	302.65	329119.0

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

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