PREVIEW / stock_1min / 2018-02-06

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-02-06.parquet
  size:    18.3 MB
  rows:    1,254,380
  symbols: 2,423

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-06 04:00:00	AAPL	Stock	38.9025	38.9025	38.875	38.875	9212.0
2018-02-06 04:01:00	AAPL	Stock	39.0	39.0	39.0	39.0	1600.0
2018-02-06 04:02:00	AAPL	Stock	39.0	39.0	39.0	39.0	800.0
2018-02-06 04:03:00	AAPL	Stock	39.1725	39.1725	39.1375	39.1725	3612.0
2018-02-06 04:04:00	AAPL	Stock	39.175	39.175	39.13	39.13	4000.0
2018-02-06 04:07:00	AAPL	Stock	39.0	39.1625	39.0	39.1625	2400.0
2018-02-06 04:08:00	AAPL	Stock	39.005	39.1775	39.0	39.125	13644.0
2018-02-06 04:09:00	AAPL	Stock	39.125	39.125	39.0	39.0	10716.0
2018-02-06 04:12:00	AAPL	Stock	39.1625	39.225	39.125	39.225	2344.0
2018-02-06 04:13:00	AAPL	Stock	39.125	39.125	39.125	39.125	800.0
2018-02-06 04:16:00	AAPL	Stock	39.1425	39.1425	39.1425	39.1425	400.0
2018-02-06 04:17:00	AAPL	Stock	39.09	39.09	39.09	39.09	1264.0
2018-02-06 04:19:00	AAPL	Stock	39.1575	39.1575	39.155	39.155	6124.0
2018-02-06 04:21:00	AAPL	Stock	39.155	39.155	39.155	39.155	400.0
2018-02-06 04:22:00	AAPL	Stock	39.155	39.155	39.155	39.155	1308.0
2018-02-06 04:23:00	AAPL	Stock	39.2075	39.2075	39.2075	39.2075	4000.0
2018-02-06 04:28:00	AAPL	Stock	39.2175	39.2175	39.2175	39.2175	2748.0
2018-02-06 04:29:00	AAPL	Stock	39.19	39.19	39.19	39.19	2800.0
2018-02-06 04:30:00	AAPL	Stock	39.22	39.22	39.22	39.22	400.0
2018-02-06 04:31:00	AAPL	Stock	39.19	39.19	39.155	39.155	15692.0
2018-02-06 04:32:00	AAPL	Stock	39.125	39.125	39.125	39.125	6328.0
2018-02-06 04:36:00	AAPL	Stock	39.1875	39.1875	39.1875	39.1875	400.0
2018-02-06 04:37:00	AAPL	Stock	39.145	39.145	39.145	39.145	800.0
2018-02-06 04:38:00	AAPL	Stock	39.175	39.175	39.175	39.175	2800.0
2018-02-06 04:39:00	AAPL	Stock	39.1725	39.22	39.1725	39.22	8008.0
2018-02-06 04:40:00	AAPL	Stock	39.125	39.125	39.025	39.05	7200.0
2018-02-06 04:41:00	AAPL	Stock	39.025	39.025	39.025	39.025	3816.0
2018-02-06 04:42:00	AAPL	Stock	39.0	39.0	38.96	38.96	6232.0
2018-02-06 04:43:00	AAPL	Stock	38.9875	38.9875	38.975	38.975	800.0
2018-02-06 04:44:00	AAPL	Stock	39.005	39.005	39.005	39.005	400.0
2018-02-06 04:45:00	AAPL	Stock	39.0025	39.0025	39.0	39.0	2060.0
2018-02-06 04:47:00	AAPL	Stock	38.96	38.96	38.96	38.96	400.0
2018-02-06 04:51:00	AAPL	Stock	38.9525	38.9525	38.9525	38.9525	400.0
2018-02-06 04:53:00	AAPL	Stock	38.905	38.9875	38.905	38.9875	1200.0
2018-02-06 04:55:00	AAPL	Stock	39.0725	39.0725	39.0725	39.0725	3464.0
2018-02-06 04:56:00	AAPL	Stock	39.015	39.015	39.015	39.015	1392.0
2018-02-06 04:57:00	AAPL	Stock	39.01	39.01	39.0075	39.0075	15964.0
2018-02-06 05:02:00	AAPL	Stock	38.93	38.93	38.925	38.925	9284.0
2018-02-06 05:03:00	AAPL	Stock	38.9025	38.9025	38.9025	38.9025	2400.0
2018-02-06 05:04:00	AAPL	Stock	38.9025	38.9025	38.84	38.84	19100.0
2018-02-06 05:05:00	AAPL	Stock	38.8775	38.8775	38.815	38.815	1140.0
2018-02-06 05:06:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	1132.0
2018-02-06 05:08:00	AAPL	Stock	38.815	38.815	38.815	38.815	1200.0
2018-02-06 05:09:00	AAPL	Stock	38.815	38.815	38.815	38.815	3992.0
2018-02-06 05:10:00	AAPL	Stock	38.9	38.9225	38.9	38.9225	2000.0
2018-02-06 05:11:00	AAPL	Stock	38.9225	38.9225	38.9225	38.9225	400.0
2018-02-06 05:13:00	AAPL	Stock	38.83	38.83	38.83	38.83	1396.0
2018-02-06 05:15:00	AAPL	Stock	38.92	38.92	38.92	38.92	2812.0
2018-02-06 05:16:00	AAPL	Stock	38.92	38.9225	38.92	38.9225	6280.0
2018-02-06 05:17:00	AAPL	Stock	38.93	38.9325	38.9025	38.9025	1600.0

> showing 50 of 1,254,380 rows — these rows as CSV

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