PREVIEW / stock_5min / 2017-02-27

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-02-27.parquet
  size:    5.5 MB
  rows:    357,630
  symbols: 3,107

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
2017-02-27 04:25:00	AAPL	Stock	34.125	34.125	34.125	34.125	800.0
2017-02-27 06:15:00	AAPL	Stock	34.1525	34.1525	34.1525	34.1525	5600.0
2017-02-27 06:20:00	AAPL	Stock	34.1525	34.1925	34.15	34.1925	9600.0
2017-02-27 06:25:00	AAPL	Stock	34.2125	34.2525	34.2125	34.25	26344.0
2017-02-27 06:30:00	AAPL	Stock	34.25	34.285	34.25	34.275	8520.0
2017-02-27 06:35:00	AAPL	Stock	34.2625	34.2725	34.2625	34.27	2000.0
2017-02-27 06:40:00	AAPL	Stock	34.2725	34.3	34.2625	34.3	21720.0
2017-02-27 06:45:00	AAPL	Stock	34.3	34.31	34.3	34.31	4400.0
2017-02-27 06:50:00	AAPL	Stock	34.3125	34.3225	34.255	34.255	11200.0
2017-02-27 06:55:00	AAPL	Stock	34.3	34.3125	34.3	34.3125	16800.0
2017-02-27 07:00:00	AAPL	Stock	34.3125	34.325	34.2625	34.2625	32340.0
2017-02-27 07:05:00	AAPL	Stock	34.265	34.31	34.215	34.26	35140.0
2017-02-27 07:10:00	AAPL	Stock	34.265	34.2675	34.26	34.2675	14348.0
2017-02-27 07:15:00	AAPL	Stock	34.2675	34.2675	34.25	34.2525	24000.0
2017-02-27 07:20:00	AAPL	Stock	34.275	34.285	34.275	34.275	9236.0
2017-02-27 07:25:00	AAPL	Stock	34.275	34.2875	34.275	34.275	13340.0
2017-02-27 07:30:00	AAPL	Stock	34.275	34.2875	34.275	34.275	19600.0
2017-02-27 07:35:00	AAPL	Stock	34.275	34.275	34.2725	34.2725	6800.0
2017-02-27 07:40:00	AAPL	Stock	34.275	34.275	34.2625	34.2625	12540.0
2017-02-27 07:45:00	AAPL	Stock	34.255	34.2625	34.2525	34.2625	8416.0
2017-02-27 07:50:00	AAPL	Stock	34.2525	34.2625	34.2325	34.235	21372.0
2017-02-27 07:55:00	AAPL	Stock	34.245	34.25	34.245	34.25	7652.0
2017-02-27 08:00:00	AAPL	Stock	34.25	34.3125	34.2325	34.25	47516.0
2017-02-27 08:05:00	AAPL	Stock	34.26	34.2625	34.235	34.235	32852.0
2017-02-27 08:10:00	AAPL	Stock	34.2425	34.25	34.2425	34.245	33140.0
2017-02-27 08:15:00	AAPL	Stock	34.2475	34.25	34.2125	34.2425	56400.0
2017-02-27 08:20:00	AAPL	Stock	34.2425	34.2475	34.23	34.23	11044.0
2017-02-27 08:25:00	AAPL	Stock	34.245	34.245	34.2375	34.2425	8200.0
2017-02-27 08:30:00	AAPL	Stock	34.24	34.265	34.24	34.2625	22324.0
2017-02-27 08:35:00	AAPL	Stock	34.2625	34.28	34.255	34.2775	27000.0
2017-02-27 08:40:00	AAPL	Stock	34.285	34.285	34.2625	34.2625	21576.0
2017-02-27 08:45:00	AAPL	Stock	34.25	34.2525	34.2325	34.2425	27800.0
2017-02-27 08:50:00	AAPL	Stock	34.24	34.26	34.235	34.25	16740.0
2017-02-27 08:55:00	AAPL	Stock	34.235	34.2475	34.2325	34.2475	12800.0
2017-02-27 09:00:00	AAPL	Stock	34.25	34.265	34.25	34.2625	13444.0
2017-02-27 09:05:00	AAPL	Stock	34.2675	34.2925	34.2525	34.29	47728.0
2017-02-27 09:10:00	AAPL	Stock	34.2875	34.3025	34.275	34.2825	42288.0
2017-02-27 09:15:00	AAPL	Stock	34.3025	34.3025	34.2838	34.2875	40440.0
2017-02-27 09:20:00	AAPL	Stock	34.295	34.3125	34.295	34.3	64840.0
2017-02-27 09:25:00	AAPL	Stock	34.305	34.325	34.25	34.2525	248376.0
2017-02-27 09:30:00	AAPL	Stock	34.26	34.2875	34.1075	34.115	7263972.0
2017-02-27 09:35:00	AAPL	Stock	34.1075	34.1512	34.07	34.105	2572688.0
2017-02-27 09:40:00	AAPL	Stock	34.105	34.1798	34.09	34.1675	2113952.0
2017-02-27 09:45:00	AAPL	Stock	34.17	34.2625	34.17	34.2525	2119108.0
2017-02-27 09:50:00	AAPL	Stock	34.2525	34.265	34.24	34.2425	1763760.0
2017-02-27 09:55:00	AAPL	Stock	34.2438	34.275	34.22	34.27	1349812.0
2017-02-27 10:00:00	AAPL	Stock	34.2725	34.28	34.23	34.2425	1188904.0
2017-02-27 10:05:00	AAPL	Stock	34.2412	34.2725	34.225	34.2675	1243912.0
2017-02-27 10:10:00	AAPL	Stock	34.2675	34.33	34.2675	34.3125	2144400.0
2017-02-27 10:15:00	AAPL	Stock	34.311	34.3125	34.2838	34.2905	1369876.0

> showing 50 of 357,630 rows — these rows as CSV

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