PREVIEW / stock_1min / 2018-03-28

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-03-28.parquet
  size:    16.1 MB
  rows:    1,149,786
  symbols: 2,390

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-03-28 04:00:00	AAPL	Stock	41.975	41.975	41.975	41.975	400.0
2018-03-28 04:10:00	AAPL	Stock	41.6525	41.6525	41.6525	41.6525	400.0
2018-03-28 04:13:00	AAPL	Stock	41.6625	41.6625	41.6625	41.6625	660.0
2018-03-28 04:15:00	AAPL	Stock	41.845	41.845	41.845	41.845	800.0
2018-03-28 04:19:00	AAPL	Stock	41.8625	41.875	41.8625	41.875	1600.0
2018-03-28 04:25:00	AAPL	Stock	41.8475	41.8475	41.8475	41.8475	400.0
2018-03-28 04:26:00	AAPL	Stock	41.85	41.925	41.85	41.925	2800.0
2018-03-28 04:27:00	AAPL	Stock	41.8625	41.8625	41.8625	41.8625	1200.0
2018-03-28 04:33:00	AAPL	Stock	41.815	41.815	41.815	41.815	864.0
2018-03-28 04:41:00	AAPL	Stock	41.8	41.935	41.8	41.8	7876.0
2018-03-28 04:53:00	AAPL	Stock	41.775	41.775	41.775	41.775	1600.0
2018-03-28 04:54:00	AAPL	Stock	41.775	41.775	41.775	41.775	1600.0
2018-03-28 04:55:00	AAPL	Stock	41.795	41.795	41.795	41.795	1200.0
2018-03-28 05:01:00	AAPL	Stock	41.85	41.85	41.8125	41.8125	7984.0
2018-03-28 05:02:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	2856.0
2018-03-28 05:04:00	AAPL	Stock	41.825	41.825	41.825	41.825	1200.0
2018-03-28 05:08:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	4000.0
2018-03-28 05:10:00	AAPL	Stock	41.795	41.795	41.795	41.795	3472.0
2018-03-28 05:16:00	AAPL	Stock	41.7775	41.7775	41.7775	41.7775	1576.0
2018-03-28 05:17:00	AAPL	Stock	41.775	41.8	41.775	41.8	2400.0
2018-03-28 05:18:00	AAPL	Stock	41.8	41.8	41.8	41.8	3600.0
2018-03-28 05:19:00	AAPL	Stock	41.8	41.8	41.775	41.775	12780.0
2018-03-28 05:20:00	AAPL	Stock	41.775	41.775	41.77	41.77	3600.0
2018-03-28 05:28:00	AAPL	Stock	41.79	41.79	41.79	41.79	400.0
2018-03-28 05:29:00	AAPL	Stock	41.8375	41.8375	41.8375	41.8375	1600.0
2018-03-28 05:32:00	AAPL	Stock	41.8875	41.8875	41.8875	41.8875	400.0
2018-03-28 05:45:00	AAPL	Stock	41.9925	42.01	41.9925	42.01	8000.0
2018-03-28 05:46:00	AAPL	Stock	42.01	42.01	42.0	42.0	8392.0
2018-03-28 05:50:00	AAPL	Stock	41.985	41.985	41.985	41.985	400.0
2018-03-28 05:51:00	AAPL	Stock	41.9975	41.9975	41.9975	41.9975	600.0
2018-03-28 05:57:00	AAPL	Stock	41.9025	41.9025	41.9025	41.9025	400.0
2018-03-28 06:02:00	AAPL	Stock	41.9075	41.9075	41.9075	41.9075	400.0
2018-03-28 06:06:00	AAPL	Stock	42.0	42.0	42.0	42.0	400.0
2018-03-28 06:08:00	AAPL	Stock	41.9425	41.9425	41.94	41.94	800.0
2018-03-28 06:09:00	AAPL	Stock	41.94	41.94	41.9075	41.9075	6004.0
2018-03-28 06:10:00	AAPL	Stock	41.8875	41.8875	41.85	41.85	8800.0
2018-03-28 06:11:00	AAPL	Stock	41.84	41.84	41.8375	41.8375	2240.0
2018-03-28 06:12:00	AAPL	Stock	41.8125	41.8125	41.8	41.8	1556.0
2018-03-28 06:15:00	AAPL	Stock	41.85	41.9125	41.85	41.9125	14000.0
2018-03-28 06:16:00	AAPL	Stock	41.91	41.9125	41.91	41.91	5600.0
2018-03-28 06:17:00	AAPL	Stock	41.875	41.875	41.875	41.875	400.0
2018-03-28 06:20:00	AAPL	Stock	41.875	41.875	41.875	41.875	800.0
2018-03-28 06:24:00	AAPL	Stock	41.885	41.885	41.885	41.885	400.0
2018-03-28 06:25:00	AAPL	Stock	41.92	41.92	41.92	41.92	500.0
2018-03-28 06:27:00	AAPL	Stock	41.94	41.975	41.94	41.975	2800.0
2018-03-28 06:29:00	AAPL	Stock	41.95	41.95	41.935	41.935	2400.0
2018-03-28 06:31:00	AAPL	Stock	41.905	41.905	41.905	41.905	2500.0
2018-03-28 06:32:00	AAPL	Stock	41.9075	41.9075	41.905	41.905	1200.0
2018-03-28 06:33:00	AAPL	Stock	41.95	41.9675	41.95	41.9675	1600.0
2018-03-28 06:37:00	AAPL	Stock	41.9675	41.9675	41.9675	41.9675	800.0

> showing 50 of 1,149,786 rows — these rows as CSV

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