PREVIEW / stock_1min / 2018-12-20

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-12-20.parquet
  size:    19.4 MB
  rows:    1,286,265
  symbols: 2,305

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-12-20 04:00:00	AAPL	Stock	40.0475	40.0475	40.0475	40.0475	400.0
2018-12-20 04:20:00	AAPL	Stock	40.1	40.1	40.1	40.1	400.0
2018-12-20 04:28:00	AAPL	Stock	40.225	40.25	40.225	40.25	1492.0
2018-12-20 04:29:00	AAPL	Stock	40.2425	40.2425	40.2425	40.2425	2000.0
2018-12-20 04:30:00	AAPL	Stock	40.1875	40.1875	40.1875	40.1875	3216.0
2018-12-20 04:41:00	AAPL	Stock	40.24	40.2425	40.24	40.2425	1200.0
2018-12-20 04:44:00	AAPL	Stock	40.1525	40.1525	40.1525	40.1525	400.0
2018-12-20 04:49:00	AAPL	Stock	40.1875	40.1875	40.1875	40.1875	2000.0
2018-12-20 04:50:00	AAPL	Stock	40.22	40.235	40.22	40.235	800.0
2018-12-20 05:02:00	AAPL	Stock	40.155	40.155	40.155	40.155	1460.0
2018-12-20 05:11:00	AAPL	Stock	40.205	40.2425	40.205	40.2425	2860.0
2018-12-20 05:14:00	AAPL	Stock	40.25	40.25	40.25	40.25	3260.0
2018-12-20 05:27:00	AAPL	Stock	40.2225	40.2225	40.2225	40.2225	2000.0
2018-12-20 05:31:00	AAPL	Stock	40.175	40.175	40.175	40.175	1696.0
2018-12-20 05:32:00	AAPL	Stock	40.175	40.175	40.175	40.175	2000.0
2018-12-20 05:36:00	AAPL	Stock	40.1725	40.1725	40.1725	40.1725	2000.0
2018-12-20 05:37:00	AAPL	Stock	40.175	40.175	40.175	40.175	2000.0
2018-12-20 05:39:00	AAPL	Stock	40.15	40.15	40.15	40.15	404.0
2018-12-20 05:41:00	AAPL	Stock	40.125	40.125	40.125	40.125	400.0
2018-12-20 05:48:00	AAPL	Stock	40.1	40.1	40.1	40.1	2000.0
2018-12-20 05:53:00	AAPL	Stock	40.15	40.15	40.15	40.15	1128.0
2018-12-20 05:56:00	AAPL	Stock	40.15	40.15	40.15	40.15	600.0
2018-12-20 05:58:00	AAPL	Stock	40.175	40.175	40.175	40.175	2000.0
2018-12-20 06:06:00	AAPL	Stock	40.21	40.21	40.21	40.21	1960.0
2018-12-20 06:14:00	AAPL	Stock	40.25	40.25	40.25	40.25	680.0
2018-12-20 06:23:00	AAPL	Stock	40.24	40.24	40.24	40.24	400.0
2018-12-20 06:28:00	AAPL	Stock	40.25	40.25	40.25	40.25	800.0
2018-12-20 06:34:00	AAPL	Stock	40.25	40.25	40.25	40.25	3420.0
2018-12-20 06:42:00	AAPL	Stock	40.275	40.275	40.275	40.275	400.0
2018-12-20 06:45:00	AAPL	Stock	40.2875	40.2875	40.2875	40.2875	11796.0
2018-12-20 06:47:00	AAPL	Stock	40.3125	40.3125	40.3125	40.3125	800.0
2018-12-20 06:56:00	AAPL	Stock	40.3	40.3	40.3	40.3	1196.0
2018-12-20 06:57:00	AAPL	Stock	40.3	40.3	40.3	40.3	2800.0
2018-12-20 07:00:00	AAPL	Stock	40.3025	40.3875	40.3025	40.38	8500.0
2018-12-20 07:01:00	AAPL	Stock	40.3875	40.4025	40.3875	40.4	5200.0
2018-12-20 07:02:00	AAPL	Stock	40.4025	40.4025	40.3925	40.3925	8196.0
2018-12-20 07:03:00	AAPL	Stock	40.405	40.4225	40.405	40.4225	1200.0
2018-12-20 07:04:00	AAPL	Stock	40.4125	40.4125	40.3925	40.3925	1600.0
2018-12-20 07:05:00	AAPL	Stock	40.3925	40.3925	40.3925	40.3925	29044.0
2018-12-20 07:11:00	AAPL	Stock	40.3875	40.3875	40.3875	40.3875	1600.0
2018-12-20 07:12:00	AAPL	Stock	40.375	40.375	40.375	40.375	1200.0
2018-12-20 07:13:00	AAPL	Stock	40.375	40.3925	40.37	40.3925	11172.0
2018-12-20 07:14:00	AAPL	Stock	40.3775	40.3775	40.3625	40.3625	892.0
2018-12-20 07:15:00	AAPL	Stock	40.3625	40.3625	40.35	40.35	4164.0
2018-12-20 07:16:00	AAPL	Stock	40.3425	40.35	40.3425	40.35	800.0
2018-12-20 07:17:00	AAPL	Stock	40.365	40.375	40.365	40.37	2204.0
2018-12-20 07:18:00	AAPL	Stock	40.37	40.3725	40.37	40.3725	804.0
2018-12-20 07:19:00	AAPL	Stock	40.3925	40.3925	40.3625	40.3625	3996.0
2018-12-20 07:20:00	AAPL	Stock	40.3375	40.3375	40.325	40.335	8424.0
2018-12-20 07:21:00	AAPL	Stock	40.3675	40.37	40.3675	40.37	4844.0

> showing 50 of 1,286,265 rows — these rows as CSV

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