PREVIEW / stock_1min / 2017-07-06

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-06.parquet
  size:    14.0 MB
  rows:    1,036,979
  symbols: 2,483

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-07-06 05:28:00	AAPL	Stock	35.895	35.895	35.8875	35.8875	4400.0
2017-07-06 05:42:00	AAPL	Stock	35.855	35.855	35.7625	35.7625	6396.0
2017-07-06 05:44:00	AAPL	Stock	35.825	35.825	35.825	35.825	2400.0
2017-07-06 05:48:00	AAPL	Stock	35.7875	35.7875	35.7875	35.7875	1800.0
2017-07-06 05:49:00	AAPL	Stock	35.825	35.825	35.825	35.825	400.0
2017-07-06 05:54:00	AAPL	Stock	35.8	35.8	35.8	35.8	1600.0
2017-07-06 06:06:00	AAPL	Stock	35.7925	35.7925	35.7925	35.7925	640.0
2017-07-06 06:09:00	AAPL	Stock	35.7925	35.7925	35.7925	35.7925	1948.0
2017-07-06 06:10:00	AAPL	Stock	35.7575	35.7575	35.7575	35.7575	1424.0
2017-07-06 06:15:00	AAPL	Stock	35.76	35.76	35.76	35.76	2000.0
2017-07-06 06:34:00	AAPL	Stock	35.79	35.79	35.79	35.79	400.0
2017-07-06 06:45:00	AAPL	Stock	35.7775	35.7775	35.775	35.775	2000.0
2017-07-06 06:50:00	AAPL	Stock	35.785	35.79	35.785	35.79	2368.0
2017-07-06 06:55:00	AAPL	Stock	35.8025	35.8025	35.8025	35.8025	400.0
2017-07-06 06:59:00	AAPL	Stock	35.81	35.81	35.81	35.81	1996.0
2017-07-06 07:02:00	AAPL	Stock	35.81	35.81	35.81	35.81	1600.0
2017-07-06 07:03:00	AAPL	Stock	35.8	35.8	35.8	35.8	1596.0
2017-07-06 07:06:00	AAPL	Stock	35.8	35.8	35.8	35.8	1000.0
2017-07-06 07:07:00	AAPL	Stock	35.8	35.8	35.8	35.8	2576.0
2017-07-06 07:13:00	AAPL	Stock	35.7925	35.7925	35.7925	35.7925	3760.0
2017-07-06 07:19:00	AAPL	Stock	35.7925	35.7925	35.7925	35.7925	600.0
2017-07-06 07:26:00	AAPL	Stock	35.8	35.8	35.8	35.8	976.0
2017-07-06 07:27:00	AAPL	Stock	35.81	35.81	35.81	35.81	1408.0
2017-07-06 07:31:00	AAPL	Stock	35.795	35.795	35.795	35.795	400.0
2017-07-06 07:33:00	AAPL	Stock	35.795	35.795	35.78	35.78	13536.0
2017-07-06 07:38:00	AAPL	Stock	35.775	35.7775	35.775	35.7775	800.0
2017-07-06 07:39:00	AAPL	Stock	35.7925	35.7925	35.7925	35.7925	11224.0
2017-07-06 07:42:00	AAPL	Stock	35.8025	35.8025	35.8025	35.8025	800.0
2017-07-06 07:44:00	AAPL	Stock	35.7925	35.7925	35.7725	35.7725	16088.0
2017-07-06 07:46:00	AAPL	Stock	35.775	35.775	35.7625	35.7625	2000.0
2017-07-06 07:47:00	AAPL	Stock	35.75	35.75	35.745	35.745	1200.0
2017-07-06 07:50:00	AAPL	Stock	35.7275	35.7275	35.7175	35.725	2576.0
2017-07-06 07:52:00	AAPL	Stock	35.725	35.725	35.7	35.7	2800.0
2017-07-06 07:54:00	AAPL	Stock	35.7225	35.725	35.72	35.725	6296.0
2017-07-06 07:55:00	AAPL	Stock	35.725	35.725	35.7125	35.7125	9404.0
2017-07-06 07:56:00	AAPL	Stock	35.7125	35.715	35.7	35.7	10600.0
2017-07-06 07:57:00	AAPL	Stock	35.7125	35.715	35.7125	35.715	8400.0
2017-07-06 07:58:00	AAPL	Stock	35.715	35.715	35.71	35.715	9516.0
2017-07-06 07:59:00	AAPL	Stock	35.7175	35.7175	35.7175	35.7175	1200.0
2017-07-06 08:00:00	AAPL	Stock	35.7475	35.775	35.7	35.725	29036.0
2017-07-06 08:01:00	AAPL	Stock	35.7475	35.7475	35.7475	35.7475	3200.0
2017-07-06 08:02:00	AAPL	Stock	35.75	35.75	35.735	35.745	7120.0
2017-07-06 08:03:00	AAPL	Stock	35.74	35.75	35.7375	35.7375	2936.0
2017-07-06 08:04:00	AAPL	Stock	35.7475	35.7525	35.7475	35.75	11600.0
2017-07-06 08:05:00	AAPL	Stock	35.7675	35.775	35.755	35.7675	14040.0
2017-07-06 08:06:00	AAPL	Stock	35.7625	35.775	35.7525	35.775	8500.0
2017-07-06 08:07:00	AAPL	Stock	35.775	35.775	35.775	35.775	800.0
2017-07-06 08:08:00	AAPL	Stock	35.7725	35.7725	35.7625	35.7625	7284.0
2017-07-06 08:09:00	AAPL	Stock	35.7725	35.775	35.755	35.755	9772.0
2017-07-06 08:10:00	AAPL	Stock	35.755	35.7625	35.755	35.7625	2800.0

> showing 50 of 1,036,979 rows — these rows as CSV

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