PREVIEW / stock_5min / 2018-04-06

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-06.parquet
  size:    5.5 MB
  rows:    354,930
  symbols: 2,840

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
2018-04-06 04:00:00	AAPL	Stock	42.7025	42.7525	42.6275	42.75	14772.0
2018-04-06 04:05:00	AAPL	Stock	42.75	42.75	42.75	42.75	1200.0
2018-04-06 04:10:00	AAPL	Stock	42.735	42.735	42.735	42.735	400.0
2018-04-06 04:30:00	AAPL	Stock	42.7875	42.7875	42.7875	42.7875	2000.0
2018-04-06 04:40:00	AAPL	Stock	42.7875	42.7875	42.7875	42.7875	400.0
2018-04-06 04:55:00	AAPL	Stock	42.75	42.75	42.75	42.75	800.0
2018-04-06 05:05:00	AAPL	Stock	42.75	42.75	42.7	42.7	4400.0
2018-04-06 05:20:00	AAPL	Stock	42.73	42.75	42.73	42.75	4316.0
2018-04-06 05:45:00	AAPL	Stock	42.8075	42.8075	42.8075	42.8075	780.0
2018-04-06 06:10:00	AAPL	Stock	42.825	42.825	42.825	42.825	800.0
2018-04-06 06:25:00	AAPL	Stock	42.85	42.85	42.825	42.85	4804.0
2018-04-06 06:30:00	AAPL	Stock	42.85	42.85	42.85	42.85	400.0
2018-04-06 06:35:00	AAPL	Stock	42.85	42.85	42.825	42.825	3464.0
2018-04-06 06:40:00	AAPL	Stock	42.8125	42.8125	42.8125	42.8125	4400.0
2018-04-06 06:45:00	AAPL	Stock	42.8125	42.8125	42.7775	42.7775	9104.0
2018-04-06 06:50:00	AAPL	Stock	42.7675	42.7675	42.7675	42.7675	4000.0
2018-04-06 06:55:00	AAPL	Stock	42.7675	42.7675	42.755	42.755	4200.0
2018-04-06 07:00:00	AAPL	Stock	42.76	42.8	42.675	42.7225	25888.0
2018-04-06 07:05:00	AAPL	Stock	42.695	42.695	42.5375	42.5375	71496.0
2018-04-06 07:10:00	AAPL	Stock	42.54	42.6	42.5175	42.555	69300.0
2018-04-06 07:15:00	AAPL	Stock	42.5875	42.5875	42.5475	42.5625	15024.0
2018-04-06 07:20:00	AAPL	Stock	42.5875	42.6175	42.555	42.6125	9952.0
2018-04-06 07:25:00	AAPL	Stock	42.6	42.6625	42.565	42.6625	10108.0
2018-04-06 07:30:00	AAPL	Stock	42.625	42.625	42.6	42.6	5148.0
2018-04-06 07:35:00	AAPL	Stock	42.625	42.625	42.5875	42.625	3212.0
2018-04-06 07:40:00	AAPL	Stock	42.65	42.65	42.6475	42.65	2400.0
2018-04-06 07:45:00	AAPL	Stock	42.6075	42.625	42.55	42.5525	4016.0
2018-04-06 07:50:00	AAPL	Stock	42.5525	42.5775	42.5375	42.545	29424.0
2018-04-06 07:55:00	AAPL	Stock	42.5675	42.6	42.5525	42.5525	10800.0
2018-04-06 08:00:00	AAPL	Stock	42.575	42.75	42.5375	42.625	64324.0
2018-04-06 08:05:00	AAPL	Stock	42.6375	42.6375	42.5775	42.635	39180.0
2018-04-06 08:10:00	AAPL	Stock	42.605	42.6325	42.605	42.6125	17504.0
2018-04-06 08:15:00	AAPL	Stock	42.62	42.7175	42.62	42.7	41088.0
2018-04-06 08:20:00	AAPL	Stock	42.7	42.7375	42.7	42.7125	19640.0
2018-04-06 08:25:00	AAPL	Stock	42.7375	42.775	42.7375	42.7525	29932.0
2018-04-06 08:30:00	AAPL	Stock	42.775	42.8325	42.6075	42.6925	150576.0
2018-04-06 08:35:00	AAPL	Stock	42.7	42.81	42.665	42.81	82908.0
2018-04-06 08:40:00	AAPL	Stock	42.8	42.8675	42.775	42.775	56696.0
2018-04-06 08:45:00	AAPL	Stock	42.825	42.8575	42.795	42.825	48320.0
2018-04-06 08:50:00	AAPL	Stock	42.855	42.8575	42.8125	42.8275	68976.0
2018-04-06 08:55:00	AAPL	Stock	42.825	42.8375	42.775	42.8	41084.0
2018-04-06 09:00:00	AAPL	Stock	42.8	42.8225	42.7525	42.785	25200.0
2018-04-06 09:05:00	AAPL	Stock	42.7775	42.7775	42.7	42.7025	27224.0
2018-04-06 09:10:00	AAPL	Stock	42.7	42.7	42.625	42.635	57696.0
2018-04-06 09:15:00	AAPL	Stock	42.64	42.66	42.6	42.6325	86168.0
2018-04-06 09:20:00	AAPL	Stock	42.625	42.7	42.6125	42.6975	38256.0
2018-04-06 09:25:00	AAPL	Stock	42.6975	42.76	42.6925	42.74	54292.0
2018-04-06 09:30:00	AAPL	Stock	42.7225	43.04	42.665	42.9825	5081192.0
2018-04-06 09:35:00	AAPL	Stock	42.9775	43.0875	42.935	43.065	1959752.0
2018-04-06 09:40:00	AAPL	Stock	43.0675	43.0685	42.885	42.9192	2075072.0

> showing 50 of 354,930 rows — these rows as CSV

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