PREVIEW / stock_1min / 2016-04-01

all stock 1-min files

  file:    by_date/stock_1min/2016/2016-04-01.parquet
  size:    14.6 MB
  rows:    1,067,676
  symbols: 2,737

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
2016-04-01 04:00:00	AAPL	Stock	27.1725	27.1725	27.1725	27.1725	400.0
2016-04-01 04:03:00	AAPL	Stock	27.105	27.105	27.1	27.1	800.0
2016-04-01 04:11:00	AAPL	Stock	27.1	27.1	27.1	27.1	4000.0
2016-04-01 04:14:00	AAPL	Stock	27.125	27.125	27.125	27.125	1200.0
2016-04-01 04:34:00	AAPL	Stock	27.1125	27.1125	27.1125	27.1125	800.0
2016-04-01 04:36:00	AAPL	Stock	27.125	27.125	27.125	27.125	2800.0
2016-04-01 04:53:00	AAPL	Stock	27.15	27.15	27.15	27.15	400.0
2016-04-01 05:56:00	AAPL	Stock	27.1375	27.1375	27.1375	27.1375	428.0
2016-04-01 06:34:00	AAPL	Stock	27.1175	27.1175	27.1175	27.1175	7000.0
2016-04-01 06:36:00	AAPL	Stock	27.1125	27.1125	27.1125	27.1125	800.0
2016-04-01 06:44:00	AAPL	Stock	27.12	27.12	27.12	27.12	1600.0
2016-04-01 06:55:00	AAPL	Stock	27.1125	27.1125	27.1125	27.1125	436.0
2016-04-01 06:57:00	AAPL	Stock	27.1125	27.1125	27.1125	27.1125	1884.0
2016-04-01 07:09:00	AAPL	Stock	27.13	27.13	27.13	27.13	8000.0
2016-04-01 07:17:00	AAPL	Stock	27.15	27.15	27.15	27.15	3600.0
2016-04-01 07:19:00	AAPL	Stock	27.15	27.15	27.15	27.15	800.0
2016-04-01 07:20:00	AAPL	Stock	27.15	27.15	27.15	27.15	1720.0
2016-04-01 07:21:00	AAPL	Stock	27.1625	27.1625	27.1625	27.1625	800.0
2016-04-01 07:23:00	AAPL	Stock	27.1625	27.1825	27.1625	27.1825	2000.0
2016-04-01 07:29:00	AAPL	Stock	27.1875	27.1925	27.1875	27.1925	18000.0
2016-04-01 07:34:00	AAPL	Stock	27.17	27.17	27.17	27.17	400.0
2016-04-01 07:44:00	AAPL	Stock	27.19	27.19	27.165	27.165	5180.0
2016-04-01 07:45:00	AAPL	Stock	27.165	27.165	27.165	27.165	5692.0
2016-04-01 07:46:00	AAPL	Stock	27.175	27.175	27.175	27.175	400.0
2016-04-01 07:52:00	AAPL	Stock	27.16	27.1625	27.1575	27.1625	3280.0
2016-04-01 07:53:00	AAPL	Stock	27.1625	27.1625	27.16	27.16	2800.0
2016-04-01 08:00:00	AAPL	Stock	27.1725	27.1875	27.1125	27.1875	18832.0
2016-04-01 08:01:00	AAPL	Stock	27.165	27.165	27.1625	27.1625	6120.0
2016-04-01 08:02:00	AAPL	Stock	27.1825	27.25	27.1825	27.24	77992.0
2016-04-01 08:03:00	AAPL	Stock	27.24	27.24	27.2125	27.2125	142964.0
2016-04-01 08:05:00	AAPL	Stock	27.23	27.23	27.2275	27.2275	2400.0
2016-04-01 08:06:00	AAPL	Stock	27.225	27.225	27.225	27.225	400.0
2016-04-01 08:07:00	AAPL	Stock	27.2375	27.2375	27.2175	27.2175	7220.0
2016-04-01 08:08:00	AAPL	Stock	27.2175	27.2175	27.2125	27.2125	1600.0
2016-04-01 08:09:00	AAPL	Stock	27.2125	27.2125	27.2	27.2125	8400.0
2016-04-01 08:12:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	6000.0
2016-04-01 08:13:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	8000.0
2016-04-01 08:16:00	AAPL	Stock	27.23	27.23	27.23	27.23	400.0
2016-04-01 08:18:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	5200.0
2016-04-01 08:19:00	AAPL	Stock	27.2275	27.235	27.2275	27.23	6204.0
2016-04-01 08:22:00	AAPL	Stock	27.225	27.235	27.215	27.2325	10432.0
2016-04-01 08:23:00	AAPL	Stock	27.235	27.25	27.2075	27.2175	21376.0
2016-04-01 08:24:00	AAPL	Stock	27.225	27.2475	27.225	27.2475	2400.0
2016-04-01 08:25:00	AAPL	Stock	27.2275	27.2275	27.2275	27.2275	400.0
2016-04-01 08:28:00	AAPL	Stock	27.2475	27.25	27.2475	27.25	800.0
2016-04-01 08:29:00	AAPL	Stock	27.25	27.25	27.225	27.225	2400.0
2016-04-01 08:30:00	AAPL	Stock	27.225	27.275	27.225	27.275	3200.0
2016-04-01 08:31:00	AAPL	Stock	27.24	27.2875	27.2375	27.2625	24740.0
2016-04-01 08:32:00	AAPL	Stock	27.275	27.275	27.275	27.275	2400.0
2016-04-01 08:33:00	AAPL	Stock	27.2675	27.2675	27.2625	27.2625	19400.0

> showing 50 of 1,067,676 rows — these rows as CSV

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