PREVIEW / stock_5min / 2017-01-31

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-31.parquet
  size:    5.5 MB
  rows:    355,254
  symbols: 3,129

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-01-31 04:20:00	AAPL	Stock	30.3375	30.3375	30.3375	30.3375	400.0
2017-01-31 04:25:00	AAPL	Stock	30.36	30.36	30.305	30.305	1544.0
2017-01-31 05:00:00	AAPL	Stock	30.4	30.4	30.4	30.4	2000.0
2017-01-31 05:20:00	AAPL	Stock	30.395	30.395	30.395	30.395	400.0
2017-01-31 05:35:00	AAPL	Stock	30.3725	30.3725	30.3725	30.3725	2000.0
2017-01-31 05:50:00	AAPL	Stock	30.37	30.37	30.37	30.37	3596.0
2017-01-31 06:10:00	AAPL	Stock	30.375	30.3925	30.345	30.345	8304.0
2017-01-31 06:35:00	AAPL	Stock	30.3875	30.3875	30.385	30.385	7200.0
2017-01-31 06:40:00	AAPL	Stock	30.4	30.4075	30.4	30.4075	4200.0
2017-01-31 06:45:00	AAPL	Stock	30.4125	30.4125	30.395	30.4	4360.0
2017-01-31 06:55:00	AAPL	Stock	30.395	30.395	30.395	30.395	820.0
2017-01-31 07:00:00	AAPL	Stock	30.3875	30.3975	30.3875	30.3975	7500.0
2017-01-31 07:05:00	AAPL	Stock	30.3875	30.4	30.3875	30.4	5380.0
2017-01-31 07:10:00	AAPL	Stock	30.4	30.4	30.3825	30.3875	10600.0
2017-01-31 07:15:00	AAPL	Stock	30.3875	30.425	30.3775	30.3775	13600.0
2017-01-31 07:25:00	AAPL	Stock	30.375	30.3825	30.375	30.3775	2000.0
2017-01-31 07:30:00	AAPL	Stock	30.38	30.3875	30.37	30.37	12000.0
2017-01-31 07:40:00	AAPL	Stock	30.365	30.365	30.3525	30.3525	12116.0
2017-01-31 07:50:00	AAPL	Stock	30.34	30.34	30.34	30.34	604.0
2017-01-31 07:55:00	AAPL	Stock	30.3475	30.3475	30.3475	30.3475	400.0
2017-01-31 08:00:00	AAPL	Stock	30.4	30.4	30.3275	30.355	82408.0
2017-01-31 08:05:00	AAPL	Stock	30.355	30.355	30.35	30.35	7200.0
2017-01-31 08:10:00	AAPL	Stock	30.35	30.355	30.33	30.33	5336.0
2017-01-31 08:15:00	AAPL	Stock	30.3425	30.3425	30.3275	30.3275	9036.0
2017-01-31 08:20:00	AAPL	Stock	30.3275	30.3425	30.3275	30.34	15060.0
2017-01-31 08:25:00	AAPL	Stock	30.3375	30.3425	30.335	30.335	7228.0
2017-01-31 08:30:00	AAPL	Stock	30.3425	30.355	30.325	30.325	48024.0
2017-01-31 08:35:00	AAPL	Stock	30.325	30.325	30.29	30.29	23736.0
2017-01-31 08:40:00	AAPL	Stock	30.2925	30.3025	30.2925	30.3	23280.0
2017-01-31 08:45:00	AAPL	Stock	30.31	30.32	30.31	30.32	4400.0
2017-01-31 08:50:00	AAPL	Stock	30.3025	30.3125	30.3	30.3025	15768.0
2017-01-31 08:55:00	AAPL	Stock	30.2875	30.3	30.2875	30.2875	14800.0
2017-01-31 09:00:00	AAPL	Stock	30.29	30.3125	30.29	30.2925	30116.0
2017-01-31 09:05:00	AAPL	Stock	30.31	30.31	30.2975	30.3	20496.0
2017-01-31 09:10:00	AAPL	Stock	30.3	30.3125	30.2925	30.3125	43944.0
2017-01-31 09:15:00	AAPL	Stock	30.305	30.325	30.305	30.315	20780.0
2017-01-31 09:20:00	AAPL	Stock	30.3175	30.3175	30.305	30.3125	34220.0
2017-01-31 09:25:00	AAPL	Stock	30.3125	30.325	30.25	30.275	124556.0
2017-01-31 09:30:00	AAPL	Stock	30.2875	30.325	30.2025	30.2525	7600220.0
2017-01-31 09:35:00	AAPL	Stock	30.25	30.3475	30.2375	30.335	3591804.0
2017-01-31 09:40:00	AAPL	Stock	30.3375	30.3475	30.265	30.3075	2728308.0
2017-01-31 09:45:00	AAPL	Stock	30.305	30.3475	30.2825	30.29	2840268.0
2017-01-31 09:50:00	AAPL	Stock	30.2875	30.3125	30.2725	30.2762	1916608.0
2017-01-31 09:55:00	AAPL	Stock	30.275	30.294	30.2675	30.29	1631516.0
2017-01-31 10:00:00	AAPL	Stock	30.29	30.2962	30.2275	30.235	2273052.0
2017-01-31 10:05:00	AAPL	Stock	30.2362	30.26	30.225	30.2378	2332040.0
2017-01-31 10:10:00	AAPL	Stock	30.2382	30.24	30.2075	30.225	1763572.0
2017-01-31 10:15:00	AAPL	Stock	30.2262	30.25	30.225	30.2468	1534368.0
2017-01-31 10:20:00	AAPL	Stock	30.2455	30.2575	30.23	30.245	1616584.0
2017-01-31 10:25:00	AAPL	Stock	30.245	30.2525	30.2275	30.23	1382424.0

> showing 50 of 355,254 rows — these rows as CSV

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