PREVIEW / stock_1hour / 2011-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-16.parquet
  size:    925 KB
  rows:    43,994
  symbols: 3,526

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
2011-11-16 04:00:00	AAPL	Stock	13.9057	13.9304	13.9057	13.9304	58800.0
2011-11-16 05:00:00	AAPL	Stock	13.9304	13.9304	13.8875	13.8929	84840.0
2011-11-16 06:00:00	AAPL	Stock	13.875	13.8929	13.8571	13.8571	44772.0
2011-11-16 07:00:00	AAPL	Stock	13.8393	13.9271	13.8332	13.8575	291816.0
2011-11-16 08:00:00	AAPL	Stock	13.8571	13.8679	13.8143	13.8243	1052464.0
2011-11-16 09:00:00	AAPL	Stock	13.8232	13.9693	13.8232	13.9114	67020324.0
2011-11-16 10:00:00	AAPL	Stock	13.9143	13.9311	13.8179	13.8943	59972024.0
2011-11-16 11:00:00	AAPL	Stock	13.8943	13.9018	13.7966	13.8089	34138104.0
2011-11-16 12:00:00	AAPL	Stock	13.8114	13.8661	13.8061	13.84	23286564.0
2011-11-16 13:00:00	AAPL	Stock	13.8407	13.9036	13.8171	13.8682	34859216.0
2011-11-16 14:00:00	AAPL	Stock	13.8668	13.8911	13.8429	13.8654	22098440.0
2011-11-16 15:00:00	AAPL	Stock	13.8639	13.885	13.7257	13.7461	85416632.0
2011-11-16 16:00:00	AAPL	Stock	13.7471	13.8513	13.7089	13.715	18287416.0
2011-11-16 17:00:00	AAPL	Stock	13.7236	13.7246	13.7107	13.7182	244664.0
2011-11-16 18:00:00	AAPL	Stock	13.7236	13.7418	13.7214	13.7375	187292.0
2011-11-16 19:00:00	AAPL	Stock	13.7304	13.7364	13.7268	13.7321	463624.0
2011-11-16 05:00:00	MSFT	Stock	26.72	26.72	26.71	26.71	300.0
2011-11-16 06:00:00	MSFT	Stock	26.48	26.48	26.48	26.48	100.0
2011-11-16 07:00:00	MSFT	Stock	26.54	26.59	26.5	26.55	2408.0
2011-11-16 08:00:00	MSFT	Stock	26.53	26.59	26.48	26.48	33693.0
2011-11-16 09:00:00	MSFT	Stock	26.49	26.52	26.36	26.37	9241693.0
2011-11-16 10:00:00	MSFT	Stock	26.38	26.49	26.27	26.45	8264302.0
2011-11-16 11:00:00	MSFT	Stock	26.45	26.49	26.38	26.41	4150294.0
2011-11-16 12:00:00	MSFT	Stock	26.4	26.48	26.38	26.41	2665426.0
2011-11-16 13:00:00	MSFT	Stock	26.41	26.51	26.4	26.45	4341686.0
2011-11-16 14:00:00	MSFT	Stock	26.45	26.5	26.4	26.45	3846582.0
2011-11-16 15:00:00	MSFT	Stock	26.45	26.47	26.04	26.08	14689064.0
2011-11-16 16:00:00	MSFT	Stock	26.08	26.475	26.02	26.06	5230105.0
2011-11-16 17:00:00	MSFT	Stock	26.06	26.06	26.03	26.06	9087.0
2011-11-16 18:00:00	MSFT	Stock	26.07	26.07	25.99	26.04	80889.0
2011-11-16 19:00:00	MSFT	Stock	26.04	26.06	26.02	26.06	9490.0
2011-11-16 09:00:00	NVDA	Stock	0.369	0.3745	0.3642	0.3735	59580320.0
2011-11-16 10:00:00	NVDA	Stock	0.3738	0.3745	0.3705	0.3733	82336800.0
2011-11-16 11:00:00	NVDA	Stock	0.3733	0.3748	0.3705	0.371	57461680.0
2011-11-16 12:00:00	NVDA	Stock	0.371	0.3745	0.3692	0.3738	43904360.0
2011-11-16 13:00:00	NVDA	Stock	0.3738	0.3748	0.372	0.372	54560240.0
2011-11-16 14:00:00	NVDA	Stock	0.372	0.3733	0.3706	0.3715	46459000.0
2011-11-16 15:00:00	NVDA	Stock	0.3715	0.3728	0.3632	0.365	155226640.0
2011-11-16 16:00:00	NVDA	Stock	0.3645	0.3706	0.3628	0.364	3234400.0
2011-11-16 17:00:00	NVDA	Stock	0.364	0.3648	0.3638	0.3648	66200.0
2011-11-16 18:00:00	NVDA	Stock	0.3638	0.3645	0.3638	0.3645	172000.0
2011-11-16 19:00:00	NVDA	Stock	0.3645	0.3665	0.3638	0.3638	114000.0
2011-11-16 05:00:00	AMZN	Stock	10.843	10.843	10.843	10.843	2000.0
2011-11-16 06:00:00	AMZN	Stock	10.782	10.8055	10.782	10.8055	22000.0
2011-11-16 07:00:00	AMZN	Stock	10.847	10.85	10.8225	10.825	49000.0
2011-11-16 08:00:00	AMZN	Stock	10.8215	10.8215	10.761	10.8	152320.0
2011-11-16 09:00:00	AMZN	Stock	10.8115	10.83	10.735	10.74	16342600.0
2011-11-16 10:00:00	AMZN	Stock	10.744	10.8485	10.719	10.7955	18637860.0
2011-11-16 11:00:00	AMZN	Stock	10.7977	10.814	10.721	10.758	11512200.0
2011-11-16 12:00:00	AMZN	Stock	10.7545	10.7795	10.725	10.7545	7926340.0

> showing 50 of 43,994 rows — these rows as CSV

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