PREVIEW / stock_5min / 2014-11-06

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-11-06.parquet
  size:    5.4 MB
  rows:    358,832
  symbols: 3,541

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
2014-11-06 04:10:00	AAPL	Stock	27.125	27.125	27.125	27.125	800.0
2014-11-06 04:15:00	AAPL	Stock	27.1125	27.1125	27.0825	27.0825	2760.0
2014-11-06 04:20:00	AAPL	Stock	27.0975	27.0975	27.0875	27.0975	7200.0
2014-11-06 04:30:00	AAPL	Stock	27.09	27.09	27.09	27.09	9500.0
2014-11-06 04:35:00	AAPL	Stock	27.09	27.09	27.09	27.09	14400.0
2014-11-06 04:40:00	AAPL	Stock	27.1	27.1	27.1	27.1	3632.0
2014-11-06 04:45:00	AAPL	Stock	27.1	27.1	27.1	27.1	6000.0
2014-11-06 04:55:00	AAPL	Stock	27.0975	27.0975	27.0975	27.0975	1000.0
2014-11-06 05:00:00	AAPL	Stock	27.105	27.105	27.105	27.105	800.0
2014-11-06 05:30:00	AAPL	Stock	27.11	27.1125	27.11	27.1125	2200.0
2014-11-06 05:45:00	AAPL	Stock	27.125	27.125	27.125	27.125	3760.0
2014-11-06 06:15:00	AAPL	Stock	27.16	27.1625	27.125	27.125	8400.0
2014-11-06 06:40:00	AAPL	Stock	27.145	27.145	27.125	27.125	6000.0
2014-11-06 06:45:00	AAPL	Stock	27.125	27.125	27.125	27.125	1736.0
2014-11-06 06:55:00	AAPL	Stock	27.1275	27.135	27.1275	27.135	800.0
2014-11-06 07:00:00	AAPL	Stock	27.145	27.1625	27.145	27.1625	24696.0
2014-11-06 07:05:00	AAPL	Stock	27.1575	27.1575	27.1475	27.15	18264.0
2014-11-06 07:10:00	AAPL	Stock	27.1475	27.1525	27.1475	27.1525	12000.0
2014-11-06 07:15:00	AAPL	Stock	27.1425	27.1425	27.125	27.125	12000.0
2014-11-06 07:20:00	AAPL	Stock	27.125	27.1475	27.125	27.1475	13200.0
2014-11-06 07:25:00	AAPL	Stock	27.1475	27.1475	27.1475	27.1475	400.0
2014-11-06 07:30:00	AAPL	Stock	27.135	27.135	27.12	27.1325	33640.0
2014-11-06 07:35:00	AAPL	Stock	27.1325	27.1325	27.125	27.125	2400.0
2014-11-06 07:40:00	AAPL	Stock	27.125	27.125	27.1125	27.1125	19880.0
2014-11-06 07:45:00	AAPL	Stock	27.1125	27.115	27.1075	27.115	11200.0
2014-11-06 07:50:00	AAPL	Stock	27.115	27.115	27.1025	27.1025	27024.0
2014-11-06 07:55:00	AAPL	Stock	27.1025	27.1025	27.09	27.09	17200.0
2014-11-06 08:00:00	AAPL	Stock	27.0925	27.16	27.0875	27.0925	97144.0
2014-11-06 08:05:00	AAPL	Stock	27.0925	27.095	27.0875	27.09	68360.0
2014-11-06 08:10:00	AAPL	Stock	27.09	27.1	27.09	27.1	76996.0
2014-11-06 08:15:00	AAPL	Stock	27.1075	27.11	27.1025	27.1025	43252.0
2014-11-06 08:20:00	AAPL	Stock	27.1075	27.1075	27.095	27.095	28220.0
2014-11-06 08:25:00	AAPL	Stock	27.095	27.1	27.0875	27.1	46364.0
2014-11-06 08:30:00	AAPL	Stock	27.1	27.125	27.0925	27.125	76720.0
2014-11-06 08:35:00	AAPL	Stock	27.125	27.1375	27.1075	27.1075	126584.0
2014-11-06 08:40:00	AAPL	Stock	27.1075	27.1125	27.0875	27.0975	98624.0
2014-11-06 08:45:00	AAPL	Stock	27.11	27.1125	27.1	27.11	37120.0
2014-11-06 08:50:00	AAPL	Stock	27.11	27.1525	27.11	27.145	180032.0
2014-11-06 08:55:00	AAPL	Stock	27.14	27.14	27.115	27.115	61752.0
2014-11-06 09:00:00	AAPL	Stock	27.12	27.12	27.115	27.12	24864.0
2014-11-06 09:05:00	AAPL	Stock	27.12	27.12	27.1125	27.115	37680.0
2014-11-06 09:10:00	AAPL	Stock	27.1125	27.115	27.1	27.1125	61100.0
2014-11-06 09:15:00	AAPL	Stock	27.1125	27.12	27.105	27.1175	43156.0
2014-11-06 09:20:00	AAPL	Stock	27.125	27.1275	27.1025	27.1125	64332.0
2014-11-06 09:25:00	AAPL	Stock	27.11	27.1375	27.1025	27.1275	96308.0
2014-11-06 09:30:00	AAPL	Stock	27.13	27.1625	27.0725	27.1285	5734204.0
2014-11-06 09:35:00	AAPL	Stock	27.13	27.14	27.02	27.055	3880444.0
2014-11-06 09:40:00	AAPL	Stock	27.055	27.1425	27.0525	27.105	4090640.0
2014-11-06 09:45:00	AAPL	Stock	27.105	27.115	27.08	27.0825	2432272.0
2014-11-06 09:50:00	AAPL	Stock	27.08	27.0975	27.015	27.055	3882012.0

> showing 50 of 358,832 rows — these rows as CSV

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