PREVIEW / stock_1min / 2017-07-25

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-25.parquet
  size:    14.4 MB
  rows:    1,047,451
  symbols: 2,490

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-25 04:51:00	AAPL	Stock	37.9825	37.9825	37.9725	37.9725	11348.0
2017-07-25 04:52:00	AAPL	Stock	37.9725	37.9725	37.9725	37.9725	800.0
2017-07-25 04:53:00	AAPL	Stock	37.9725	37.9725	37.9725	37.9725	400.0
2017-07-25 05:09:00	AAPL	Stock	38.0225	38.0225	38.0225	38.0225	8000.0
2017-07-25 05:46:00	AAPL	Stock	38.0375	38.0475	38.0375	38.0475	3508.0
2017-07-25 06:05:00	AAPL	Stock	38.0575	38.0575	38.0575	38.0575	1736.0
2017-07-25 07:00:00	AAPL	Stock	38.05	38.05	38.05	38.05	612.0
2017-07-25 07:17:00	AAPL	Stock	38.05	38.05	38.05	38.05	2200.0
2017-07-25 07:32:00	AAPL	Stock	38.06	38.06	38.06	38.06	400.0
2017-07-25 07:33:00	AAPL	Stock	38.0675	38.0675	38.0675	38.0675	7780.0
2017-07-25 07:38:00	AAPL	Stock	38.095	38.0975	38.095	38.0975	4376.0
2017-07-25 07:39:00	AAPL	Stock	38.1075	38.1075	38.1075	38.1075	800.0
2017-07-25 07:40:00	AAPL	Stock	38.0975	38.0975	38.0975	38.0975	3000.0
2017-07-25 07:41:00	AAPL	Stock	38.0975	38.0975	38.0975	38.0975	400.0
2017-07-25 07:47:00	AAPL	Stock	38.1125	38.1125	38.1125	38.1125	716.0
2017-07-25 07:48:00	AAPL	Stock	38.1	38.1	38.1	38.1	2400.0
2017-07-25 08:00:00	AAPL	Stock	38.095	38.1125	38.055	38.1025	8856.0
2017-07-25 08:01:00	AAPL	Stock	38.1	38.1075	38.0975	38.0975	6272.0
2017-07-25 08:02:00	AAPL	Stock	38.1075	38.1075	38.1075	38.1075	8000.0
2017-07-25 08:03:00	AAPL	Stock	38.0975	38.0975	38.0775	38.0775	4800.0
2017-07-25 08:08:00	AAPL	Stock	38.095	38.095	38.095	38.095	2000.0
2017-07-25 08:10:00	AAPL	Stock	38.1	38.1	38.1	38.1	800.0
2017-07-25 08:11:00	AAPL	Stock	38.095	38.0975	38.095	38.0975	2000.0
2017-07-25 08:12:00	AAPL	Stock	38.1	38.1	38.1	38.1	440.0
2017-07-25 08:13:00	AAPL	Stock	38.1	38.1	38.1	38.1	880.0
2017-07-25 08:14:00	AAPL	Stock	38.1	38.1	38.1	38.1	7300.0
2017-07-25 08:15:00	AAPL	Stock	38.1	38.11	38.1	38.11	3364.0
2017-07-25 08:16:00	AAPL	Stock	38.125	38.15	38.125	38.15	14772.0
2017-07-25 08:17:00	AAPL	Stock	38.15	38.15	38.1125	38.1125	11580.0
2017-07-25 08:18:00	AAPL	Stock	38.1175	38.1175	38.1175	38.1175	788.0
2017-07-25 08:19:00	AAPL	Stock	38.1175	38.1175	38.1175	38.1175	1200.0
2017-07-25 08:20:00	AAPL	Stock	38.1175	38.1175	38.095	38.095	11376.0
2017-07-25 08:22:00	AAPL	Stock	38.1	38.1	38.1	38.1	400.0
2017-07-25 08:23:00	AAPL	Stock	38.115	38.1375	38.1125	38.1125	6776.0
2017-07-25 08:24:00	AAPL	Stock	38.1	38.15	38.1	38.1425	5956.0
2017-07-25 08:25:00	AAPL	Stock	38.1	38.1	38.1	38.1	436.0
2017-07-25 08:27:00	AAPL	Stock	38.1025	38.1025	38.1	38.1	1528.0
2017-07-25 08:31:00	AAPL	Stock	38.1	38.1	38.1	38.1	7616.0
2017-07-25 08:34:00	AAPL	Stock	38.12	38.12	38.12	38.12	1000.0
2017-07-25 08:38:00	AAPL	Stock	38.12	38.12	38.0825	38.0875	12000.0
2017-07-25 08:39:00	AAPL	Stock	38.075	38.0975	38.075	38.0975	9540.0
2017-07-25 08:40:00	AAPL	Stock	38.075	38.075	38.06	38.06	3200.0
2017-07-25 08:42:00	AAPL	Stock	38.0675	38.0675	38.0525	38.0525	824.0
2017-07-25 08:45:00	AAPL	Stock	38.0675	38.0675	38.0575	38.0575	2800.0
2017-07-25 08:46:00	AAPL	Stock	38.0575	38.0575	38.0575	38.0575	800.0
2017-07-25 08:47:00	AAPL	Stock	38.0625	38.0625	38.0525	38.0525	1200.0
2017-07-25 08:48:00	AAPL	Stock	38.04	38.04	38.04	38.04	1200.0
2017-07-25 08:49:00	AAPL	Stock	38.0325	38.0325	38.0275	38.0275	2000.0
2017-07-25 08:50:00	AAPL	Stock	38.04	38.0675	38.04	38.0675	5936.0
2017-07-25 08:51:00	AAPL	Stock	38.04	38.05	38.0375	38.05	5316.0

> showing 50 of 1,047,451 rows — these rows as CSV

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