PREVIEW / stock_daily / 2014-08-08

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-08.parquet
  size:    220 KB
  rows:    6,616
  symbols: 3,577

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-08	AAPL	Stock	23.565	23.705	23.32	23.685	167460000.0
2014-08-08	MSFT	Stock	43.23	43.32	42.91	43.2	28942700.0
2014-08-08	NVDA	Stock	0.4555	0.4775	0.4555	0.475	894348000.0
2014-08-08	AMZN	Stock	15.597	15.866	15.533	15.84	54118000.0
2014-08-08	GOOGL	Stock	28.601	28.9782	28.451	28.897	29900440.0
2014-08-08	META	Stock	73.4	73.43	72.56	73.06	27202000.0
2014-08-08	TSLA	Stock	16.744	16.784	16.4333	16.542	76351500.0
2014-08-08	TLT	Stock	115.93	116.42	115.38	115.52	9536664.0
2014-08-08	ES	Stock	42.61	43.49	42.61	43.48	1635100.0
2014-08-08	CL	Stock	64.37	65.22	64.32	65.18	2175300.0
2014-08-08	A	Stock	39.5637	39.5708	39.2418	39.5136	2468868.0
2014-08-08	AABA-DELISTED	Stock	35.73	35.96	35.4	35.91	10180144.0
2014-08-08	AACG	Stock	4.44	4.53	4.44	4.53	2900.0
2014-08-08	AAIC-DELISTED	Stock	26.71	26.81	26.55	26.74	159848.0
2014-08-08	AAL	Stock	36.56	37.38	35.23	37.18	20753800.0
2014-08-08	AAMC-DELISTED	Stock	177.4588	177.9382	174.7059	177.9382	7749.0
2014-08-08	AAME	Stock	4.14	4.24	4.06	4.19	17400.0
2014-08-08	AAOI	Stock	19.0	19.17	18.14	18.2	183700.0
2014-08-08	AAON	Stock	12.6467	12.88	12.44	12.84	219450.0
2014-08-08	AAP	Stock	122.3	125.21	121.7	125.11	666800.0
2014-08-08	AAT	Stock	34.44	34.7	34.39	34.67	131800.0
2014-08-08	AAU-DELISTED	Stock	1.45	1.45	1.4	1.45	113070.0
2014-08-08	AAUAF-DELISTED	Stock	1.45	1.45	1.4	1.45	113883.0
2014-08-08	AAV-DELISTED	Stock	5.35	5.59	5.28	5.52	312018.0
2014-08-08	AAVL-DELISTED	Stock	23.21	24.74	23.01	23.49	77210.0
2014-08-08	AAWW-DELISTED	Stock	32.38	33.16	32.31	33.06	217909.0
2014-08-08	AAXJ	Stock	64.09	64.4465	64.03	64.35	1065436.0
2014-08-08	AAXN-DELISTED	Stock	12.22	12.43	12.02	12.375	792486.0
2014-08-08	AB	Stock	25.68	25.76	25.15	25.46	231100.0
2014-08-08	ABAC-DELISTED	Stock	1.93	2.12	1.93	2.06	77350.0
2014-08-08	ABAX-DELISTED	Stock	45.48	45.94	45.245	45.57	145130.0
2014-08-08	ABB-DELISTED	Stock	22.32	22.48	22.2	22.47	1082816.0
2014-08-08	ABBNY-DELISTED	Stock	22.32	22.48	22.2	22.47	1126879.0
2014-08-08	ABBV	Stock	52.72	52.89	52.29	52.82	13117700.0
2014-08-08	ABC-DELISTED	Stock	75.0	75.57	74.66	75.43	1229060.0
2014-08-08	ABCB	Stock	21.58	21.86	21.58	21.86	91400.0
2014-08-08	ABCD-DELISTED	Stock	1.79	1.97	1.79	1.84	14088.0
2014-08-08	ABCO-DELISTED	Stock	48.94	49.29	48.73	49.01	132821.0
2014-08-08	ABDC-DELISTED	Stock	12.74	12.9668	12.66	12.66	38207.0
2014-08-08	ABE-DELISTED	Stock	14.22	14.34	14.22	14.32	4856.0
2014-08-08	ABEO	Stock	337.5	337.5	337.5	337.5	32.0
2014-08-08	ABEV	Stock	6.7	6.84	6.69	6.82	22465600.0
2014-08-08	ABG	Stock	66.63	67.55	66.38	67.41	254600.0
2014-08-08	ABGB-DELISTED	Stock	24.47	24.7799	24.34	24.74	8544.0
2014-08-08	ABIL-DELISTED	Stock	9.89	9.89	9.815	9.815	700.0
2014-08-08	ABM	Stock	24.86	25.26	24.77	25.24	182100.0
2014-08-08	ABMD-DELISTED	Stock	25.45	25.72	25.22	25.33	197755.0
2014-08-08	ABR	Stock	6.92	6.98	6.92	6.97	44200.0
2014-08-08	ABR.A-DELISTED	Stock	24.99	24.99	24.89	24.99	5069.0
2014-08-08	ABR.B-DELISTED	Stock	24.5	24.69	24.4636	24.5001	2606.0

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

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