PREVIEW / stock_1min / 2017-04-11

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-04-11.parquet
  size:    14.4 MB
  rows:    1,059,879
  symbols: 2,532

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-04-11 05:48:00	AAPL	Stock	35.725	35.725	35.705	35.705	2060.0
2017-04-11 05:50:00	AAPL	Stock	35.7025	35.7175	35.7025	35.7175	800.0
2017-04-11 05:51:00	AAPL	Stock	35.7175	35.7175	35.7175	35.7175	480.0
2017-04-11 05:53:00	AAPL	Stock	35.725	35.725	35.725	35.725	800.0
2017-04-11 05:54:00	AAPL	Stock	35.725	35.725	35.725	35.725	800.0
2017-04-11 05:56:00	AAPL	Stock	35.725	35.725	35.725	35.725	2000.0
2017-04-11 05:58:00	AAPL	Stock	35.725	35.725	35.725	35.725	800.0
2017-04-11 05:59:00	AAPL	Stock	35.725	35.725	35.725	35.725	3200.0
2017-04-11 06:11:00	AAPL	Stock	35.75	35.75	35.75	35.75	1200.0
2017-04-11 06:39:00	AAPL	Stock	35.7625	35.7625	35.7625	35.7625	800.0
2017-04-11 06:40:00	AAPL	Stock	35.75	35.75	35.75	35.75	1600.0
2017-04-11 06:54:00	AAPL	Stock	35.775	35.775	35.775	35.775	800.0
2017-04-11 06:56:00	AAPL	Stock	35.775	35.775	35.775	35.775	448.0
2017-04-11 06:58:00	AAPL	Stock	35.7525	35.7525	35.7525	35.7525	400.0
2017-04-11 07:01:00	AAPL	Stock	35.775	35.775	35.775	35.775	1200.0
2017-04-11 07:02:00	AAPL	Stock	35.775	35.775	35.775	35.775	400.0
2017-04-11 07:07:00	AAPL	Stock	35.775	35.775	35.775	35.775	400.0
2017-04-11 07:09:00	AAPL	Stock	35.775	35.775	35.775	35.775	1920.0
2017-04-11 07:13:00	AAPL	Stock	35.775	35.775	35.775	35.775	400.0
2017-04-11 07:14:00	AAPL	Stock	35.775	35.775	35.775	35.775	1800.0
2017-04-11 07:15:00	AAPL	Stock	35.775	35.775	35.775	35.775	400.0
2017-04-11 07:16:00	AAPL	Stock	35.775	35.775	35.775	35.775	800.0
2017-04-11 07:18:00	AAPL	Stock	35.775	35.775	35.755	35.775	1200.0
2017-04-11 07:19:00	AAPL	Stock	35.775	35.775	35.775	35.775	800.0
2017-04-11 07:22:00	AAPL	Stock	35.775	35.775	35.775	35.775	800.0
2017-04-11 07:23:00	AAPL	Stock	35.775	35.775	35.775	35.775	400.0
2017-04-11 07:30:00	AAPL	Stock	35.775	35.775	35.775	35.775	400.0
2017-04-11 07:39:00	AAPL	Stock	35.7725	35.7725	35.7725	35.7725	412.0
2017-04-11 07:40:00	AAPL	Stock	35.7725	35.7725	35.7725	35.7725	4752.0
2017-04-11 07:42:00	AAPL	Stock	35.775	35.775	35.775	35.775	800.0
2017-04-11 07:43:00	AAPL	Stock	35.775	35.775	35.775	35.775	4400.0
2017-04-11 07:55:00	AAPL	Stock	35.775	35.775	35.775	35.775	400.0
2017-04-11 07:56:00	AAPL	Stock	35.775	35.775	35.775	35.775	400.0
2017-04-11 07:59:00	AAPL	Stock	35.775	35.775	35.775	35.775	1600.0
2017-04-11 08:00:00	AAPL	Stock	35.775	35.785	35.7575	35.7725	18620.0
2017-04-11 08:01:00	AAPL	Stock	35.775	35.775	35.775	35.775	4000.0
2017-04-11 08:03:00	AAPL	Stock	35.775	35.78	35.775	35.78	800.0
2017-04-11 08:05:00	AAPL	Stock	35.7875	35.7875	35.7875	35.7875	800.0
2017-04-11 08:06:00	AAPL	Stock	35.8075	35.8075	35.8075	35.8075	1292.0
2017-04-11 08:07:00	AAPL	Stock	35.7975	35.8	35.7875	35.7875	4400.0
2017-04-11 08:08:00	AAPL	Stock	35.8	35.8	35.8	35.8	3200.0
2017-04-11 08:09:00	AAPL	Stock	35.81	35.81	35.79	35.79	1796.0
2017-04-11 08:10:00	AAPL	Stock	35.81	35.81	35.81	35.81	400.0
2017-04-11 08:12:00	AAPL	Stock	35.7925	35.7925	35.7925	35.7925	400.0
2017-04-11 08:18:00	AAPL	Stock	35.78	35.78	35.78	35.78	1140.0
2017-04-11 08:23:00	AAPL	Stock	35.78	35.78	35.765	35.765	10396.0
2017-04-11 08:25:00	AAPL	Stock	35.7675	35.775	35.7675	35.775	2800.0
2017-04-11 08:28:00	AAPL	Stock	35.77	35.77	35.765	35.7675	4080.0
2017-04-11 08:29:00	AAPL	Stock	35.7525	35.755	35.75	35.75	10912.0
2017-04-11 08:32:00	AAPL	Stock	35.7525	35.7525	35.7525	35.7525	1200.0

> showing 50 of 1,059,879 rows — these rows as CSV

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