PREVIEW / stock_1min / 2017-11-17

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-11-17.parquet
  size:    14.8 MB
  rows:    1,067,473
  symbols: 2,449

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-11-17 04:08:00	AAPL	Stock	42.8225	42.8225	42.8225	42.8225	400.0
2017-11-17 04:10:00	AAPL	Stock	42.81	42.81	42.81	42.81	1200.0
2017-11-17 04:33:00	AAPL	Stock	42.815	42.815	42.815	42.815	400.0
2017-11-17 04:49:00	AAPL	Stock	42.8275	42.8275	42.8275	42.8275	400.0
2017-11-17 06:00:00	AAPL	Stock	42.8375	42.8375	42.8375	42.8375	904.0
2017-11-17 06:08:00	AAPL	Stock	42.8425	42.8425	42.8425	42.8425	400.0
2017-11-17 06:42:00	AAPL	Stock	42.825	42.825	42.825	42.825	5600.0
2017-11-17 06:49:00	AAPL	Stock	42.825	42.825	42.825	42.825	4000.0
2017-11-17 07:00:00	AAPL	Stock	42.825	42.825	42.795	42.795	7292.0
2017-11-17 07:04:00	AAPL	Stock	42.8225	42.825	42.8225	42.825	38792.0
2017-11-17 07:05:00	AAPL	Stock	42.825	42.825	42.825	42.825	2000.0
2017-11-17 07:06:00	AAPL	Stock	42.825	42.825	42.825	42.825	1600.0
2017-11-17 07:07:00	AAPL	Stock	42.825	42.825	42.825	42.825	1552.0
2017-11-17 07:09:00	AAPL	Stock	42.825	42.825	42.825	42.825	3112.0
2017-11-17 07:10:00	AAPL	Stock	42.825	42.825	42.825	42.825	20800.0
2017-11-17 07:11:00	AAPL	Stock	42.825	42.825	42.825	42.825	5516.0
2017-11-17 07:12:00	AAPL	Stock	42.825	42.825	42.825	42.825	1272.0
2017-11-17 07:23:00	AAPL	Stock	42.825	42.825	42.825	42.825	1200.0
2017-11-17 07:25:00	AAPL	Stock	42.825	42.825	42.825	42.825	1600.0
2017-11-17 07:26:00	AAPL	Stock	42.825	42.825	42.825	42.825	9200.0
2017-11-17 07:28:00	AAPL	Stock	42.825	42.825	42.825	42.825	400.0
2017-11-17 07:35:00	AAPL	Stock	42.825	42.825	42.825	42.825	1124.0
2017-11-17 07:40:00	AAPL	Stock	42.825	42.825	42.825	42.825	2104.0
2017-11-17 07:41:00	AAPL	Stock	42.825	42.825	42.825	42.825	5812.0
2017-11-17 07:43:00	AAPL	Stock	42.825	42.825	42.825	42.825	1200.0
2017-11-17 07:46:00	AAPL	Stock	42.8125	42.8125	42.8	42.8	10168.0
2017-11-17 07:49:00	AAPL	Stock	42.8125	42.8125	42.8125	42.8125	1792.0
2017-11-17 07:50:00	AAPL	Stock	42.8125	42.825	42.8125	42.825	6144.0
2017-11-17 07:58:00	AAPL	Stock	42.805	42.805	42.805	42.805	4388.0
2017-11-17 07:59:00	AAPL	Stock	42.8025	42.8025	42.8025	42.8025	5000.0
2017-11-17 08:00:00	AAPL	Stock	42.8125	42.825	42.7875	42.795	65032.0
2017-11-17 08:02:00	AAPL	Stock	42.79	42.795	42.79	42.795	1628.0
2017-11-17 08:04:00	AAPL	Stock	42.7775	42.7775	42.75	42.7725	47332.0
2017-11-17 08:05:00	AAPL	Stock	42.77	42.77	42.765	42.765	3376.0
2017-11-17 08:06:00	AAPL	Stock	42.7575	42.76	42.7575	42.76	2596.0
2017-11-17 08:07:00	AAPL	Stock	42.795	42.795	42.795	42.795	4000.0
2017-11-17 08:08:00	AAPL	Stock	42.785	42.785	42.785	42.785	800.0
2017-11-17 08:09:00	AAPL	Stock	42.7875	42.7875	42.7875	42.7875	760.0
2017-11-17 08:11:00	AAPL	Stock	42.775	42.775	42.775	42.775	1796.0
2017-11-17 08:12:00	AAPL	Stock	42.775	42.785	42.7525	42.7525	4092.0
2017-11-17 08:14:00	AAPL	Stock	42.7525	42.7525	42.7525	42.7525	1952.0
2017-11-17 08:15:00	AAPL	Stock	42.7625	42.7625	42.7625	42.7625	800.0
2017-11-17 08:20:00	AAPL	Stock	42.755	42.77	42.75	42.77	5740.0
2017-11-17 08:22:00	AAPL	Stock	42.73	42.73	42.7275	42.7275	2148.0
2017-11-17 08:23:00	AAPL	Stock	42.7275	42.7275	42.7275	42.7275	800.0
2017-11-17 08:24:00	AAPL	Stock	42.725	42.725	42.725	42.725	1376.0
2017-11-17 08:25:00	AAPL	Stock	42.725	42.725	42.725	42.725	2592.0
2017-11-17 08:28:00	AAPL	Stock	42.725	42.725	42.715	42.715	4816.0
2017-11-17 08:29:00	AAPL	Stock	42.7425	42.7475	42.74	42.7425	5744.0
2017-11-17 08:30:00	AAPL	Stock	42.745	42.745	42.715	42.715	1836.0

> showing 50 of 1,067,473 rows — these rows as CSV

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