PREVIEW / stock_1min / 2017-01-04

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-04.parquet
  size:    15.5 MB
  rows:    1,108,733
  symbols: 2,612

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-01-04 04:15:00	AAPL	Stock	28.9925	28.9925	28.99	28.99	1484.0
2017-01-04 04:46:00	AAPL	Stock	29.0675	29.0675	29.0675	29.0675	1200.0
2017-01-04 04:54:00	AAPL	Stock	29.0675	29.0675	29.0675	29.0675	400.0
2017-01-04 06:05:00	AAPL	Stock	29.0375	29.075	29.0375	29.075	2092.0
2017-01-04 06:20:00	AAPL	Stock	29.05	29.05	29.0375	29.045	4672.0
2017-01-04 06:21:00	AAPL	Stock	29.05	29.05	29.05	29.05	1184.0
2017-01-04 06:28:00	AAPL	Stock	29.05	29.05	29.05	29.05	788.0
2017-01-04 06:31:00	AAPL	Stock	29.05	29.05	29.05	29.05	2000.0
2017-01-04 06:54:00	AAPL	Stock	29.02	29.02	29.02	29.02	2000.0
2017-01-04 07:06:00	AAPL	Stock	29.05	29.05	29.05	29.05	1976.0
2017-01-04 07:09:00	AAPL	Stock	29.05	29.05	29.05	29.05	500.0
2017-01-04 07:10:00	AAPL	Stock	29.0625	29.075	29.0625	29.075	2800.0
2017-01-04 07:12:00	AAPL	Stock	29.0275	29.0275	29.0275	29.0275	400.0
2017-01-04 07:19:00	AAPL	Stock	29.03	29.03	29.025	29.025	6400.0
2017-01-04 07:21:00	AAPL	Stock	29.02	29.02	29.02	29.02	2000.0
2017-01-04 07:22:00	AAPL	Stock	29.025	29.025	29.025	29.025	1200.0
2017-01-04 07:23:00	AAPL	Stock	29.025	29.025	29.025	29.025	400.0
2017-01-04 07:24:00	AAPL	Stock	29.02	29.02	29.02	29.02	1600.0
2017-01-04 07:27:00	AAPL	Stock	29.0125	29.0125	28.9875	28.9875	18160.0
2017-01-04 07:32:00	AAPL	Stock	28.975	28.975	28.975	28.975	4400.0
2017-01-04 07:33:00	AAPL	Stock	28.9725	28.9725	28.9725	28.9725	800.0
2017-01-04 07:34:00	AAPL	Stock	28.9725	28.9725	28.9675	28.9675	2800.0
2017-01-04 07:35:00	AAPL	Stock	28.965	28.965	28.9625	28.9625	1800.0
2017-01-04 07:36:00	AAPL	Stock	28.965	28.965	28.9625	28.9625	1400.0
2017-01-04 07:37:00	AAPL	Stock	28.975	28.975	28.975	28.975	400.0
2017-01-04 07:40:00	AAPL	Stock	28.9825	28.9825	28.9825	28.9825	400.0
2017-01-04 07:45:00	AAPL	Stock	28.9825	28.9825	28.9825	28.9825	1600.0
2017-01-04 07:47:00	AAPL	Stock	28.9675	28.9675	28.9625	28.9625	12400.0
2017-01-04 07:51:00	AAPL	Stock	28.9675	28.9675	28.955	28.955	7888.0
2017-01-04 07:52:00	AAPL	Stock	28.955	28.9625	28.95	28.9525	19540.0
2017-01-04 07:53:00	AAPL	Stock	28.955	28.955	28.95	28.95	23708.0
2017-01-04 08:00:00	AAPL	Stock	28.9625	29.025	28.9625	28.9625	8800.0
2017-01-04 08:01:00	AAPL	Stock	28.9925	28.9925	28.9925	28.9925	2000.0
2017-01-04 08:02:00	AAPL	Stock	28.99	28.9925	28.99	28.9925	5200.0
2017-01-04 08:05:00	AAPL	Stock	28.9875	28.9925	28.9875	28.9875	7200.0
2017-01-04 08:15:00	AAPL	Stock	28.9925	28.9925	28.99	28.99	1200.0
2017-01-04 08:16:00	AAPL	Stock	28.99	29.0225	28.99	29.0225	7160.0
2017-01-04 08:17:00	AAPL	Stock	29.005	29.005	29.0025	29.005	24000.0
2017-01-04 08:19:00	AAPL	Stock	29.0225	29.0225	29.0225	29.0225	2800.0
2017-01-04 08:23:00	AAPL	Stock	29.0025	29.0025	29.0025	29.0025	3600.0
2017-01-04 08:30:00	AAPL	Stock	29.005	29.005	29.005	29.005	2004.0
2017-01-04 08:31:00	AAPL	Stock	29.005	29.005	28.9775	28.9825	7628.0
2017-01-04 08:32:00	AAPL	Stock	28.9825	28.9825	28.9775	28.9775	8000.0
2017-01-04 08:36:00	AAPL	Stock	28.975	28.9775	28.975	28.9775	2000.0
2017-01-04 08:38:00	AAPL	Stock	29.005	29.0075	29.0	29.0075	5200.0
2017-01-04 08:39:00	AAPL	Stock	29.0075	29.01	29.0075	29.01	4000.0
2017-01-04 08:40:00	AAPL	Stock	29.01	29.01	28.985	28.985	1700.0
2017-01-04 08:43:00	AAPL	Stock	28.985	28.9875	28.985	28.9875	2400.0
2017-01-04 08:44:00	AAPL	Stock	28.9975	28.9975	28.9975	28.9975	2000.0
2017-01-04 08:45:00	AAPL	Stock	28.99	28.99	28.99	28.99	5520.0

> showing 50 of 1,108,733 rows — these rows as CSV

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