PREVIEW / stock_5min / 2014-07-31

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-31.parquet
  size:    5.7 MB
  rows:    376,677
  symbols: 3,587

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-07-31 04:00:00	AAPL	Stock	24.4875	24.4875	24.4875	24.4875	400.0
2014-07-31 04:05:00	AAPL	Stock	24.45	24.45	24.45	24.45	800.0
2014-07-31 04:10:00	AAPL	Stock	24.4225	24.4225	24.3875	24.3875	5800.0
2014-07-31 04:15:00	AAPL	Stock	24.3875	24.3875	24.3875	24.3875	3400.0
2014-07-31 04:25:00	AAPL	Stock	24.3875	24.3875	24.3775	24.3775	2800.0
2014-07-31 04:30:00	AAPL	Stock	24.355	24.355	24.35	24.35	1840.0
2014-07-31 04:35:00	AAPL	Stock	24.355	24.3625	24.3475	24.3475	5104.0
2014-07-31 04:40:00	AAPL	Stock	24.325	24.325	24.3225	24.3225	11176.0
2014-07-31 04:50:00	AAPL	Stock	24.3025	24.3025	24.25	24.25	13400.0
2014-07-31 04:55:00	AAPL	Stock	24.25	24.25	24.225	24.25	3612.0
2014-07-31 05:00:00	AAPL	Stock	24.225	24.225	24.225	24.225	5200.0
2014-07-31 05:05:00	AAPL	Stock	24.225	24.225	24.225	24.225	900.0
2014-07-31 05:10:00	AAPL	Stock	24.225	24.25	24.175	24.2125	13520.0
2014-07-31 05:15:00	AAPL	Stock	24.22	24.225	24.22	24.225	2312.0
2014-07-31 05:20:00	AAPL	Stock	24.225	24.225	24.225	24.225	800.0
2014-07-31 05:25:00	AAPL	Stock	24.2375	24.25	24.225	24.225	10260.0
2014-07-31 05:30:00	AAPL	Stock	24.25	24.25	24.2125	24.2125	21428.0
2014-07-31 05:35:00	AAPL	Stock	24.2225	24.2275	24.2225	24.2275	3140.0
2014-07-31 06:00:00	AAPL	Stock	24.25	24.25	24.25	24.25	4000.0
2014-07-31 06:05:00	AAPL	Stock	24.2675	24.2675	24.2525	24.2525	800.0
2014-07-31 06:10:00	AAPL	Stock	24.22	24.22	24.2125	24.2125	6020.0
2014-07-31 06:15:00	AAPL	Stock	24.2425	24.2425	24.2175	24.2175	5600.0
2014-07-31 06:20:00	AAPL	Stock	24.2275	24.2275	24.2275	24.2275	840.0
2014-07-31 06:25:00	AAPL	Stock	24.2275	24.2375	24.2275	24.2375	2000.0
2014-07-31 06:30:00	AAPL	Stock	24.2475	24.2525	24.23	24.2525	8980.0
2014-07-31 06:35:00	AAPL	Stock	24.2375	24.2375	24.2375	24.2375	1600.0
2014-07-31 06:40:00	AAPL	Stock	24.2375	24.2475	24.2375	24.2475	4540.0
2014-07-31 06:45:00	AAPL	Stock	24.225	24.225	24.225	24.225	2000.0
2014-07-31 06:50:00	AAPL	Stock	24.22	24.22	24.2125	24.2125	27280.0
2014-07-31 06:55:00	AAPL	Stock	24.2125	24.22	24.2125	24.2175	26128.0
2014-07-31 07:00:00	AAPL	Stock	24.2225	24.2225	24.1875	24.215	47152.0
2014-07-31 07:05:00	AAPL	Stock	24.205	24.2625	24.2025	24.2625	24076.0
2014-07-31 07:10:00	AAPL	Stock	24.26	24.27	24.25	24.2525	23448.0
2014-07-31 07:15:00	AAPL	Stock	24.2525	24.27	24.2525	24.27	1420.0
2014-07-31 07:20:00	AAPL	Stock	24.275	24.305	24.275	24.275	38640.0
2014-07-31 07:25:00	AAPL	Stock	24.2975	24.2975	24.2975	24.2975	1200.0
2014-07-31 07:30:00	AAPL	Stock	24.3	24.3175	24.3	24.315	15140.0
2014-07-31 07:35:00	AAPL	Stock	24.32	24.3225	24.3125	24.3125	10400.0
2014-07-31 07:40:00	AAPL	Stock	24.3125	24.3225	24.3125	24.3225	2400.0
2014-07-31 07:45:00	AAPL	Stock	24.3225	24.3225	24.3	24.3	30128.0
2014-07-31 07:50:00	AAPL	Stock	24.3	24.3075	24.3	24.3075	10084.0
2014-07-31 07:55:00	AAPL	Stock	24.3075	24.3075	24.275	24.2875	86148.0
2014-07-31 08:00:00	AAPL	Stock	24.3	24.55	24.215	24.3425	254516.0
2014-07-31 08:05:00	AAPL	Stock	24.3425	24.3475	24.33	24.3475	55916.0
2014-07-31 08:10:00	AAPL	Stock	24.3375	24.3375	24.32	24.32	31024.0
2014-07-31 08:15:00	AAPL	Stock	24.325	24.35	24.325	24.3375	47832.0
2014-07-31 08:20:00	AAPL	Stock	24.3375	24.3425	24.3275	24.3275	50904.0
2014-07-31 08:25:00	AAPL	Stock	24.3325	24.345	24.3325	24.335	30416.0
2014-07-31 08:30:00	AAPL	Stock	24.3325	24.3325	24.31	24.3125	55184.0
2014-07-31 08:35:00	AAPL	Stock	24.315	24.335	24.31	24.3275	72668.0

> showing 50 of 376,677 rows — these rows as CSV

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