PREVIEW / stock_1min / 2017-08-01

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-01.parquet
  size:    14.4 MB
  rows:    1,043,729
  symbols: 2,476

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-08-01 04:00:00	AAPL	Stock	37.2625	37.2625	37.2625	37.2625	1456.0
2017-08-01 04:02:00	AAPL	Stock	37.2525	37.2625	37.2525	37.2625	4268.0
2017-08-01 04:03:00	AAPL	Stock	37.25	37.25	37.2475	37.2475	4304.0
2017-08-01 04:04:00	AAPL	Stock	37.2	37.2	37.1875	37.1875	3848.0
2017-08-01 04:06:00	AAPL	Stock	37.255	37.255	37.2525	37.2525	800.0
2017-08-01 04:07:00	AAPL	Stock	37.26	37.26	37.26	37.26	2400.0
2017-08-01 04:10:00	AAPL	Stock	37.2875	37.2875	37.2875	37.2875	2544.0
2017-08-01 04:11:00	AAPL	Stock	37.2875	37.2875	37.2875	37.2875	1200.0
2017-08-01 04:18:00	AAPL	Stock	37.32	37.3225	37.32	37.3225	1524.0
2017-08-01 05:08:00	AAPL	Stock	37.325	37.325	37.325	37.325	9984.0
2017-08-01 05:09:00	AAPL	Stock	37.325	37.325	37.325	37.325	5200.0
2017-08-01 05:21:00	AAPL	Stock	37.3425	37.3425	37.3425	37.3425	400.0
2017-08-01 05:23:00	AAPL	Stock	37.3275	37.3275	37.3275	37.3275	400.0
2017-08-01 05:36:00	AAPL	Stock	37.3525	37.3525	37.3525	37.3525	604.0
2017-08-01 05:54:00	AAPL	Stock	37.33	37.33	37.33	37.33	400.0
2017-08-01 06:00:00	AAPL	Stock	37.3275	37.3275	37.3275	37.3275	400.0
2017-08-01 06:31:00	AAPL	Stock	37.2925	37.2925	37.2925	37.2925	1664.0
2017-08-01 06:42:00	AAPL	Stock	37.2925	37.2925	37.2925	37.2925	5200.0
2017-08-01 06:43:00	AAPL	Stock	37.315	37.315	37.315	37.315	800.0
2017-08-01 06:46:00	AAPL	Stock	37.2925	37.2925	37.2875	37.2875	13904.0
2017-08-01 06:51:00	AAPL	Stock	37.2925	37.2925	37.2925	37.2925	2400.0
2017-08-01 06:52:00	AAPL	Stock	37.3075	37.3125	37.3075	37.3125	4800.0
2017-08-01 06:53:00	AAPL	Stock	37.3125	37.3125	37.3075	37.3125	4000.0
2017-08-01 06:54:00	AAPL	Stock	37.3125	37.3125	37.3125	37.3125	800.0
2017-08-01 06:55:00	AAPL	Stock	37.3125	37.3175	37.3125	37.3175	13292.0
2017-08-01 06:58:00	AAPL	Stock	37.3125	37.3125	37.3125	37.3125	4400.0
2017-08-01 06:59:00	AAPL	Stock	37.3025	37.3025	37.3025	37.3025	400.0
2017-08-01 07:00:00	AAPL	Stock	37.3125	37.3125	37.3025	37.3025	3212.0
2017-08-01 07:01:00	AAPL	Stock	37.3	37.3	37.3	37.3	3992.0
2017-08-01 07:02:00	AAPL	Stock	37.3	37.3	37.2825	37.2825	8000.0
2017-08-01 07:03:00	AAPL	Stock	37.275	37.275	37.275	37.275	800.0
2017-08-01 07:04:00	AAPL	Stock	37.2625	37.2625	37.25	37.25	6360.0
2017-08-01 07:05:00	AAPL	Stock	37.2525	37.2525	37.25	37.25	1200.0
2017-08-01 07:06:00	AAPL	Stock	37.25	37.25	37.225	37.225	1432.0
2017-08-01 07:07:00	AAPL	Stock	37.2275	37.2275	37.2275	37.2275	2000.0
2017-08-01 07:08:00	AAPL	Stock	37.275	37.275	37.275	37.275	400.0
2017-08-01 07:09:00	AAPL	Stock	37.2275	37.2275	37.225	37.225	6000.0
2017-08-01 07:10:00	AAPL	Stock	37.2125	37.2125	37.2125	37.2125	1476.0
2017-08-01 07:11:00	AAPL	Stock	37.25	37.25	37.25	37.25	400.0
2017-08-01 07:14:00	AAPL	Stock	37.2675	37.2675	37.2675	37.2675	572.0
2017-08-01 07:21:00	AAPL	Stock	37.2225	37.2225	37.2225	37.2225	3200.0
2017-08-01 07:24:00	AAPL	Stock	37.215	37.215	37.215	37.215	1600.0
2017-08-01 07:25:00	AAPL	Stock	37.215	37.215	37.215	37.215	692.0
2017-08-01 07:26:00	AAPL	Stock	37.22	37.2375	37.22	37.2375	8400.0
2017-08-01 07:32:00	AAPL	Stock	37.25	37.2525	37.2475	37.2525	7216.0
2017-08-01 07:34:00	AAPL	Stock	37.25	37.255	37.25	37.255	4004.0
2017-08-01 07:45:00	AAPL	Stock	37.255	37.255	37.255	37.255	800.0
2017-08-01 07:50:00	AAPL	Stock	37.2525	37.2525	37.25	37.25	800.0
2017-08-01 07:53:00	AAPL	Stock	37.265	37.27	37.265	37.27	6000.0
2017-08-01 07:54:00	AAPL	Stock	37.25	37.25	37.25	37.25	12744.0

> showing 50 of 1,043,729 rows — these rows as CSV

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