PREVIEW / stock_daily / 2015-04-17

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-17.parquet
  size:    223 KB
  rows:    6,646
  symbols: 3,507

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
2015-04-17	AAPL	Stock	31.3875	31.535	31.115	31.1875	207828000.0
2015-04-17	MSFT	Stock	41.67	41.74	41.16	41.62	42387600.0
2015-04-17	NVDA	Stock	0.5505	0.5605	0.5502	0.555	293636000.0
2015-04-17	AMZN	Stock	19.1315	19.178	18.72	18.778	76794000.0
2015-04-17	GOOGL	Stock	26.8655	26.99	26.45	26.637	49233960.0
2015-04-17	META	Stock	81.48	82.11	80.37	80.78	24215000.0
2015-04-17	TSLA	Stock	13.666	13.792	13.5667	13.786	37048500.0
2015-04-17	TLT	Stock	129.77	131.7	129.7	131.45	7268774.0
2015-04-17	ES	Stock	50.16	50.79	49.95	50.05	1946400.0
2015-04-17	CL	Stock	69.69	69.84	68.98	69.28	2238000.0
2015-04-17	A	Stock	42.74	43.05	42.6	42.98	2332500.0
2015-04-17	AA.B-DELISTED	Stock	45.6	45.7199	45.12	45.44	342433.0
2015-04-17	AABA-DELISTED	Stock	45.38	45.44	44.25	44.45	12426044.0
2015-04-17	AAC-DELISTED	Stock	31.65	31.87	31.5	31.64	87700.0
2015-04-17	AACG	Stock	4.45	4.46	4.39	4.39	2900.0
2015-04-17	AAIC-DELISTED	Stock	23.97	24.04	23.9	24.0	164280.0
2015-04-17	AAL	Stock	47.96	48.65	47.95	48.19	8659800.0
2015-04-17	AAMC-DELISTED	Stock	68.6088	68.6088	65.3059	65.3059	34326.0
2015-04-17	AAME	Stock	3.95	3.96	3.95	3.96	500.0
2015-04-17	AAMI	Stock	18.87	19.08	18.6	18.67	147800.0
2015-04-17	AAOI	Stock	14.64	15.245	14.41	14.76	557000.0
2015-04-17	AAON	Stock	16.0	16.0	15.62	15.7267	136500.0
2015-04-17	AAP	Stock	149.01	149.8	147.93	149.8	795600.0
2015-04-17	AAT	Stock	40.97	41.25	40.73	41.18	100800.0
2015-04-17	AAU-DELISTED	Stock	0.82	0.8425	0.798	0.817	89459.0
2015-04-17	AAUAF-DELISTED	Stock	0.82	0.8399	0.796	0.815	89941.0
2015-04-17	AAV-DELISTED	Stock	5.9	6.11	5.88	6.06	162921.0
2015-04-17	AAVL-DELISTED	Stock	41.68	42.01	40.03	40.33	363431.0
2015-04-17	AAWW-DELISTED	Stock	44.13	44.14	42.9	43.28	182710.0
2015-04-17	AAXJ	Stock	67.62	67.97	67.35	67.85	1668427.0
2015-04-17	AAXN-DELISTED	Stock	29.41	29.65	28.06	28.39	4403886.0
2015-04-17	AB	Stock	31.48	31.88	31.18	31.31	261500.0
2015-04-17	ABAC-DELISTED	Stock	1.6301	1.672	1.6301	1.672	1000.0
2015-04-17	ABAX-DELISTED	Stock	63.36	63.41	62.23	62.26	67795.0
2015-04-17	ABB-DELISTED	Stock	21.77	21.8	21.67	21.78	1090951.0
2015-04-17	ABBNY-DELISTED	Stock	21.77	21.8	21.67	21.78	1185807.0
2015-04-17	ABBV	Stock	62.12	62.79	61.87	62.29	9905600.0
2015-04-17	ABC-DELISTED	Stock	113.21	113.71	112.05	112.6	2022610.0
2015-04-17	ABCB	Stock	26.1	26.28	25.51	25.66	63400.0
2015-04-17	ABCD-DELISTED	Stock	2.98	3.015	2.926	3.0	13386.0
2015-04-17	ABCO-DELISTED	Stock	53.05	53.43	51.75	52.31	198518.0
2015-04-17	ABCW-DELISTED	Stock	34.14	34.61	34.14	34.41	8762.0
2015-04-17	ABDC-DELISTED	Stock	13.95	14.01	13.85	13.91	33177.0
2015-04-17	ABE-DELISTED	Stock	13.36	13.36	13.2	13.21	10931.0
2015-04-17	ABEO	Stock	83.75	83.75	78.25	83.5	3060.0
2015-04-17	ABEOW-DELISTED	Stock	1.35	1.382	1.35	1.382	4275.0
2015-04-17	ABEV	Stock	6.27	6.29	6.21	6.25	10722700.0
2015-04-17	ABG	Stock	85.29	85.59	84.65	85.33	210200.0
2015-04-17	ABGB-DELISTED	Stock	16.91	17.12	16.88	17.06	25381.0
2015-04-17	ABIL-DELISTED	Stock	10.05	10.08	10.04	10.04	12100.0

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

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