PREVIEW / stock_5min / 2017-07-18

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-18.parquet
  size:    5.3 MB
  rows:    344,053
  symbols: 3,003

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-07-18 04:15:00	AAPL	Stock	37.3775	37.3775	37.3775	37.3775	400.0
2017-07-18 04:25:00	AAPL	Stock	37.375	37.375	37.375	37.375	1624.0
2017-07-18 04:30:00	AAPL	Stock	37.375	37.375	37.375	37.375	636.0
2017-07-18 04:35:00	AAPL	Stock	37.375	37.375	37.375	37.375	5864.0
2017-07-18 05:45:00	AAPL	Stock	37.405	37.405	37.405	37.405	800.0
2017-07-18 06:00:00	AAPL	Stock	37.405	37.405	37.38	37.38	1480.0
2017-07-18 06:15:00	AAPL	Stock	37.385	37.385	37.38	37.38	2000.0
2017-07-18 06:25:00	AAPL	Stock	37.38	37.38	37.38	37.38	400.0
2017-07-18 06:30:00	AAPL	Stock	37.375	37.375	37.375	37.375	1600.0
2017-07-18 06:40:00	AAPL	Stock	37.3625	37.3625	37.35	37.35	4400.0
2017-07-18 06:50:00	AAPL	Stock	37.3725	37.3725	37.3525	37.3725	1600.0
2017-07-18 06:55:00	AAPL	Stock	37.3625	37.3625	37.35	37.35	2000.0
2017-07-18 07:00:00	AAPL	Stock	37.35	37.3625	37.35	37.35	3200.0
2017-07-18 07:05:00	AAPL	Stock	37.3625	37.38	37.355	37.3625	7400.0
2017-07-18 07:10:00	AAPL	Stock	37.3525	37.3525	37.2875	37.3225	31808.0
2017-07-18 07:15:00	AAPL	Stock	37.3	37.3175	37.3	37.3	9176.0
2017-07-18 07:20:00	AAPL	Stock	37.295	37.295	37.295	37.295	800.0
2017-07-18 07:25:00	AAPL	Stock	37.29	37.3	37.2875	37.3	22896.0
2017-07-18 07:30:00	AAPL	Stock	37.2925	37.2925	37.2875	37.2875	7600.0
2017-07-18 07:35:00	AAPL	Stock	37.2925	37.295	37.2875	37.295	3100.0
2017-07-18 07:40:00	AAPL	Stock	37.295	37.295	37.295	37.295	400.0
2017-07-18 07:45:00	AAPL	Stock	37.295	37.295	37.295	37.295	2800.0
2017-07-18 07:50:00	AAPL	Stock	37.275	37.275	37.275	37.275	9568.0
2017-07-18 08:00:00	AAPL	Stock	37.29	37.3725	37.2775	37.335	22572.0
2017-07-18 08:05:00	AAPL	Stock	37.3075	37.3375	37.3075	37.3375	16460.0
2017-07-18 08:10:00	AAPL	Stock	37.325	37.325	37.32	37.32	1600.0
2017-07-18 08:15:00	AAPL	Stock	37.3225	37.3425	37.3225	37.3425	1600.0
2017-07-18 08:20:00	AAPL	Stock	37.32	37.3425	37.295	37.32	46336.0
2017-07-18 08:25:00	AAPL	Stock	37.32	37.3325	37.3125	37.3325	5996.0
2017-07-18 08:30:00	AAPL	Stock	37.3325	37.3375	37.3325	37.3375	5060.0
2017-07-18 08:35:00	AAPL	Stock	37.32	37.32	37.3125	37.3125	12172.0
2017-07-18 08:40:00	AAPL	Stock	37.2925	37.2925	37.2625	37.2625	34400.0
2017-07-18 08:45:00	AAPL	Stock	37.2625	37.265	37.2	37.205	70484.0
2017-07-18 08:50:00	AAPL	Stock	37.2075	37.2475	37.2075	37.2325	20588.0
2017-07-18 08:55:00	AAPL	Stock	37.2375	37.25	37.2125	37.215	46780.0
2017-07-18 09:00:00	AAPL	Stock	37.205	37.225	37.2025	37.2125	10280.0
2017-07-18 09:05:00	AAPL	Stock	37.225	37.2375	37.225	37.225	23060.0
2017-07-18 09:10:00	AAPL	Stock	37.2475	37.25	37.225	37.23	6400.0
2017-07-18 09:15:00	AAPL	Stock	37.235	37.2375	37.225	37.225	44208.0
2017-07-18 09:20:00	AAPL	Stock	37.2475	37.2475	37.2175	37.2275	17940.0
2017-07-18 09:25:00	AAPL	Stock	37.225	37.365	37.2	37.3625	96588.0
2017-07-18 09:30:00	AAPL	Stock	37.36	37.36	37.2025	37.2112	2798324.0
2017-07-18 09:35:00	AAPL	Stock	37.2125	37.2558	37.18	37.23	1776588.0
2017-07-18 09:40:00	AAPL	Stock	37.23	37.311	37.2175	37.2775	1799012.0
2017-07-18 09:45:00	AAPL	Stock	37.275	37.32	37.2548	37.2625	1207624.0
2017-07-18 09:50:00	AAPL	Stock	37.265	37.2858	37.2275	37.2275	906436.0
2017-07-18 09:55:00	AAPL	Stock	37.229	37.2525	37.205	37.2075	1280444.0
2017-07-18 10:00:00	AAPL	Stock	37.21	37.24	37.1675	37.185	1304932.0
2017-07-18 10:05:00	AAPL	Stock	37.185	37.2375	37.1763	37.235	1005120.0
2017-07-18 10:10:00	AAPL	Stock	37.235	37.2775	37.2075	37.2602	1043308.0

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

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