PREVIEW / stock_1min / 2017-05-01

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-05-01.parquet
  size:    14.5 MB
  rows:    1,051,192
  symbols: 2,522

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-05-01 04:08:00	AAPL	Stock	36.0025	36.0025	36.0025	36.0025	400.0
2017-05-01 06:09:00	AAPL	Stock	36.035	36.035	36.035	36.035	400.0
2017-05-01 06:11:00	AAPL	Stock	36.035	36.04	36.035	36.04	3700.0
2017-05-01 06:41:00	AAPL	Stock	36.0325	36.035	36.0325	36.035	8380.0
2017-05-01 07:00:00	AAPL	Stock	36.0575	36.0575	36.0575	36.0575	2400.0
2017-05-01 07:01:00	AAPL	Stock	36.0475	36.0475	36.0475	36.0475	1800.0
2017-05-01 07:04:00	AAPL	Stock	36.06	36.06	36.06	36.06	3600.0
2017-05-01 07:05:00	AAPL	Stock	36.0625	36.0625	36.0625	36.0625	2800.0
2017-05-01 07:06:00	AAPL	Stock	36.0625	36.0625	36.0625	36.0625	1200.0
2017-05-01 07:09:00	AAPL	Stock	36.0575	36.0575	36.0575	36.0575	400.0
2017-05-01 07:11:00	AAPL	Stock	36.0575	36.0575	36.0575	36.0575	1800.0
2017-05-01 07:12:00	AAPL	Stock	36.07	36.0725	36.07	36.0725	3252.0
2017-05-01 07:13:00	AAPL	Stock	36.0625	36.0625	36.0575	36.0625	7132.0
2017-05-01 07:14:00	AAPL	Stock	36.0625	36.0625	36.05	36.05	1600.0
2017-05-01 07:15:00	AAPL	Stock	36.075	36.075	36.075	36.075	1200.0
2017-05-01 07:16:00	AAPL	Stock	36.0725	36.075	36.0725	36.075	3652.0
2017-05-01 07:17:00	AAPL	Stock	36.075	36.075	36.075	36.075	3148.0
2017-05-01 07:19:00	AAPL	Stock	36.1025	36.1025	36.0975	36.0975	1200.0
2017-05-01 07:20:00	AAPL	Stock	36.08	36.08	36.08	36.08	2000.0
2017-05-01 07:23:00	AAPL	Stock	36.0875	36.0875	36.0875	36.0875	800.0
2017-05-01 07:24:00	AAPL	Stock	36.0975	36.1	36.0975	36.1	1200.0
2017-05-01 07:25:00	AAPL	Stock	36.1	36.1	36.1	36.1	3500.0
2017-05-01 07:27:00	AAPL	Stock	36.1	36.1	36.1	36.1	3200.0
2017-05-01 07:28:00	AAPL	Stock	36.1125	36.1125	36.1125	36.1125	2800.0
2017-05-01 07:30:00	AAPL	Stock	36.0875	36.0875	36.0875	36.0875	400.0
2017-05-01 07:31:00	AAPL	Stock	36.0875	36.1	36.0875	36.1	5500.0
2017-05-01 07:35:00	AAPL	Stock	36.11	36.11	36.11	36.11	400.0
2017-05-01 07:36:00	AAPL	Stock	36.1	36.1	36.1	36.1	1600.0
2017-05-01 07:38:00	AAPL	Stock	36.1	36.1	36.1	36.1	1540.0
2017-05-01 07:39:00	AAPL	Stock	36.1	36.12	36.1	36.12	8344.0
2017-05-01 07:42:00	AAPL	Stock	36.1125	36.1125	36.1	36.1	3276.0
2017-05-01 07:43:00	AAPL	Stock	36.1	36.1	36.1	36.1	400.0
2017-05-01 07:45:00	AAPL	Stock	36.0875	36.0875	36.0875	36.0875	1928.0
2017-05-01 07:47:00	AAPL	Stock	36.0775	36.0825	36.0775	36.0825	5600.0
2017-05-01 07:48:00	AAPL	Stock	36.095	36.095	36.095	36.095	800.0
2017-05-01 07:53:00	AAPL	Stock	36.0875	36.0875	36.0875	36.0875	2400.0
2017-05-01 07:58:00	AAPL	Stock	36.0875	36.0875	36.0875	36.0875	4900.0
2017-05-01 07:59:00	AAPL	Stock	36.0875	36.0875	36.0875	36.0875	1976.0
2017-05-01 08:00:00	AAPL	Stock	36.075	36.1175	36.0625	36.0875	53932.0
2017-05-01 08:01:00	AAPL	Stock	36.095	36.1	36.095	36.1	13348.0
2017-05-01 08:03:00	AAPL	Stock	36.095	36.11	36.095	36.095	9864.0
2017-05-01 08:04:00	AAPL	Stock	36.1	36.1	36.1	36.1	3204.0
2017-05-01 08:05:00	AAPL	Stock	36.105	36.105	36.095	36.095	6768.0
2017-05-01 08:06:00	AAPL	Stock	36.1075	36.1075	36.105	36.105	9800.0
2017-05-01 08:08:00	AAPL	Stock	36.1075	36.1075	36.1075	36.1075	400.0
2017-05-01 08:09:00	AAPL	Stock	36.105	36.105	36.105	36.105	400.0
2017-05-01 08:10:00	AAPL	Stock	36.1025	36.1025	36.0975	36.0975	5200.0
2017-05-01 08:11:00	AAPL	Stock	36.0975	36.1075	36.0875	36.0875	9140.0
2017-05-01 08:12:00	AAPL	Stock	36.0975	36.1075	36.0975	36.1075	8500.0
2017-05-01 08:14:00	AAPL	Stock	36.0925	36.0925	36.0925	36.0925	1520.0

> showing 50 of 1,051,192 rows — these rows as CSV

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