PREVIEW / stock_5min / 2017-11-27

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-27.parquet
  size:    5.5 MB
  rows:    359,776
  symbols: 2,942

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-11-27 04:00:00	AAPL	Stock	43.715	43.715	43.715	43.715	400.0
2017-11-27 04:20:00	AAPL	Stock	43.75	43.75	43.75	43.75	400.0
2017-11-27 04:30:00	AAPL	Stock	43.725	43.725	43.7175	43.725	1400.0
2017-11-27 05:10:00	AAPL	Stock	43.725	43.725	43.725	43.725	668.0
2017-11-27 05:15:00	AAPL	Stock	43.77	43.77	43.77	43.77	484.0
2017-11-27 05:50:00	AAPL	Stock	43.7975	43.8	43.7975	43.8	1276.0
2017-11-27 06:05:00	AAPL	Stock	43.81	43.845	43.81	43.845	1200.0
2017-11-27 06:30:00	AAPL	Stock	43.81	43.81	43.81	43.81	400.0
2017-11-27 06:35:00	AAPL	Stock	43.81	43.81	43.81	43.81	1040.0
2017-11-27 06:40:00	AAPL	Stock	43.81	43.81	43.8	43.8	2400.0
2017-11-27 06:45:00	AAPL	Stock	43.7925	43.7925	43.7925	43.7925	800.0
2017-11-27 06:55:00	AAPL	Stock	43.795	43.795	43.75	43.775	9884.0
2017-11-27 07:00:00	AAPL	Stock	43.755	43.78	43.75	43.78	8280.0
2017-11-27 07:05:00	AAPL	Stock	43.7875	43.7875	43.7625	43.7625	14464.0
2017-11-27 07:10:00	AAPL	Stock	43.7525	43.7525	43.75	43.75	4400.0
2017-11-27 07:20:00	AAPL	Stock	43.7375	43.7375	43.7325	43.7325	5860.0
2017-11-27 07:25:00	AAPL	Stock	43.7325	43.7375	43.73	43.73	12688.0
2017-11-27 07:30:00	AAPL	Stock	43.73	43.73	43.715	43.715	11800.0
2017-11-27 07:35:00	AAPL	Stock	43.705	43.705	43.625	43.6325	37264.0
2017-11-27 07:40:00	AAPL	Stock	43.625	43.6375	43.61	43.6125	8876.0
2017-11-27 07:45:00	AAPL	Stock	43.6125	43.625	43.6125	43.625	4644.0
2017-11-27 07:50:00	AAPL	Stock	43.6375	43.6375	43.6375	43.6375	2000.0
2017-11-27 07:55:00	AAPL	Stock	43.6475	43.6475	43.645	43.645	1200.0
2017-11-27 08:00:00	AAPL	Stock	43.81	43.875	43.6125	43.635	115024.0
2017-11-27 08:05:00	AAPL	Stock	43.6275	43.65	43.6275	43.65	16600.0
2017-11-27 08:10:00	AAPL	Stock	43.6475	43.6475	43.635	43.6375	9716.0
2017-11-27 08:15:00	AAPL	Stock	43.6375	43.67	43.635	43.65	8468.0
2017-11-27 08:20:00	AAPL	Stock	43.65	43.66	43.64	43.65	20692.0
2017-11-27 08:25:00	AAPL	Stock	43.65	43.6625	43.65	43.6625	2724.0
2017-11-27 08:30:00	AAPL	Stock	43.6625	43.67	43.65	43.67	16012.0
2017-11-27 08:35:00	AAPL	Stock	43.67	43.675	43.6625	43.6725	4084.0
2017-11-27 08:40:00	AAPL	Stock	43.67	43.6775	43.67	43.675	32276.0
2017-11-27 08:45:00	AAPL	Stock	43.6775	43.6775	43.675	43.675	19960.0
2017-11-27 08:50:00	AAPL	Stock	43.675	43.6925	43.675	43.6925	19896.0
2017-11-27 08:55:00	AAPL	Stock	43.6875	43.6875	43.675	43.6775	49660.0
2017-11-27 09:00:00	AAPL	Stock	43.675	43.6775	43.67	43.6775	15296.0
2017-11-27 09:05:00	AAPL	Stock	43.685	43.6925	43.6775	43.6925	14280.0
2017-11-27 09:10:00	AAPL	Stock	43.7	43.7	43.7	43.7	1856.0
2017-11-27 09:15:00	AAPL	Stock	43.705	43.71	43.6925	43.7	24872.0
2017-11-27 09:20:00	AAPL	Stock	43.6925	43.705	43.69	43.705	8580.0
2017-11-27 09:25:00	AAPL	Stock	43.695	43.765	43.695	43.765	174328.0
2017-11-27 09:30:00	AAPL	Stock	43.7625	43.775	43.5175	43.5275	4188000.0
2017-11-27 09:35:00	AAPL	Stock	43.5275	43.5448	43.335	43.4925	4283040.0
2017-11-27 09:40:00	AAPL	Stock	43.4925	43.625	43.4875	43.615	3027248.0
2017-11-27 09:45:00	AAPL	Stock	43.6125	43.7225	43.55	43.715	2340544.0
2017-11-27 09:50:00	AAPL	Stock	43.715	43.7425	43.6875	43.7025	1878760.0
2017-11-27 09:55:00	AAPL	Stock	43.7025	43.7125	43.625	43.6538	1273328.0
2017-11-27 10:00:00	AAPL	Stock	43.66	43.7	43.6578	43.6975	868520.0
2017-11-27 10:05:00	AAPL	Stock	43.6975	43.7175	43.6675	43.7025	793148.0
2017-11-27 10:10:00	AAPL	Stock	43.7025	43.7225	43.675	43.6925	962720.0

> showing 50 of 359,776 rows — these rows as CSV

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