PREVIEW / stock_5min / 2017-11-17

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-17.parquet
  size:    5.6 MB
  rows:    361,758
  symbols: 2,946

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-17 04:05:00	AAPL	Stock	42.8225	42.8225	42.8225	42.8225	400.0
2017-11-17 04:10:00	AAPL	Stock	42.81	42.81	42.81	42.81	1200.0
2017-11-17 04:30:00	AAPL	Stock	42.815	42.815	42.815	42.815	400.0
2017-11-17 04:45:00	AAPL	Stock	42.8275	42.8275	42.8275	42.8275	400.0
2017-11-17 06:00:00	AAPL	Stock	42.8375	42.8375	42.8375	42.8375	904.0
2017-11-17 06:05:00	AAPL	Stock	42.8425	42.8425	42.8425	42.8425	400.0
2017-11-17 06:40:00	AAPL	Stock	42.825	42.825	42.825	42.825	5600.0
2017-11-17 06:45:00	AAPL	Stock	42.825	42.825	42.825	42.825	4000.0
2017-11-17 07:00:00	AAPL	Stock	42.825	42.825	42.795	42.825	46084.0
2017-11-17 07:05:00	AAPL	Stock	42.825	42.825	42.825	42.825	8264.0
2017-11-17 07:10:00	AAPL	Stock	42.825	42.825	42.825	42.825	27588.0
2017-11-17 07:20:00	AAPL	Stock	42.825	42.825	42.825	42.825	1200.0
2017-11-17 07:25:00	AAPL	Stock	42.825	42.825	42.825	42.825	11200.0
2017-11-17 07:35:00	AAPL	Stock	42.825	42.825	42.825	42.825	1124.0
2017-11-17 07:40:00	AAPL	Stock	42.825	42.825	42.825	42.825	9116.0
2017-11-17 07:45:00	AAPL	Stock	42.8125	42.8125	42.8	42.8125	11960.0
2017-11-17 07:50:00	AAPL	Stock	42.8125	42.825	42.8125	42.825	6144.0
2017-11-17 07:55:00	AAPL	Stock	42.805	42.805	42.8025	42.8025	9388.0
2017-11-17 08:00:00	AAPL	Stock	42.8125	42.825	42.75	42.7725	113992.0
2017-11-17 08:05:00	AAPL	Stock	42.77	42.795	42.7575	42.7875	11532.0
2017-11-17 08:10:00	AAPL	Stock	42.775	42.785	42.7525	42.7525	7840.0
2017-11-17 08:15:00	AAPL	Stock	42.7625	42.7625	42.7625	42.7625	800.0
2017-11-17 08:20:00	AAPL	Stock	42.755	42.77	42.725	42.725	10064.0
2017-11-17 08:25:00	AAPL	Stock	42.725	42.7475	42.715	42.7425	13152.0
2017-11-17 08:30:00	AAPL	Stock	42.745	42.745	42.715	42.715	8032.0
2017-11-17 08:35:00	AAPL	Stock	42.72	42.75	42.72	42.75	25776.0
2017-11-17 08:40:00	AAPL	Stock	42.75	42.7725	42.745	42.75	11528.0
2017-11-17 08:45:00	AAPL	Stock	42.75	42.7925	42.75	42.785	9196.0
2017-11-17 08:50:00	AAPL	Stock	42.7725	42.7725	42.7375	42.7425	19280.0
2017-11-17 08:55:00	AAPL	Stock	42.745	42.7725	42.7375	42.7725	13380.0
2017-11-17 09:00:00	AAPL	Stock	42.74	42.74	42.74	42.74	1600.0
2017-11-17 09:05:00	AAPL	Stock	42.7525	42.7525	42.7525	42.7525	400.0
2017-11-17 09:10:00	AAPL	Stock	42.7525	42.7625	42.75	42.75	27088.0
2017-11-17 09:15:00	AAPL	Stock	42.7375	42.7525	42.7375	42.74	14928.0
2017-11-17 09:20:00	AAPL	Stock	42.725	42.7625	42.725	42.75	7620.0
2017-11-17 09:25:00	AAPL	Stock	42.75	42.7625	42.6875	42.7625	154984.0
2017-11-17 09:30:00	AAPL	Stock	42.76	42.7625	42.5625	42.59	7249664.0
2017-11-17 09:35:00	AAPL	Stock	42.59	42.6025	42.515	42.515	1925116.0
2017-11-17 09:40:00	AAPL	Stock	42.515	42.5725	42.4575	42.5625	2320336.0
2017-11-17 09:45:00	AAPL	Stock	42.565	42.57	42.4925	42.4925	1424244.0
2017-11-17 09:50:00	AAPL	Stock	42.495	42.5475	42.4825	42.5358	1621208.0
2017-11-17 09:55:00	AAPL	Stock	42.535	42.5425	42.4825	42.5225	1659272.0
2017-11-17 10:00:00	AAPL	Stock	42.5212	42.53	42.4575	42.505	1311376.0
2017-11-17 10:05:00	AAPL	Stock	42.5025	42.5638	42.485	42.5625	1015596.0
2017-11-17 10:10:00	AAPL	Stock	42.5638	42.6275	42.5638	42.5875	1512744.0
2017-11-17 10:15:00	AAPL	Stock	42.585	42.6475	42.56	42.6265	1012368.0
2017-11-17 10:20:00	AAPL	Stock	42.625	42.6325	42.6	42.6	1042212.0
2017-11-17 10:25:00	AAPL	Stock	42.6025	42.645	42.59	42.64	771124.0
2017-11-17 10:30:00	AAPL	Stock	42.64	42.6438	42.6175	42.6375	821008.0
2017-11-17 10:35:00	AAPL	Stock	42.6375	42.6975	42.6335	42.69	1150836.0

> showing 50 of 361,758 rows — these rows as CSV

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