PREVIEW / stock_5min / 2017-12-15

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-12-15.parquet
  size:    5.8 MB
  rows:    379,360
  symbols: 2,943

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-12-15 04:10:00	AAPL	Stock	43.125	43.125	43.125	43.125	400.0
2017-12-15 05:15:00	AAPL	Stock	43.05	43.05	43.05	43.05	3600.0
2017-12-15 06:00:00	AAPL	Stock	43.0275	43.0275	43.0275	43.0275	796.0
2017-12-15 06:05:00	AAPL	Stock	43.065	43.065	43.065	43.065	400.0
2017-12-15 06:10:00	AAPL	Stock	43.0875	43.0875	43.0875	43.0875	788.0
2017-12-15 06:20:00	AAPL	Stock	43.1125	43.1125	43.1125	43.1125	400.0
2017-12-15 06:25:00	AAPL	Stock	43.1025	43.11	43.1025	43.11	1200.0
2017-12-15 06:30:00	AAPL	Stock	43.1125	43.1125	43.1125	43.1125	2000.0
2017-12-15 06:35:00	AAPL	Stock	43.1125	43.1125	43.1125	43.1125	400.0
2017-12-15 06:40:00	AAPL	Stock	43.1125	43.1125	43.1125	43.1125	1800.0
2017-12-15 06:55:00	AAPL	Stock	43.125	43.125	43.125	43.125	3980.0
2017-12-15 07:00:00	AAPL	Stock	43.1025	43.105	43.1025	43.105	800.0
2017-12-15 07:10:00	AAPL	Stock	43.105	43.1075	43.105	43.1075	10000.0
2017-12-15 07:15:00	AAPL	Stock	43.105	43.105	43.105	43.105	412.0
2017-12-15 07:20:00	AAPL	Stock	43.105	43.1075	43.105	43.1075	1860.0
2017-12-15 07:30:00	AAPL	Stock	43.1175	43.1175	43.1175	43.1175	400.0
2017-12-15 07:45:00	AAPL	Stock	43.1125	43.1375	43.1125	43.1375	53716.0
2017-12-15 07:50:00	AAPL	Stock	43.14	43.15	43.14	43.15	4400.0
2017-12-15 07:55:00	AAPL	Stock	43.135	43.15	43.135	43.15	1056.0
2017-12-15 08:00:00	AAPL	Stock	43.1375	43.14	43.075	43.1125	101016.0
2017-12-15 08:05:00	AAPL	Stock	43.1125	43.1125	43.1125	43.1125	1184.0
2017-12-15 08:10:00	AAPL	Stock	43.1125	43.135	43.1125	43.135	5668.0
2017-12-15 08:15:00	AAPL	Stock	43.115	43.1225	43.115	43.115	14800.0
2017-12-15 08:20:00	AAPL	Stock	43.1275	43.1575	43.1275	43.155	32640.0
2017-12-15 08:25:00	AAPL	Stock	43.1425	43.1425	43.1375	43.1375	4148.0
2017-12-15 08:30:00	AAPL	Stock	43.155	43.155	43.055	43.055	9028.0
2017-12-15 08:35:00	AAPL	Stock	43.15	43.155	43.1375	43.1375	13516.0
2017-12-15 08:40:00	AAPL	Stock	43.15	43.155	43.1375	43.1375	12588.0
2017-12-15 08:45:00	AAPL	Stock	43.1375	43.145	43.125	43.125	6588.0
2017-12-15 08:50:00	AAPL	Stock	43.1275	43.15	43.1275	43.15	4400.0
2017-12-15 08:55:00	AAPL	Stock	43.135	43.1375	43.135	43.1375	2200.0
2017-12-15 09:00:00	AAPL	Stock	43.1375	43.1575	43.1375	43.15	16512.0
2017-12-15 09:05:00	AAPL	Stock	43.14	43.15	43.055	43.1175	894940.0
2017-12-15 09:10:00	AAPL	Stock	43.14	43.1625	43.1125	43.1125	43164.0
2017-12-15 09:15:00	AAPL	Stock	43.125	43.1375	43.125	43.1375	8220.0
2017-12-15 09:20:00	AAPL	Stock	43.145	43.15	43.135	43.15	22348.0
2017-12-15 09:25:00	AAPL	Stock	43.155	43.4475	43.1375	43.28	2040116.0
2017-12-15 09:30:00	AAPL	Stock	43.2025	43.42	43.115	43.2275	33915772.0
2017-12-15 09:35:00	AAPL	Stock	43.2325	43.275	43.185	43.1925	2441032.0
2017-12-15 09:40:00	AAPL	Stock	43.1925	43.2575	43.1675	43.1925	1668588.0
2017-12-15 09:45:00	AAPL	Stock	43.1925	43.24	43.16	43.1775	1590916.0
2017-12-15 09:50:00	AAPL	Stock	43.1775	43.22	43.15	43.2	1004096.0
2017-12-15 09:55:00	AAPL	Stock	43.2	43.2525	43.19	43.2125	1323808.0
2017-12-15 10:00:00	AAPL	Stock	43.215	43.2325	43.1875	43.2175	894476.0
2017-12-15 10:05:00	AAPL	Stock	43.215	43.245	43.185	43.2175	742040.0
2017-12-15 10:10:00	AAPL	Stock	43.22	43.2375	43.1625	43.1638	1258608.0
2017-12-15 10:15:00	AAPL	Stock	43.165	43.2525	43.16	43.23	1448440.0
2017-12-15 10:20:00	AAPL	Stock	43.225	43.2312	43.2	43.22	780660.0
2017-12-15 10:25:00	AAPL	Stock	43.2175	43.26	43.2025	43.235	1023704.0
2017-12-15 10:30:00	AAPL	Stock	43.235	43.2675	43.18	43.2038	1364096.0

> showing 50 of 379,360 rows — these rows as CSV

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