PREVIEW / stock_daily / 2014-04-25

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-25.parquet
  size:    217 KB
  rows:    6,506
  symbols: 3,530

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
2014-04-25	AAPL	Stock	20.1618	20.4282	20.1414	20.4264	390275200.0
2014-04-25	MSFT	Stock	40.29	40.68	39.75	39.91	56876800.0
2014-04-25	NVDA	Stock	0.4805	0.485	0.4673	0.4683	313600000.0
2014-04-25	AMZN	Stock	15.8125	15.8245	15.1355	15.1915	323604000.0
2014-04-25	GOOGL	Stock	26.613	26.693	26.125	26.155	47452080.0
2014-04-25	META	Stock	59.97	60.01	57.57	57.71	92502000.0
2014-04-25	TSLA	Stock	13.4667	13.78	13.1767	13.3233	104950500.0
2014-04-25	TLT	Stock	111.49	111.99	111.32	111.33	5976534.0
2014-04-25	ES	Stock	46.54	47.02	46.48	46.97	1232300.0
2014-04-25	CL	Stock	66.5	66.94	65.92	66.24	3169500.0
2014-04-25	A	Stock	39.5207	39.5207	38.6767	38.9056	2209539.0
2014-04-25	AABA-DELISTED	Stock	35.03	35.1	34.29	34.49	18831311.0
2014-04-25	AACG	Stock	4.05	4.06	4.0	4.06	13300.0
2014-04-25	AAIC-DELISTED	Stock	25.92	25.92	25.7	25.73	192894.0
2014-04-25	AAL	Stock	37.0	37.11	35.91	36.0	9574100.0
2014-04-25	AAMC-DELISTED	Stock	291.4676	291.4676	282.3529	287.4824	18255.0
2014-04-25	AAME	Stock	3.47	3.58	3.45	3.47	15900.0
2014-04-25	AAOI	Stock	23.34	23.8	23.01	23.55	205000.0
2014-04-25	AAON	Stock	12.72	12.9156	12.4844	12.6311	336375.0
2014-04-25	AAP	Stock	121.81	122.29	120.01	120.63	635800.0
2014-04-25	AAT	Stock	33.58	33.76	33.48	33.58	134800.0
2014-04-25	AAU-DELISTED	Stock	1.44	1.48	1.43	1.47	71306.0
2014-04-25	AAUAF-DELISTED	Stock	1.44	1.48	1.43	1.47	71847.0
2014-04-25	AAV-DELISTED	Stock	5.85	5.94	5.73	5.9	409953.0
2014-04-25	AAWW-DELISTED	Stock	35.46	35.59	34.5	34.66	124436.0
2014-04-25	AAXJ	Stock	59.48	59.48	59.11	59.44	1149185.0
2014-04-25	AAXN-DELISTED	Stock	18.07	18.07	17.52	17.72	758748.0
2014-04-25	AB	Stock	26.3	26.67	25.43	25.6	416400.0
2014-04-25	ABAC-DELISTED	Stock	2.2	2.247	2.13	2.14	12100.0
2014-04-25	ABAX-DELISTED	Stock	36.99	41.46	36.77	38.99	266449.0
2014-04-25	ABB-DELISTED	Stock	26.04	26.1	25.94	26.01	858079.0
2014-04-25	ABBNY-DELISTED	Stock	26.04	26.1	25.94	26.0	889296.0
2014-04-25	ABBV	Stock	50.21	50.98	48.95	49.14	7289100.0
2014-04-25	ABC-DELISTED	Stock	64.53	64.79	62.55	62.83	2666973.0
2014-04-25	ABCB	Stock	22.1	22.48	21.67	21.78	77500.0
2014-04-25	ABCD-DELISTED	Stock	2.17	2.33	2.15	2.28	24653.0
2014-04-25	ABCO-DELISTED	Stock	58.52	59.09	57.45	57.58	162633.0
2014-04-25	ABE-DELISTED	Stock	13.25	13.36	13.0931	13.24	3657.0
2014-04-25	ABEO	Stock	650.0	650.0	575.0	600.0	10.0
2014-04-25	ABEV	Stock	7.77	7.78	7.6	7.67	9585200.0
2014-04-25	ABFS-DELISTED	Stock	38.33	39.04	37.88	38.0	316515.0
2014-04-25	ABG	Stock	59.97	60.12	58.67	59.51	347600.0
2014-04-25	ABGB-DELISTED	Stock	22.56	22.56	22.03	22.1576	74836.0
2014-04-25	ABIL-DELISTED	Stock	9.65	9.79	9.63	9.72	81652.0
2014-04-25	ABM	Stock	27.19	27.29	26.95	26.95	180200.0
2014-04-25	ABMD-DELISTED	Stock	24.94	25.13	24.54	24.69	236543.0
2014-04-25	ABR	Stock	7.0	7.02	6.98	7.02	104900.0
2014-04-25	ABR.A-DELISTED	Stock	24.91	25.1	24.91	25.0599	5911.0
2014-04-25	ABR.B-DELISTED	Stock	23.79	23.829	23.6901	23.829	5528.0
2014-04-25	ABR.C-DELISTED	Stock	25.06	25.2	25.0	25.03	22048.0

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

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