PREVIEW / stock_1min / 2018-09-21

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-09-21.parquet
  size:    15.3 MB
  rows:    1,088,755
  symbols: 2,328

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-09-21 04:00:00	AAPL	Stock	55.19	55.25	55.19	55.25	2300.0
2018-09-21 04:21:00	AAPL	Stock	55.2975	55.2975	55.2975	55.2975	800.0
2018-09-21 04:22:00	AAPL	Stock	55.36	55.36	55.31	55.31	7948.0
2018-09-21 04:34:00	AAPL	Stock	55.31	55.31	55.25	55.25	6648.0
2018-09-21 04:58:00	AAPL	Stock	55.1375	55.1375	55.1	55.1	6360.0
2018-09-21 05:21:00	AAPL	Stock	55.1	55.1125	55.1	55.1	3396.0
2018-09-21 05:22:00	AAPL	Stock	55.1	55.1	55.1	55.1	400.0
2018-09-21 05:23:00	AAPL	Stock	55.0875	55.0875	55.0875	55.0875	400.0
2018-09-21 05:24:00	AAPL	Stock	55.08	55.08	55.08	55.08	400.0
2018-09-21 05:46:00	AAPL	Stock	55.1875	55.1875	55.1875	55.1875	400.0
2018-09-21 05:48:00	AAPL	Stock	55.1875	55.1875	55.1875	55.1875	2800.0
2018-09-21 05:52:00	AAPL	Stock	55.175	55.175	55.175	55.175	872.0
2018-09-21 06:06:00	AAPL	Stock	55.175	55.175	55.175	55.175	400.0
2018-09-21 06:18:00	AAPL	Stock	55.195	55.2	55.195	55.2	4400.0
2018-09-21 06:38:00	AAPL	Stock	55.1875	55.1875	55.1875	55.1875	1120.0
2018-09-21 06:53:00	AAPL	Stock	55.1275	55.1275	55.1275	55.1275	400.0
2018-09-21 06:56:00	AAPL	Stock	55.125	55.125	55.125	55.125	1600.0
2018-09-21 06:57:00	AAPL	Stock	55.125	55.125	55.125	55.125	400.0
2018-09-21 07:00:00	AAPL	Stock	55.1575	55.1575	55.15	55.15	2584.0
2018-09-21 07:01:00	AAPL	Stock	55.1275	55.1275	55.125	55.125	6400.0
2018-09-21 07:03:00	AAPL	Stock	55.15	55.1575	55.15	55.155	3600.0
2018-09-21 07:05:00	AAPL	Stock	55.14	55.14	55.125	55.125	18724.0
2018-09-21 07:06:00	AAPL	Stock	55.1075	55.1075	55.1	55.1	2800.0
2018-09-21 07:11:00	AAPL	Stock	55.0975	55.0975	55.0975	55.0975	800.0
2018-09-21 07:12:00	AAPL	Stock	55.0975	55.0975	55.0975	55.0975	3048.0
2018-09-21 07:22:00	AAPL	Stock	55.0875	55.0875	55.0875	55.0875	400.0
2018-09-21 07:25:00	AAPL	Stock	55.0675	55.0675	55.0675	55.0675	2600.0
2018-09-21 07:26:00	AAPL	Stock	55.065	55.065	55.065	55.065	400.0
2018-09-21 07:29:00	AAPL	Stock	55.05	55.05	55.05	55.05	2620.0
2018-09-21 07:31:00	AAPL	Stock	55.075	55.075	55.075	55.075	3288.0
2018-09-21 07:32:00	AAPL	Stock	55.075	55.075	55.0725	55.075	1600.0
2018-09-21 07:33:00	AAPL	Stock	55.075	55.075	55.0475	55.0475	3048.0
2018-09-21 07:34:00	AAPL	Stock	55.025	55.05	55.0	55.0175	16484.0
2018-09-21 07:36:00	AAPL	Stock	55.005	55.005	55.005	55.005	400.0
2018-09-21 07:37:00	AAPL	Stock	55.01	55.01	55.01	55.01	400.0
2018-09-21 07:38:00	AAPL	Stock	55.01	55.01	55.0	55.0	2476.0
2018-09-21 07:39:00	AAPL	Stock	55.0	55.0	55.0	55.0	1028.0
2018-09-21 07:40:00	AAPL	Stock	54.98	55.01	54.98	55.01	1200.0
2018-09-21 07:41:00	AAPL	Stock	55.01	55.01	55.01	55.01	1200.0
2018-09-21 07:42:00	AAPL	Stock	55.025	55.025	55.025	55.025	1000.0
2018-09-21 07:47:00	AAPL	Stock	55.0125	55.0125	55.0125	55.0125	400.0
2018-09-21 07:54:00	AAPL	Stock	55.04	55.04	55.04	55.04	400.0
2018-09-21 07:55:00	AAPL	Stock	55.0425	55.0875	55.0425	55.0875	5192.0
2018-09-21 07:59:00	AAPL	Stock	55.075	55.075	55.075	55.075	436.0
2018-09-21 08:00:00	AAPL	Stock	55.155	55.1575	55.0	55.0725	66504.0
2018-09-21 08:01:00	AAPL	Stock	55.075	55.08	55.0725	55.08	5880.0
2018-09-21 08:02:00	AAPL	Stock	55.08	55.0825	55.075	55.0825	4800.0
2018-09-21 08:03:00	AAPL	Stock	55.0825	55.085	55.0825	55.085	4760.0
2018-09-21 08:04:00	AAPL	Stock	55.085	55.085	55.085	55.085	2400.0
2018-09-21 08:05:00	AAPL	Stock	55.1	55.1075	55.1	55.1075	2684.0

> showing 50 of 1,088,755 rows — these rows as CSV

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