PREVIEW / stock_1min / 2017-06-29

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-06-29.parquet
  size:    15.2 MB
  rows:    1,087,821
  symbols: 2,500

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-06-29 04:17:00	AAPL	Stock	36.4475	36.45	36.4475	36.45	3064.0
2017-06-29 04:18:00	AAPL	Stock	36.41	36.41	36.41	36.41	4000.0
2017-06-29 04:22:00	AAPL	Stock	36.41	36.41	36.41	36.41	800.0
2017-06-29 04:31:00	AAPL	Stock	36.41	36.41	36.4075	36.4075	2400.0
2017-06-29 04:32:00	AAPL	Stock	36.4075	36.4075	36.4075	36.4075	400.0
2017-06-29 04:44:00	AAPL	Stock	36.385	36.385	36.385	36.385	1200.0
2017-06-29 05:21:00	AAPL	Stock	36.375	36.375	36.3725	36.3725	2000.0
2017-06-29 05:23:00	AAPL	Stock	36.3825	36.3825	36.3825	36.3825	3820.0
2017-06-29 05:29:00	AAPL	Stock	36.3925	36.3925	36.3925	36.3925	1004.0
2017-06-29 05:34:00	AAPL	Stock	36.3925	36.3925	36.3925	36.3925	400.0
2017-06-29 05:35:00	AAPL	Stock	36.3925	36.3925	36.3925	36.3925	400.0
2017-06-29 05:40:00	AAPL	Stock	36.3825	36.3825	36.3825	36.3825	400.0
2017-06-29 05:41:00	AAPL	Stock	36.38	36.38	36.38	36.38	400.0
2017-06-29 05:42:00	AAPL	Stock	36.365	36.365	36.365	36.365	2796.0
2017-06-29 05:43:00	AAPL	Stock	36.36	36.36	36.36	36.36	1564.0
2017-06-29 05:46:00	AAPL	Stock	36.36	36.36	36.3475	36.3475	1920.0
2017-06-29 06:09:00	AAPL	Stock	36.3525	36.3525	36.3475	36.3475	1600.0
2017-06-29 06:12:00	AAPL	Stock	36.3375	36.3375	36.335	36.335	2000.0
2017-06-29 06:15:00	AAPL	Stock	36.335	36.335	36.3225	36.325	9200.0
2017-06-29 06:19:00	AAPL	Stock	36.33	36.33	36.33	36.33	4000.0
2017-06-29 06:21:00	AAPL	Stock	36.315	36.315	36.315	36.315	3220.0
2017-06-29 06:29:00	AAPL	Stock	36.33	36.33	36.33	36.33	400.0
2017-06-29 06:33:00	AAPL	Stock	36.33	36.33	36.33	36.33	2000.0
2017-06-29 06:35:00	AAPL	Stock	36.3275	36.3275	36.3275	36.3275	400.0
2017-06-29 06:36:00	AAPL	Stock	36.32	36.32	36.315	36.315	2780.0
2017-06-29 06:37:00	AAPL	Stock	36.315	36.315	36.315	36.315	1200.0
2017-06-29 06:39:00	AAPL	Stock	36.31	36.31	36.31	36.31	1600.0
2017-06-29 06:45:00	AAPL	Stock	36.325	36.325	36.325	36.325	1980.0
2017-06-29 06:59:00	AAPL	Stock	36.325	36.325	36.3225	36.3225	4000.0
2017-06-29 07:00:00	AAPL	Stock	36.325	36.35	36.325	36.35	6400.0
2017-06-29 07:03:00	AAPL	Stock	36.3675	36.375	36.3675	36.375	2048.0
2017-06-29 07:10:00	AAPL	Stock	36.3725	36.3725	36.3725	36.3725	1600.0
2017-06-29 07:11:00	AAPL	Stock	36.3725	36.3725	36.3725	36.3725	1200.0
2017-06-29 07:12:00	AAPL	Stock	36.3725	36.3725	36.3725	36.3725	1200.0
2017-06-29 07:13:00	AAPL	Stock	36.3725	36.4025	36.3725	36.3975	11524.0
2017-06-29 07:14:00	AAPL	Stock	36.4025	36.4025	36.4025	36.4025	1840.0
2017-06-29 07:16:00	AAPL	Stock	36.375	36.385	36.375	36.385	1200.0
2017-06-29 07:17:00	AAPL	Stock	36.38	36.38	36.38	36.38	400.0
2017-06-29 07:18:00	AAPL	Stock	36.375	36.3975	36.375	36.3975	3600.0
2017-06-29 07:19:00	AAPL	Stock	36.4025	36.4025	36.4025	36.4025	2408.0
2017-06-29 07:20:00	AAPL	Stock	36.4025	36.4025	36.4025	36.4025	6240.0
2017-06-29 07:25:00	AAPL	Stock	36.4	36.4	36.3975	36.3975	2000.0
2017-06-29 07:27:00	AAPL	Stock	36.3875	36.3875	36.3875	36.3875	1600.0
2017-06-29 07:29:00	AAPL	Stock	36.395	36.4025	36.395	36.4025	6248.0
2017-06-29 07:30:00	AAPL	Stock	36.4125	36.4125	36.4125	36.4125	1036.0
2017-06-29 07:34:00	AAPL	Stock	36.415	36.415	36.4125	36.4125	2400.0
2017-06-29 07:35:00	AAPL	Stock	36.4125	36.4125	36.4125	36.4125	1080.0
2017-06-29 07:36:00	AAPL	Stock	36.4325	36.4325	36.4325	36.4325	564.0
2017-06-29 07:38:00	AAPL	Stock	36.4325	36.435	36.4325	36.435	2684.0
2017-06-29 07:40:00	AAPL	Stock	36.425	36.425	36.4125	36.4125	6620.0

> showing 50 of 1,087,821 rows — these rows as CSV

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