PREVIEW / stock_daily / 2016-12-08

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-08.parquet
  size:    218 KB
  rows:    6,549
  symbols: 3,154

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
2016-12-08	AAPL	Stock	27.715	28.1075	27.65	28.03	108273200.0
2016-12-08	MSFT	Stock	61.3	61.58	60.84	61.01	21220800.0
2016-12-08	NVDA	Stock	2.3798	2.4155	2.3262	2.337	381544000.0
2016-12-08	AMZN	Stock	38.5935	38.6895	38.2595	38.3665	63792000.0
2016-12-08	GOOGL	Stock	39.6475	39.95	39.3953	39.7585	32250620.0
2016-12-08	META	Stock	117.98	119.5	117.64	118.91	22442800.0
2016-12-08	TSLA	Stock	12.8033	12.8333	12.636	12.8193	47911500.0
2016-12-08	TLT	Stock	119.15	119.31	118.78	118.98	12041139.0
2016-12-08	ES	Stock	52.55	53.36	52.21	53.3	1623000.0
2016-12-08	CL	Stock	65.66	66.0	65.3	65.7	3204400.0
2016-12-08	A	Stock	44.99	45.83	44.77	45.8	1848400.0
2016-12-08	AA	Stock	31.28	31.84	30.8	31.31	3064500.0
2016-12-08	AAAP-DELISTED	Stock	30.33	30.64	29.6901	30.04	59642.0
2016-12-08	AABA-DELISTED	Stock	40.66	41.6	40.4168	41.4	8603656.0
2016-12-08	AAC-DELISTED	Stock	8.27	8.39	8.12	8.31	232890.0
2016-12-08	AACG	Stock	3.83	3.86	3.83	3.86	700.0
2016-12-08	AAIC-DELISTED	Stock	16.78	17.11	16.62	17.0	460870.0
2016-12-08	AAL	Stock	48.6	48.6	47.7	48.05	6240000.0
2016-12-08	AAMC-DELISTED	Stock	10.8824	12.3529	10.5882	12.2206	199009.0
2016-12-08	AAME	Stock	3.9	4.0	3.85	3.85	1600.0
2016-12-08	AAMI	Stock	14.91	15.25	14.82	15.23	259800.0
2016-12-08	AAOI	Stock	24.5	25.33	24.398	24.9	358900.0
2016-12-08	AAON	Stock	21.7667	22.0	21.7	21.9667	361500.0
2016-12-08	AAP	Stock	176.41	177.83	175.18	176.52	796800.0
2016-12-08	AAT	Stock	41.62	42.32	41.17	42.23	344200.0
2016-12-08	AAU-DELISTED	Stock	1.13	1.18	1.08	1.16	352036.0
2016-12-08	AAUAF-DELISTED	Stock	1.13	1.18	1.08	1.16	355645.0
2016-12-08	AAV-DELISTED	Stock	7.2	7.225	7.04	7.1	65127.0
2016-12-08	AAWW-DELISTED	Stock	51.4	52.75	51.0	52.0	165596.0
2016-12-08	AAXJ	Stock	57.59	57.94	57.535	57.86	1754611.0
2016-12-08	AAXN-DELISTED	Stock	27.69	27.7	24.92	25.26	2203627.0
2016-12-08	AB	Stock	22.35	23.23	22.05	23.0	1270800.0
2016-12-08	ABAC-DELISTED	Stock	3.152	3.44	3.152	3.39	14933.0
2016-12-08	ABAX-DELISTED	Stock	53.12	53.86	52.88	53.77	136096.0
2016-12-08	ABB-DELISTED	Stock	20.89	21.01	20.86	20.9	1458934.0
2016-12-08	ABBNY-DELISTED	Stock	20.89	21.01	20.86	20.92	1561960.0
2016-12-08	ABBV	Stock	60.02	60.98	59.09	60.9	9192300.0
2016-12-08	ABC-DELISTED	Stock	76.31	77.64	75.68	76.89	2296472.0
2016-12-08	ABCB	Stock	46.45	47.45	46.09	47.3	143400.0
2016-12-08	ABCD-DELISTED	Stock	4.61	4.86	4.61	4.8	70276.0
2016-12-08	ABCO-DELISTED	Stock	32.65	34.05	32.35	34.0	370647.0
2016-12-08	ABDC-DELISTED	Stock	11.8	12.15	11.8	11.85	33748.0
2016-12-08	ABE-DELISTED	Stock	11.31	11.48	11.28	11.28	10650.0
2016-12-08	ABEO	Stock	146.25	148.75	142.5	145.0	10096.0
2016-12-08	ABEOW-DELISTED	Stock	3.1	3.15	3.05	3.05	2850.0
2016-12-08	ABEV	Stock	4.89	4.9	4.82	4.85	13151800.0
2016-12-08	ABG	Stock	63.15	64.25	62.6	63.95	203400.0
2016-12-08	ABIL-DELISTED	Stock	3.44	3.45	3.24	3.27	15065.0
2016-12-08	ABM	Stock	42.92	43.12	42.72	42.95	601600.0
2016-12-08	ABMD-DELISTED	Stock	116.82	118.79	115.25	118.09	380215.0

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

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