PREVIEW / stock_5min / 2014-07-25

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-07-25.parquet
  size:    5.2 MB
  rows:    349,204
  symbols: 3,570

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-25 04:25:00	AAPL	Stock	24.225	24.225	24.225	24.225	800.0
2014-07-25 05:05:00	AAPL	Stock	24.2175	24.225	24.2175	24.225	4400.0
2014-07-25 05:20:00	AAPL	Stock	24.2	24.2	24.195	24.195	1600.0
2014-07-25 05:25:00	AAPL	Stock	24.205	24.205	24.205	24.205	2000.0
2014-07-25 05:40:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	2400.0
2014-07-25 05:45:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	7600.0
2014-07-25 06:00:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	6000.0
2014-07-25 06:05:00	AAPL	Stock	24.21	24.2275	24.21	24.2275	2056.0
2014-07-25 06:10:00	AAPL	Stock	24.225	24.225	24.225	24.225	1508.0
2014-07-25 06:20:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	2760.0
2014-07-25 06:45:00	AAPL	Stock	24.2125	24.2125	24.195	24.195	1612.0
2014-07-25 07:05:00	AAPL	Stock	24.205	24.205	24.195	24.205	3200.0
2014-07-25 07:10:00	AAPL	Stock	24.1925	24.1925	24.19	24.19	1600.0
2014-07-25 07:15:00	AAPL	Stock	24.19	24.19	24.1875	24.19	13220.0
2014-07-25 07:20:00	AAPL	Stock	24.19	24.19	24.19	24.19	800.0
2014-07-25 07:25:00	AAPL	Stock	24.1975	24.2	24.1975	24.2	4800.0
2014-07-25 07:30:00	AAPL	Stock	24.2	24.2	24.2	24.2	2000.0
2014-07-25 07:35:00	AAPL	Stock	24.195	24.2	24.195	24.2	1200.0
2014-07-25 07:40:00	AAPL	Stock	24.2	24.2	24.195	24.195	1200.0
2014-07-25 07:45:00	AAPL	Stock	24.2	24.2	24.1975	24.1975	12632.0
2014-07-25 07:50:00	AAPL	Stock	24.1975	24.1975	24.1975	24.1975	1940.0
2014-07-25 07:55:00	AAPL	Stock	24.2	24.2	24.2	24.2	14476.0
2014-07-25 08:00:00	AAPL	Stock	24.195	24.2575	24.18	24.2075	70212.0
2014-07-25 08:05:00	AAPL	Stock	24.2075	24.245	24.2075	24.2375	61700.0
2014-07-25 08:10:00	AAPL	Stock	24.24	24.24	24.2325	24.2325	16140.0
2014-07-25 08:15:00	AAPL	Stock	24.235	24.235	24.2275	24.2275	3200.0
2014-07-25 08:20:00	AAPL	Stock	24.225	24.25	24.225	24.24	41060.0
2014-07-25 08:25:00	AAPL	Stock	24.2275	24.2275	24.2275	24.2275	1600.0
2014-07-25 08:30:00	AAPL	Stock	24.2275	24.2275	24.2275	24.2275	3200.0
2014-07-25 08:35:00	AAPL	Stock	24.225	24.225	24.2075	24.2075	6688.0
2014-07-25 08:40:00	AAPL	Stock	24.2075	24.215	24.1875	24.215	48292.0
2014-07-25 08:45:00	AAPL	Stock	24.2125	24.23	24.2125	24.2125	12400.0
2014-07-25 08:50:00	AAPL	Stock	24.22	24.23	24.22	24.2275	3600.0
2014-07-25 08:55:00	AAPL	Stock	24.225	24.225	24.215	24.2175	15400.0
2014-07-25 09:00:00	AAPL	Stock	24.2075	24.2125	24.1975	24.2125	10352.0
2014-07-25 09:05:00	AAPL	Stock	24.2075	24.2075	24.19	24.19	9180.0
2014-07-25 09:10:00	AAPL	Stock	24.19	24.195	24.1775	24.1925	96324.0
2014-07-25 09:15:00	AAPL	Stock	24.195	24.2	24.185	24.19	31000.0
2014-07-25 09:20:00	AAPL	Stock	24.19	24.19	24.185	24.185	24000.0
2014-07-25 09:25:00	AAPL	Stock	24.18	24.255	24.18	24.2225	119952.0
2014-07-25 09:30:00	AAPL	Stock	24.215	24.2625	24.16	24.2038	6513280.0
2014-07-25 09:35:00	AAPL	Stock	24.2025	24.2825	24.19	24.24	3465236.0
2014-07-25 09:40:00	AAPL	Stock	24.2375	24.2425	24.185	24.2425	2687028.0
2014-07-25 09:45:00	AAPL	Stock	24.2425	24.2625	24.2062	24.2252	3204276.0
2014-07-25 09:50:00	AAPL	Stock	24.2275	24.35	24.225	24.35	4615540.0
2014-07-25 09:55:00	AAPL	Stock	24.35	24.36	24.3175	24.32	3191928.0
2014-07-25 10:00:00	AAPL	Stock	24.3225	24.3775	24.3225	24.3725	4569320.0
2014-07-25 10:05:00	AAPL	Stock	24.37	24.3725	24.3225	24.35	2646480.0
2014-07-25 10:10:00	AAPL	Stock	24.3502	24.375	24.3425	24.3532	2180740.0
2014-07-25 10:15:00	AAPL	Stock	24.3538	24.4	24.3475	24.3972	2904408.0

> showing 50 of 349,204 rows — these rows as CSV

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