PREVIEW / stock_1min / 2018-03-21

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-03-21.parquet
  size:    14.7 MB
  rows:    1,062,325
  symbols: 2,387

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-03-21 05:16:00	AAPL	Stock	43.75	43.75	43.75	43.75	1944.0
2018-03-21 06:01:00	AAPL	Stock	43.7475	43.7475	43.7475	43.7475	856.0
2018-03-21 06:57:00	AAPL	Stock	43.8075	43.8075	43.8075	43.8075	2000.0
2018-03-21 06:58:00	AAPL	Stock	43.8075	43.8075	43.8075	43.8075	3660.0
2018-03-21 07:00:00	AAPL	Stock	43.8075	43.81	43.8075	43.81	4300.0
2018-03-21 07:01:00	AAPL	Stock	43.8	43.8	43.8	43.8	1300.0
2018-03-21 07:02:00	AAPL	Stock	43.8	43.8	43.8	43.8	1980.0
2018-03-21 07:06:00	AAPL	Stock	43.8125	43.8125	43.8125	43.8125	7964.0
2018-03-21 07:08:00	AAPL	Stock	43.86	43.86	43.825	43.825	20596.0
2018-03-21 07:23:00	AAPL	Stock	43.85	43.85	43.85	43.85	1600.0
2018-03-21 07:26:00	AAPL	Stock	43.855	43.855	43.85	43.85	2000.0
2018-03-21 07:27:00	AAPL	Stock	43.8625	43.8625	43.8625	43.8625	400.0
2018-03-21 07:28:00	AAPL	Stock	43.8725	43.8725	43.8725	43.8725	772.0
2018-03-21 07:32:00	AAPL	Stock	43.8625	43.8625	43.8625	43.8625	12000.0
2018-03-21 07:34:00	AAPL	Stock	43.865	43.865	43.865	43.865	1200.0
2018-03-21 07:37:00	AAPL	Stock	43.865	43.865	43.865	43.865	1000.0
2018-03-21 07:39:00	AAPL	Stock	43.855	43.855	43.855	43.855	4000.0
2018-03-21 07:41:00	AAPL	Stock	43.85	43.85	43.85	43.85	400.0
2018-03-21 07:43:00	AAPL	Stock	43.8375	43.8375	43.7475	43.7475	24460.0
2018-03-21 07:44:00	AAPL	Stock	43.75	43.75	43.665	43.745	30560.0
2018-03-21 07:45:00	AAPL	Stock	43.7075	43.7125	43.6375	43.6725	21180.0
2018-03-21 07:47:00	AAPL	Stock	43.7	43.725	43.6775	43.725	7036.0
2018-03-21 07:52:00	AAPL	Stock	43.7125	43.7125	43.7075	43.7075	20744.0
2018-03-21 07:53:00	AAPL	Stock	43.7125	43.7125	43.7125	43.7125	1200.0
2018-03-21 07:54:00	AAPL	Stock	43.7575	43.7725	43.7575	43.7725	19948.0
2018-03-21 07:58:00	AAPL	Stock	43.725	43.725	43.725	43.725	2296.0
2018-03-21 08:00:00	AAPL	Stock	43.7125	43.8775	43.7125	43.75	37308.0
2018-03-21 08:03:00	AAPL	Stock	43.7525	43.7525	43.7525	43.7525	1600.0
2018-03-21 08:04:00	AAPL	Stock	43.7625	43.7625	43.7625	43.7625	3800.0
2018-03-21 08:07:00	AAPL	Stock	43.75	43.75	43.725	43.725	6400.0
2018-03-21 08:08:00	AAPL	Stock	43.725	43.725	43.7225	43.7225	4388.0
2018-03-21 08:09:00	AAPL	Stock	43.725	43.725	43.7225	43.7225	2000.0
2018-03-21 08:11:00	AAPL	Stock	43.7225	43.7225	43.7225	43.7225	800.0
2018-03-21 08:17:00	AAPL	Stock	43.75	43.75	43.75	43.75	800.0
2018-03-21 08:18:00	AAPL	Stock	43.7525	43.7525	43.7525	43.7525	2032.0
2018-03-21 08:20:00	AAPL	Stock	43.75	43.75	43.75	43.75	9892.0
2018-03-21 08:25:00	AAPL	Stock	43.7625	43.7625	43.7625	43.7625	1600.0
2018-03-21 08:26:00	AAPL	Stock	43.7625	43.7625	43.7625	43.7625	400.0
2018-03-21 08:28:00	AAPL	Stock	43.7725	43.775	43.7725	43.775	22296.0
2018-03-21 08:33:00	AAPL	Stock	43.7925	43.7925	43.7925	43.7925	916.0
2018-03-21 08:34:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	800.0
2018-03-21 08:37:00	AAPL	Stock	43.765	43.7675	43.7625	43.7675	2000.0
2018-03-21 08:44:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	616.0
2018-03-21 08:45:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	4000.0
2018-03-21 08:48:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	800.0
2018-03-21 08:49:00	AAPL	Stock	43.7875	43.7875	43.785	43.7875	4088.0
2018-03-21 08:53:00	AAPL	Stock	43.785	43.7875	43.785	43.7875	3424.0
2018-03-21 08:59:00	AAPL	Stock	43.81	43.81	43.81	43.81	800.0
2018-03-21 09:00:00	AAPL	Stock	43.81	43.81	43.81	43.81	780.0
2018-03-21 09:01:00	AAPL	Stock	43.8125	43.8125	43.7875	43.7875	800.0

> showing 50 of 1,062,325 rows — these rows as CSV

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