PREVIEW / stock_5min / 2017-06-27

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-06-27.parquet
  size:    5.4 MB
  rows:    355,781
  symbols: 3,013

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-06-27 04:00:00	AAPL	Stock	36.3025	36.305	36.29	36.29	5060.0
2017-06-27 04:25:00	AAPL	Stock	36.265	36.265	36.265	36.265	400.0
2017-06-27 04:50:00	AAPL	Stock	36.285	36.285	36.285	36.285	2000.0
2017-06-27 05:10:00	AAPL	Stock	36.285	36.285	36.2525	36.2525	2424.0
2017-06-27 05:15:00	AAPL	Stock	36.235	36.235	36.235	36.235	3772.0
2017-06-27 05:45:00	AAPL	Stock	36.325	36.325	36.25	36.25	11600.0
2017-06-27 05:50:00	AAPL	Stock	36.25	36.25	36.225	36.225	4800.0
2017-06-27 05:55:00	AAPL	Stock	36.225	36.225	36.225	36.225	400.0
2017-06-27 06:00:00	AAPL	Stock	36.2	36.2	36.2	36.2	2800.0
2017-06-27 06:05:00	AAPL	Stock	36.2	36.2	36.2	36.2	2200.0
2017-06-27 06:10:00	AAPL	Stock	36.2	36.2	36.2	36.2	12156.0
2017-06-27 06:15:00	AAPL	Stock	36.1925	36.1925	36.185	36.185	1584.0
2017-06-27 06:20:00	AAPL	Stock	36.1925	36.205	36.1925	36.205	3808.0
2017-06-27 06:25:00	AAPL	Stock	36.205	36.205	36.205	36.205	1184.0
2017-06-27 06:30:00	AAPL	Stock	36.2075	36.2075	36.2075	36.2075	400.0
2017-06-27 06:35:00	AAPL	Stock	36.225	36.225	36.225	36.225	400.0
2017-06-27 06:40:00	AAPL	Stock	36.225	36.225	36.225	36.225	2400.0
2017-06-27 06:45:00	AAPL	Stock	36.225	36.25	36.225	36.25	14000.0
2017-06-27 06:50:00	AAPL	Stock	36.2375	36.2475	36.225	36.2475	6800.0
2017-06-27 06:55:00	AAPL	Stock	36.2475	36.2475	36.2475	36.2475	1200.0
2017-06-27 07:00:00	AAPL	Stock	36.25	36.25	36.25	36.25	5424.0
2017-06-27 07:05:00	AAPL	Stock	36.2475	36.25	36.2325	36.2325	6604.0
2017-06-27 07:10:00	AAPL	Stock	36.235	36.2375	36.235	36.235	4000.0
2017-06-27 07:15:00	AAPL	Stock	36.2475	36.25	36.2475	36.25	33936.0
2017-06-27 07:20:00	AAPL	Stock	36.2725	36.2825	36.255	36.27	11920.0
2017-06-27 07:25:00	AAPL	Stock	36.26	36.26	36.2475	36.2475	14592.0
2017-06-27 07:35:00	AAPL	Stock	36.255	36.255	36.255	36.255	4824.0
2017-06-27 07:40:00	AAPL	Stock	36.2725	36.2875	36.2725	36.2825	10392.0
2017-06-27 07:45:00	AAPL	Stock	36.2875	36.3	36.2875	36.2975	5200.0
2017-06-27 07:50:00	AAPL	Stock	36.275	36.325	36.275	36.325	17744.0
2017-06-27 07:55:00	AAPL	Stock	36.305	36.305	36.305	36.305	1000.0
2017-06-27 08:00:00	AAPL	Stock	36.3125	36.3375	36.25	36.3375	21872.0
2017-06-27 08:05:00	AAPL	Stock	36.325	36.345	36.325	36.345	17148.0
2017-06-27 08:10:00	AAPL	Stock	36.345	36.3575	36.33	36.335	42116.0
2017-06-27 08:15:00	AAPL	Stock	36.345	36.345	36.3125	36.3125	36872.0
2017-06-27 08:20:00	AAPL	Stock	36.315	36.3175	36.3025	36.3025	9356.0
2017-06-27 08:25:00	AAPL	Stock	36.3025	36.33	36.3025	36.33	2264.0
2017-06-27 08:30:00	AAPL	Stock	36.345	36.3625	36.345	36.36	7960.0
2017-06-27 08:35:00	AAPL	Stock	36.355	36.36	36.355	36.355	15932.0
2017-06-27 08:40:00	AAPL	Stock	36.34	36.3525	36.3125	36.3125	13924.0
2017-06-27 08:45:00	AAPL	Stock	36.3	36.3125	36.265	36.3125	31200.0
2017-06-27 08:50:00	AAPL	Stock	36.2975	36.32	36.2975	36.3125	14192.0
2017-06-27 08:55:00	AAPL	Stock	36.31	36.31	36.305	36.31	4488.0
2017-06-27 09:00:00	AAPL	Stock	36.2975	36.2975	36.28	36.285	11888.0
2017-06-27 09:05:00	AAPL	Stock	36.285	36.3	36.275	36.2875	45804.0
2017-06-27 09:10:00	AAPL	Stock	36.2975	36.2975	36.2775	36.2775	11612.0
2017-06-27 09:15:00	AAPL	Stock	36.2875	36.3075	36.2875	36.2875	10472.0
2017-06-27 09:20:00	AAPL	Stock	36.3	36.31	36.285	36.31	5760.0
2017-06-27 09:25:00	AAPL	Stock	36.29	36.3125	36.25	36.255	23656.0
2017-06-27 09:30:00	AAPL	Stock	36.2525	36.325	36.1925	36.2918	4106788.0

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

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