PREVIEW / stock_1min / 2018-07-13

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-13.parquet
  size:    14.0 MB
  rows:    1,009,191
  symbols: 2,326

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-07-13 04:30:00	AAPL	Stock	47.8	47.8	47.8	47.8	660.0
2018-07-13 05:13:00	AAPL	Stock	47.875	47.875	47.875	47.875	2240.0
2018-07-13 05:32:00	AAPL	Stock	47.7575	47.7575	47.7575	47.7575	400.0
2018-07-13 05:45:00	AAPL	Stock	47.7125	47.7125	47.7125	47.7125	848.0
2018-07-13 06:42:00	AAPL	Stock	47.75	47.75	47.75	47.75	1600.0
2018-07-13 06:52:00	AAPL	Stock	47.785	47.785	47.785	47.785	3944.0
2018-07-13 06:53:00	AAPL	Stock	47.7875	47.7875	47.7875	47.7875	3600.0
2018-07-13 07:00:00	AAPL	Stock	47.8	47.8	47.8	47.8	400.0
2018-07-13 07:02:00	AAPL	Stock	47.82	47.82	47.82	47.82	3200.0
2018-07-13 07:04:00	AAPL	Stock	47.825	47.845	47.825	47.845	20040.0
2018-07-13 07:06:00	AAPL	Stock	47.8525	47.8525	47.8525	47.8525	756.0
2018-07-13 07:08:00	AAPL	Stock	47.8525	47.8525	47.8525	47.8525	3436.0
2018-07-13 07:09:00	AAPL	Stock	47.87	47.87	47.87	47.87	8000.0
2018-07-13 07:17:00	AAPL	Stock	47.805	47.8175	47.8	47.8	7460.0
2018-07-13 07:18:00	AAPL	Stock	47.78	47.78	47.775	47.775	1600.0
2018-07-13 07:19:00	AAPL	Stock	47.82	47.82	47.82	47.82	400.0
2018-07-13 07:20:00	AAPL	Stock	47.82	47.82	47.82	47.82	800.0
2018-07-13 07:26:00	AAPL	Stock	47.775	47.775	47.775	47.775	1208.0
2018-07-13 07:27:00	AAPL	Stock	47.765	47.765	47.75	47.75	19100.0
2018-07-13 07:31:00	AAPL	Stock	47.75	47.75	47.75	47.75	1940.0
2018-07-13 07:39:00	AAPL	Stock	47.725	47.725	47.72	47.72	1400.0
2018-07-13 07:40:00	AAPL	Stock	47.72	47.72	47.7175	47.7175	11200.0
2018-07-13 07:43:00	AAPL	Stock	47.72	47.72	47.72	47.72	1200.0
2018-07-13 07:45:00	AAPL	Stock	47.72	47.72	47.72	47.72	5200.0
2018-07-13 07:46:00	AAPL	Stock	47.72	47.72	47.72	47.72	800.0
2018-07-13 07:47:00	AAPL	Stock	47.72	47.72	47.72	47.72	3200.0
2018-07-13 07:59:00	AAPL	Stock	47.775	47.7825	47.775	47.7825	6664.0
2018-07-13 08:00:00	AAPL	Stock	47.8525	47.8525	47.72	47.845	50072.0
2018-07-13 08:01:00	AAPL	Stock	47.845	47.85	47.845	47.85	4400.0
2018-07-13 08:02:00	AAPL	Stock	47.825	47.825	47.825	47.825	1200.0
2018-07-13 08:03:00	AAPL	Stock	47.825	47.825	47.825	47.825	11364.0
2018-07-13 08:04:00	AAPL	Stock	47.8125	47.8125	47.8125	47.8125	7396.0
2018-07-13 08:06:00	AAPL	Stock	47.7575	47.7625	47.7575	47.7625	3216.0
2018-07-13 08:08:00	AAPL	Stock	47.7575	47.7575	47.7575	47.7575	5780.0
2018-07-13 08:12:00	AAPL	Stock	47.7575	47.7575	47.7575	47.7575	400.0
2018-07-13 08:13:00	AAPL	Stock	47.7525	47.7525	47.7525	47.7525	516.0
2018-07-13 08:15:00	AAPL	Stock	47.7575	47.7575	47.7575	47.7575	2400.0
2018-07-13 08:16:00	AAPL	Stock	47.7575	47.7575	47.7575	47.7575	22800.0
2018-07-13 08:18:00	AAPL	Stock	47.755	47.7575	47.755	47.7575	4004.0
2018-07-13 08:19:00	AAPL	Stock	47.7575	47.7575	47.7575	47.7575	13176.0
2018-07-13 08:22:00	AAPL	Stock	47.7525	47.7575	47.745	47.7575	7160.0
2018-07-13 08:24:00	AAPL	Stock	47.7575	47.7575	47.7575	47.7575	400.0
2018-07-13 08:27:00	AAPL	Stock	47.75	47.75	47.75	47.75	800.0
2018-07-13 08:29:00	AAPL	Stock	47.7475	47.75	47.7475	47.75	6000.0
2018-07-13 08:31:00	AAPL	Stock	47.735	47.735	47.735	47.735	1680.0
2018-07-13 08:32:00	AAPL	Stock	47.7475	47.7475	47.7475	47.7475	400.0
2018-07-13 08:33:00	AAPL	Stock	47.75	47.75	47.74	47.74	12800.0
2018-07-13 08:36:00	AAPL	Stock	47.7375	47.7375	47.7275	47.735	7352.0
2018-07-13 08:37:00	AAPL	Stock	47.735	47.735	47.735	47.735	1600.0
2018-07-13 08:38:00	AAPL	Stock	47.735	47.735	47.735	47.735	800.0

> showing 50 of 1,009,191 rows — these rows as CSV

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