PREVIEW / stock_1min / 2018-02-09

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-02-09.parquet
  size:    18.5 MB
  rows:    1,247,400
  symbols: 2,410

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-02-09 04:00:00	AAPL	Stock	39.1275	39.14	39.1275	39.1275	9212.0
2018-02-09 04:04:00	AAPL	Stock	39.185	39.185	39.185	39.185	5188.0
2018-02-09 04:05:00	AAPL	Stock	39.185	39.185	39.185	39.185	400.0
2018-02-09 04:10:00	AAPL	Stock	39.185	39.2125	39.185	39.185	20500.0
2018-02-09 04:11:00	AAPL	Stock	39.225	39.225	39.2125	39.2125	4400.0
2018-02-09 04:13:00	AAPL	Stock	39.2125	39.2125	39.2125	39.2125	600.0
2018-02-09 04:32:00	AAPL	Stock	39.1225	39.1225	39.07	39.07	1992.0
2018-02-09 04:34:00	AAPL	Stock	39.07	39.07	39.07	39.07	2000.0
2018-02-09 04:40:00	AAPL	Stock	39.105	39.115	39.105	39.1125	2636.0
2018-02-09 04:41:00	AAPL	Stock	39.0975	39.1175	39.0975	39.1175	1200.0
2018-02-09 04:44:00	AAPL	Stock	39.1175	39.1175	39.1175	39.1175	548.0
2018-02-09 05:10:00	AAPL	Stock	39.1025	39.1025	39.1025	39.1025	800.0
2018-02-09 05:11:00	AAPL	Stock	39.1025	39.1025	39.0025	39.0025	7828.0
2018-02-09 05:35:00	AAPL	Stock	39.1175	39.1625	39.1175	39.1625	21600.0
2018-02-09 05:38:00	AAPL	Stock	39.2125	39.2125	39.2125	39.2125	400.0
2018-02-09 05:43:00	AAPL	Stock	39.1375	39.1375	39.1375	39.1375	400.0
2018-02-09 05:44:00	AAPL	Stock	39.1375	39.1375	39.1375	39.1375	400.0
2018-02-09 05:52:00	AAPL	Stock	39.1375	39.1375	39.1375	39.1375	400.0
2018-02-09 05:56:00	AAPL	Stock	39.175	39.175	39.175	39.175	2000.0
2018-02-09 05:58:00	AAPL	Stock	39.1675	39.1675	39.1675	39.1675	2000.0
2018-02-09 06:00:00	AAPL	Stock	39.1675	39.1675	39.1675	39.1675	400.0
2018-02-09 06:03:00	AAPL	Stock	39.1	39.1	39.1	39.1	6400.0
2018-02-09 06:04:00	AAPL	Stock	39.1	39.1	39.1	39.1	2000.0
2018-02-09 06:05:00	AAPL	Stock	39.0975	39.0975	39.0975	39.0975	400.0
2018-02-09 06:07:00	AAPL	Stock	39.0625	39.0625	39.0625	39.0625	400.0
2018-02-09 06:12:00	AAPL	Stock	39.08	39.08	39.08	39.08	400.0
2018-02-09 06:16:00	AAPL	Stock	39.0725	39.075	39.0725	39.075	2152.0
2018-02-09 06:18:00	AAPL	Stock	39.0725	39.0725	39.0725	39.0725	1600.0
2018-02-09 06:19:00	AAPL	Stock	39.0725	39.0725	39.0725	39.0725	4400.0
2018-02-09 06:20:00	AAPL	Stock	39.0725	39.0725	39.0575	39.0575	12560.0
2018-02-09 06:23:00	AAPL	Stock	39.0125	39.0125	39.0	39.0	5200.0
2018-02-09 06:24:00	AAPL	Stock	39.0	39.0025	39.0	39.0025	1800.0
2018-02-09 06:25:00	AAPL	Stock	39.0475	39.0475	39.0475	39.0475	800.0
2018-02-09 06:26:00	AAPL	Stock	39.0475	39.0475	39.045	39.045	6000.0
2018-02-09 06:27:00	AAPL	Stock	39.005	39.0075	39.005	39.0075	7464.0
2018-02-09 06:28:00	AAPL	Stock	39.0	39.0	39.0	39.0	2200.0
2018-02-09 06:29:00	AAPL	Stock	38.9825	38.9825	38.9825	38.9825	404.0
2018-02-09 06:30:00	AAPL	Stock	38.9825	38.9825	38.98	38.98	2000.0
2018-02-09 06:31:00	AAPL	Stock	38.98	38.98	38.965	38.965	4048.0
2018-02-09 06:33:00	AAPL	Stock	39.0325	39.06	39.0325	39.06	3608.0
2018-02-09 06:34:00	AAPL	Stock	39.0	39.0	39.0	39.0	400.0
2018-02-09 06:35:00	AAPL	Stock	38.98	39.0	38.9775	39.0	8360.0
2018-02-09 06:36:00	AAPL	Stock	38.965	38.965	38.965	38.965	632.0
2018-02-09 06:37:00	AAPL	Stock	38.965	38.965	38.965	38.965	1260.0
2018-02-09 06:38:00	AAPL	Stock	38.9875	38.9875	38.9875	38.9875	3900.0
2018-02-09 06:41:00	AAPL	Stock	38.9575	38.9875	38.9575	38.9875	5040.0
2018-02-09 06:42:00	AAPL	Stock	39.0	39.0	38.975	38.975	928.0
2018-02-09 06:43:00	AAPL	Stock	38.975	38.975	38.8825	38.8825	24936.0
2018-02-09 06:44:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	412.0
2018-02-09 06:45:00	AAPL	Stock	38.9575	38.9975	38.95	38.95	4800.0

> showing 50 of 1,247,400 rows — these rows as CSV

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