PREVIEW / stock_1min / 2018-01-26

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-01-26.parquet
  size:    16.1 MB
  rows:    1,073,884
  symbols: 2,418

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-01-26 04:00:00	AAPL	Stock	43.0025	43.0625	43.0025	43.0625	5484.0
2018-01-26 04:01:00	AAPL	Stock	43.0625	43.0625	43.0625	43.0625	2200.0
2018-01-26 04:09:00	AAPL	Stock	43.06	43.06	43.06	43.06	400.0
2018-01-26 04:14:00	AAPL	Stock	43.025	43.025	43.025	43.025	4000.0
2018-01-26 04:15:00	AAPL	Stock	43.025	43.025	43.025	43.025	4000.0
2018-01-26 04:16:00	AAPL	Stock	43.025	43.025	43.0025	43.0025	14540.0
2018-01-26 04:17:00	AAPL	Stock	43.0	43.0	43.0	43.0	4000.0
2018-01-26 04:19:00	AAPL	Stock	43.0	43.0	43.0	43.0	5604.0
2018-01-26 04:20:00	AAPL	Stock	42.9975	43.0	42.9975	43.0	2920.0
2018-01-26 04:22:00	AAPL	Stock	43.0	43.0	43.0	43.0	3320.0
2018-01-26 04:23:00	AAPL	Stock	43.0	43.0	43.0	43.0	3184.0
2018-01-26 04:24:00	AAPL	Stock	43.0	43.0	43.0	43.0	19200.0
2018-01-26 04:25:00	AAPL	Stock	43.0	43.0	43.0	43.0	9600.0
2018-01-26 04:26:00	AAPL	Stock	43.0	43.0	43.0	43.0	1760.0
2018-01-26 04:30:00	AAPL	Stock	43.0	43.0	43.0	43.0	8400.0
2018-01-26 04:36:00	AAPL	Stock	42.9875	42.9875	42.9875	42.9875	400.0
2018-01-26 04:45:00	AAPL	Stock	43.0875	43.0875	43.0875	43.0875	400.0
2018-01-26 04:47:00	AAPL	Stock	43.0875	43.0875	43.0875	43.0875	400.0
2018-01-26 05:22:00	AAPL	Stock	43.075	43.075	43.075	43.075	800.0
2018-01-26 05:26:00	AAPL	Stock	43.075	43.075	43.075	43.075	400.0
2018-01-26 05:27:00	AAPL	Stock	43.075	43.075	43.075	43.075	800.0
2018-01-26 05:30:00	AAPL	Stock	43.0875	43.0875	43.0875	43.0875	1200.0
2018-01-26 05:35:00	AAPL	Stock	43.1	43.1	43.1	43.1	1956.0
2018-01-26 05:48:00	AAPL	Stock	43.075	43.075	43.075	43.075	11020.0
2018-01-26 05:54:00	AAPL	Stock	43.075	43.075	43.075	43.075	400.0
2018-01-26 05:57:00	AAPL	Stock	43.125	43.125	43.125	43.125	1968.0
2018-01-26 06:02:00	AAPL	Stock	43.1175	43.12	43.1075	43.1175	4316.0
2018-01-26 06:05:00	AAPL	Stock	43.1175	43.125	43.1175	43.1175	13932.0
2018-01-26 06:09:00	AAPL	Stock	43.17	43.17	43.125	43.125	2212.0
2018-01-26 06:17:00	AAPL	Stock	43.125	43.125	43.125	43.125	8900.0
2018-01-26 06:18:00	AAPL	Stock	43.125	43.125	43.1175	43.1175	31200.0
2018-01-26 06:20:00	AAPL	Stock	43.125	43.125	43.125	43.125	6792.0
2018-01-26 06:21:00	AAPL	Stock	43.125	43.125	43.125	43.125	8000.0
2018-01-26 06:22:00	AAPL	Stock	43.1125	43.125	43.1125	43.125	1000.0
2018-01-26 06:25:00	AAPL	Stock	43.125	43.125	43.125	43.125	2000.0
2018-01-26 06:27:00	AAPL	Stock	43.125	43.125	43.125	43.125	2800.0
2018-01-26 06:30:00	AAPL	Stock	43.125	43.125	43.125	43.125	400.0
2018-01-26 06:32:00	AAPL	Stock	43.125	43.125	43.125	43.125	800.0
2018-01-26 06:33:00	AAPL	Stock	43.125	43.125	43.125	43.125	536.0
2018-01-26 06:37:00	AAPL	Stock	43.1025	43.1025	43.1025	43.1025	400.0
2018-01-26 06:38:00	AAPL	Stock	43.125	43.125	43.125	43.125	656.0
2018-01-26 06:42:00	AAPL	Stock	43.1375	43.1375	43.1375	43.1375	784.0
2018-01-26 06:44:00	AAPL	Stock	43.15	43.15	43.15	43.15	3960.0
2018-01-26 06:45:00	AAPL	Stock	43.175	43.175	43.175	43.175	600.0
2018-01-26 06:48:00	AAPL	Stock	43.15	43.15	43.15	43.15	400.0
2018-01-26 06:49:00	AAPL	Stock	43.1675	43.1675	43.1675	43.1675	400.0
2018-01-26 06:51:00	AAPL	Stock	43.15	43.15	43.15	43.15	7172.0
2018-01-26 06:52:00	AAPL	Stock	43.15	43.15	43.15	43.15	800.0
2018-01-26 06:56:00	AAPL	Stock	43.165	43.165	43.165	43.165	1332.0
2018-01-26 07:00:00	AAPL	Stock	43.1325	43.1325	43.13	43.1325	3560.0

> showing 50 of 1,073,884 rows — these rows as CSV

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