PREVIEW / stock_1min / 2017-05-18

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-05-18.parquet
  size:    15.2 MB
  rows:    1,096,872
  symbols: 2,501

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-18 04:16:00	AAPL	Stock	37.625	37.625	37.625	37.625	640.0
2017-05-18 04:23:00	AAPL	Stock	37.5925	37.5925	37.5925	37.5925	504.0
2017-05-18 04:29:00	AAPL	Stock	37.6125	37.6175	37.6125	37.6175	4356.0
2017-05-18 04:30:00	AAPL	Stock	37.6175	37.6175	37.6175	37.6175	1644.0
2017-05-18 04:40:00	AAPL	Stock	37.625	37.625	37.625	37.625	700.0
2017-05-18 04:42:00	AAPL	Stock	37.625	37.625	37.625	37.625	3200.0
2017-05-18 04:59:00	AAPL	Stock	37.655	37.655	37.655	37.655	800.0
2017-05-18 05:01:00	AAPL	Stock	37.655	37.655	37.655	37.655	400.0
2017-05-18 05:03:00	AAPL	Stock	37.625	37.625	37.625	37.625	400.0
2017-05-18 05:04:00	AAPL	Stock	37.6225	37.6225	37.6075	37.6075	2400.0
2017-05-18 05:06:00	AAPL	Stock	37.5875	37.5875	37.5625	37.5625	1200.0
2017-05-18 05:09:00	AAPL	Stock	37.5375	37.5375	37.5375	37.5375	400.0
2017-05-18 05:16:00	AAPL	Stock	37.6	37.6075	37.6	37.6075	800.0
2017-05-18 05:19:00	AAPL	Stock	37.5	37.5	37.5	37.5	1052.0
2017-05-18 05:27:00	AAPL	Stock	37.5	37.5	37.5	37.5	400.0
2017-05-18 05:31:00	AAPL	Stock	37.475	37.475	37.475	37.475	800.0
2017-05-18 05:35:00	AAPL	Stock	37.43	37.43	37.43	37.43	400.0
2017-05-18 05:39:00	AAPL	Stock	37.4725	37.475	37.465	37.475	5200.0
2017-05-18 05:40:00	AAPL	Stock	37.475	37.4875	37.475	37.4875	1600.0
2017-05-18 05:41:00	AAPL	Stock	37.5	37.5175	37.5	37.5175	1200.0
2017-05-18 05:42:00	AAPL	Stock	37.4875	37.4875	37.4875	37.4875	400.0
2017-05-18 05:43:00	AAPL	Stock	37.4875	37.4875	37.4875	37.4875	400.0
2017-05-18 05:44:00	AAPL	Stock	37.475	37.475	37.4625	37.4625	9932.0
2017-05-18 05:49:00	AAPL	Stock	37.45	37.45	37.45	37.45	8000.0
2017-05-18 05:58:00	AAPL	Stock	37.435	37.45	37.435	37.45	2000.0
2017-05-18 06:00:00	AAPL	Stock	37.4625	37.4625	37.4625	37.4625	1600.0
2017-05-18 06:01:00	AAPL	Stock	37.4375	37.4375	37.4375	37.4375	9948.0
2017-05-18 06:02:00	AAPL	Stock	37.4375	37.4625	37.4375	37.4625	1892.0
2017-05-18 06:03:00	AAPL	Stock	37.4375	37.4375	37.4375	37.4375	2516.0
2017-05-18 06:05:00	AAPL	Stock	37.4375	37.4375	37.4375	37.4375	400.0
2017-05-18 06:06:00	AAPL	Stock	37.4275	37.4275	37.4275	37.4275	3180.0
2017-05-18 06:12:00	AAPL	Stock	37.4625	37.4625	37.4625	37.4625	804.0
2017-05-18 06:14:00	AAPL	Stock	37.4375	37.4375	37.4375	37.4375	5112.0
2017-05-18 06:15:00	AAPL	Stock	37.4375	37.4375	37.4375	37.4375	4000.0
2017-05-18 06:16:00	AAPL	Stock	37.4625	37.4625	37.4375	37.4625	9200.0
2017-05-18 06:23:00	AAPL	Stock	37.4625	37.4625	37.4625	37.4625	400.0
2017-05-18 06:27:00	AAPL	Stock	37.4825	37.4825	37.465	37.465	4240.0
2017-05-18 06:28:00	AAPL	Stock	37.44	37.44	37.44	37.44	8000.0
2017-05-18 06:29:00	AAPL	Stock	37.44	37.44	37.4375	37.4375	13600.0
2017-05-18 06:30:00	AAPL	Stock	37.475	37.475	37.44	37.44	2000.0
2017-05-18 06:32:00	AAPL	Stock	37.46	37.46	37.46	37.46	1200.0
2017-05-18 06:33:00	AAPL	Stock	37.4625	37.4625	37.4625	37.4625	560.0
2017-05-18 06:35:00	AAPL	Stock	37.4925	37.4925	37.4925	37.4925	400.0
2017-05-18 06:38:00	AAPL	Stock	37.475	37.475	37.475	37.475	600.0
2017-05-18 06:39:00	AAPL	Stock	37.45	37.45	37.45	37.45	600.0
2017-05-18 06:40:00	AAPL	Stock	37.45	37.45	37.45	37.45	400.0
2017-05-18 06:53:00	AAPL	Stock	37.45	37.45	37.4275	37.4275	18100.0
2017-05-18 06:54:00	AAPL	Stock	37.4275	37.4275	37.4025	37.4025	12520.0
2017-05-18 06:55:00	AAPL	Stock	37.425	37.425	37.425	37.425	800.0
2017-05-18 07:00:00	AAPL	Stock	37.425	37.425	37.425	37.425	2800.0

> showing 50 of 1,096,872 rows — these rows as CSV

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