PREVIEW / stock_5min / 2016-09-27

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-09-27.parquet
  size:    5.3 MB
  rows:    348,556
  symbols: 3,205

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
2016-09-27 04:15:00	AAPL	Stock	28.385	28.385	28.385	28.385	400.0
2016-09-27 04:25:00	AAPL	Stock	28.34	28.34	28.34	28.34	1748.0
2016-09-27 04:55:00	AAPL	Stock	28.325	28.325	28.2275	28.2275	8872.0
2016-09-27 05:20:00	AAPL	Stock	28.2825	28.2825	28.2825	28.2825	840.0
2016-09-27 05:25:00	AAPL	Stock	28.2825	28.2825	28.2825	28.2825	800.0
2016-09-27 05:40:00	AAPL	Stock	28.2875	28.2875	28.2875	28.2875	416.0
2016-09-27 06:05:00	AAPL	Stock	28.22	28.22	28.22	28.22	400.0
2016-09-27 06:10:00	AAPL	Stock	28.25	28.25	28.25	28.25	1200.0
2016-09-27 06:20:00	AAPL	Stock	28.25	28.25	28.25	28.25	400.0
2016-09-27 06:25:00	AAPL	Stock	28.25	28.25	28.25	28.25	400.0
2016-09-27 06:30:00	AAPL	Stock	28.2275	28.2275	28.2125	28.2125	14000.0
2016-09-27 06:45:00	AAPL	Stock	28.21	28.32	28.21	28.32	37320.0
2016-09-27 07:00:00	AAPL	Stock	28.31	28.31	28.31	28.31	800.0
2016-09-27 07:05:00	AAPL	Stock	28.2875	28.3125	28.2875	28.3125	920.0
2016-09-27 07:10:00	AAPL	Stock	28.265	28.31	28.265	28.3	10320.0
2016-09-27 07:15:00	AAPL	Stock	28.3	28.3	28.3	28.3	4800.0
2016-09-27 07:20:00	AAPL	Stock	28.305	28.33	28.305	28.33	23880.0
2016-09-27 07:25:00	AAPL	Stock	28.3375	28.3375	28.3025	28.325	12960.0
2016-09-27 07:30:00	AAPL	Stock	28.3475	28.35	28.3425	28.3425	6000.0
2016-09-27 07:35:00	AAPL	Stock	28.3425	28.355	28.3425	28.355	9120.0
2016-09-27 07:40:00	AAPL	Stock	28.36	28.375	28.34	28.34	27940.0
2016-09-27 07:45:00	AAPL	Stock	28.34	28.34	28.325	28.325	5664.0
2016-09-27 07:50:00	AAPL	Stock	28.33	28.33	28.33	28.33	1952.0
2016-09-27 07:55:00	AAPL	Stock	28.33	28.3475	28.33	28.3475	13024.0
2016-09-27 08:00:00	AAPL	Stock	28.3625	28.3625	28.1625	28.2975	87700.0
2016-09-27 08:05:00	AAPL	Stock	28.2975	28.3075	28.2975	28.3	18816.0
2016-09-27 08:10:00	AAPL	Stock	28.3	28.3	28.2975	28.3	18400.0
2016-09-27 08:15:00	AAPL	Stock	28.3	28.3	28.2775	28.2875	19644.0
2016-09-27 08:20:00	AAPL	Stock	28.2875	28.2875	28.225	28.2425	50984.0
2016-09-27 08:25:00	AAPL	Stock	28.2425	28.2475	28.2325	28.2375	13264.0
2016-09-27 08:30:00	AAPL	Stock	28.2475	28.25	28.24	28.2475	19340.0
2016-09-27 08:35:00	AAPL	Stock	28.2425	28.2725	28.225	28.2625	60188.0
2016-09-27 08:40:00	AAPL	Stock	28.27	28.29	28.245	28.245	31896.0
2016-09-27 08:45:00	AAPL	Stock	28.25	28.3	28.25	28.28	13080.0
2016-09-27 08:50:00	AAPL	Stock	28.295	28.295	28.28	28.2925	6076.0
2016-09-27 08:55:00	AAPL	Stock	28.2925	28.295	28.2775	28.295	44200.0
2016-09-27 09:00:00	AAPL	Stock	28.2825	28.2825	28.275	28.2775	58760.0
2016-09-27 09:05:00	AAPL	Stock	28.2775	28.2775	28.245	28.2525	159540.0
2016-09-27 09:10:00	AAPL	Stock	28.25	28.25	28.2375	28.25	58924.0
2016-09-27 09:15:00	AAPL	Stock	28.25	28.2675	28.25	28.2675	29000.0
2016-09-27 09:20:00	AAPL	Stock	28.2775	28.2775	28.265	28.265	30792.0
2016-09-27 09:25:00	AAPL	Stock	28.2625	28.27	28.23	28.23	23800.0
2016-09-27 09:30:00	AAPL	Stock	28.25	28.2575	28.1125	28.1825	5053724.0
2016-09-27 09:35:00	AAPL	Stock	28.1775	28.235	28.14	28.14	2666540.0
2016-09-27 09:40:00	AAPL	Stock	28.1425	28.2	28.13	28.1638	2934204.0
2016-09-27 09:45:00	AAPL	Stock	28.165	28.235	28.155	28.1825	2329240.0
2016-09-27 09:50:00	AAPL	Stock	28.1825	28.195	28.1375	28.155	2180332.0
2016-09-27 09:55:00	AAPL	Stock	28.155	28.2	28.135	28.1925	1594144.0
2016-09-27 10:00:00	AAPL	Stock	28.1912	28.285	28.1675	28.2475	2832264.0
2016-09-27 10:05:00	AAPL	Stock	28.25	28.265	28.215	28.2272	1643280.0

> showing 50 of 348,556 rows — these rows as CSV

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