PREVIEW / stock_1min / 2017-03-03

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-03-03.parquet
  size:    14.2 MB
  rows:    1,039,310
  symbols: 2,524

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
2017-03-03 05:57:00	AAPL	Stock	34.72	34.72	34.72	34.72	604.0
2017-03-03 06:17:00	AAPL	Stock	34.7175	34.745	34.7175	34.745	4000.0
2017-03-03 06:32:00	AAPL	Stock	34.7225	34.7225	34.7225	34.7225	400.0
2017-03-03 06:41:00	AAPL	Stock	34.7225	34.7225	34.7225	34.7225	800.0
2017-03-03 06:50:00	AAPL	Stock	34.7225	34.7225	34.7225	34.7225	400.0
2017-03-03 06:57:00	AAPL	Stock	34.7125	34.7125	34.7125	34.7125	584.0
2017-03-03 07:00:00	AAPL	Stock	34.7125	34.7125	34.7125	34.7125	2000.0
2017-03-03 07:05:00	AAPL	Stock	34.7	34.7	34.7	34.7	800.0
2017-03-03 07:09:00	AAPL	Stock	34.7125	34.7125	34.7125	34.7125	2400.0
2017-03-03 07:12:00	AAPL	Stock	34.725	34.725	34.725	34.725	1200.0
2017-03-03 07:13:00	AAPL	Stock	34.725	34.725	34.725	34.725	2400.0
2017-03-03 07:17:00	AAPL	Stock	34.7125	34.7125	34.7125	34.7125	2000.0
2017-03-03 07:35:00	AAPL	Stock	34.705	34.705	34.7025	34.7025	1200.0
2017-03-03 07:36:00	AAPL	Stock	34.7025	34.7025	34.7025	34.7025	596.0
2017-03-03 07:41:00	AAPL	Stock	34.6875	34.69	34.6875	34.69	2000.0
2017-03-03 07:42:00	AAPL	Stock	34.68	34.68	34.6775	34.6775	8200.0
2017-03-03 07:46:00	AAPL	Stock	34.675	34.675	34.655	34.655	4400.0
2017-03-03 07:47:00	AAPL	Stock	34.655	34.6625	34.655	34.655	5200.0
2017-03-03 07:49:00	AAPL	Stock	34.655	34.655	34.65	34.65	3220.0
2017-03-03 07:50:00	AAPL	Stock	34.65	34.65	34.6375	34.6375	4548.0
2017-03-03 07:51:00	AAPL	Stock	34.655	34.655	34.655	34.655	1956.0
2017-03-03 07:52:00	AAPL	Stock	34.64	34.64	34.64	34.64	1552.0
2017-03-03 07:53:00	AAPL	Stock	34.655	34.655	34.655	34.655	1600.0
2017-03-03 07:55:00	AAPL	Stock	34.655	34.655	34.655	34.655	800.0
2017-03-03 07:56:00	AAPL	Stock	34.655	34.6575	34.655	34.6575	2800.0
2017-03-03 07:57:00	AAPL	Stock	34.655	34.655	34.655	34.655	2400.0
2017-03-03 07:58:00	AAPL	Stock	34.655	34.6575	34.655	34.6575	3360.0
2017-03-03 08:00:00	AAPL	Stock	34.725	34.7375	34.655	34.6575	22760.0
2017-03-03 08:01:00	AAPL	Stock	34.6525	34.6575	34.65	34.6575	4800.0
2017-03-03 08:02:00	AAPL	Stock	34.6575	34.6575	34.6575	34.6575	6000.0
2017-03-03 08:03:00	AAPL	Stock	34.6575	34.6575	34.6575	34.6575	2000.0
2017-03-03 08:04:00	AAPL	Stock	34.6575	34.6575	34.6575	34.6575	900.0
2017-03-03 08:05:00	AAPL	Stock	34.6575	34.6575	34.6525	34.6525	1280.0
2017-03-03 08:06:00	AAPL	Stock	34.6525	34.6525	34.6525	34.6525	4000.0
2017-03-03 08:07:00	AAPL	Stock	34.6575	34.6575	34.655	34.655	3600.0
2017-03-03 08:08:00	AAPL	Stock	34.655	34.6575	34.655	34.6575	2580.0
2017-03-03 08:10:00	AAPL	Stock	34.6625	34.6625	34.6625	34.6625	2000.0
2017-03-03 08:14:00	AAPL	Stock	34.67	34.67	34.655	34.655	7112.0
2017-03-03 08:15:00	AAPL	Stock	34.6575	34.6575	34.6575	34.6575	3200.0
2017-03-03 08:16:00	AAPL	Stock	34.6575	34.6575	34.6575	34.6575	2800.0
2017-03-03 08:17:00	AAPL	Stock	34.6625	34.67	34.6625	34.67	4400.0
2017-03-03 08:20:00	AAPL	Stock	34.67	34.67	34.6675	34.6675	800.0
2017-03-03 08:22:00	AAPL	Stock	34.67	34.67	34.67	34.67	1200.0
2017-03-03 08:24:00	AAPL	Stock	34.67	34.67	34.67	34.67	3200.0
2017-03-03 08:25:00	AAPL	Stock	34.6725	34.6725	34.6725	34.6725	5948.0
2017-03-03 08:26:00	AAPL	Stock	34.6675	34.6675	34.6675	34.6675	1884.0
2017-03-03 08:28:00	AAPL	Stock	34.665	34.665	34.665	34.665	564.0
2017-03-03 08:29:00	AAPL	Stock	34.67	34.67	34.67	34.67	1200.0
2017-03-03 08:30:00	AAPL	Stock	34.665	34.665	34.665	34.665	400.0
2017-03-03 08:31:00	AAPL	Stock	34.6725	34.6725	34.6725	34.6725	3680.0

> showing 50 of 1,039,310 rows — these rows as CSV

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