PREVIEW / stock_daily / 2014-08-25

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-25.parquet
  size:    222 KB
  rows:    6,634
  symbols: 3,581

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-08-25	AAPL	Stock	25.4475	25.5425	25.32	25.385	161080000.0
2014-08-25	MSFT	Stock	45.4	45.44	45.04	45.17	16910000.0
2014-08-25	NVDA	Stock	0.479	0.4822	0.4768	0.4778	153380000.0
2014-08-25	AMZN	Stock	16.6605	16.8385	16.6355	16.701	39154000.0
2014-08-25	GOOGL	Stock	29.7385	29.779	29.463	29.5285	25960980.0
2014-08-25	META	Stock	74.94	75.28	74.79	75.02	19734000.0
2014-08-25	TSLA	Stock	17.2127	17.5787	17.2127	17.5033	64771500.0
2014-08-25	TLT	Stock	117.45	117.78	117.2099	117.73	5764713.0
2014-08-25	ES	Stock	45.21	45.51	45.17	45.35	936000.0
2014-08-25	CL	Stock	64.92	65.14	64.72	64.87	1556800.0
2014-08-25	A	Stock	41.402	41.5951	41.1874	41.3019	1352006.0
2014-08-25	AABA-DELISTED	Stock	38.14	38.22	37.54	37.71	13048425.0
2014-08-25	AACG	Stock	4.67	4.75	4.53	4.64	7000.0
2014-08-25	AAIC-DELISTED	Stock	27.97	28.01	27.9	27.98	168050.0
2014-08-25	AAL	Stock	40.23	40.28	39.4	39.42	7071800.0
2014-08-25	AAMC-DELISTED	Stock	188.2353	194.1706	186.0059	193.8235	54981.0
2014-08-25	AAME	Stock	4.07	4.15	4.06	4.15	700.0
2014-08-25	AAOI	Stock	19.36	19.74	19.36	19.42	114000.0
2014-08-25	AAON	Stock	12.5467	12.62	12.3067	12.4467	169950.0
2014-08-25	AAP	Stock	136.15	136.96	135.61	136.33	432500.0
2014-08-25	AAT	Stock	35.1	35.24	34.66	34.85	96700.0
2014-08-25	AAU-DELISTED	Stock	1.47	1.47	1.4	1.44	43474.0
2014-08-25	AAUAF-DELISTED	Stock	1.44	1.44	1.4	1.44	45148.0
2014-08-25	AAV-DELISTED	Stock	5.89	5.9998	5.83	5.98	274644.0
2014-08-25	AAVL-DELISTED	Stock	31.19	31.57	29.04	30.34	344698.0
2014-08-25	AAWW-DELISTED	Stock	34.09	34.09	33.2	33.45	134304.0
2014-08-25	AAXJ	Stock	65.82	65.95	65.78	65.93	125220.0
2014-08-25	AAXN-DELISTED	Stock	16.17	16.54	15.86	15.955	3165699.0
2014-08-25	AB	Stock	27.12	27.49	27.09	27.39	310000.0
2014-08-25	ABAC-DELISTED	Stock	2.0	2.05	1.93	2.0	31800.0
2014-08-25	ABAX-DELISTED	Stock	46.53	47.22	45.55	45.73	133180.0
2014-08-25	ABB-DELISTED	Stock	22.81	22.9476	22.79	22.875	1100119.0
2014-08-25	ABBNY-DELISTED	Stock	22.81	22.9476	22.79	22.87	1145712.0
2014-08-25	ABBV	Stock	55.38	55.92	55.18	55.87	7553500.0
2014-08-25	ABC-DELISTED	Stock	77.03	77.29	76.67	76.92	386264.0
2014-08-25	ABCB	Stock	23.41	24.25	23.41	24.04	160800.0
2014-08-25	ABCD-DELISTED	Stock	1.62	1.67	1.56	1.66	37200.0
2014-08-25	ABCO-DELISTED	Stock	50.23	50.23	48.82	49.1	209530.0
2014-08-25	ABDC-DELISTED	Stock	13.2	13.5	13.2	13.4	81965.0
2014-08-25	ABE-DELISTED	Stock	14.61	14.68	14.61	14.68	3607.0
2014-08-25	ABEO	Stock	375.0	437.5	375.0	437.5	17.0
2014-08-25	ABEV	Stock	7.16	7.25	7.13	7.24	6788100.0
2014-08-25	ABG	Stock	68.67	69.01	67.93	68.88	216000.0
2014-08-25	ABGB-DELISTED	Stock	26.91	27.3083	26.91	27.26	9598.0
2014-08-25	ABM	Stock	26.45	26.48	26.06	26.13	171000.0
2014-08-25	ABMD-DELISTED	Stock	25.07	25.28	24.75	25.13	145643.0
2014-08-25	ABR	Stock	6.95	7.02	6.91	6.98	183600.0
2014-08-25	ABR.A-DELISTED	Stock	24.7399	24.75	24.67	24.6701	7300.0
2014-08-25	ABR.B-DELISTED	Stock	24.11	24.24	24.05	24.18	9723.0
2014-08-25	ABR.C-DELISTED	Stock	25.11	25.11	25.11	25.11	100.0

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

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