PREVIEW / stock_1min / 2016-04-18

all stock 1-min files

  file:    by_date/stock_1min/2016/2016-04-18.parquet
  size:    14.4 MB
  rows:    1,054,009
  symbols: 2,715

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
2016-04-18 04:00:00	AAPL	Stock	27.4	27.4	27.3025	27.3025	11948.0
2016-04-18 04:05:00	AAPL	Stock	27.3	27.3	27.3	27.3	2356.0
2016-04-18 04:24:00	AAPL	Stock	27.255	27.255	27.2525	27.2525	6320.0
2016-04-18 04:49:00	AAPL	Stock	27.3025	27.3025	27.3025	27.3025	800.0
2016-04-18 05:00:00	AAPL	Stock	27.345	27.345	27.345	27.345	400.0
2016-04-18 05:06:00	AAPL	Stock	27.3025	27.3025	27.3025	27.3025	1600.0
2016-04-18 05:29:00	AAPL	Stock	27.31	27.31	27.31	27.31	2000.0
2016-04-18 05:30:00	AAPL	Stock	27.3	27.3	27.3	27.3	2464.0
2016-04-18 05:53:00	AAPL	Stock	27.325	27.325	27.325	27.325	400.0
2016-04-18 05:56:00	AAPL	Stock	27.345	27.345	27.345	27.345	3200.0
2016-04-18 05:57:00	AAPL	Stock	27.345	27.345	27.345	27.345	800.0
2016-04-18 05:59:00	AAPL	Stock	27.3525	27.36	27.3525	27.36	4400.0
2016-04-18 06:07:00	AAPL	Stock	27.36	27.36	27.36	27.36	3600.0
2016-04-18 06:08:00	AAPL	Stock	27.3625	27.3625	27.3625	27.3625	7200.0
2016-04-18 06:14:00	AAPL	Stock	27.36	27.36	27.36	27.36	400.0
2016-04-18 06:15:00	AAPL	Stock	27.36	27.36	27.36	27.36	3600.0
2016-04-18 06:19:00	AAPL	Stock	27.36	27.36	27.36	27.36	3600.0
2016-04-18 06:32:00	AAPL	Stock	27.35	27.35	27.35	27.35	2000.0
2016-04-18 06:35:00	AAPL	Stock	27.335	27.335	27.335	27.335	1612.0
2016-04-18 06:38:00	AAPL	Stock	27.335	27.335	27.335	27.335	400.0
2016-04-18 06:39:00	AAPL	Stock	27.35	27.35	27.35	27.35	2000.0
2016-04-18 06:41:00	AAPL	Stock	27.315	27.315	27.315	27.315	400.0
2016-04-18 06:58:00	AAPL	Stock	27.3125	27.3125	27.3125	27.3125	400.0
2016-04-18 07:01:00	AAPL	Stock	27.325	27.325	27.325	27.325	2796.0
2016-04-18 07:02:00	AAPL	Stock	27.325	27.325	27.325	27.325	4400.0
2016-04-18 07:03:00	AAPL	Stock	27.34	27.34	27.3	27.3	11552.0
2016-04-18 07:08:00	AAPL	Stock	27.31	27.3125	27.31	27.3125	3200.0
2016-04-18 07:10:00	AAPL	Stock	27.32	27.32	27.32	27.32	420.0
2016-04-18 07:12:00	AAPL	Stock	27.32	27.325	27.32	27.325	2800.0
2016-04-18 07:13:00	AAPL	Stock	27.3325	27.3325	27.3325	27.3325	2400.0
2016-04-18 07:14:00	AAPL	Stock	27.335	27.34	27.335	27.34	10796.0
2016-04-18 07:15:00	AAPL	Stock	27.3375	27.3375	27.3375	27.3375	10588.0
2016-04-18 07:17:00	AAPL	Stock	27.325	27.3325	27.325	27.3325	5260.0
2016-04-18 07:18:00	AAPL	Stock	27.325	27.325	27.325	27.325	9464.0
2016-04-18 07:19:00	AAPL	Stock	27.325	27.325	27.325	27.325	1200.0
2016-04-18 07:21:00	AAPL	Stock	27.3125	27.3125	27.3125	27.3125	1600.0
2016-04-18 07:22:00	AAPL	Stock	27.3125	27.315	27.3125	27.3125	13200.0
2016-04-18 07:23:00	AAPL	Stock	27.3125	27.3125	27.28	27.28	9800.0
2016-04-18 07:24:00	AAPL	Stock	27.2875	27.2875	27.2775	27.2775	13968.0
2016-04-18 07:25:00	AAPL	Stock	27.2775	27.28	27.2775	27.28	12400.0
2016-04-18 07:27:00	AAPL	Stock	27.29	27.29	27.29	27.29	400.0
2016-04-18 07:29:00	AAPL	Stock	27.29	27.29	27.29	27.29	5000.0
2016-04-18 07:30:00	AAPL	Stock	27.29	27.2925	27.2775	27.2775	9668.0
2016-04-18 07:31:00	AAPL	Stock	27.275	27.275	27.275	27.275	400.0
2016-04-18 07:33:00	AAPL	Stock	27.27	27.27	27.2625	27.2625	5800.0
2016-04-18 07:34:00	AAPL	Stock	27.25	27.255	27.125	27.2325	17972.0
2016-04-18 07:35:00	AAPL	Stock	27.2475	27.25	27.2475	27.25	1524.0
2016-04-18 07:36:00	AAPL	Stock	27.2475	27.2475	27.2375	27.2475	3600.0
2016-04-18 07:37:00	AAPL	Stock	27.245	27.26	27.2375	27.26	37328.0
2016-04-18 07:38:00	AAPL	Stock	27.26	27.26	27.24	27.24	2400.0

> showing 50 of 1,054,009 rows — these rows as CSV

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