PREVIEW / stock_1min / 2017-10-24

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-24.parquet
  size:    14.4 MB
  rows:    1,043,359
  symbols: 2,434

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-10-24 04:00:00	AAPL	Stock	38.825	39.05	38.825	39.05	1200.0
2017-10-24 04:05:00	AAPL	Stock	39.0875	39.0875	39.0875	39.0875	400.0
2017-10-24 04:06:00	AAPL	Stock	39.1225	39.1225	39.1225	39.1225	400.0
2017-10-24 04:07:00	AAPL	Stock	39.1225	39.1375	39.1225	39.125	2400.0
2017-10-24 04:10:00	AAPL	Stock	39.125	39.125	39.125	39.125	2000.0
2017-10-24 04:12:00	AAPL	Stock	39.125	39.125	39.125	39.125	400.0
2017-10-24 04:19:00	AAPL	Stock	39.125	39.125	39.125	39.125	400.0
2017-10-24 04:22:00	AAPL	Stock	39.125	39.125	39.125	39.125	4320.0
2017-10-24 04:23:00	AAPL	Stock	39.1875	39.1875	39.1875	39.1875	1200.0
2017-10-24 04:26:00	AAPL	Stock	39.125	39.125	39.125	39.125	5768.0
2017-10-24 04:27:00	AAPL	Stock	39.125	39.125	39.125	39.125	400.0
2017-10-24 04:28:00	AAPL	Stock	39.125	39.125	39.125	39.125	6000.0
2017-10-24 04:29:00	AAPL	Stock	39.125	39.125	39.125	39.125	2800.0
2017-10-24 04:30:00	AAPL	Stock	39.125	39.125	39.125	39.125	4000.0
2017-10-24 04:35:00	AAPL	Stock	39.125	39.125	39.125	39.125	800.0
2017-10-24 04:40:00	AAPL	Stock	39.125	39.125	39.1125	39.1125	2800.0
2017-10-24 04:41:00	AAPL	Stock	39.1125	39.1125	39.1125	39.1125	800.0
2017-10-24 05:16:00	AAPL	Stock	39.1125	39.1125	39.1125	39.1125	400.0
2017-10-24 05:19:00	AAPL	Stock	39.1675	39.1875	39.1675	39.1875	9368.0
2017-10-24 05:34:00	AAPL	Stock	39.1725	39.185	39.1725	39.185	3700.0
2017-10-24 05:45:00	AAPL	Stock	39.085	39.085	39.025	39.025	14680.0
2017-10-24 05:46:00	AAPL	Stock	39.0	39.0	39.0	39.0	4800.0
2017-10-24 05:47:00	AAPL	Stock	39.0025	39.0025	39.0	39.0	5200.0
2017-10-24 05:48:00	AAPL	Stock	38.9425	38.9425	38.9425	38.9425	1600.0
2017-10-24 05:49:00	AAPL	Stock	38.9025	38.9425	38.9	38.9	19380.0
2017-10-24 05:53:00	AAPL	Stock	38.925	38.925	38.925	38.925	744.0
2017-10-24 05:54:00	AAPL	Stock	38.8775	38.88	38.85	38.85	3200.0
2017-10-24 05:55:00	AAPL	Stock	38.865	38.865	38.86	38.86	2800.0
2017-10-24 05:57:00	AAPL	Stock	38.85	38.86	38.85	38.86	4856.0
2017-10-24 05:58:00	AAPL	Stock	38.8375	38.8375	38.8075	38.8075	12416.0
2017-10-24 05:59:00	AAPL	Stock	38.8	38.8075	38.775	38.775	3200.0
2017-10-24 06:01:00	AAPL	Stock	38.7625	38.7625	38.75	38.75	5732.0
2017-10-24 06:02:00	AAPL	Stock	38.805	38.805	38.805	38.805	400.0
2017-10-24 06:03:00	AAPL	Stock	38.825	38.825	38.825	38.825	920.0
2017-10-24 06:05:00	AAPL	Stock	38.7575	38.7575	38.7575	38.7575	2000.0
2017-10-24 06:06:00	AAPL	Stock	38.7575	38.7575	38.755	38.755	2000.0
2017-10-24 06:07:00	AAPL	Stock	38.765	38.765	38.765	38.765	400.0
2017-10-24 06:08:00	AAPL	Stock	38.7575	38.7575	38.75	38.755	6000.0
2017-10-24 06:09:00	AAPL	Stock	38.7375	38.7375	38.7325	38.7325	6060.0
2017-10-24 06:12:00	AAPL	Stock	38.7325	38.7325	38.7325	38.7325	400.0
2017-10-24 06:13:00	AAPL	Stock	38.75	38.75	38.75	38.75	1000.0
2017-10-24 06:14:00	AAPL	Stock	38.75	38.75	38.75	38.75	3000.0
2017-10-24 06:15:00	AAPL	Stock	38.82	38.82	38.75	38.75	3600.0
2017-10-24 06:16:00	AAPL	Stock	38.75	38.825	38.75	38.8125	9200.0
2017-10-24 06:17:00	AAPL	Stock	38.8125	38.8125	38.8125	38.8125	2400.0
2017-10-24 06:19:00	AAPL	Stock	38.8125	38.825	38.8125	38.8125	2800.0
2017-10-24 06:22:00	AAPL	Stock	38.8	38.8	38.8	38.8	2000.0
2017-10-24 06:23:00	AAPL	Stock	38.8	38.8	38.8	38.8	800.0
2017-10-24 06:25:00	AAPL	Stock	38.8	38.8	38.8	38.8	1240.0
2017-10-24 06:26:00	AAPL	Stock	38.8	38.8	38.8	38.8	744.0

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

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