PREVIEW / stock_1min / 2017-05-09

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-05-09.parquet
  size:    15.1 MB
  rows:    1,086,663
  symbols: 2,509

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-09 04:01:00	AAPL	Stock	38.3125	38.3125	38.3125	38.3125	400.0
2017-05-09 04:02:00	AAPL	Stock	38.3125	38.3125	38.3125	38.3125	400.0
2017-05-09 04:07:00	AAPL	Stock	38.35	38.375	38.35	38.375	2000.0
2017-05-09 04:11:00	AAPL	Stock	38.35	38.375	38.35	38.375	4784.0
2017-05-09 04:12:00	AAPL	Stock	38.3625	38.3725	38.3625	38.3725	5388.0
2017-05-09 04:15:00	AAPL	Stock	38.3675	38.37	38.3675	38.37	800.0
2017-05-09 04:23:00	AAPL	Stock	38.3	38.3	38.3	38.3	400.0
2017-05-09 04:37:00	AAPL	Stock	38.35	38.35	38.35	38.35	4000.0
2017-05-09 04:38:00	AAPL	Stock	38.325	38.325	38.325	38.325	1444.0
2017-05-09 04:50:00	AAPL	Stock	38.325	38.325	38.325	38.325	1200.0
2017-05-09 04:55:00	AAPL	Stock	38.37	38.37	38.37	38.37	2000.0
2017-05-09 04:56:00	AAPL	Stock	38.37	38.375	38.37	38.375	4000.0
2017-05-09 05:02:00	AAPL	Stock	38.37	38.37	38.37	38.37	400.0
2017-05-09 05:04:00	AAPL	Stock	38.37	38.37	38.37	38.37	1200.0
2017-05-09 05:08:00	AAPL	Stock	38.3525	38.3525	38.35	38.35	1260.0
2017-05-09 05:09:00	AAPL	Stock	38.35	38.35	38.35	38.35	2800.0
2017-05-09 05:27:00	AAPL	Stock	38.375	38.3925	38.375	38.3925	4400.0
2017-05-09 05:28:00	AAPL	Stock	38.3925	38.3925	38.3925	38.3925	2000.0
2017-05-09 05:29:00	AAPL	Stock	38.375	38.375	38.375	38.375	7680.0
2017-05-09 05:40:00	AAPL	Stock	38.3975	38.3975	38.3975	38.3975	4000.0
2017-05-09 05:45:00	AAPL	Stock	38.4325	38.4325	38.4325	38.4325	400.0
2017-05-09 05:54:00	AAPL	Stock	38.4375	38.4375	38.4375	38.4375	400.0
2017-05-09 05:56:00	AAPL	Stock	38.4	38.4	38.4	38.4	540.0
2017-05-09 05:57:00	AAPL	Stock	38.425	38.43	38.425	38.43	1200.0
2017-05-09 05:58:00	AAPL	Stock	38.425	38.425	38.425	38.425	5600.0
2017-05-09 06:06:00	AAPL	Stock	38.42	38.42	38.42	38.42	800.0
2017-05-09 06:12:00	AAPL	Stock	38.3975	38.3975	38.3975	38.3975	400.0
2017-05-09 06:13:00	AAPL	Stock	38.375	38.3975	38.375	38.3975	9252.0
2017-05-09 06:17:00	AAPL	Stock	38.3875	38.3875	38.3875	38.3875	1780.0
2017-05-09 06:19:00	AAPL	Stock	38.4	38.4	38.4	38.4	400.0
2017-05-09 06:20:00	AAPL	Stock	38.42	38.42	38.42	38.42	400.0
2017-05-09 06:21:00	AAPL	Stock	38.4	38.4	38.4	38.4	4000.0
2017-05-09 06:24:00	AAPL	Stock	38.3875	38.3875	38.3875	38.3875	4000.0
2017-05-09 06:30:00	AAPL	Stock	38.3875	38.3875	38.3875	38.3875	1000.0
2017-05-09 06:31:00	AAPL	Stock	38.3775	38.3975	38.3775	38.3975	1244.0
2017-05-09 06:36:00	AAPL	Stock	38.3775	38.3775	38.37	38.37	8000.0
2017-05-09 06:37:00	AAPL	Stock	38.37	38.37	38.37	38.37	3200.0
2017-05-09 06:44:00	AAPL	Stock	38.375	38.375	38.375	38.375	4400.0
2017-05-09 06:45:00	AAPL	Stock	38.3875	38.3875	38.3875	38.3875	1200.0
2017-05-09 06:50:00	AAPL	Stock	38.355	38.355	38.355	38.355	400.0
2017-05-09 06:58:00	AAPL	Stock	38.37	38.37	38.37	38.37	400.0
2017-05-09 07:01:00	AAPL	Stock	38.3675	38.3675	38.3675	38.3675	1512.0
2017-05-09 07:02:00	AAPL	Stock	38.3675	38.3675	38.3675	38.3675	4000.0
2017-05-09 07:03:00	AAPL	Stock	38.3625	38.3625	38.3625	38.3625	7200.0
2017-05-09 07:05:00	AAPL	Stock	38.3625	38.375	38.355	38.355	18480.0
2017-05-09 07:06:00	AAPL	Stock	38.35	38.35	38.35	38.35	3800.0
2017-05-09 07:10:00	AAPL	Stock	38.3525	38.3525	38.3525	38.3525	400.0
2017-05-09 07:11:00	AAPL	Stock	38.375	38.375	38.375	38.375	2400.0
2017-05-09 07:12:00	AAPL	Stock	38.375	38.375	38.375	38.375	5544.0
2017-05-09 07:13:00	AAPL	Stock	38.375	38.375	38.375	38.375	4116.0

> showing 50 of 1,086,663 rows — these rows as CSV

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