PREVIEW / stock_1min / 2016-08-01

all stock 1-min files

  file:    by_date/stock_1min/2016/2016-08-01.parquet
  size:    14.9 MB
  rows:    1,076,471
  symbols: 2,680

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-08-01 04:00:00	AAPL	Stock	26.1	26.1	26.1	26.1	2000.0
2016-08-01 04:01:00	AAPL	Stock	26.125	26.125	26.125	26.125	800.0
2016-08-01 04:53:00	AAPL	Stock	26.13	26.13	26.13	26.13	3920.0
2016-08-01 05:39:00	AAPL	Stock	26.1325	26.1325	26.1325	26.1325	400.0
2016-08-01 05:48:00	AAPL	Stock	26.155	26.155	26.155	26.155	400.0
2016-08-01 05:50:00	AAPL	Stock	26.155	26.155	26.1475	26.1475	4120.0
2016-08-01 06:01:00	AAPL	Stock	26.1475	26.1475	26.1475	26.1475	11280.0
2016-08-01 06:13:00	AAPL	Stock	26.13	26.13	26.13	26.13	1600.0
2016-08-01 06:26:00	AAPL	Stock	26.125	26.125	26.125	26.125	800.0
2016-08-01 06:31:00	AAPL	Stock	26.1375	26.1375	26.1375	26.1375	3600.0
2016-08-01 06:36:00	AAPL	Stock	26.1425	26.1425	26.125	26.125	2800.0
2016-08-01 06:39:00	AAPL	Stock	26.125	26.125	26.125	26.125	10800.0
2016-08-01 06:48:00	AAPL	Stock	26.125	26.125	26.125	26.125	2104.0
2016-08-01 06:55:00	AAPL	Stock	26.125	26.125	26.125	26.125	664.0
2016-08-01 06:56:00	AAPL	Stock	26.125	26.125	26.125	26.125	1200.0
2016-08-01 07:01:00	AAPL	Stock	26.125	26.125	26.125	26.125	800.0
2016-08-01 07:02:00	AAPL	Stock	26.125	26.15	26.125	26.15	6000.0
2016-08-01 07:03:00	AAPL	Stock	26.15	26.15	26.1375	26.15	8400.0
2016-08-01 07:04:00	AAPL	Stock	26.15	26.15	26.15	26.15	400.0
2016-08-01 07:06:00	AAPL	Stock	26.16	26.1625	26.1575	26.1575	4000.0
2016-08-01 07:08:00	AAPL	Stock	26.1625	26.1625	26.1625	26.1625	15200.0
2016-08-01 07:10:00	AAPL	Stock	26.1625	26.1725	26.1625	26.1725	4800.0
2016-08-01 07:15:00	AAPL	Stock	26.1575	26.1575	26.1575	26.1575	400.0
2016-08-01 07:17:00	AAPL	Stock	26.1525	26.1525	26.1525	26.1525	2000.0
2016-08-01 07:24:00	AAPL	Stock	26.15	26.1575	26.15	26.1525	7320.0
2016-08-01 07:25:00	AAPL	Stock	26.15	26.15	26.15	26.15	8800.0
2016-08-01 07:31:00	AAPL	Stock	26.155	26.1725	26.155	26.1725	7680.0
2016-08-01 07:33:00	AAPL	Stock	26.1725	26.245	26.1725	26.225	11448.0
2016-08-01 08:00:00	AAPL	Stock	26.1625	26.1875	26.1275	26.175	65804.0
2016-08-01 08:01:00	AAPL	Stock	26.1775	26.1875	26.1775	26.1875	17220.0
2016-08-01 08:02:00	AAPL	Stock	26.1875	26.2125	26.1875	26.2125	14344.0
2016-08-01 08:03:00	AAPL	Stock	26.22	26.2225	26.22	26.2225	9624.0
2016-08-01 08:04:00	AAPL	Stock	26.2175	26.2175	26.2175	26.2175	19176.0
2016-08-01 08:05:00	AAPL	Stock	26.2175	26.2225	26.2175	26.2225	6400.0
2016-08-01 08:06:00	AAPL	Stock	26.2175	26.2225	26.2175	26.2225	13980.0
2016-08-01 08:07:00	AAPL	Stock	26.2175	26.2175	26.2175	26.2175	1600.0
2016-08-01 08:08:00	AAPL	Stock	26.2125	26.2125	26.2125	26.2125	10000.0
2016-08-01 08:09:00	AAPL	Stock	26.2125	26.2125	26.2125	26.2125	27772.0
2016-08-01 08:10:00	AAPL	Stock	26.2	26.2	26.1875	26.1875	3440.0
2016-08-01 08:11:00	AAPL	Stock	26.1925	26.1925	26.1875	26.1875	2400.0
2016-08-01 08:12:00	AAPL	Stock	26.2	26.2	26.1875	26.1875	8400.0
2016-08-01 08:15:00	AAPL	Stock	26.2	26.2	26.1925	26.1925	10120.0
2016-08-01 08:16:00	AAPL	Stock	26.2	26.2075	26.2	26.2075	5200.0
2016-08-01 08:18:00	AAPL	Stock	26.2	26.2	26.18	26.19	11600.0
2016-08-01 08:21:00	AAPL	Stock	26.1775	26.1775	26.175	26.175	1600.0
2016-08-01 08:23:00	AAPL	Stock	26.1975	26.1975	26.1975	26.1975	4000.0
2016-08-01 08:25:00	AAPL	Stock	26.1975	26.1975	26.1975	26.1975	800.0
2016-08-01 08:26:00	AAPL	Stock	26.195	26.195	26.195	26.195	1600.0
2016-08-01 08:27:00	AAPL	Stock	26.19	26.2	26.19	26.2	16620.0
2016-08-01 08:28:00	AAPL	Stock	26.2	26.2025	26.195	26.195	5200.0

> showing 50 of 1,076,471 rows — these rows as CSV

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