PREVIEW / stock_1min / 2017-09-21

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-21.parquet
  size:    13.8 MB
  rows:    1,006,615
  symbols: 2,439

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-09-21 04:01:00	AAPL	Stock	39.0125	39.0125	39.0125	39.0125	400.0
2017-09-21 04:03:00	AAPL	Stock	39.025	39.025	39.025	39.025	400.0
2017-09-21 04:06:00	AAPL	Stock	39.05	39.05	39.05	39.05	1500.0
2017-09-21 04:08:00	AAPL	Stock	39.05	39.05	39.05	39.05	408.0
2017-09-21 04:10:00	AAPL	Stock	39.05	39.05	39.05	39.05	408.0
2017-09-21 04:15:00	AAPL	Stock	39.0	39.0	39.0	39.0	800.0
2017-09-21 04:29:00	AAPL	Stock	39.02	39.02	39.02	39.02	400.0
2017-09-21 05:00:00	AAPL	Stock	39.0	39.0	39.0	39.0	400.0
2017-09-21 05:03:00	AAPL	Stock	39.01	39.01	39.01	39.01	400.0
2017-09-21 05:09:00	AAPL	Stock	39.0	39.0	39.0	39.0	800.0
2017-09-21 05:11:00	AAPL	Stock	39.0	39.0	39.0	39.0	800.0
2017-09-21 05:13:00	AAPL	Stock	39.0	39.0	39.0	39.0	736.0
2017-09-21 05:21:00	AAPL	Stock	39.0	39.0	39.0	39.0	424.0
2017-09-21 05:34:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	748.0
2017-09-21 05:52:00	AAPL	Stock	38.9825	38.9825	38.9825	38.9825	896.0
2017-09-21 06:02:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	732.0
2017-09-21 06:05:00	AAPL	Stock	39.0225	39.025	39.0225	39.025	2304.0
2017-09-21 06:08:00	AAPL	Stock	39.025	39.025	39.025	39.025	480.0
2017-09-21 06:20:00	AAPL	Stock	38.975	38.975	38.975	38.975	3936.0
2017-09-21 06:27:00	AAPL	Stock	38.975	38.975	38.975	38.975	5880.0
2017-09-21 06:34:00	AAPL	Stock	38.975	38.975	38.9625	38.9625	1572.0
2017-09-21 06:43:00	AAPL	Stock	38.975	38.975	38.975	38.975	1372.0
2017-09-21 06:44:00	AAPL	Stock	38.975	38.975	38.975	38.975	604.0
2017-09-21 06:45:00	AAPL	Stock	38.9575	38.9575	38.9575	38.9575	748.0
2017-09-21 06:46:00	AAPL	Stock	38.9575	38.9625	38.9575	38.9625	2400.0
2017-09-21 06:48:00	AAPL	Stock	38.9575	38.9575	38.9575	38.9575	800.0
2017-09-21 06:53:00	AAPL	Stock	38.9375	38.955	38.9375	38.955	1664.0
2017-09-21 06:54:00	AAPL	Stock	38.955	38.9575	38.955	38.9575	800.0
2017-09-21 06:56:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	400.0
2017-09-21 06:57:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	2400.0
2017-09-21 06:58:00	AAPL	Stock	38.975	39.0	38.975	39.0	7744.0
2017-09-21 07:00:00	AAPL	Stock	39.0	39.0125	38.9625	39.0125	5548.0
2017-09-21 07:05:00	AAPL	Stock	38.99	38.99	38.99	38.99	480.0
2017-09-21 07:06:00	AAPL	Stock	38.99	38.99	38.99	38.99	2840.0
2017-09-21 07:07:00	AAPL	Stock	38.9875	38.9875	38.975	38.9775	6400.0
2017-09-21 07:15:00	AAPL	Stock	38.9975	38.9975	38.9975	38.9975	600.0
2017-09-21 07:17:00	AAPL	Stock	38.9675	38.995	38.9675	38.995	800.0
2017-09-21 07:19:00	AAPL	Stock	38.9775	38.9775	38.975	38.975	1600.0
2017-09-21 07:20:00	AAPL	Stock	38.9675	38.9675	38.9675	38.9675	800.0
2017-09-21 07:22:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	868.0
2017-09-21 07:23:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	800.0
2017-09-21 07:30:00	AAPL	Stock	38.95	38.95	38.9375	38.9375	2844.0
2017-09-21 07:31:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	400.0
2017-09-21 07:45:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	3340.0
2017-09-21 07:46:00	AAPL	Stock	38.955	38.955	38.955	38.955	532.0
2017-09-21 07:47:00	AAPL	Stock	38.965	38.965	38.955	38.955	2400.0
2017-09-21 07:48:00	AAPL	Stock	38.955	38.955	38.955	38.955	2000.0
2017-09-21 07:50:00	AAPL	Stock	38.965	38.965	38.965	38.965	3600.0
2017-09-21 07:51:00	AAPL	Stock	38.955	38.955	38.955	38.955	800.0
2017-09-21 07:57:00	AAPL	Stock	38.975	38.975	38.975	38.975	1780.0

> showing 50 of 1,006,615 rows — these rows as CSV

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