PREVIEW / stock_5min / 2017-02-17

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-02-17.parquet
  size:    5.3 MB
  rows:    347,181
  symbols: 3,101

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-02-17 04:10:00	AAPL	Stock	33.8725	33.8725	33.8725	33.8725	400.0
2017-02-17 04:50:00	AAPL	Stock	33.7425	33.7425	33.7425	33.7425	520.0
2017-02-17 04:55:00	AAPL	Stock	33.725	33.725	33.725	33.725	548.0
2017-02-17 05:00:00	AAPL	Stock	33.745	33.745	33.745	33.745	1200.0
2017-02-17 05:15:00	AAPL	Stock	33.7	33.7	33.7	33.7	456.0
2017-02-17 05:20:00	AAPL	Stock	33.7175	33.7175	33.7175	33.7175	1720.0
2017-02-17 05:30:00	AAPL	Stock	33.7175	33.7175	33.71	33.71	1600.0
2017-02-17 05:50:00	AAPL	Stock	33.7725	33.7725	33.7725	33.7725	400.0
2017-02-17 06:20:00	AAPL	Stock	33.7425	33.7625	33.7425	33.7625	2400.0
2017-02-17 06:25:00	AAPL	Stock	33.7675	33.7675	33.7525	33.7525	7480.0
2017-02-17 06:30:00	AAPL	Stock	33.7125	33.7125	33.7125	33.7125	400.0
2017-02-17 06:50:00	AAPL	Stock	33.725	33.725	33.725	33.725	400.0
2017-02-17 07:00:00	AAPL	Stock	33.755	33.755	33.755	33.755	1320.0
2017-02-17 07:05:00	AAPL	Stock	33.7375	33.7375	33.7375	33.7375	576.0
2017-02-17 07:15:00	AAPL	Stock	33.75	33.7625	33.75	33.755	4128.0
2017-02-17 07:20:00	AAPL	Stock	33.77	33.7775	33.77	33.7775	25020.0
2017-02-17 07:25:00	AAPL	Stock	33.7525	33.7525	33.7525	33.7525	400.0
2017-02-17 07:30:00	AAPL	Stock	33.745	33.745	33.745	33.745	1944.0
2017-02-17 07:35:00	AAPL	Stock	33.7475	33.7475	33.745	33.745	1188.0
2017-02-17 07:40:00	AAPL	Stock	33.75	33.75	33.75	33.75	3648.0
2017-02-17 07:45:00	AAPL	Stock	33.7525	33.7725	33.7525	33.7725	1200.0
2017-02-17 07:55:00	AAPL	Stock	33.77	33.775	33.77	33.77	9672.0
2017-02-17 08:00:00	AAPL	Stock	33.7525	33.78	33.7375	33.7525	40324.0
2017-02-17 08:05:00	AAPL	Stock	33.7575	33.7575	33.7325	33.735	17164.0
2017-02-17 08:10:00	AAPL	Stock	33.7425	33.765	33.7425	33.765	2000.0
2017-02-17 08:15:00	AAPL	Stock	33.755	33.755	33.7375	33.7375	10212.0
2017-02-17 08:20:00	AAPL	Stock	33.735	33.7375	33.735	33.7375	24748.0
2017-02-17 08:25:00	AAPL	Stock	33.7375	33.7375	33.7125	33.7225	29984.0
2017-02-17 08:30:00	AAPL	Stock	33.715	33.7475	33.715	33.7275	16956.0
2017-02-17 08:35:00	AAPL	Stock	33.725	33.7375	33.725	33.725	6668.0
2017-02-17 08:40:00	AAPL	Stock	33.7475	33.7475	33.7275	33.7375	5200.0
2017-02-17 08:45:00	AAPL	Stock	33.7375	33.755	33.7375	33.7525	10100.0
2017-02-17 08:50:00	AAPL	Stock	33.765	33.765	33.7525	33.7525	3000.0
2017-02-17 08:55:00	AAPL	Stock	33.7675	33.7675	33.755	33.755	3600.0
2017-02-17 09:00:00	AAPL	Stock	33.765	33.775	33.765	33.775	2440.0
2017-02-17 09:05:00	AAPL	Stock	33.76	33.76	33.7375	33.7375	8960.0
2017-02-17 09:10:00	AAPL	Stock	33.7375	33.7375	33.725	33.7375	24060.0
2017-02-17 09:15:00	AAPL	Stock	33.725	33.7375	33.725	33.735	35876.0
2017-02-17 09:20:00	AAPL	Stock	33.7325	33.7325	33.7275	33.7325	24200.0
2017-02-17 09:25:00	AAPL	Stock	33.735	33.7875	33.7275	33.775	65308.0
2017-02-17 09:30:00	AAPL	Stock	33.775	33.8975	33.775	33.8375	12741260.0
2017-02-17 09:35:00	AAPL	Stock	33.835	33.88	33.7925	33.7938	2624748.0
2017-02-17 09:40:00	AAPL	Stock	33.79	33.835	33.79	33.8142	1725448.0
2017-02-17 09:45:00	AAPL	Stock	33.8125	33.8725	33.8125	33.8675	1463116.0
2017-02-17 09:50:00	AAPL	Stock	33.8675	33.87	33.8325	33.8425	1184516.0
2017-02-17 09:55:00	AAPL	Stock	33.8425	33.9	33.83	33.9	2110980.0
2017-02-17 10:00:00	AAPL	Stock	33.8995	33.9475	33.8725	33.9075	2205644.0
2017-02-17 10:05:00	AAPL	Stock	33.91	33.92	33.875	33.88	1115128.0
2017-02-17 10:10:00	AAPL	Stock	33.88	33.9025	33.8672	33.8698	1007604.0
2017-02-17 10:15:00	AAPL	Stock	33.87	33.8925	33.8525	33.881	985944.0

> showing 50 of 347,181 rows — these rows as CSV

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