PREVIEW / stock_daily / 2016-04-18

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-18.parquet
  size:    219 KB
  rows:    6,576
  symbols: 3,311

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-04-18	AAPL	Stock	27.2225	27.2375	26.735	26.87	243286000.0
2016-04-18	MSFT	Stock	55.49	56.59	55.21	56.46	23786000.0
2016-04-18	NVDA	Stock	0.9265	0.9265	0.9152	0.9242	307320000.0
2016-04-18	AMZN	Stock	31.2675	31.882	31.248	31.7675	87218000.0
2016-04-18	GOOGL	Stock	39.0095	39.4275	38.8805	39.384	33540300.0
2016-04-18	META	Stock	109.74	110.81	109.2	110.45	21167200.0
2016-04-18	TSLA	Stock	16.8153	17.2207	16.7773	16.9253	64071000.0
2016-04-18	TLT	Stock	131.33	131.44	130.66	131.31	4486643.0
2016-04-18	ES	Stock	56.63	57.13	56.5	57.12	1609300.0
2016-04-18	CL	Stock	70.9	71.47	70.78	71.32	2152700.0
2016-04-18	A	Stock	40.72	41.45	40.61	41.31	1536100.0
2016-04-18	AA.B-DELISTED	Stock	34.8	35.27	34.59	35.19	16170.0
2016-04-18	AAAP-DELISTED	Stock	34.6	35.29	34.19	34.96	7078.0
2016-04-18	AABA-DELISTED	Stock	36.24	37.0	35.88	36.52	16886187.0
2016-04-18	AAC-DELISTED	Stock	19.08	19.37	18.83	19.02	128360.0
2016-04-18	AACG	Stock	5.25	5.5	5.23	5.5	2600.0
2016-04-18	AAIC-DELISTED	Stock	12.75	12.78	12.57	12.67	108693.0
2016-04-18	AAL	Stock	41.18	41.26	40.44	40.92	5245700.0
2016-04-18	AAMC-DELISTED	Stock	5.7412	6.7074	5.7382	6.4294	175722.0
2016-04-18	AAME	Stock	4.55	4.55	4.02	4.21	4400.0
2016-04-18	AAMI	Stock	13.51	13.88	13.318	13.79	136700.0
2016-04-18	AAOI	Stock	15.79	16.11	15.64	16.11	160400.0
2016-04-18	AAON	Stock	18.16	18.2533	18.0867	18.1667	178350.0
2016-04-18	AAP	Stock	160.38	163.29	159.27	160.94	749100.0
2016-04-18	AAT	Stock	38.69	39.03	38.51	38.76	146800.0
2016-04-18	AAU-DELISTED	Stock	1.18	1.2	1.14	1.15	460901.0
2016-04-18	AAUAF-DELISTED	Stock	1.18	1.2	1.14	1.15	464688.0
2016-04-18	AAV-DELISTED	Stock	5.04	5.35	4.97	5.3	64648.0
2016-04-18	AAVL-DELISTED	Stock	5.46	5.61	5.27	5.58	333007.0
2016-04-18	AAWW-DELISTED	Stock	40.04	40.74	39.73	40.69	115712.0
2016-04-18	AAXJ	Stock	54.98	55.57	54.98	55.46	401316.0
2016-04-18	AAXN-DELISTED	Stock	18.0	18.84	17.8	18.49	2078243.0
2016-04-18	AB	Stock	23.53	23.97	23.39	23.43	354400.0
2016-04-18	ABAC-DELISTED	Stock	0.6	0.62	0.6	0.6199	12800.0
2016-04-18	ABAX-DELISTED	Stock	45.2	46.28	44.575	46.24	116559.0
2016-04-18	ABB-DELISTED	Stock	19.74	20.02	19.74	19.99	1553958.0
2016-04-18	ABBNY-DELISTED	Stock	19.74	20.02	19.74	19.99	1586864.0
2016-04-18	ABBV	Stock	59.5	60.32	59.3	59.88	6089400.0
2016-04-18	ABC-DELISTED	Stock	88.04	88.72	87.64	88.65	1538092.0
2016-04-18	ABCB	Stock	30.72	31.08	30.35	30.97	94900.0
2016-04-18	ABCD-DELISTED	Stock	4.452	4.4999	4.37	4.46	11660.0
2016-04-18	ABCO-DELISTED	Stock	31.93	33.15	31.6508	32.36	538157.0
2016-04-18	ABCW-DELISTED	Stock	45.87	46.53	45.87	46.49	169608.0
2016-04-18	ABDC-DELISTED	Stock	11.69	11.8	11.674	11.73	19325.0
2016-04-18	ABE-DELISTED	Stock	11.7883	12.13	11.7883	12.123	6531.0
2016-04-18	ABEO	Stock	69.75	71.5	68.0	70.25	2080.0
2016-04-18	ABEV	Stock	5.22	5.3	5.19	5.23	18768600.0
2016-04-18	ABG	Stock	59.17	60.3	58.85	59.84	331000.0
2016-04-18	ABGB-DELISTED	Stock	1.4	1.44	1.33	1.37	123363.0
2016-04-18	ABIL-DELISTED	Stock	6.81	6.83	6.66	6.7	5400.0

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

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