PREVIEW / stock_5min / 2017-05-17

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-05-17.parquet
  size:    5.6 MB
  rows:    363,584
  symbols: 3,049

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-05-17 04:00:00	AAPL	Stock	38.6875	38.7375	38.675	38.675	20500.0
2017-05-17 04:15:00	AAPL	Stock	38.7	38.7	38.7	38.7	7476.0
2017-05-17 04:40:00	AAPL	Stock	38.725	38.725	38.725	38.725	4000.0
2017-05-17 04:45:00	AAPL	Stock	38.7375	38.7375	38.7025	38.705	1260.0
2017-05-17 04:55:00	AAPL	Stock	38.695	38.7	38.6875	38.6875	4400.0
2017-05-17 05:05:00	AAPL	Stock	38.675	38.675	38.675	38.675	7600.0
2017-05-17 05:30:00	AAPL	Stock	38.6275	38.6275	38.6275	38.6275	800.0
2017-05-17 05:35:00	AAPL	Stock	38.66	38.6625	38.66	38.6625	3756.0
2017-05-17 05:40:00	AAPL	Stock	38.675	38.675	38.675	38.675	1744.0
2017-05-17 05:50:00	AAPL	Stock	38.65	38.675	38.65	38.675	1344.0
2017-05-17 05:55:00	AAPL	Stock	38.675	38.675	38.675	38.675	4000.0
2017-05-17 06:00:00	AAPL	Stock	38.675	38.675	38.655	38.655	1200.0
2017-05-17 06:05:00	AAPL	Stock	38.66	38.66	38.65	38.65	5216.0
2017-05-17 06:10:00	AAPL	Stock	38.65	38.65	38.65	38.65	400.0
2017-05-17 06:15:00	AAPL	Stock	38.65	38.65	38.65	38.65	832.0
2017-05-17 06:25:00	AAPL	Stock	38.6625	38.6625	38.6625	38.6625	3600.0
2017-05-17 06:30:00	AAPL	Stock	38.6625	38.675	38.6625	38.675	24692.0
2017-05-17 06:40:00	AAPL	Stock	38.685	38.685	38.685	38.685	1600.0
2017-05-17 06:45:00	AAPL	Stock	38.6825	38.6825	38.6825	38.6825	1200.0
2017-05-17 06:50:00	AAPL	Stock	38.7075	38.71	38.7075	38.71	3324.0
2017-05-17 07:00:00	AAPL	Stock	38.7125	38.735	38.7125	38.735	7132.0
2017-05-17 07:05:00	AAPL	Stock	38.7175	38.72	38.7175	38.7175	2000.0
2017-05-17 07:10:00	AAPL	Stock	38.7125	38.72	38.7125	38.72	1052.0
2017-05-17 07:15:00	AAPL	Stock	38.725	38.7325	38.7125	38.7325	5300.0
2017-05-17 07:20:00	AAPL	Stock	38.735	38.735	38.7125	38.7125	5932.0
2017-05-17 07:25:00	AAPL	Stock	38.7125	38.7125	38.7125	38.7125	800.0
2017-05-17 07:30:00	AAPL	Stock	38.7225	38.7225	38.7	38.7	12828.0
2017-05-17 07:35:00	AAPL	Stock	38.6875	38.6875	38.6875	38.6875	1200.0
2017-05-17 07:40:00	AAPL	Stock	38.6875	38.6875	38.6625	38.6625	5080.0
2017-05-17 07:45:00	AAPL	Stock	38.675	38.675	38.675	38.675	5400.0
2017-05-17 07:50:00	AAPL	Stock	38.7	38.7	38.6875	38.6875	7800.0
2017-05-17 07:55:00	AAPL	Stock	38.6875	38.695	38.6875	38.695	1444.0
2017-05-17 08:00:00	AAPL	Stock	38.6775	38.735	38.6325	38.6375	75716.0
2017-05-17 08:05:00	AAPL	Stock	38.645	38.645	38.6375	38.645	45376.0
2017-05-17 08:10:00	AAPL	Stock	38.6375	38.6375	38.585	38.585	35468.0
2017-05-17 08:15:00	AAPL	Stock	38.595	38.6	38.5	38.5	94528.0
2017-05-17 08:20:00	AAPL	Stock	38.5	38.5375	38.5	38.525	47536.0
2017-05-17 08:25:00	AAPL	Stock	38.5375	38.5475	38.525	38.5375	13000.0
2017-05-17 08:30:00	AAPL	Stock	38.5275	38.5425	38.5025	38.5125	24520.0
2017-05-17 08:35:00	AAPL	Stock	38.5075	38.515	38.475	38.48	51776.0
2017-05-17 08:40:00	AAPL	Stock	38.4825	38.4925	38.4525	38.485	48396.0
2017-05-17 08:45:00	AAPL	Stock	38.4625	38.5125	38.4625	38.5	100276.0
2017-05-17 08:50:00	AAPL	Stock	38.5	38.52	38.49	38.5	67064.0
2017-05-17 08:55:00	AAPL	Stock	38.5225	38.5425	38.4625	38.4625	55540.0
2017-05-17 09:00:00	AAPL	Stock	38.4625	38.4725	38.4175	38.435	129268.0
2017-05-17 09:05:00	AAPL	Stock	38.405	38.4475	38.405	38.4325	88072.0
2017-05-17 09:10:00	AAPL	Stock	38.4275	38.45	38.4075	38.425	44600.0
2017-05-17 09:15:00	AAPL	Stock	38.415	38.4725	38.415	38.4375	23184.0
2017-05-17 09:20:00	AAPL	Stock	38.4475	38.45	38.4	38.4025	172956.0
2017-05-17 09:25:00	AAPL	Stock	38.4125	38.8675	38.385	38.4975	110116.0

> showing 50 of 363,584 rows — these rows as CSV

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