PREVIEW / stock_5min / 2017-10-25

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-25.parquet
  size:    5.5 MB
  rows:    353,909
  symbols: 2,926

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-10-25 04:30:00	AAPL	Stock	39.235	39.2475	39.235	39.2475	4000.0
2017-10-25 04:50:00	AAPL	Stock	39.245	39.245	39.245	39.245	760.0
2017-10-25 04:55:00	AAPL	Stock	39.23	39.23	39.23	39.23	3200.0
2017-10-25 05:05:00	AAPL	Stock	39.2475	39.2575	39.2475	39.2575	6712.0
2017-10-25 05:10:00	AAPL	Stock	39.31	39.31	39.25	39.25	1200.0
2017-10-25 05:30:00	AAPL	Stock	39.25	39.25	39.2375	39.2375	968.0
2017-10-25 06:00:00	AAPL	Stock	39.3225	39.3225	39.3225	39.3225	1156.0
2017-10-25 06:10:00	AAPL	Stock	39.3225	39.3225	39.3225	39.3225	832.0
2017-10-25 06:30:00	AAPL	Stock	39.275	39.275	39.275	39.275	400.0
2017-10-25 06:50:00	AAPL	Stock	39.25	39.25	39.25	39.25	800.0
2017-10-25 06:55:00	AAPL	Stock	39.3	39.3	39.3	39.3	4000.0
2017-10-25 07:05:00	AAPL	Stock	39.2775	39.2775	39.2775	39.2775	400.0
2017-10-25 07:10:00	AAPL	Stock	39.3	39.3	39.3	39.3	800.0
2017-10-25 07:15:00	AAPL	Stock	39.2975	39.3	39.2975	39.3	4060.0
2017-10-25 07:20:00	AAPL	Stock	39.2975	39.35	39.2975	39.35	16956.0
2017-10-25 07:25:00	AAPL	Stock	39.3125	39.3125	39.3125	39.3125	400.0
2017-10-25 07:30:00	AAPL	Stock	39.3	39.3	39.3	39.3	444.0
2017-10-25 07:35:00	AAPL	Stock	39.3	39.3	39.3	39.3	1684.0
2017-10-25 07:40:00	AAPL	Stock	39.3	39.3	39.3	39.3	400.0
2017-10-25 07:50:00	AAPL	Stock	39.3	39.3	39.3	39.3	800.0
2017-10-25 07:55:00	AAPL	Stock	39.315	39.315	39.3	39.3	5576.0
2017-10-25 08:00:00	AAPL	Stock	39.3	39.3175	39.275	39.2825	24840.0
2017-10-25 08:05:00	AAPL	Stock	39.275	39.28	39.275	39.28	3520.0
2017-10-25 08:10:00	AAPL	Stock	39.3	39.3	39.2825	39.2825	8556.0
2017-10-25 08:15:00	AAPL	Stock	39.3	39.3	39.2875	39.2875	2200.0
2017-10-25 08:20:00	AAPL	Stock	39.2875	39.2925	39.2875	39.2925	4800.0
2017-10-25 08:25:00	AAPL	Stock	39.2925	39.3125	39.2925	39.31	9316.0
2017-10-25 08:30:00	AAPL	Stock	39.31	39.3125	39.31	39.3125	7200.0
2017-10-25 08:35:00	AAPL	Stock	39.3125	39.3175	39.3	39.3	11044.0
2017-10-25 08:40:00	AAPL	Stock	39.305	39.3175	39.305	39.3175	7360.0
2017-10-25 08:45:00	AAPL	Stock	39.3175	39.3175	39.3	39.3175	8400.0
2017-10-25 08:50:00	AAPL	Stock	39.3025	39.315	39.3025	39.315	3392.0
2017-10-25 08:55:00	AAPL	Stock	39.3175	39.3175	39.3175	39.3175	2000.0
2017-10-25 09:00:00	AAPL	Stock	39.3025	39.3125	39.3025	39.3125	3580.0
2017-10-25 09:05:00	AAPL	Stock	39.3125	39.3125	39.3025	39.3125	10396.0
2017-10-25 09:10:00	AAPL	Stock	39.31	39.3125	39.305	39.3125	11464.0
2017-10-25 09:15:00	AAPL	Stock	39.3125	39.3125	39.305	39.3125	6400.0
2017-10-25 09:20:00	AAPL	Stock	39.305	39.31	39.3	39.3	26100.0
2017-10-25 09:25:00	AAPL	Stock	39.3	39.3175	39.2225	39.2225	100852.0
2017-10-25 09:30:00	AAPL	Stock	39.2275	39.3875	39.2225	39.34	2666636.0
2017-10-25 09:35:00	AAPL	Stock	39.34	39.365	39.25	39.2825	1397524.0
2017-10-25 09:40:00	AAPL	Stock	39.28	39.34	39.2592	39.2625	1348496.0
2017-10-25 09:45:00	AAPL	Stock	39.2575	39.2725	39.1812	39.1875	1334312.0
2017-10-25 09:50:00	AAPL	Stock	39.19	39.215	39.13	39.1325	1150544.0
2017-10-25 09:55:00	AAPL	Stock	39.1325	39.22	39.1125	39.2125	1019952.0
2017-10-25 10:00:00	AAPL	Stock	39.21	39.2735	39.21	39.26	938296.0
2017-10-25 10:05:00	AAPL	Stock	39.2588	39.29	39.2375	39.2588	762884.0
2017-10-25 10:10:00	AAPL	Stock	39.26	39.3	39.255	39.2675	774084.0
2017-10-25 10:15:00	AAPL	Stock	39.2675	39.2925	39.23	39.2438	1296516.0
2017-10-25 10:20:00	AAPL	Stock	39.2475	39.2835	39.225	39.2458	1187716.0

> showing 50 of 353,909 rows — these rows as CSV

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