PREVIEW / stock_1min / 2018-07-03

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-03.parquet
  size:    9.1 MB
  rows:    636,591
  symbols: 2,311

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-07-03 04:53:00	AAPL	Stock	46.8175	46.8175	46.8175	46.8175	3884.0
2018-07-03 05:12:00	AAPL	Stock	46.8225	46.8225	46.8225	46.8225	7200.0
2018-07-03 05:41:00	AAPL	Stock	46.925	46.925	46.925	46.925	400.0
2018-07-03 05:42:00	AAPL	Stock	46.83	46.83	46.8275	46.8275	2504.0
2018-07-03 05:43:00	AAPL	Stock	46.8275	46.8275	46.8275	46.8275	1200.0
2018-07-03 05:49:00	AAPL	Stock	46.83	46.83	46.825	46.825	3720.0
2018-07-03 06:09:00	AAPL	Stock	46.925	46.925	46.925	46.925	808.0
2018-07-03 06:17:00	AAPL	Stock	46.9475	46.9725	46.9475	46.9725	5580.0
2018-07-03 06:19:00	AAPL	Stock	46.9725	46.9725	46.9725	46.9725	800.0
2018-07-03 06:39:00	AAPL	Stock	46.9425	46.9425	46.9425	46.9425	400.0
2018-07-03 06:41:00	AAPL	Stock	46.9625	46.9625	46.9625	46.9625	4000.0
2018-07-03 06:43:00	AAPL	Stock	46.975	46.975	46.9175	46.9175	4172.0
2018-07-03 07:00:00	AAPL	Stock	46.925	46.925	46.92	46.92	3800.0
2018-07-03 07:01:00	AAPL	Stock	46.92	46.935	46.92	46.935	1200.0
2018-07-03 07:02:00	AAPL	Stock	46.935	46.9375	46.935	46.9375	4716.0
2018-07-03 07:03:00	AAPL	Stock	46.9375	46.9375	46.9375	46.9375	400.0
2018-07-03 07:04:00	AAPL	Stock	46.95	46.95	46.95	46.95	428.0
2018-07-03 07:06:00	AAPL	Stock	46.9375	46.9475	46.9375	46.9475	6892.0
2018-07-03 07:07:00	AAPL	Stock	46.9475	46.9475	46.9475	46.9475	3984.0
2018-07-03 07:09:00	AAPL	Stock	46.93	46.93	46.93	46.93	2912.0
2018-07-03 07:10:00	AAPL	Stock	46.945	46.945	46.945	46.945	400.0
2018-07-03 07:11:00	AAPL	Stock	46.9375	46.9375	46.8925	46.8975	5600.0
2018-07-03 07:12:00	AAPL	Stock	46.925	46.9375	46.9225	46.9375	9116.0
2018-07-03 07:13:00	AAPL	Stock	46.935	46.9375	46.935	46.9375	3828.0
2018-07-03 07:14:00	AAPL	Stock	46.9375	46.9375	46.9375	46.9375	3292.0
2018-07-03 07:16:00	AAPL	Stock	46.9375	46.9375	46.935	46.9375	7952.0
2018-07-03 07:17:00	AAPL	Stock	46.9375	46.9375	46.9375	46.9375	1600.0
2018-07-03 07:18:00	AAPL	Stock	46.9375	46.9375	46.9375	46.9375	400.0
2018-07-03 07:22:00	AAPL	Stock	46.9375	46.9375	46.9125	46.9125	2152.0
2018-07-03 07:23:00	AAPL	Stock	46.93	46.93	46.93	46.93	1980.0
2018-07-03 07:26:00	AAPL	Stock	46.92	46.92	46.92	46.92	800.0
2018-07-03 07:28:00	AAPL	Stock	46.93	46.955	46.93	46.955	7924.0
2018-07-03 07:29:00	AAPL	Stock	46.9425	46.965	46.9275	46.965	6400.0
2018-07-03 07:30:00	AAPL	Stock	46.9525	46.9525	46.9525	46.9525	400.0
2018-07-03 07:31:00	AAPL	Stock	46.95	46.95	46.95	46.95	800.0
2018-07-03 07:32:00	AAPL	Stock	46.94	46.94	46.9375	46.9375	2400.0
2018-07-03 07:34:00	AAPL	Stock	46.945	46.945	46.94	46.945	1200.0
2018-07-03 07:35:00	AAPL	Stock	46.9575	46.9725	46.9575	46.9725	5340.0
2018-07-03 07:36:00	AAPL	Stock	46.9725	46.9725	46.9725	46.9725	400.0
2018-07-03 07:37:00	AAPL	Stock	46.9725	46.9725	46.9725	46.9725	10800.0
2018-07-03 07:38:00	AAPL	Stock	46.9725	46.9725	46.965	46.97	19072.0
2018-07-03 07:39:00	AAPL	Stock	46.97	46.9725	46.97	46.9725	3800.0
2018-07-03 07:40:00	AAPL	Stock	46.9725	46.9725	46.97	46.9725	5312.0
2018-07-03 07:42:00	AAPL	Stock	46.9725	46.9775	46.9725	46.9775	19288.0
2018-07-03 07:45:00	AAPL	Stock	46.9875	46.9975	46.975	46.975	11420.0
2018-07-03 07:46:00	AAPL	Stock	46.975	46.985	46.975	46.985	1000.0
2018-07-03 07:48:00	AAPL	Stock	46.985	46.985	46.985	46.985	800.0
2018-07-03 07:49:00	AAPL	Stock	46.975	46.975	46.975	46.975	2340.0
2018-07-03 07:50:00	AAPL	Stock	46.9725	46.9725	46.9725	46.9725	400.0
2018-07-03 07:53:00	AAPL	Stock	46.9625	46.9625	46.95	46.95	3200.0

> showing 50 of 636,591 rows — these rows as CSV

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