PREVIEW / stock_1min / 2018-04-26

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-26.parquet
  size:    14.6 MB
  rows:    1,056,759
  symbols: 2,396

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-04-26 04:05:00	AAPL	Stock	41.125	41.125	41.125	41.125	2860.0
2018-04-26 04:18:00	AAPL	Stock	41.15	41.15	41.15	41.15	400.0
2018-04-26 04:35:00	AAPL	Stock	41.1175	41.1175	41.1175	41.1175	2000.0
2018-04-26 04:36:00	AAPL	Stock	41.075	41.075	41.07	41.07	800.0
2018-04-26 04:39:00	AAPL	Stock	41.07	41.07	41.07	41.07	800.0
2018-04-26 04:43:00	AAPL	Stock	41.0675	41.105	41.0675	41.105	5200.0
2018-04-26 05:03:00	AAPL	Stock	41.0375	41.0375	41.0375	41.0375	1920.0
2018-04-26 05:10:00	AAPL	Stock	41.0775	41.0775	41.0775	41.0775	800.0
2018-04-26 05:26:00	AAPL	Stock	41.1225	41.125	41.1225	41.125	1200.0
2018-04-26 06:18:00	AAPL	Stock	41.1775	41.1775	41.1775	41.1775	400.0
2018-04-26 06:22:00	AAPL	Stock	41.205	41.2225	41.205	41.2225	2204.0
2018-04-26 06:29:00	AAPL	Stock	41.1625	41.1625	41.1625	41.1625	5404.0
2018-04-26 06:49:00	AAPL	Stock	41.1125	41.1125	41.1	41.1	9496.0
2018-04-26 06:53:00	AAPL	Stock	41.1	41.1	41.1	41.1	7200.0
2018-04-26 06:54:00	AAPL	Stock	41.1	41.1	41.1	41.1	18400.0
2018-04-26 07:00:00	AAPL	Stock	41.195	41.195	41.1	41.1	800.0
2018-04-26 07:05:00	AAPL	Stock	41.105	41.105	41.105	41.105	400.0
2018-04-26 07:06:00	AAPL	Stock	41.105	41.1375	41.1	41.1375	6280.0
2018-04-26 07:07:00	AAPL	Stock	41.1375	41.1375	41.1125	41.1125	7600.0
2018-04-26 07:09:00	AAPL	Stock	41.1125	41.1225	41.1125	41.1225	4000.0
2018-04-26 07:10:00	AAPL	Stock	41.1125	41.1125	41.1125	41.1125	4000.0
2018-04-26 07:11:00	AAPL	Stock	41.1	41.1	41.0875	41.0875	4236.0
2018-04-26 07:17:00	AAPL	Stock	41.085	41.085	41.065	41.07	8352.0
2018-04-26 07:18:00	AAPL	Stock	41.065	41.065	41.05	41.05	3956.0
2018-04-26 07:19:00	AAPL	Stock	41.0275	41.0275	41.025	41.025	2164.0
2018-04-26 07:20:00	AAPL	Stock	41.075	41.075	41.025	41.0475	11064.0
2018-04-26 07:24:00	AAPL	Stock	41.0475	41.0475	41.0475	41.0475	400.0
2018-04-26 07:29:00	AAPL	Stock	41.0475	41.0475	41.0375	41.0375	12400.0
2018-04-26 07:32:00	AAPL	Stock	41.015	41.015	41.0	41.0	8600.0
2018-04-26 07:33:00	AAPL	Stock	40.9875	41.0125	40.9875	41.0	4704.0
2018-04-26 07:34:00	AAPL	Stock	41.0	41.0	40.97	41.0	4000.0
2018-04-26 07:35:00	AAPL	Stock	40.995	40.995	40.995	40.995	424.0
2018-04-26 07:36:00	AAPL	Stock	40.9775	40.9775	40.9775	40.9775	400.0
2018-04-26 07:37:00	AAPL	Stock	40.9775	40.9775	40.965	40.965	14068.0
2018-04-26 07:39:00	AAPL	Stock	40.9625	40.9625	40.9625	40.9625	400.0
2018-04-26 07:40:00	AAPL	Stock	40.9875	40.9875	40.9875	40.9875	800.0
2018-04-26 07:41:00	AAPL	Stock	40.9875	40.995	40.9875	40.995	1080.0
2018-04-26 07:43:00	AAPL	Stock	41.0	41.0	41.0	41.0	400.0
2018-04-26 07:44:00	AAPL	Stock	41.0	41.0	41.0	41.0	2800.0
2018-04-26 07:45:00	AAPL	Stock	41.0	41.0	41.0	41.0	400.0
2018-04-26 07:46:00	AAPL	Stock	41.0	41.0	41.0	41.0	1200.0
2018-04-26 07:48:00	AAPL	Stock	41.0025	41.005	41.0	41.0	1600.0
2018-04-26 07:49:00	AAPL	Stock	41.0	41.0	40.99	41.0	1772.0
2018-04-26 07:55:00	AAPL	Stock	41.01	41.0125	41.0	41.0	4904.0
2018-04-26 07:56:00	AAPL	Stock	40.99	40.99	40.9875	40.9875	2400.0
2018-04-26 07:57:00	AAPL	Stock	40.9775	40.9775	40.9775	40.9775	800.0
2018-04-26 07:58:00	AAPL	Stock	40.9775	40.9775	40.9775	40.9775	800.0
2018-04-26 07:59:00	AAPL	Stock	40.9625	40.9625	40.9625	40.9625	1020.0
2018-04-26 08:00:00	AAPL	Stock	41.0	41.1625	40.955	41.0	51500.0
2018-04-26 08:02:00	AAPL	Stock	40.98	40.98	40.98	40.98	1812.0

> showing 50 of 1,056,759 rows — these rows as CSV

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