PREVIEW / stock_daily / 2014-08-29

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-29.parquet
  size:    221 KB
  rows:    6,640
  symbols: 3,585

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-29	AAPL	Stock	25.715	25.725	25.55	25.625	178380000.0
2014-08-29	MSFT	Stock	45.09	45.44	44.86	45.43	21607600.0
2014-08-29	NVDA	Stock	0.4865	0.4872	0.4812	0.4862	207932000.0
2014-08-29	AMZN	Stock	17.088	17.091	16.884	16.952	38790000.0
2014-08-29	GOOGL	Stock	29.1175	29.145	28.912	29.118	24137680.0
2014-08-29	META	Stock	74.3	74.82	74.01	74.82	26241000.0
2014-08-29	TSLA	Stock	17.9133	18.1333	17.834	17.98	96706500.0
2014-08-29	TLT	Stock	118.92	119.43	118.75	119.05	8513461.0
2014-08-29	ES	Stock	45.59	45.9	45.52	45.89	855700.0
2014-08-29	CL	Stock	64.74	64.76	64.4	64.73	2102500.0
2014-08-29	A	Stock	41.0086	41.1302	40.8298	40.887	2767900.0
2014-08-29	AABA-DELISTED	Stock	38.57	38.67	38.2	38.51	10519391.0
2014-08-29	AAIC-DELISTED	Stock	28.17	28.45	28.1	28.42	175339.0
2014-08-29	AAL	Stock	39.1	39.35	38.36	38.88	6644600.0
2014-08-29	AAMC-DELISTED	Stock	212.6	219.1088	212.5765	218.95	36608.0
2014-08-29	AAME	Stock	4.08	4.12	4.02	4.08	6600.0
2014-08-29	AAOI	Stock	21.71	21.859	20.79	21.24	209400.0
2014-08-29	AAON	Stock	12.2733	12.4933	12.22	12.44	104100.0
2014-08-29	AAP	Stock	137.43	137.81	135.86	136.42	599300.0
2014-08-29	AAT	Stock	34.81	35.11	34.56	35.05	152700.0
2014-08-29	AAU-DELISTED	Stock	1.43	1.44	1.4	1.43	53100.0
2014-08-29	AAUAF-DELISTED	Stock	1.43	1.44	1.4	1.43	53840.0
2014-08-29	AAV-DELISTED	Stock	6.14	6.17	6.11	6.16	311005.0
2014-08-29	AAVL-DELISTED	Stock	29.4	31.19	28.8	29.64	47707.0
2014-08-29	AAWW-DELISTED	Stock	33.0	33.72	33.0	33.45	233060.0
2014-08-29	AAXJ	Stock	65.73	65.9	65.5	65.72	429544.0
2014-08-29	AAXN-DELISTED	Stock	15.68	15.83	15.35	15.67	1063423.0
2014-08-29	AB	Stock	27.29	27.68	27.14	27.66	212500.0
2014-08-29	ABAC-DELISTED	Stock	1.9	1.93	1.85	1.89	21076.0
2014-08-29	ABAX-DELISTED	Stock	47.19	47.9	46.91	47.79	72314.0
2014-08-29	ABB-DELISTED	Stock	22.79	22.79	22.69	22.76	627437.0
2014-08-29	ABBNY-DELISTED	Stock	22.79	22.79	22.69	22.77	732118.0
2014-08-29	ABBV	Stock	55.75	55.8	55.24	55.28	7524400.0
2014-08-29	ABC-DELISTED	Stock	77.0	77.41	76.8	77.395	851912.0
2014-08-29	ABCB	Stock	22.85	22.97	22.62	22.89	40400.0
2014-08-29	ABCD-DELISTED	Stock	1.64	1.66	1.62	1.655	12907.0
2014-08-29	ABCO-DELISTED	Stock	48.82	49.71	48.03	49.61	122364.0
2014-08-29	ABDC-DELISTED	Stock	13.53	13.7	13.33	13.68	44356.0
2014-08-29	ABE-DELISTED	Stock	14.68	14.77	14.6711	14.77	6867.0
2014-08-29	ABEO	Stock	412.5	412.5	375.0	412.5	5.0
2014-08-29	ABEV	Stock	7.27	7.3	7.2	7.29	7012800.0
2014-08-29	ABG	Stock	69.66	70.03	69.14	69.68	80900.0
2014-08-29	ABGB-DELISTED	Stock	28.86	29.15	28.75	28.7801	3028.0
2014-08-29	ABM	Stock	26.4	26.64	26.29	26.6	128300.0
2014-08-29	ABMD-DELISTED	Stock	26.08	26.33	25.89	26.03	149523.0
2014-08-29	ABR	Stock	6.98	7.0	6.96	6.99	51800.0
2014-08-29	ABR.A-DELISTED	Stock	24.85	24.86	24.72	24.75	8748.0
2014-08-29	ABR.B-DELISTED	Stock	24.24	24.502	24.24	24.25	3770.0
2014-08-29	ABR.C-DELISTED	Stock	25.19	25.19	25.19	25.19	100.0
2014-08-29	ABRN-DELISTED	Stock	24.66	24.7	24.62	24.67	19685.0

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

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