PREVIEW / stock_1min / 2018-02-05

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-02-05.parquet
  size:    18.3 MB
  rows:    1,216,273
  symbols: 2,414

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-05 04:00:00	AAPL	Stock	40.0	40.0	40.0	40.0	9272.0
2018-02-05 04:04:00	AAPL	Stock	40.0	40.0	40.0	40.0	496.0
2018-02-05 04:05:00	AAPL	Stock	39.95	39.95	39.95	39.95	4640.0
2018-02-05 04:06:00	AAPL	Stock	39.95	39.95	39.95	39.95	15200.0
2018-02-05 04:07:00	AAPL	Stock	39.9375	40.0	39.9375	40.0	3956.0
2018-02-05 04:08:00	AAPL	Stock	40.0	40.0	39.9775	39.9775	2068.0
2018-02-05 04:09:00	AAPL	Stock	40.0	40.0	40.0	40.0	4000.0
2018-02-05 04:10:00	AAPL	Stock	40.0	40.0	40.0	40.0	8432.0
2018-02-05 04:11:00	AAPL	Stock	40.0	40.0	40.0	40.0	1980.0
2018-02-05 04:14:00	AAPL	Stock	40.0	40.0	40.0	40.0	2400.0
2018-02-05 04:15:00	AAPL	Stock	40.0	40.0	39.9625	39.9975	2400.0
2018-02-05 04:16:00	AAPL	Stock	40.0	40.025	40.0	40.025	2620.0
2018-02-05 04:17:00	AAPL	Stock	40.0	40.0	40.0	40.0	1440.0
2018-02-05 04:18:00	AAPL	Stock	40.0	40.0	40.0	40.0	1988.0
2018-02-05 04:19:00	AAPL	Stock	40.0	40.0	40.0	40.0	2400.0
2018-02-05 04:20:00	AAPL	Stock	40.0	40.0	40.0	40.0	800.0
2018-02-05 04:24:00	AAPL	Stock	40.005	40.005	40.005	40.005	800.0
2018-02-05 04:26:00	AAPL	Stock	40.0225	40.0225	40.0225	40.0225	800.0
2018-02-05 04:27:00	AAPL	Stock	40.035	40.035	40.0	40.0	5496.0
2018-02-05 04:28:00	AAPL	Stock	40.0	40.0	40.0	40.0	400.0
2018-02-05 04:29:00	AAPL	Stock	40.0375	40.0375	40.0375	40.0375	400.0
2018-02-05 04:30:00	AAPL	Stock	40.025	40.025	40.025	40.025	800.0
2018-02-05 04:32:00	AAPL	Stock	40.0125	40.02	40.0125	40.02	808.0
2018-02-05 04:33:00	AAPL	Stock	40.02	40.02	40.02	40.02	1200.0
2018-02-05 04:40:00	AAPL	Stock	40.07	40.07	40.05	40.05	2000.0
2018-02-05 04:42:00	AAPL	Stock	40.07	40.07	40.07	40.07	400.0
2018-02-05 04:43:00	AAPL	Stock	40.07	40.07	40.07	40.07	7600.0
2018-02-05 04:44:00	AAPL	Stock	40.07	40.07	40.07	40.07	3960.0
2018-02-05 04:46:00	AAPL	Stock	40.1225	40.1275	40.1225	40.1275	1400.0
2018-02-05 04:47:00	AAPL	Stock	40.1275	40.1275	40.125	40.125	1600.0
2018-02-05 04:50:00	AAPL	Stock	40.1675	40.175	40.1675	40.175	1564.0
2018-02-05 04:52:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2018-02-05 04:57:00	AAPL	Stock	40.1	40.1	40.1	40.1	400.0
2018-02-05 04:58:00	AAPL	Stock	40.125	40.125	40.125	40.125	1200.0
2018-02-05 05:02:00	AAPL	Stock	40.09	40.09	40.0875	40.0875	2000.0
2018-02-05 05:03:00	AAPL	Stock	40.075	40.075	40.075	40.075	800.0
2018-02-05 05:04:00	AAPL	Stock	40.0725	40.0725	40.0725	40.0725	1600.0
2018-02-05 05:10:00	AAPL	Stock	40.12	40.12	40.12	40.12	420.0
2018-02-05 05:13:00	AAPL	Stock	40.125	40.15	40.125	40.15	2800.0
2018-02-05 05:14:00	AAPL	Stock	40.125	40.125	40.125	40.125	840.0
2018-02-05 05:15:00	AAPL	Stock	40.1275	40.1275	40.1275	40.1275	1200.0
2018-02-05 05:16:00	AAPL	Stock	40.125	40.125	40.125	40.125	4400.0
2018-02-05 05:20:00	AAPL	Stock	40.0925	40.0925	40.0925	40.0925	400.0
2018-02-05 05:24:00	AAPL	Stock	40.11	40.11	40.1	40.11	2400.0
2018-02-05 05:25:00	AAPL	Stock	40.09	40.0925	40.09	40.09	4460.0
2018-02-05 05:37:00	AAPL	Stock	40.125	40.125	40.125	40.125	7592.0
2018-02-05 05:40:00	AAPL	Stock	40.125	40.125	40.125	40.125	7600.0
2018-02-05 05:44:00	AAPL	Stock	40.17	40.17	40.17	40.17	3636.0
2018-02-05 05:57:00	AAPL	Stock	40.14	40.14	40.14	40.14	400.0
2018-02-05 06:00:00	AAPL	Stock	40.1375	40.1375	40.135	40.135	1928.0

> showing 50 of 1,216,273 rows — these rows as CSV

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