PREVIEW / stock_1min / 2017-08-04

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-04.parquet
  size:    14.1 MB
  rows:    1,025,931
  symbols: 2,471

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-08-04 04:01:00	AAPL	Stock	38.925	38.9725	38.925	38.9725	2272.0
2017-08-04 06:01:00	AAPL	Stock	38.9725	38.9725	38.9725	38.9725	3244.0
2017-08-04 06:02:00	AAPL	Stock	38.9725	38.975	38.9725	38.975	2000.0
2017-08-04 06:03:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	400.0
2017-08-04 06:29:00	AAPL	Stock	38.945	38.945	38.945	38.945	1200.0
2017-08-04 06:30:00	AAPL	Stock	38.945	38.96	38.945	38.96	2800.0
2017-08-04 06:40:00	AAPL	Stock	38.9575	38.9575	38.9575	38.9575	400.0
2017-08-04 06:44:00	AAPL	Stock	38.9575	38.9575	38.9575	38.9575	1200.0
2017-08-04 06:47:00	AAPL	Stock	38.955	38.955	38.955	38.955	400.0
2017-08-04 07:01:00	AAPL	Stock	38.9375	38.9375	38.93	38.93	2412.0
2017-08-04 07:09:00	AAPL	Stock	38.955	38.955	38.955	38.955	2400.0
2017-08-04 07:10:00	AAPL	Stock	38.95	38.95	38.95	38.95	1200.0
2017-08-04 07:12:00	AAPL	Stock	38.95	38.95	38.95	38.95	1200.0
2017-08-04 07:20:00	AAPL	Stock	38.955	38.955	38.955	38.955	4000.0
2017-08-04 07:21:00	AAPL	Stock	38.95	38.955	38.95	38.955	820.0
2017-08-04 07:31:00	AAPL	Stock	38.9625	38.9625	38.945	38.945	5600.0
2017-08-04 07:32:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	400.0
2017-08-04 07:34:00	AAPL	Stock	38.95	38.95	38.95	38.95	2040.0
2017-08-04 07:35:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	400.0
2017-08-04 07:37:00	AAPL	Stock	38.9675	38.9675	38.9675	38.9675	400.0
2017-08-04 07:38:00	AAPL	Stock	38.955	38.955	38.955	38.955	400.0
2017-08-04 07:45:00	AAPL	Stock	38.955	38.955	38.955	38.955	1200.0
2017-08-04 07:46:00	AAPL	Stock	38.955	38.955	38.955	38.955	460.0
2017-08-04 07:52:00	AAPL	Stock	38.95	38.95	38.95	38.95	2152.0
2017-08-04 07:55:00	AAPL	Stock	38.95	38.95	38.95	38.95	400.0
2017-08-04 07:58:00	AAPL	Stock	38.955	38.955	38.955	38.955	400.0
2017-08-04 08:00:00	AAPL	Stock	38.95	38.975	38.95	38.9675	8432.0
2017-08-04 08:01:00	AAPL	Stock	38.9475	38.9475	38.9475	38.9475	800.0
2017-08-04 08:02:00	AAPL	Stock	38.9475	38.9475	38.945	38.945	1280.0
2017-08-04 08:03:00	AAPL	Stock	38.9475	38.955	38.9475	38.955	2960.0
2017-08-04 08:04:00	AAPL	Stock	38.955	38.955	38.955	38.955	1200.0
2017-08-04 08:06:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	700.0
2017-08-04 08:08:00	AAPL	Stock	38.9675	38.9675	38.9675	38.9675	1200.0
2017-08-04 08:09:00	AAPL	Stock	38.95	38.9675	38.95	38.9675	1200.0
2017-08-04 08:14:00	AAPL	Stock	38.9625	38.965	38.9625	38.965	4000.0
2017-08-04 08:15:00	AAPL	Stock	38.965	38.965	38.965	38.965	400.0
2017-08-04 08:17:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	580.0
2017-08-04 08:18:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	560.0
2017-08-04 08:19:00	AAPL	Stock	38.955	38.955	38.955	38.955	500.0
2017-08-04 08:20:00	AAPL	Stock	38.96	38.96	38.96	38.96	400.0
2017-08-04 08:24:00	AAPL	Stock	38.96	38.9675	38.95	38.9675	3420.0
2017-08-04 08:26:00	AAPL	Stock	38.9675	38.9675	38.9675	38.9675	400.0
2017-08-04 08:27:00	AAPL	Stock	38.9625	38.9625	38.9625	38.9625	600.0
2017-08-04 08:29:00	AAPL	Stock	38.96	38.96	38.96	38.96	1200.0
2017-08-04 08:30:00	AAPL	Stock	38.9675	38.9875	38.9675	38.9875	14472.0
2017-08-04 08:31:00	AAPL	Stock	38.99	39.0325	38.99	39.0325	34004.0
2017-08-04 08:32:00	AAPL	Stock	39.03	39.0325	39.01	39.0325	8960.0
2017-08-04 08:33:00	AAPL	Stock	39.0325	39.0325	39.025	39.0325	1600.0
2017-08-04 08:34:00	AAPL	Stock	39.0125	39.0375	39.0125	39.0375	4000.0
2017-08-04 08:35:00	AAPL	Stock	39.0375	39.05	39.0375	39.05	12908.0

> showing 50 of 1,025,931 rows — these rows as CSV

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