PREVIEW / stock_5min / 2016-10-24

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-10-24.parquet
  size:    5.1 MB
  rows:    338,046
  symbols: 3,212

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-10-24 04:00:00	AAPL	Stock	29.1675	29.25	29.1675	29.25	800.0
2016-10-24 04:35:00	AAPL	Stock	29.2675	29.2675	29.2675	29.2675	400.0
2016-10-24 04:40:00	AAPL	Stock	29.2675	29.2675	29.2675	29.2675	400.0
2016-10-24 04:50:00	AAPL	Stock	29.285	29.285	29.285	29.285	400.0
2016-10-24 05:05:00	AAPL	Stock	29.3125	29.36	29.3125	29.3125	6000.0
2016-10-24 05:10:00	AAPL	Stock	29.365	29.365	29.365	29.365	400.0
2016-10-24 05:15:00	AAPL	Stock	29.35	29.3625	29.35	29.3625	2800.0
2016-10-24 05:20:00	AAPL	Stock	29.35	29.3625	29.3425	29.3425	8124.0
2016-10-24 05:30:00	AAPL	Stock	29.35	29.35	29.35	29.35	4000.0
2016-10-24 05:35:00	AAPL	Stock	29.3525	29.3525	29.3375	29.3375	4800.0
2016-10-24 05:40:00	AAPL	Stock	29.325	29.325	29.325	29.325	2000.0
2016-10-24 05:50:00	AAPL	Stock	29.3425	29.35	29.3425	29.35	1952.0
2016-10-24 06:00:00	AAPL	Stock	29.35	29.37	29.3375	29.37	6056.0
2016-10-24 06:30:00	AAPL	Stock	29.37	29.37	29.3625	29.37	7872.0
2016-10-24 06:40:00	AAPL	Stock	29.3625	29.3625	29.3625	29.3625	800.0
2016-10-24 06:45:00	AAPL	Stock	29.35	29.35	29.35	29.35	800.0
2016-10-24 06:50:00	AAPL	Stock	29.3625	29.3625	29.355	29.355	4680.0
2016-10-24 06:55:00	AAPL	Stock	29.3675	29.37	29.355	29.37	6000.0
2016-10-24 07:00:00	AAPL	Stock	29.35	29.3675	29.325	29.3675	23576.0
2016-10-24 07:05:00	AAPL	Stock	29.35	29.35	29.3475	29.3475	10852.0
2016-10-24 07:10:00	AAPL	Stock	29.3275	29.3275	29.315	29.315	1200.0
2016-10-24 07:15:00	AAPL	Stock	29.3125	29.3125	29.3125	29.3125	3800.0
2016-10-24 07:20:00	AAPL	Stock	29.335	29.335	29.335	29.335	2288.0
2016-10-24 07:25:00	AAPL	Stock	29.335	29.335	29.335	29.335	1200.0
2016-10-24 07:30:00	AAPL	Stock	29.315	29.315	29.3125	29.3125	1400.0
2016-10-24 07:35:00	AAPL	Stock	29.3	29.3	29.3	29.3	16300.0
2016-10-24 07:40:00	AAPL	Stock	29.3	29.3	29.3	29.3	1200.0
2016-10-24 07:45:00	AAPL	Stock	29.275	29.275	29.275	29.275	1200.0
2016-10-24 07:50:00	AAPL	Stock	29.2925	29.3	29.2925	29.2925	2000.0
2016-10-24 08:00:00	AAPL	Stock	29.3575	29.3575	29.2525	29.2875	107632.0
2016-10-24 08:05:00	AAPL	Stock	29.2975	29.31	29.2925	29.2925	21472.0
2016-10-24 08:10:00	AAPL	Stock	29.3	29.3	29.2875	29.2925	8640.0
2016-10-24 08:15:00	AAPL	Stock	29.2875	29.2875	29.2475	29.26	60184.0
2016-10-24 08:20:00	AAPL	Stock	29.275	29.275	29.2725	29.275	4720.0
2016-10-24 08:25:00	AAPL	Stock	29.275	29.275	29.2675	29.275	3888.0
2016-10-24 08:30:00	AAPL	Stock	29.2625	29.2825	29.25	29.25	29380.0
2016-10-24 08:35:00	AAPL	Stock	29.2525	29.2825	29.25	29.28	27884.0
2016-10-24 08:40:00	AAPL	Stock	29.29	29.295	29.28	29.295	56332.0
2016-10-24 08:45:00	AAPL	Stock	29.2875	29.2875	29.265	29.265	27680.0
2016-10-24 08:50:00	AAPL	Stock	29.28	29.295	29.28	29.2825	26752.0
2016-10-24 08:55:00	AAPL	Stock	29.2825	29.285	29.28	29.28	15900.0
2016-10-24 09:00:00	AAPL	Stock	29.29	29.3125	29.28	29.3	65032.0
2016-10-24 09:05:00	AAPL	Stock	29.3125	29.3125	29.3	29.3125	22480.0
2016-10-24 09:10:00	AAPL	Stock	29.32	29.3225	29.3	29.3	23084.0
2016-10-24 09:15:00	AAPL	Stock	29.3	29.3425	29.295	29.295	53060.0
2016-10-24 09:20:00	AAPL	Stock	29.2825	29.2825	29.25	29.25	50952.0
2016-10-24 09:25:00	AAPL	Stock	29.2475	29.275	29.225	29.2725	65004.0
2016-10-24 09:30:00	AAPL	Stock	29.275	29.3725	29.25	29.3725	5287912.0
2016-10-24 09:35:00	AAPL	Stock	29.3725	29.3975	29.3425	29.3625	3136248.0
2016-10-24 09:40:00	AAPL	Stock	29.36	29.3675	29.2825	29.3225	2310824.0

> showing 50 of 338,046 rows — these rows as CSV

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