PREVIEW / stock_1hour / 2013-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-28.parquet
  size:    996 KB
  rows:    46,221
  symbols: 3,513

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2013-08-28 04:00:00	AAPL	Stock	17.4107	17.4214	17.3757	17.3757	115724.0
2013-08-28 05:00:00	AAPL	Stock	17.4	17.4018	17.375	17.375	34888.0
2013-08-28 06:00:00	AAPL	Stock	17.3732	17.3732	17.3271	17.3529	151564.0
2013-08-28 07:00:00	AAPL	Stock	17.3529	17.3686	17.3236	17.3332	445312.0
2013-08-28 08:00:00	AAPL	Stock	17.3539	17.4882	17.3236	17.4286	3302068.0
2013-08-28 09:00:00	AAPL	Stock	17.4286	17.6368	17.3571	17.5894	69673632.0
2013-08-28 10:00:00	AAPL	Stock	17.5901	17.6193	17.4757	17.6107	59441396.0
2013-08-28 11:00:00	AAPL	Stock	17.6111	17.6152	17.4825	17.5639	31469676.0
2013-08-28 12:00:00	AAPL	Stock	17.5682	17.6343	17.5468	17.6221	22065988.0
2013-08-28 13:00:00	AAPL	Stock	17.6239	17.7071	17.6111	17.6411	37755592.0
2013-08-28 14:00:00	AAPL	Stock	17.6429	17.6768	17.5893	17.6046	24470992.0
2013-08-28 15:00:00	AAPL	Stock	17.605	17.6496	17.5096	17.525	43128372.0
2013-08-28 16:00:00	AAPL	Stock	17.5239	17.5765	17.5111	17.5239	12205844.0
2013-08-28 17:00:00	AAPL	Stock	17.5189	17.5214	17.5	17.5143	297500.0
2013-08-28 18:00:00	AAPL	Stock	17.5111	17.5214	17.5054	17.5057	133112.0
2013-08-28 19:00:00	AAPL	Stock	17.5057	17.5118	17.4957	17.5036	301336.0
2013-08-28 06:00:00	MSFT	Stock	33.17	33.3	33.16	33.3	10682.0
2013-08-28 07:00:00	MSFT	Stock	33.37	33.37	33.17	33.26	3213.0
2013-08-28 08:00:00	MSFT	Stock	33.26	33.45	33.16	33.4	33316.0
2013-08-28 09:00:00	MSFT	Stock	33.4	33.6	33.24	33.39	5999217.0
2013-08-28 10:00:00	MSFT	Stock	33.39	33.48	33.26	33.26	5749711.0
2013-08-28 11:00:00	MSFT	Stock	33.26	33.38	33.22	33.32	7119907.0
2013-08-28 12:00:00	MSFT	Stock	33.312	33.33	33.21	33.25	5134306.0
2013-08-28 13:00:00	MSFT	Stock	33.26	33.31	33.21	33.26	2863758.0
2013-08-28 14:00:00	MSFT	Stock	33.26	33.31	33.03	33.07	4555991.0
2013-08-28 15:00:00	MSFT	Stock	33.07	33.175	33.0	33.02	8596351.0
2013-08-28 16:00:00	MSFT	Stock	33.02	33.27	32.97	33.146	3587307.0
2013-08-28 17:00:00	MSFT	Stock	32.98	33.01	32.98	33.01	3500.0
2013-08-28 18:00:00	MSFT	Stock	33.0	33.04	33.0	33.04	2517.0
2013-08-28 19:00:00	MSFT	Stock	33.01	33.01	33.0	33.0	1779.0
2013-08-28 09:00:00	NVDA	Stock	0.371	0.3735	0.37	0.3723	20797080.0
2013-08-28 10:00:00	NVDA	Stock	0.3723	0.3733	0.3715	0.372	60456560.0
2013-08-28 11:00:00	NVDA	Stock	0.372	0.3723	0.3692	0.3703	32957760.0
2013-08-28 12:00:00	NVDA	Stock	0.3703	0.3708	0.3685	0.3701	48434880.0
2013-08-28 13:00:00	NVDA	Stock	0.3701	0.3703	0.3692	0.3698	25405760.0
2013-08-28 14:00:00	NVDA	Stock	0.3697	0.3703	0.369	0.3692	24223560.0
2013-08-28 15:00:00	NVDA	Stock	0.3695	0.3715	0.3688	0.37	93230320.0
2013-08-28 16:00:00	NVDA	Stock	0.3698	0.3703	0.3692	0.3701	4614680.0
2013-08-28 04:00:00	AMZN	Stock	14.0365	14.0365	14.0365	14.0365	2000.0
2013-08-28 07:00:00	AMZN	Stock	14.025	14.025	14.025	14.025	2000.0
2013-08-28 08:00:00	AMZN	Stock	14.002	14.031	13.975	14.0175	174380.0
2013-08-28 09:00:00	AMZN	Stock	14.014	14.12	13.9665	14.0545	5085960.0
2013-08-28 10:00:00	AMZN	Stock	14.0695	14.1478	14.0235	14.1395	4332540.0
2013-08-28 11:00:00	AMZN	Stock	14.1405	14.1435	14.0185	14.068	2886300.0
2013-08-28 12:00:00	AMZN	Stock	14.068	14.116	14.0605	14.1	2311360.0
2013-08-28 13:00:00	AMZN	Stock	14.098	14.1445	14.0945	14.136	2844380.0
2013-08-28 14:00:00	AMZN	Stock	14.1328	14.137	14.0785	14.09	1883240.0
2013-08-28 15:00:00	AMZN	Stock	14.0955	14.15	14.076	14.078	4897740.0
2013-08-28 16:00:00	AMZN	Stock	14.079	14.1039	14.05	14.079	4671820.0
2013-08-28 04:00:00	META	Stock	39.54	39.61	39.44	39.5	7673.0

> showing 50 of 46,221 rows — these rows as CSV

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