PREVIEW / stock_1min / 2017-05-08

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-05-08.parquet
  size:    14.6 MB
  rows:    1,062,551
  symbols: 2,519

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-08 04:07:00	AAPL	Stock	37.295	37.295	37.295	37.295	800.0
2017-05-08 04:09:00	AAPL	Stock	37.295	37.295	37.295	37.295	800.0
2017-05-08 04:13:00	AAPL	Stock	37.2475	37.2475	37.2475	37.2475	532.0
2017-05-08 04:43:00	AAPL	Stock	37.255	37.255	37.255	37.255	800.0
2017-05-08 04:50:00	AAPL	Stock	37.25	37.25	37.25	37.25	400.0
2017-05-08 04:59:00	AAPL	Stock	37.25	37.25	37.25	37.25	1200.0
2017-05-08 06:27:00	AAPL	Stock	37.24	37.24	37.24	37.24	1200.0
2017-05-08 06:33:00	AAPL	Stock	37.2475	37.2475	37.2475	37.2475	800.0
2017-05-08 06:41:00	AAPL	Stock	37.2625	37.2625	37.2625	37.2625	800.0
2017-05-08 06:43:00	AAPL	Stock	37.2925	37.2925	37.2925	37.2925	400.0
2017-05-08 06:46:00	AAPL	Stock	37.2925	37.32	37.2925	37.315	6000.0
2017-05-08 06:47:00	AAPL	Stock	37.335	37.335	37.335	37.335	400.0
2017-05-08 06:54:00	AAPL	Stock	37.3225	37.3225	37.3225	37.3225	760.0
2017-05-08 06:55:00	AAPL	Stock	37.3325	37.335	37.3325	37.335	3600.0
2017-05-08 07:01:00	AAPL	Stock	37.33	37.3325	37.33	37.3325	4460.0
2017-05-08 07:02:00	AAPL	Stock	37.325	37.325	37.325	37.325	400.0
2017-05-08 07:03:00	AAPL	Stock	37.325	37.3275	37.325	37.3275	4400.0
2017-05-08 07:04:00	AAPL	Stock	37.3275	37.3275	37.3125	37.3125	1180.0
2017-05-08 07:05:00	AAPL	Stock	37.3075	37.3075	37.3075	37.3075	7600.0
2017-05-08 07:11:00	AAPL	Stock	37.3125	37.3125	37.3125	37.3125	1200.0
2017-05-08 07:12:00	AAPL	Stock	37.32	37.35	37.32	37.3275	22508.0
2017-05-08 07:13:00	AAPL	Stock	37.3475	37.3475	37.3475	37.3475	400.0
2017-05-08 07:14:00	AAPL	Stock	37.3475	37.3475	37.3375	37.3425	1600.0
2017-05-08 07:15:00	AAPL	Stock	37.3425	37.345	37.3425	37.3425	5528.0
2017-05-08 07:16:00	AAPL	Stock	37.345	37.345	37.3325	37.345	14800.0
2017-05-08 07:17:00	AAPL	Stock	37.345	37.375	37.345	37.375	5272.0
2017-05-08 07:19:00	AAPL	Stock	37.345	37.3475	37.345	37.3475	3340.0
2017-05-08 07:21:00	AAPL	Stock	37.3375	37.3475	37.3375	37.3475	3960.0
2017-05-08 07:22:00	AAPL	Stock	37.3425	37.345	37.3275	37.3275	29852.0
2017-05-08 07:26:00	AAPL	Stock	37.33	37.33	37.325	37.325	1980.0
2017-05-08 07:27:00	AAPL	Stock	37.325	37.325	37.32	37.325	4236.0
2017-05-08 07:28:00	AAPL	Stock	37.33	37.33	37.33	37.33	900.0
2017-05-08 07:29:00	AAPL	Stock	37.3275	37.3275	37.3275	37.3275	800.0
2017-05-08 07:32:00	AAPL	Stock	37.3275	37.3275	37.3275	37.3275	800.0
2017-05-08 07:34:00	AAPL	Stock	37.3275	37.3375	37.3275	37.3375	2600.0
2017-05-08 07:35:00	AAPL	Stock	37.3425	37.3425	37.3425	37.3425	1600.0
2017-05-08 07:36:00	AAPL	Stock	37.3375	37.3375	37.335	37.335	2820.0
2017-05-08 07:38:00	AAPL	Stock	37.3225	37.3225	37.32	37.32	3200.0
2017-05-08 07:40:00	AAPL	Stock	37.335	37.335	37.335	37.335	720.0
2017-05-08 07:41:00	AAPL	Stock	37.3375	37.3375	37.3375	37.3375	4600.0
2017-05-08 07:42:00	AAPL	Stock	37.34	37.34	37.33	37.33	2400.0
2017-05-08 07:44:00	AAPL	Stock	37.33	37.33	37.33	37.33	400.0
2017-05-08 07:45:00	AAPL	Stock	37.33	37.33	37.33	37.33	2840.0
2017-05-08 07:46:00	AAPL	Stock	37.32	37.33	37.32	37.33	4000.0
2017-05-08 07:47:00	AAPL	Stock	37.33	37.33	37.33	37.33	1200.0
2017-05-08 07:48:00	AAPL	Stock	37.32	37.32	37.3125	37.3125	10200.0
2017-05-08 07:49:00	AAPL	Stock	37.3	37.32	37.3	37.3125	13984.0
2017-05-08 07:51:00	AAPL	Stock	37.305	37.305	37.3	37.3	7000.0
2017-05-08 07:52:00	AAPL	Stock	37.3	37.3	37.295	37.295	7556.0
2017-05-08 07:53:00	AAPL	Stock	37.29	37.29	37.29	37.29	1480.0

> showing 50 of 1,062,551 rows — these rows as CSV

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