PREVIEW / stock_5min / 2018-07-27

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-27.parquet
  size:    5.5 MB
  rows:    352,152
  symbols: 2,774

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-07-27 04:00:00	AAPL	Stock	48.65	48.65	48.65	48.65	800.0
2018-07-27 04:10:00	AAPL	Stock	48.73	48.73	48.73	48.73	400.0
2018-07-27 04:20:00	AAPL	Stock	48.7125	48.7125	48.7125	48.7125	4496.0
2018-07-27 04:30:00	AAPL	Stock	48.65	48.65	48.65	48.65	404.0
2018-07-27 04:45:00	AAPL	Stock	48.75	48.75	48.75	48.75	400.0
2018-07-27 04:50:00	AAPL	Stock	48.75	48.7725	48.75	48.75	3280.0
2018-07-27 05:20:00	AAPL	Stock	48.7425	48.75	48.7425	48.75	6800.0
2018-07-27 05:50:00	AAPL	Stock	48.69	48.69	48.69	48.69	700.0
2018-07-27 05:55:00	AAPL	Stock	48.7	48.7	48.7	48.7	448.0
2018-07-27 06:50:00	AAPL	Stock	48.7125	48.7125	48.7125	48.7125	400.0
2018-07-27 07:00:00	AAPL	Stock	48.6975	48.755	48.6875	48.705	27528.0
2018-07-27 07:05:00	AAPL	Stock	48.7125	48.7325	48.7125	48.7325	6000.0
2018-07-27 07:10:00	AAPL	Stock	48.73	48.73	48.73	48.73	2656.0
2018-07-27 07:15:00	AAPL	Stock	48.71	48.725	48.7025	48.7075	7200.0
2018-07-27 07:20:00	AAPL	Stock	48.72	48.725	48.72	48.725	5660.0
2018-07-27 07:25:00	AAPL	Stock	48.7075	48.7075	48.6625	48.6775	4496.0
2018-07-27 07:30:00	AAPL	Stock	48.6775	48.71	48.6775	48.71	3284.0
2018-07-27 07:35:00	AAPL	Stock	48.685	48.685	48.6825	48.6825	1632.0
2018-07-27 07:40:00	AAPL	Stock	48.6875	48.7	48.6875	48.6875	8496.0
2018-07-27 07:45:00	AAPL	Stock	48.6875	48.75	48.6875	48.75	53996.0
2018-07-27 07:50:00	AAPL	Stock	48.7475	48.7475	48.705	48.71	10572.0
2018-07-27 07:55:00	AAPL	Stock	48.7125	48.72	48.6875	48.6875	11924.0
2018-07-27 08:00:00	AAPL	Stock	48.745	48.7525	48.67	48.68	57108.0
2018-07-27 08:05:00	AAPL	Stock	48.67	48.6875	48.67	48.6875	5088.0
2018-07-27 08:10:00	AAPL	Stock	48.685	48.6875	48.6775	48.6775	6000.0
2018-07-27 08:15:00	AAPL	Stock	48.6925	48.7475	48.6925	48.7375	50368.0
2018-07-27 08:20:00	AAPL	Stock	48.7375	48.77	48.7375	48.7675	85628.0
2018-07-27 08:25:00	AAPL	Stock	48.7525	48.77	48.7325	48.7325	50456.0
2018-07-27 08:30:00	AAPL	Stock	48.745	48.75	48.6825	48.6825	16164.0
2018-07-27 08:35:00	AAPL	Stock	48.6875	48.7425	48.6775	48.7425	28604.0
2018-07-27 08:40:00	AAPL	Stock	48.7375	48.75	48.725	48.725	18840.0
2018-07-27 08:45:00	AAPL	Stock	48.7375	48.7625	48.7375	48.76	39088.0
2018-07-27 08:50:00	AAPL	Stock	48.7625	48.7725	48.7625	48.77	10724.0
2018-07-27 08:55:00	AAPL	Stock	48.77	48.7875	48.77	48.7875	13100.0
2018-07-27 09:00:00	AAPL	Stock	48.7875	48.7875	48.75	48.7725	14104.0
2018-07-27 09:05:00	AAPL	Stock	48.7575	48.775	48.7525	48.775	11160.0
2018-07-27 09:10:00	AAPL	Stock	48.7725	48.78	48.755	48.77	15356.0
2018-07-27 09:15:00	AAPL	Stock	48.7575	48.77	48.735	48.745	15892.0
2018-07-27 09:20:00	AAPL	Stock	48.7375	48.7625	48.7375	48.7575	5672.0
2018-07-27 09:25:00	AAPL	Stock	48.7525	48.7525	48.6625	48.7325	38540.0
2018-07-27 09:30:00	AAPL	Stock	48.735	48.7975	48.6775	48.6838	2646132.0
2018-07-27 09:35:00	AAPL	Stock	48.6875	48.7375	48.6725	48.7175	936416.0
2018-07-27 09:40:00	AAPL	Stock	48.72	48.75	48.685	48.7188	1154948.0
2018-07-27 09:45:00	AAPL	Stock	48.719	48.75	48.68	48.685	1242804.0
2018-07-27 09:50:00	AAPL	Stock	48.69	48.725	48.66	48.72	946688.0
2018-07-27 09:55:00	AAPL	Stock	48.7212	48.7325	48.595	48.6175	1427596.0
2018-07-27 10:00:00	AAPL	Stock	48.6125	48.6555	48.58	48.62	898068.0
2018-07-27 10:05:00	AAPL	Stock	48.6175	48.645	48.5625	48.5688	604384.0
2018-07-27 10:10:00	AAPL	Stock	48.5675	48.575	48.3975	48.4075	1803424.0
2018-07-27 10:15:00	AAPL	Stock	48.4075	48.4925	48.39	48.485	1163248.0

> showing 50 of 352,152 rows — these rows as CSV

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