PREVIEW / stock_5min / 2011-09-27

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-09-27.parquet
  size:    5.0 MB
  rows:    338,051
  symbols: 3,548

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-09-27 04:00:00	AAPL	Stock	14.4854	14.4854	14.4854	14.4854	2800.0
2011-09-27 04:10:00	AAPL	Stock	14.4946	14.5004	14.4946	14.5004	30800.0
2011-09-27 04:35:00	AAPL	Stock	14.53	14.53	14.53	14.53	5600.0
2011-09-27 04:40:00	AAPL	Stock	14.53	14.5304	14.53	14.53	22400.0
2011-09-27 04:50:00	AAPL	Stock	14.5357	14.5357	14.5357	14.5357	19600.0
2011-09-27 05:40:00	AAPL	Stock	14.5179	14.535	14.5179	14.535	14252.0
2011-09-27 05:45:00	AAPL	Stock	14.5179	14.5179	14.5179	14.5179	8400.0
2011-09-27 05:50:00	AAPL	Stock	14.5107	14.5107	14.5107	14.5107	5600.0
2011-09-27 06:00:00	AAPL	Stock	14.5179	14.5179	14.5179	14.5179	2800.0
2011-09-27 06:05:00	AAPL	Stock	14.5179	14.5179	14.5179	14.5179	4200.0
2011-09-27 06:10:00	AAPL	Stock	14.5482	14.5536	14.5482	14.5536	8400.0
2011-09-27 06:15:00	AAPL	Stock	14.5482	14.5482	14.5482	14.5482	5600.0
2011-09-27 06:35:00	AAPL	Stock	14.5368	14.5368	14.5368	14.5368	2800.0
2011-09-27 06:40:00	AAPL	Stock	14.5357	14.5357	14.5357	14.5357	5600.0
2011-09-27 06:50:00	AAPL	Stock	14.5368	14.5589	14.5368	14.5589	54068.0
2011-09-27 06:55:00	AAPL	Stock	14.5396	14.5396	14.5357	14.5357	43120.0
2011-09-27 07:00:00	AAPL	Stock	14.5357	14.6068	14.5357	14.5893	108500.0
2011-09-27 07:05:00	AAPL	Stock	14.5893	14.5893	14.5625	14.575	48300.0
2011-09-27 07:10:00	AAPL	Stock	14.5689	14.5893	14.5661	14.5893	68880.0
2011-09-27 07:15:00	AAPL	Stock	14.5786	14.5929	14.5786	14.5929	26880.0
2011-09-27 07:20:00	AAPL	Stock	14.5929	14.5929	14.5714	14.5714	48356.0
2011-09-27 07:25:00	AAPL	Stock	14.5732	14.5893	14.5625	14.5825	53900.0
2011-09-27 07:30:00	AAPL	Stock	14.5893	14.5943	14.5743	14.5857	50400.0
2011-09-27 07:35:00	AAPL	Stock	14.5929	14.605	14.5929	14.5982	114520.0
2011-09-27 07:40:00	AAPL	Stock	14.6036	14.6239	14.5964	14.6032	132020.0
2011-09-27 07:45:00	AAPL	Stock	14.6039	14.6286	14.6039	14.6157	158256.0
2011-09-27 07:50:00	AAPL	Stock	14.6275	14.6286	14.6129	14.6196	119700.0
2011-09-27 07:55:00	AAPL	Stock	14.62	14.6282	14.6071	14.6193	85708.0
2011-09-27 08:00:00	AAPL	Stock	14.6079	14.625	14.5914	14.6036	946092.0
2011-09-27 08:05:00	AAPL	Stock	14.6	14.6104	14.5946	14.6054	509152.0
2011-09-27 08:10:00	AAPL	Stock	14.6054	14.6182	14.5893	14.5932	653716.0
2011-09-27 08:15:00	AAPL	Stock	14.5939	14.6071	14.5936	14.6036	289828.0
2011-09-27 08:20:00	AAPL	Stock	14.6032	14.6032	14.5893	14.5996	249704.0
2011-09-27 08:25:00	AAPL	Stock	14.5996	14.6143	14.5975	14.605	354004.0
2011-09-27 08:30:00	AAPL	Stock	14.6	14.6071	14.6	14.6064	225512.0
2011-09-27 08:35:00	AAPL	Stock	14.6046	14.6068	14.6	14.6036	53480.0
2011-09-27 08:40:00	AAPL	Stock	14.6054	14.6068	14.5893	14.6036	240968.0
2011-09-27 08:45:00	AAPL	Stock	14.6	14.6043	14.5929	14.6004	360864.0
2011-09-27 08:50:00	AAPL	Stock	14.6	14.6054	14.5971	14.6	463484.0
2011-09-27 08:55:00	AAPL	Stock	14.6021	14.6089	14.5889	14.5982	396928.0
2011-09-27 09:00:00	AAPL	Stock	14.5986	14.6214	14.5893	14.6107	2000404.0
2011-09-27 09:05:00	AAPL	Stock	14.6079	14.6179	14.5929	14.5946	1224692.0
2011-09-27 09:10:00	AAPL	Stock	14.5946	14.5982	14.5786	14.5918	783692.0
2011-09-27 09:15:00	AAPL	Stock	14.5911	14.5996	14.5843	14.5914	306068.0
2011-09-27 09:20:00	AAPL	Stock	14.5961	14.6068	14.5889	14.6029	195888.0
2011-09-27 09:25:00	AAPL	Stock	14.6043	14.6064	14.5954	14.5979	347816.0
2011-09-27 09:30:00	AAPL	Stock	14.6036	14.6161	14.5093	14.5175	31477852.0
2011-09-27 09:35:00	AAPL	Stock	14.5196	14.5436	14.4871	14.5198	20856892.0
2011-09-27 09:40:00	AAPL	Stock	14.5214	14.53	14.4821	14.492	13584816.0
2011-09-27 09:45:00	AAPL	Stock	14.4971	14.5279	14.4839	14.5239	12163480.0

> showing 50 of 338,051 rows — these rows as CSV

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