PREVIEW / stock_daily / 2017-02-23

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-23.parquet
  size:    216 KB
  rows:    6,476
  symbols: 3,070

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
2017-02-23	AAPL	Stock	34.345	34.37	34.075	34.1325	83152800.0
2017-02-23	MSFT	Stock	64.42	64.73	64.19	64.62	20273100.0
2017-02-23	NVDA	Stock	2.6375	2.6598	2.492	2.5122	1592888000.0
2017-02-23	AMZN	Stock	42.8785	43.043	42.4	42.6095	69240000.0
2017-02-23	GOOGL	Stock	42.554	42.631	42.125	42.55	27733620.0
2017-02-23	META	Stock	135.89	136.12	134.33	135.36	18422500.0
2017-02-23	TSLA	Stock	17.6	17.644	17.0373	17.066	223728000.0
2017-02-23	TLT	Stock	120.57	120.74	120.33	120.67	5330784.0
2017-02-23	ES	Stock	57.86	58.76	57.8	58.12	1902100.0
2017-02-23	CL	Stock	73.88	75.09	73.79	74.44	7203800.0
2017-02-23	A	Stock	51.44	51.6	51.2	51.47	1006900.0
2017-02-23	AA	Stock	36.86	36.88	34.26	34.32	7140000.0
2017-02-23	AAAP-DELISTED	Stock	36.92	37.13	36.38	36.97	213632.0
2017-02-23	AABA-DELISTED	Stock	46.04	46.14	45.29	45.41	7296963.0
2017-02-23	AAC-DELISTED	Stock	7.85	7.93	7.71	7.75	154595.0
2017-02-23	AACG	Stock	3.9	4.1	3.78	3.91	47800.0
2017-02-23	AAIC-DELISTED	Stock	14.89	15.0641	14.83	14.87	322250.0
2017-02-23	AAL	Stock	46.42	47.32	45.89	46.1	5247000.0
2017-02-23	AAMC-DELISTED	Stock	20.7059	21.1912	20.6471	21.1765	24201.0
2017-02-23	AAMI	Stock	15.13	15.17	14.945	15.04	263800.0
2017-02-23	AAOI	Stock	37.73	38.26	36.33	37.47	1023400.0
2017-02-23	AAON	Stock	21.6667	22.8533	20.0667	21.3	790200.0
2017-02-23	AAP	Stock	159.41	159.66	156.66	157.72	1395800.0
2017-02-23	AAT	Stock	44.1	44.43	43.74	44.2	222100.0
2017-02-23	AAU-DELISTED	Stock	1.15	1.16	1.07	1.1	435583.0
2017-02-23	AAUAF-DELISTED	Stock	1.15	1.16	1.07	1.12	436659.0
2017-02-23	AAV-DELISTED	Stock	6.25	6.35	6.225	6.3	76053.0
2017-02-23	AAWW-DELISTED	Stock	51.85	56.0	51.5	56.0	248410.0
2017-02-23	AAXJ	Stock	61.45	61.565	61.32	61.39	512699.0
2017-02-23	AAXN-DELISTED	Stock	26.31	26.4299	25.41	25.45	573179.0
2017-02-23	AB	Stock	23.95	24.05	23.75	23.85	224500.0
2017-02-23	ABAC-DELISTED	Stock	2.809	2.83	2.7717	2.79	10594.0
2017-02-23	ABAX-DELISTED	Stock	49.73	49.73	48.88	49.26	96232.0
2017-02-23	ABB-DELISTED	Stock	22.89	22.92	22.75	22.77	2475920.0
2017-02-23	ABBNY-DELISTED	Stock	22.89	22.92	22.75	22.78	2559557.0
2017-02-23	ABBV	Stock	61.68	62.24	61.45	61.94	8057700.0
2017-02-23	ABC-DELISTED	Stock	91.45	92.396	90.96	91.62	1393257.0
2017-02-23	ABCB	Stock	49.5	49.5	48.35	49.2	113900.0
2017-02-23	ABCD-DELISTED	Stock	4.61	5.01	4.61	4.98	53086.0
2017-02-23	ABCO-DELISTED	Stock	46.75	46.8	46.525	46.65	304069.0
2017-02-23	ABDC-DELISTED	Stock	12.9	12.98	12.7601	12.79	48117.0
2017-02-23	ABE-DELISTED	Stock	12.2384	12.27	12.1995	12.2299	17252.0
2017-02-23	ABEO	Stock	127.5	127.5	121.25	125.0	7996.0
2017-02-23	ABEOW-DELISTED	Stock	3.15	3.15	3.05	3.05	524.0
2017-02-23	ABEV	Stock	6.0	6.01	5.87	5.88	11272700.0
2017-02-23	ABG	Stock	68.45	68.85	65.7	65.85	363800.0
2017-02-23	ABIL-DELISTED	Stock	2.815	2.835	2.78	2.8	5306.0
2017-02-23	ABM	Stock	41.09	41.34	40.83	41.1	180200.0
2017-02-23	ABMD-DELISTED	Stock	117.03	117.22	114.3601	116.91	248504.0
2017-02-23	ABR	Stock	7.39	7.44	7.35	7.43	62100.0

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

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