PREVIEW / stock_5min / 2017-08-28

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-28.parquet
  size:    5.2 MB
  rows:    344,070
  symbols: 2,993

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-08-28 06:20:00	AAPL	Stock	39.94	39.94	39.94	39.94	400.0
2017-08-28 06:35:00	AAPL	Stock	39.9125	39.9125	39.9125	39.9125	400.0
2017-08-28 06:45:00	AAPL	Stock	39.95	39.9525	39.95	39.95	7140.0
2017-08-28 06:50:00	AAPL	Stock	39.9525	39.9525	39.9525	39.9525	400.0
2017-08-28 06:55:00	AAPL	Stock	39.95	39.95	39.95	39.95	400.0
2017-08-28 07:00:00	AAPL	Stock	39.95	39.95	39.93	39.93	1556.0
2017-08-28 07:10:00	AAPL	Stock	39.9425	39.9425	39.9425	39.9425	400.0
2017-08-28 07:15:00	AAPL	Stock	39.9725	40.0	39.9725	40.0	7788.0
2017-08-28 07:20:00	AAPL	Stock	40.05	40.05	40.05	40.05	1180.0
2017-08-28 07:25:00	AAPL	Stock	40.05	40.05	40.045	40.045	1768.0
2017-08-28 07:30:00	AAPL	Stock	40.0025	40.0025	40.0	40.0	4920.0
2017-08-28 07:40:00	AAPL	Stock	40.025	40.025	40.025	40.025	400.0
2017-08-28 07:45:00	AAPL	Stock	40.0375	40.0375	40.025	40.025	3600.0
2017-08-28 07:55:00	AAPL	Stock	40.0125	40.0125	40.0125	40.0125	1204.0
2017-08-28 08:00:00	AAPL	Stock	40.045	40.045	39.9275	40.025	39268.0
2017-08-28 08:05:00	AAPL	Stock	40.025	40.025	40.0125	40.0125	4456.0
2017-08-28 08:10:00	AAPL	Stock	40.045	40.045	40.0175	40.0175	800.0
2017-08-28 08:15:00	AAPL	Stock	40.025	40.045	40.0225	40.045	16988.0
2017-08-28 08:20:00	AAPL	Stock	40.045	40.05	40.0425	40.05	8788.0
2017-08-28 08:25:00	AAPL	Stock	40.05	40.05	40.0425	40.0425	12800.0
2017-08-28 08:30:00	AAPL	Stock	40.05	40.0625	40.05	40.05	2000.0
2017-08-28 08:35:00	AAPL	Stock	40.0425	40.06	40.04	40.06	4400.0
2017-08-28 08:40:00	AAPL	Stock	40.0625	40.075	40.0625	40.075	20172.0
2017-08-28 08:45:00	AAPL	Stock	40.075	40.075	40.0625	40.065	5200.0
2017-08-28 08:50:00	AAPL	Stock	40.065	40.065	40.065	40.065	1200.0
2017-08-28 08:55:00	AAPL	Stock	40.065	40.075	40.065	40.0725	16440.0
2017-08-28 09:00:00	AAPL	Stock	40.0675	40.075	40.0675	40.075	25552.0
2017-08-28 09:05:00	AAPL	Stock	40.0725	40.075	40.0525	40.07	25532.0
2017-08-28 09:10:00	AAPL	Stock	40.07	40.07	40.055	40.055	17516.0
2017-08-28 09:15:00	AAPL	Stock	40.0625	40.0625	40.04	40.045	25568.0
2017-08-28 09:20:00	AAPL	Stock	40.055	40.0625	40.05	40.0625	31792.0
2017-08-28 09:25:00	AAPL	Stock	40.0625	40.0675	40.0275	40.05	35736.0
2017-08-28 09:30:00	AAPL	Stock	40.035	40.1525	40.025	40.1525	3071708.0
2017-08-28 09:35:00	AAPL	Stock	40.1475	40.15	40.0647	40.0725	1295936.0
2017-08-28 09:40:00	AAPL	Stock	40.0737	40.1325	40.07	40.1325	1589556.0
2017-08-28 09:45:00	AAPL	Stock	40.13	40.205	40.055	40.0948	2662472.0
2017-08-28 09:50:00	AAPL	Stock	40.0938	40.1175	39.9825	40.0375	2087824.0
2017-08-28 09:55:00	AAPL	Stock	40.04	40.17	40.0157	40.1562	2174580.0
2017-08-28 10:00:00	AAPL	Stock	40.157	40.23	40.105	40.2	1603536.0
2017-08-28 10:05:00	AAPL	Stock	40.2	40.2775	40.19	40.238	2858620.0
2017-08-28 10:10:00	AAPL	Stock	40.235	40.3675	40.235	40.365	2209232.0
2017-08-28 10:15:00	AAPL	Stock	40.365	40.3825	40.335	40.365	1776432.0
2017-08-28 10:20:00	AAPL	Stock	40.3625	40.39	40.33	40.3625	2133224.0
2017-08-28 10:25:00	AAPL	Stock	40.3623	40.3725	40.29	40.3	1017588.0
2017-08-28 10:30:00	AAPL	Stock	40.3	40.311	40.2625	40.2762	1553812.0
2017-08-28 10:35:00	AAPL	Stock	40.2775	40.3375	40.25	40.3375	1142820.0
2017-08-28 10:40:00	AAPL	Stock	40.335	40.4425	40.3275	40.4375	1802868.0
2017-08-28 10:45:00	AAPL	Stock	40.4375	40.4575	40.3875	40.4225	1530832.0
2017-08-28 10:50:00	AAPL	Stock	40.4225	40.4725	40.4025	40.4405	1264528.0
2017-08-28 10:55:00	AAPL	Stock	40.4422	40.4575	40.4225	40.4475	766528.0

> showing 50 of 344,070 rows — these rows as CSV

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