PREVIEW / stock_5min / 2017-12-18

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-12-18.parquet
  size:    5.8 MB
  rows:    378,165
  symbols: 2,952

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-12-18 04:00:00	AAPL	Stock	43.56	43.595	43.56	43.595	7800.0
2017-12-18 04:10:00	AAPL	Stock	43.7125	43.7425	43.7125	43.7375	7584.0
2017-12-18 04:15:00	AAPL	Stock	43.7	43.7	43.7	43.7	464.0
2017-12-18 04:20:00	AAPL	Stock	43.6975	43.7	43.6975	43.7	1444.0
2017-12-18 04:25:00	AAPL	Stock	43.7225	43.75	43.7225	43.75	3840.0
2017-12-18 04:30:00	AAPL	Stock	43.76	43.7675	43.76	43.7675	5684.0
2017-12-18 04:40:00	AAPL	Stock	43.7675	43.7675	43.7675	43.7675	1200.0
2017-12-18 04:45:00	AAPL	Stock	43.7075	43.7075	43.7075	43.7075	400.0
2017-12-18 05:35:00	AAPL	Stock	43.7275	43.7275	43.7275	43.7275	400.0
2017-12-18 05:40:00	AAPL	Stock	43.73	43.75	43.73	43.75	1600.0
2017-12-18 05:45:00	AAPL	Stock	43.7675	43.7675	43.7675	43.7675	800.0
2017-12-18 05:50:00	AAPL	Stock	43.76	43.7625	43.76	43.7625	2044.0
2017-12-18 06:00:00	AAPL	Stock	43.78	43.975	43.78	43.975	72320.0
2017-12-18 06:05:00	AAPL	Stock	43.8125	43.8125	43.8125	43.8125	400.0
2017-12-18 06:10:00	AAPL	Stock	43.85	43.8525	43.85	43.8525	800.0
2017-12-18 06:15:00	AAPL	Stock	43.855	43.855	43.855	43.855	2872.0
2017-12-18 06:25:00	AAPL	Stock	43.85	43.85	43.85	43.85	400.0
2017-12-18 06:35:00	AAPL	Stock	43.85	43.8625	43.85	43.8625	2900.0
2017-12-18 06:50:00	AAPL	Stock	43.8575	43.8575	43.8575	43.8575	400.0
2017-12-18 06:55:00	AAPL	Stock	43.8375	43.8375	43.83	43.83	2000.0
2017-12-18 07:00:00	AAPL	Stock	43.8175	43.84	43.7875	43.8	56476.0
2017-12-18 07:05:00	AAPL	Stock	43.825	43.825	43.725	43.7425	27608.0
2017-12-18 07:10:00	AAPL	Stock	43.75	43.7625	43.7375	43.7375	4980.0
2017-12-18 07:15:00	AAPL	Stock	43.7375	43.775	43.7375	43.75	4000.0
2017-12-18 07:20:00	AAPL	Stock	43.75	43.75	43.7375	43.7425	4328.0
2017-12-18 07:25:00	AAPL	Stock	43.75	43.78	43.75	43.75	11200.0
2017-12-18 07:30:00	AAPL	Stock	43.75	43.7525	43.75	43.75	10168.0
2017-12-18 07:35:00	AAPL	Stock	43.75	43.7825	43.75	43.7825	12496.0
2017-12-18 07:40:00	AAPL	Stock	43.75	43.75	43.725	43.7325	17308.0
2017-12-18 07:45:00	AAPL	Stock	43.7325	43.7325	43.7325	43.7325	1312.0
2017-12-18 07:50:00	AAPL	Stock	43.7325	43.7375	43.725	43.73	11940.0
2017-12-18 07:55:00	AAPL	Stock	43.75	43.7725	43.75	43.7625	18332.0
2017-12-18 08:00:00	AAPL	Stock	43.8875	43.8875	43.7325	43.7875	88572.0
2017-12-18 08:05:00	AAPL	Stock	43.785	43.7875	43.7625	43.7625	25652.0
2017-12-18 08:10:00	AAPL	Stock	43.77	43.775	43.7625	43.77	22400.0
2017-12-18 08:15:00	AAPL	Stock	43.7825	43.7875	43.7725	43.785	10700.0
2017-12-18 08:20:00	AAPL	Stock	43.7875	43.8025	43.775	43.7875	59032.0
2017-12-18 08:25:00	AAPL	Stock	43.7875	43.7875	43.7575	43.775	36252.0
2017-12-18 08:30:00	AAPL	Stock	43.7575	43.7575	43.7375	43.7375	33800.0
2017-12-18 08:35:00	AAPL	Stock	43.745	43.75	43.7425	43.75	1512.0
2017-12-18 08:40:00	AAPL	Stock	43.7375	43.75	43.7375	43.75	18532.0
2017-12-18 08:45:00	AAPL	Stock	43.75	43.75	43.7025	43.7125	29008.0
2017-12-18 08:50:00	AAPL	Stock	43.7175	43.7225	43.7125	43.7125	13316.0
2017-12-18 08:55:00	AAPL	Stock	43.7125	43.7275	43.7125	43.7275	11136.0
2017-12-18 09:00:00	AAPL	Stock	43.705	43.7275	43.705	43.7275	26592.0
2017-12-18 09:05:00	AAPL	Stock	43.7025	43.7425	43.7025	43.74	35120.0
2017-12-18 09:10:00	AAPL	Stock	43.735	43.7425	43.735	43.74	17248.0
2017-12-18 09:15:00	AAPL	Stock	43.7375	43.7425	43.735	43.7425	27048.0
2017-12-18 09:20:00	AAPL	Stock	43.7375	43.745	43.7275	43.745	15060.0
2017-12-18 09:25:00	AAPL	Stock	43.73	43.7375	43.7125	43.715	57980.0

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

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