PREVIEW / stock_1min / 2018-07-09

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-09.parquet
  size:    15.0 MB
  rows:    1,072,596
  symbols: 2,358

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-07-09 03:59:00	AAPL	Stock	47.225	47.225	47.225	47.225	400.0
2018-07-09 04:16:00	AAPL	Stock	47.25	47.25	47.25	47.25	800.0
2018-07-09 04:59:00	AAPL	Stock	47.25	47.25	47.25	47.25	3108.0
2018-07-09 05:01:00	AAPL	Stock	47.2525	47.2525	47.225	47.225	18872.0
2018-07-09 05:03:00	AAPL	Stock	47.22	47.22	47.22	47.22	4000.0
2018-07-09 05:05:00	AAPL	Stock	47.225	47.225	47.225	47.225	400.0
2018-07-09 05:29:00	AAPL	Stock	47.2	47.2	47.2	47.2	1036.0
2018-07-09 05:47:00	AAPL	Stock	47.2125	47.2125	47.2125	47.2125	800.0
2018-07-09 05:50:00	AAPL	Stock	47.2125	47.2125	47.2125	47.2125	6456.0
2018-07-09 06:58:00	AAPL	Stock	47.2175	47.2175	47.2175	47.2175	400.0
2018-07-09 06:59:00	AAPL	Stock	47.245	47.245	47.225	47.225	1792.0
2018-07-09 07:00:00	AAPL	Stock	47.2475	47.25	47.2475	47.25	10400.0
2018-07-09 07:02:00	AAPL	Stock	47.2675	47.2675	47.26	47.26	23360.0
2018-07-09 07:03:00	AAPL	Stock	47.26	47.26	47.26	47.26	800.0
2018-07-09 07:04:00	AAPL	Stock	47.26	47.26	47.2525	47.2525	6000.0
2018-07-09 07:05:00	AAPL	Stock	47.26	47.2625	47.26	47.2625	800.0
2018-07-09 07:06:00	AAPL	Stock	47.27	47.27	47.25	47.25	7360.0
2018-07-09 07:07:00	AAPL	Stock	47.275	47.275	47.275	47.275	4000.0
2018-07-09 07:12:00	AAPL	Stock	47.26	47.26	47.2575	47.2575	4000.0
2018-07-09 07:13:00	AAPL	Stock	47.2725	47.2725	47.2675	47.2675	3680.0
2018-07-09 07:15:00	AAPL	Stock	47.275	47.275	47.2675	47.2675	3688.0
2018-07-09 07:18:00	AAPL	Stock	47.285	47.285	47.27	47.27	800.0
2018-07-09 07:20:00	AAPL	Stock	47.2825	47.2825	47.2825	47.2825	400.0
2018-07-09 07:21:00	AAPL	Stock	47.265	47.265	47.24	47.24	26800.0
2018-07-09 07:22:00	AAPL	Stock	47.2375	47.2375	47.2375	47.2375	2000.0
2018-07-09 07:24:00	AAPL	Stock	47.24	47.24	47.24	47.24	4000.0
2018-07-09 07:25:00	AAPL	Stock	47.245	47.245	47.2375	47.2375	1712.0
2018-07-09 07:28:00	AAPL	Stock	47.24	47.24	47.2375	47.2375	4800.0
2018-07-09 07:29:00	AAPL	Stock	47.2375	47.2375	47.2375	47.2375	2000.0
2018-07-09 07:30:00	AAPL	Stock	47.225	47.225	47.225	47.225	4400.0
2018-07-09 07:31:00	AAPL	Stock	47.2375	47.2375	47.2375	47.2375	4000.0
2018-07-09 07:34:00	AAPL	Stock	47.225	47.225	47.225	47.225	1160.0
2018-07-09 07:35:00	AAPL	Stock	47.215	47.215	47.215	47.215	692.0
2018-07-09 07:38:00	AAPL	Stock	47.2375	47.2375	47.2375	47.2375	4560.0
2018-07-09 07:39:00	AAPL	Stock	47.25	47.25	47.25	47.25	400.0
2018-07-09 07:40:00	AAPL	Stock	47.25	47.25	47.25	47.25	532.0
2018-07-09 07:42:00	AAPL	Stock	47.27	47.275	47.27	47.275	7980.0
2018-07-09 07:45:00	AAPL	Stock	47.2525	47.285	47.2525	47.285	4252.0
2018-07-09 07:47:00	AAPL	Stock	47.2725	47.2775	47.2725	47.2775	800.0
2018-07-09 07:48:00	AAPL	Stock	47.28	47.28	47.28	47.28	648.0
2018-07-09 07:55:00	AAPL	Stock	47.275	47.275	47.2725	47.2725	2400.0
2018-07-09 07:56:00	AAPL	Stock	47.265	47.265	47.265	47.265	800.0
2018-07-09 07:58:00	AAPL	Stock	47.28	47.28	47.28	47.28	400.0
2018-07-09 07:59:00	AAPL	Stock	47.28	47.2875	47.28	47.2875	11868.0
2018-07-09 08:00:00	AAPL	Stock	47.2625	47.3	47.225	47.3	41656.0
2018-07-09 08:01:00	AAPL	Stock	47.2875	47.2875	47.28	47.28	3344.0
2018-07-09 08:02:00	AAPL	Stock	47.28	47.28	47.2775	47.2775	51944.0
2018-07-09 08:03:00	AAPL	Stock	47.28	47.3025	47.28	47.3025	48536.0
2018-07-09 08:04:00	AAPL	Stock	47.305	47.375	47.305	47.3725	35432.0
2018-07-09 08:05:00	AAPL	Stock	47.3625	47.365	47.3625	47.3625	20192.0

> showing 50 of 1,072,596 rows — these rows as CSV

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