PREVIEW / stock_1min / 2018-07-27

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-27.parquet
  size:    15.0 MB
  rows:    1,072,624
  symbols: 2,308

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	400.0
2018-07-27 04:03:00	AAPL	Stock	48.65	48.65	48.65	48.65	400.0
2018-07-27 04:12: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	3600.0
2018-07-27 04:21:00	AAPL	Stock	48.7125	48.7125	48.7125	48.7125	896.0
2018-07-27 04:30:00	AAPL	Stock	48.65	48.65	48.65	48.65	404.0
2018-07-27 04:48:00	AAPL	Stock	48.75	48.75	48.75	48.75	400.0
2018-07-27 04:52:00	AAPL	Stock	48.75	48.75	48.75	48.75	2400.0
2018-07-27 04:53:00	AAPL	Stock	48.7725	48.7725	48.75	48.75	880.0
2018-07-27 05:23:00	AAPL	Stock	48.7425	48.7425	48.7425	48.7425	3600.0
2018-07-27 05:24:00	AAPL	Stock	48.75	48.75	48.75	48.75	3200.0
2018-07-27 05:51:00	AAPL	Stock	48.69	48.69	48.69	48.69	700.0
2018-07-27 05:56:00	AAPL	Stock	48.7	48.7	48.7	48.7	448.0
2018-07-27 06:54: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.75	23428.0
2018-07-27 07:02:00	AAPL	Stock	48.7425	48.7425	48.7425	48.7425	1600.0
2018-07-27 07:03:00	AAPL	Stock	48.7325	48.7325	48.7325	48.7325	500.0
2018-07-27 07:04:00	AAPL	Stock	48.705	48.705	48.705	48.705	2000.0
2018-07-27 07:08:00	AAPL	Stock	48.7125	48.7325	48.7125	48.7325	6000.0
2018-07-27 07:14:00	AAPL	Stock	48.73	48.73	48.73	48.73	2656.0
2018-07-27 07:15:00	AAPL	Stock	48.71	48.715	48.7025	48.7025	6000.0
2018-07-27 07:17:00	AAPL	Stock	48.7025	48.7025	48.7025	48.7025	400.0
2018-07-27 07:19:00	AAPL	Stock	48.725	48.725	48.7075	48.7075	800.0
2018-07-27 07:20:00	AAPL	Stock	48.72	48.72	48.72	48.72	1200.0
2018-07-27 07:24:00	AAPL	Stock	48.725	48.725	48.725	48.725	4460.0
2018-07-27 07:25:00	AAPL	Stock	48.7075	48.7075	48.7075	48.7075	668.0
2018-07-27 07:26:00	AAPL	Stock	48.6875	48.6875	48.6775	48.6775	2600.0
2018-07-27 07:27:00	AAPL	Stock	48.6625	48.6625	48.6625	48.6625	828.0
2018-07-27 07:28:00	AAPL	Stock	48.6775	48.6775	48.6775	48.6775	400.0
2018-07-27 07:30:00	AAPL	Stock	48.6775	48.6775	48.6775	48.6775	400.0
2018-07-27 07:32:00	AAPL	Stock	48.6775	48.6775	48.6775	48.6775	1892.0
2018-07-27 07:33:00	AAPL	Stock	48.71	48.71	48.71	48.71	992.0
2018-07-27 07:36:00	AAPL	Stock	48.685	48.685	48.685	48.685	832.0
2018-07-27 07:37:00	AAPL	Stock	48.6825	48.6825	48.6825	48.6825	800.0
2018-07-27 07:40:00	AAPL	Stock	48.6875	48.6875	48.6875	48.6875	400.0
2018-07-27 07:42:00	AAPL	Stock	48.6975	48.7	48.69	48.69	7108.0
2018-07-27 07:43:00	AAPL	Stock	48.6975	48.6975	48.6975	48.6975	400.0
2018-07-27 07:44:00	AAPL	Stock	48.6875	48.6875	48.6875	48.6875	588.0
2018-07-27 07:45:00	AAPL	Stock	48.6875	48.695	48.6875	48.695	1616.0
2018-07-27 07:46:00	AAPL	Stock	48.6975	48.7	48.6975	48.7	19732.0
2018-07-27 07:47:00	AAPL	Stock	48.7	48.7175	48.7	48.71	3200.0
2018-07-27 07:48:00	AAPL	Stock	48.71	48.7375	48.71	48.7375	25448.0
2018-07-27 07:49:00	AAPL	Stock	48.745	48.75	48.745	48.75	4000.0
2018-07-27 07:50:00	AAPL	Stock	48.7475	48.7475	48.7475	48.7475	400.0
2018-07-27 07:51:00	AAPL	Stock	48.725	48.725	48.725	48.725	400.0
2018-07-27 07:52:00	AAPL	Stock	48.74	48.74	48.705	48.7125	9372.0
2018-07-27 07:54:00	AAPL	Stock	48.71	48.71	48.71	48.71	400.0
2018-07-27 07:55:00	AAPL	Stock	48.7125	48.72	48.7	48.72	3200.0
2018-07-27 07:56:00	AAPL	Stock	48.7	48.7	48.6925	48.695	3276.0
2018-07-27 07:57:00	AAPL	Stock	48.6925	48.6925	48.6925	48.6925	412.0

> showing 50 of 1,072,624 rows — these rows as CSV

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