PREVIEW / stock_5min / 2014-07-24

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-24.parquet
  size:    5.3 MB
  rows:    351,791
  symbols: 3,557

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-24 04:00:00	AAPL	Stock	24.3275	24.35	24.3275	24.35	1040.0
2014-07-24 04:05:00	AAPL	Stock	24.325	24.325	24.325	24.325	1120.0
2014-07-24 04:15:00	AAPL	Stock	24.35	24.3725	24.3475	24.3725	5200.0
2014-07-24 04:25:00	AAPL	Stock	24.3425	24.3425	24.3425	24.3425	4720.0
2014-07-24 04:30:00	AAPL	Stock	24.3425	24.3425	24.32	24.32	4400.0
2014-07-24 04:35:00	AAPL	Stock	24.32	24.32	24.3125	24.3125	12800.0
2014-07-24 04:40:00	AAPL	Stock	24.3125	24.3125	24.3125	24.3125	2000.0
2014-07-24 04:50:00	AAPL	Stock	24.3175	24.3175	24.315	24.315	3900.0
2014-07-24 04:55:00	AAPL	Stock	24.32	24.32	24.32	24.32	5600.0
2014-07-24 05:00:00	AAPL	Stock	24.3225	24.3225	24.3225	24.3225	1200.0
2014-07-24 05:05:00	AAPL	Stock	24.3175	24.3175	24.3	24.3	1200.0
2014-07-24 05:25:00	AAPL	Stock	24.3225	24.325	24.3225	24.325	7896.0
2014-07-24 05:55:00	AAPL	Stock	24.3125	24.3125	24.3125	24.3125	1200.0
2014-07-24 06:00:00	AAPL	Stock	24.325	24.325	24.325	24.325	6800.0
2014-07-24 06:05:00	AAPL	Stock	24.325	24.3325	24.325	24.3325	7172.0
2014-07-24 06:10:00	AAPL	Stock	24.3325	24.3375	24.3325	24.3375	11060.0
2014-07-24 06:15:00	AAPL	Stock	24.345	24.3575	24.345	24.3575	15300.0
2014-07-24 06:20:00	AAPL	Stock	24.36	24.3625	24.35	24.3625	10856.0
2014-07-24 06:30:00	AAPL	Stock	24.345	24.345	24.34	24.34	6000.0
2014-07-24 06:35:00	AAPL	Stock	24.35	24.3525	24.35	24.3525	15732.0
2014-07-24 06:40:00	AAPL	Stock	24.3525	24.3525	24.3525	24.3525	10100.0
2014-07-24 06:45:00	AAPL	Stock	24.35	24.35	24.345	24.35	3200.0
2014-07-24 06:50:00	AAPL	Stock	24.345	24.345	24.34	24.34	2724.0
2014-07-24 06:55:00	AAPL	Stock	24.3325	24.35	24.3325	24.35	11476.0
2014-07-24 07:00:00	AAPL	Stock	24.325	24.345	24.295	24.3025	28400.0
2014-07-24 07:05:00	AAPL	Stock	24.295	24.295	24.2725	24.2725	18400.0
2014-07-24 07:10:00	AAPL	Stock	24.2675	24.27	24.245	24.27	75632.0
2014-07-24 07:15:00	AAPL	Stock	24.2875	24.2975	24.275	24.2975	16000.0
2014-07-24 07:20:00	AAPL	Stock	24.2975	24.31	24.2925	24.3	66588.0
2014-07-24 07:25:00	AAPL	Stock	24.2925	24.2925	24.2875	24.2875	8956.0
2014-07-24 07:30:00	AAPL	Stock	24.2875	24.3	24.2875	24.3	40000.0
2014-07-24 07:35:00	AAPL	Stock	24.3	24.35	24.285	24.3375	196264.0
2014-07-24 07:40:00	AAPL	Stock	24.34	24.35	24.3375	24.3375	55600.0
2014-07-24 07:45:00	AAPL	Stock	24.3425	24.3425	24.33	24.3425	18240.0
2014-07-24 07:50:00	AAPL	Stock	24.3325	24.3325	24.2925	24.3125	23824.0
2014-07-24 07:55:00	AAPL	Stock	24.315	24.3175	24.3	24.3	30968.0
2014-07-24 08:00:00	AAPL	Stock	24.3	24.3475	24.25	24.3125	163920.0
2014-07-24 08:05:00	AAPL	Stock	24.3125	24.32	24.3025	24.31	21820.0
2014-07-24 08:10:00	AAPL	Stock	24.31	24.315	24.3025	24.315	15244.0
2014-07-24 08:15:00	AAPL	Stock	24.315	24.3225	24.3	24.32	62640.0
2014-07-24 08:20:00	AAPL	Stock	24.3075	24.3375	24.3075	24.325	94144.0
2014-07-24 08:25:00	AAPL	Stock	24.3075	24.3125	24.3075	24.3125	2004.0
2014-07-24 08:30:00	AAPL	Stock	24.3125	24.3125	24.275	24.2925	85048.0
2014-07-24 08:35:00	AAPL	Stock	24.2925	24.2925	24.27	24.275	43672.0
2014-07-24 08:40:00	AAPL	Stock	24.275	24.28	24.225	24.225	91696.0
2014-07-24 08:45:00	AAPL	Stock	24.2225	24.2325	24.16	24.21	137112.0
2014-07-24 08:50:00	AAPL	Stock	24.2025	24.22	24.1875	24.22	102116.0
2014-07-24 08:55:00	AAPL	Stock	24.225	24.235	24.2175	24.2175	122744.0
2014-07-24 09:00:00	AAPL	Stock	24.2125	24.2175	24.185	24.195	106796.0
2014-07-24 09:05:00	AAPL	Stock	24.2125	24.215	24.1975	24.205	36844.0

> showing 50 of 351,791 rows — these rows as CSV

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