PREVIEW / stock_5min / 2017-08-17

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-17.parquet
  size:    5.3 MB
  rows:    346,737
  symbols: 2,960

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-08-17 04:05:00	AAPL	Stock	40.21	40.21	40.21	40.21	400.0
2017-08-17 06:05:00	AAPL	Stock	40.175	40.175	40.175	40.175	400.0
2017-08-17 06:50:00	AAPL	Stock	40.195	40.1975	40.195	40.1975	800.0
2017-08-17 06:55:00	AAPL	Stock	40.195	40.2	40.195	40.2	3600.0
2017-08-17 07:00:00	AAPL	Stock	40.2125	40.22	40.1625	40.1625	3600.0
2017-08-17 07:05:00	AAPL	Stock	40.1575	40.1625	40.1575	40.1625	3000.0
2017-08-17 07:25:00	AAPL	Stock	40.1375	40.1375	40.1375	40.1375	800.0
2017-08-17 07:30:00	AAPL	Stock	40.13	40.175	40.13	40.175	4600.0
2017-08-17 07:35:00	AAPL	Stock	40.1275	40.1275	40.0975	40.0975	7476.0
2017-08-17 07:40:00	AAPL	Stock	40.0975	40.1025	40.08	40.08	3344.0
2017-08-17 07:45:00	AAPL	Stock	40.095	40.1025	40.095	40.1025	1824.0
2017-08-17 07:50:00	AAPL	Stock	40.1225	40.125	40.1225	40.125	8800.0
2017-08-17 07:55:00	AAPL	Stock	40.105	40.105	40.1	40.1	6800.0
2017-08-17 08:00:00	AAPL	Stock	40.1	40.1625	40.075	40.1	30640.0
2017-08-17 08:05:00	AAPL	Stock	40.0875	40.0975	40.065	40.0925	8820.0
2017-08-17 08:10:00	AAPL	Stock	40.1	40.1	40.09	40.1	15800.0
2017-08-17 08:15:00	AAPL	Stock	40.09	40.125	40.09	40.1	15400.0
2017-08-17 08:20:00	AAPL	Stock	40.095	40.095	40.075	40.085	9744.0
2017-08-17 08:25:00	AAPL	Stock	40.07	40.0775	40.065	40.0775	11200.0
2017-08-17 08:30:00	AAPL	Stock	40.09	40.1	40.09	40.0925	10688.0
2017-08-17 08:35:00	AAPL	Stock	40.09	40.115	40.09	40.11	48732.0
2017-08-17 08:40:00	AAPL	Stock	40.115	40.135	40.115	40.135	12000.0
2017-08-17 08:45:00	AAPL	Stock	40.1375	40.15	40.125	40.14	11564.0
2017-08-17 08:50:00	AAPL	Stock	40.1325	40.15	40.125	40.14	11052.0
2017-08-17 08:55:00	AAPL	Stock	40.1275	40.1275	40.1125	40.1125	32840.0
2017-08-17 09:00:00	AAPL	Stock	40.125	40.125	40.115	40.125	19712.0
2017-08-17 09:05:00	AAPL	Stock	40.1225	40.1225	40.105	40.1125	43072.0
2017-08-17 09:10:00	AAPL	Stock	40.1125	40.1125	40.095	40.1025	56252.0
2017-08-17 09:15:00	AAPL	Stock	40.1025	40.1125	40.1025	40.105	28468.0
2017-08-17 09:20:00	AAPL	Stock	40.1125	40.13	40.1125	40.125	26252.0
2017-08-17 09:25:00	AAPL	Stock	40.13	40.1625	40.125	40.1575	3600.0
2017-08-17 09:30:00	AAPL	Stock	40.13	40.1775	40.045	40.0892	3239464.0
2017-08-17 09:35:00	AAPL	Stock	40.0925	40.0925	39.91	40.015	3558740.0
2017-08-17 09:40:00	AAPL	Stock	40.0075	40.09	40.005	40.0825	1265292.0
2017-08-17 09:45:00	AAPL	Stock	40.085	40.1425	40.0775	40.087	1232484.0
2017-08-17 09:50:00	AAPL	Stock	40.0875	40.0975	40.0025	40.0037	1113376.0
2017-08-17 09:55:00	AAPL	Stock	40.0075	40.045	39.9525	39.96	1493728.0
2017-08-17 10:00:00	AAPL	Stock	39.96	39.96	39.85	39.895	2510752.0
2017-08-17 10:05:00	AAPL	Stock	39.895	39.97	39.855	39.865	1398456.0
2017-08-17 10:10:00	AAPL	Stock	39.865	39.8842	39.76	39.765	2622508.0
2017-08-17 10:15:00	AAPL	Stock	39.7662	39.77	39.6005	39.7425	3128720.0
2017-08-17 10:20:00	AAPL	Stock	39.745	39.8	39.675	39.785	1770100.0
2017-08-17 10:25:00	AAPL	Stock	39.786	39.7875	39.7125	39.7425	1454676.0
2017-08-17 10:30:00	AAPL	Stock	39.7475	39.8625	39.715	39.8525	2103524.0
2017-08-17 10:35:00	AAPL	Stock	39.8572	39.865	39.765	39.8075	1362648.0
2017-08-17 10:40:00	AAPL	Stock	39.805	39.8175	39.73	39.7575	1074608.0
2017-08-17 10:45:00	AAPL	Stock	39.76	39.8325	39.7532	39.8152	819144.0
2017-08-17 10:50:00	AAPL	Stock	39.817	39.817	39.7325	39.8	923436.0
2017-08-17 10:55:00	AAPL	Stock	39.8045	39.8378	39.75	39.765	1115800.0
2017-08-17 11:00:00	AAPL	Stock	39.77	39.845	39.7675	39.807	890388.0

> showing 50 of 346,737 rows — these rows as CSV

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