PREVIEW / stock_1min / 2018-06-27

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-06-27.parquet
  size:    15.9 MB
  rows:    1,127,002
  symbols: 2,351

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-06-27 04:00:00	AAPL	Stock	45.9725	45.9725	45.7	45.75	18856.0
2018-06-27 04:02:00	AAPL	Stock	45.7525	45.7525	45.75	45.75	6816.0
2018-06-27 04:05:00	AAPL	Stock	45.7	45.7	45.6875	45.6875	2920.0
2018-06-27 04:06:00	AAPL	Stock	45.75	45.75	45.75	45.75	2000.0
2018-06-27 04:07:00	AAPL	Stock	45.725	45.725	45.705	45.705	3888.0
2018-06-27 04:08:00	AAPL	Stock	45.75	45.75	45.75	45.75	400.0
2018-06-27 04:10:00	AAPL	Stock	45.7375	45.7375	45.7375	45.7375	2000.0
2018-06-27 04:13:00	AAPL	Stock	45.725	45.725	45.725	45.725	400.0
2018-06-27 04:28:00	AAPL	Stock	45.7275	45.7275	45.625	45.625	2560.0
2018-06-27 04:42:00	AAPL	Stock	45.625	45.6325	45.625	45.6325	1400.0
2018-06-27 04:44:00	AAPL	Stock	45.6325	45.6325	45.6325	45.6325	600.0
2018-06-27 04:50:00	AAPL	Stock	45.625	45.625	45.625	45.625	3000.0
2018-06-27 04:52:00	AAPL	Stock	45.625	45.625	45.625	45.625	3200.0
2018-06-27 04:55:00	AAPL	Stock	45.625	45.625	45.625	45.625	2160.0
2018-06-27 05:02:00	AAPL	Stock	45.7	45.7	45.7	45.7	4860.0
2018-06-27 05:04:00	AAPL	Stock	45.7	45.7	45.7	45.7	432.0
2018-06-27 05:24:00	AAPL	Stock	45.8075	45.8075	45.8075	45.8075	1600.0
2018-06-27 05:25:00	AAPL	Stock	45.8	45.8	45.8	45.8	400.0
2018-06-27 05:49:00	AAPL	Stock	45.8	45.8	45.8	45.8	400.0
2018-06-27 05:55:00	AAPL	Stock	45.835	45.8375	45.835	45.8375	1600.0
2018-06-27 05:56:00	AAPL	Stock	45.845	45.875	45.8425	45.8725	6448.0
2018-06-27 05:57:00	AAPL	Stock	45.875	45.875	45.875	45.875	2000.0
2018-06-27 05:58:00	AAPL	Stock	45.875	45.92	45.875	45.92	2736.0
2018-06-27 06:09:00	AAPL	Stock	45.85	45.85	45.85	45.85	3872.0
2018-06-27 06:25:00	AAPL	Stock	45.8625	45.8625	45.8625	45.8625	400.0
2018-06-27 06:40:00	AAPL	Stock	45.8575	45.8625	45.8575	45.8625	1532.0
2018-06-27 06:52:00	AAPL	Stock	45.8875	45.9	45.8875	45.9	9132.0
2018-06-27 06:56:00	AAPL	Stock	45.9	45.925	45.9	45.925	16000.0
2018-06-27 06:59:00	AAPL	Stock	45.88	45.88	45.875	45.875	1600.0
2018-06-27 07:00:00	AAPL	Stock	45.9125	45.9175	45.9125	45.9175	6000.0
2018-06-27 07:02:00	AAPL	Stock	45.9275	45.9275	45.925	45.925	1692.0
2018-06-27 07:03:00	AAPL	Stock	45.95	45.95	45.95	45.95	400.0
2018-06-27 07:04:00	AAPL	Stock	45.95	45.9575	45.95	45.95	4800.0
2018-06-27 07:05:00	AAPL	Stock	45.95	45.95	45.95	45.95	7200.0
2018-06-27 07:07:00	AAPL	Stock	45.925	45.925	45.925	45.925	1496.0
2018-06-27 07:08:00	AAPL	Stock	45.925	45.95	45.925	45.95	4964.0
2018-06-27 07:09:00	AAPL	Stock	45.965	45.965	45.965	45.965	700.0
2018-06-27 07:10:00	AAPL	Stock	45.93	45.93	45.9	45.92	2888.0
2018-06-27 07:11:00	AAPL	Stock	45.905	45.905	45.905	45.905	532.0
2018-06-27 07:15:00	AAPL	Stock	45.905	45.905	45.905	45.905	472.0
2018-06-27 07:16:00	AAPL	Stock	45.9	45.9	45.9	45.9	400.0
2018-06-27 07:19:00	AAPL	Stock	45.8875	45.8875	45.875	45.875	7236.0
2018-06-27 07:20:00	AAPL	Stock	45.8475	45.8475	45.8475	45.8475	800.0
2018-06-27 07:21:00	AAPL	Stock	45.8475	45.85	45.8475	45.85	1200.0
2018-06-27 07:22:00	AAPL	Stock	45.84	45.84	45.8375	45.8375	1200.0
2018-06-27 07:23:00	AAPL	Stock	45.825	45.825	45.825	45.825	400.0
2018-06-27 07:24:00	AAPL	Stock	45.8475	45.885	45.8475	45.885	15608.0
2018-06-27 07:26:00	AAPL	Stock	45.875	45.875	45.875	45.875	440.0
2018-06-27 07:27:00	AAPL	Stock	45.875	45.875	45.875	45.875	800.0
2018-06-27 07:28:00	AAPL	Stock	45.8625	45.8625	45.8625	45.8625	800.0

> showing 50 of 1,127,002 rows — these rows as CSV

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