PREVIEW / stock_5min / 2017-01-10

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-10.parquet
  size:    5.4 MB
  rows:    352,378
  symbols: 3,120

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-10 06:05:00	AAPL	Stock	29.7875	29.7875	29.7875	29.7875	400.0
2017-01-10 06:10:00	AAPL	Stock	29.7875	29.7875	29.7875	29.7875	912.0
2017-01-10 07:00:00	AAPL	Stock	29.75	29.75	29.75	29.75	800.0
2017-01-10 07:05:00	AAPL	Stock	29.7875	29.7925	29.7825	29.7925	3640.0
2017-01-10 07:10:00	AAPL	Stock	29.77	29.77	29.77	29.77	400.0
2017-01-10 07:15:00	AAPL	Stock	29.77	29.77	29.77	29.77	2000.0
2017-01-10 07:25:00	AAPL	Stock	29.77	29.77	29.77	29.77	7168.0
2017-01-10 07:45:00	AAPL	Stock	29.775	29.775	29.775	29.775	400.0
2017-01-10 07:55:00	AAPL	Stock	29.775	29.775	29.775	29.775	4000.0
2017-01-10 08:00:00	AAPL	Stock	29.7825	29.7825	29.675	29.75	39548.0
2017-01-10 08:05:00	AAPL	Stock	29.7525	29.76	29.75	29.7575	15092.0
2017-01-10 08:10:00	AAPL	Stock	29.75	29.76	29.7425	29.7425	11648.0
2017-01-10 08:20:00	AAPL	Stock	29.76	29.76	29.7375	29.7375	2000.0
2017-01-10 08:25:00	AAPL	Stock	29.74	29.755	29.74	29.755	2800.0
2017-01-10 08:30:00	AAPL	Stock	29.735	29.7375	29.7275	29.73	17472.0
2017-01-10 08:35:00	AAPL	Stock	29.7375	29.7375	29.7375	29.7375	1200.0
2017-01-10 08:40:00	AAPL	Stock	29.75	29.755	29.745	29.755	34300.0
2017-01-10 08:45:00	AAPL	Stock	29.75	29.7525	29.7475	29.75	14624.0
2017-01-10 08:50:00	AAPL	Stock	29.73	29.74	29.715	29.7375	41184.0
2017-01-10 08:55:00	AAPL	Stock	29.7375	29.7375	29.7375	29.7375	10000.0
2017-01-10 09:00:00	AAPL	Stock	29.73	29.7375	29.725	29.7375	3688.0
2017-01-10 09:05:00	AAPL	Stock	29.7325	29.735	29.7175	29.7175	56040.0
2017-01-10 09:10:00	AAPL	Stock	29.7175	29.7225	29.71	29.7125	29424.0
2017-01-10 09:15:00	AAPL	Stock	29.7175	29.7225	29.715	29.7225	25396.0
2017-01-10 09:20:00	AAPL	Stock	29.73	29.735	29.725	29.725	10708.0
2017-01-10 09:25:00	AAPL	Stock	29.7375	29.7375	29.6925	29.7	58492.0
2017-01-10 09:30:00	AAPL	Stock	29.6925	29.7425	29.6325	29.665	6256520.0
2017-01-10 09:35:00	AAPL	Stock	29.6662	29.7375	29.645	29.685	2562548.0
2017-01-10 09:40:00	AAPL	Stock	29.685	29.6925	29.575	29.6425	2443228.0
2017-01-10 09:45:00	AAPL	Stock	29.6425	29.695	29.6225	29.665	1953784.0
2017-01-10 09:50:00	AAPL	Stock	29.665	29.715	29.5975	29.645	2382112.0
2017-01-10 09:55:00	AAPL	Stock	29.645	29.6975	29.6275	29.695	1107896.0
2017-01-10 10:00:00	AAPL	Stock	29.695	29.7375	29.675	29.735	1452684.0
2017-01-10 10:05:00	AAPL	Stock	29.735	29.7375	29.665	29.67	1324260.0
2017-01-10 10:10:00	AAPL	Stock	29.6725	29.7375	29.6575	29.7338	2784832.0
2017-01-10 10:15:00	AAPL	Stock	29.7338	29.7362	29.6575	29.665	1582088.0
2017-01-10 10:20:00	AAPL	Stock	29.665	29.6925	29.6625	29.6825	904164.0
2017-01-10 10:25:00	AAPL	Stock	29.6825	29.6825	29.65	29.66	1147536.0
2017-01-10 10:30:00	AAPL	Stock	29.6588	29.7225	29.6275	29.7175	1736800.0
2017-01-10 10:35:00	AAPL	Stock	29.7175	29.725	29.6825	29.695	881748.0
2017-01-10 10:40:00	AAPL	Stock	29.6975	29.7175	29.69	29.69	674388.0
2017-01-10 10:45:00	AAPL	Stock	29.6875	29.7125	29.67	29.7025	845456.0
2017-01-10 10:50:00	AAPL	Stock	29.7012	29.71	29.6775	29.71	652252.0
2017-01-10 10:55:00	AAPL	Stock	29.71	29.7225	29.6825	29.685	758352.0
2017-01-10 11:00:00	AAPL	Stock	29.685	29.74	29.685	29.7388	1198528.0
2017-01-10 11:05:00	AAPL	Stock	29.7388	29.75	29.7225	29.75	1371304.0
2017-01-10 11:10:00	AAPL	Stock	29.75	29.75	29.7388	29.75	1250792.0
2017-01-10 11:15:00	AAPL	Stock	29.75	29.7725	29.745	29.7662	1577356.0
2017-01-10 11:20:00	AAPL	Stock	29.7675	29.815	29.765	29.8038	1368480.0
2017-01-10 11:25:00	AAPL	Stock	29.805	29.8125	29.7958	29.8075	938928.0

> showing 50 of 352,378 rows — these rows as CSV

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