PREVIEW / stock_1min / 2017-11-03

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-11-03.parquet
  size:    14.7 MB
  rows:    1,063,415
  symbols: 2,451

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-11-03 04:00:00	AAPL	Stock	43.3875	43.4525	43.3875	43.4525	16852.0
2017-11-03 04:01:00	AAPL	Stock	43.4375	43.4375	43.4375	43.4375	1000.0
2017-11-03 04:02:00	AAPL	Stock	43.435	43.435	43.375	43.4	14200.0
2017-11-03 04:05:00	AAPL	Stock	43.425	43.425	43.425	43.425	2804.0
2017-11-03 04:07:00	AAPL	Stock	43.435	43.46	43.435	43.46	4464.0
2017-11-03 04:08:00	AAPL	Stock	43.45	43.45	43.45	43.45	2444.0
2017-11-03 04:09:00	AAPL	Stock	43.45	43.45	43.425	43.45	8616.0
2017-11-03 04:12:00	AAPL	Stock	43.465	43.465	43.465	43.465	800.0
2017-11-03 04:14:00	AAPL	Stock	43.4675	43.4675	43.4675	43.4675	1200.0
2017-11-03 04:16:00	AAPL	Stock	43.4775	43.4875	43.4475	43.4475	5488.0
2017-11-03 04:17:00	AAPL	Stock	43.45	43.45	43.45	43.45	400.0
2017-11-03 04:18:00	AAPL	Stock	43.45	43.4875	43.45	43.4875	2600.0
2017-11-03 04:21:00	AAPL	Stock	43.4875	43.4875	43.4875	43.4875	400.0
2017-11-03 04:22:00	AAPL	Stock	43.4875	43.4875	43.4875	43.4875	800.0
2017-11-03 04:24:00	AAPL	Stock	43.4925	43.4925	43.4925	43.4925	4448.0
2017-11-03 04:25:00	AAPL	Stock	43.4875	43.4875	43.4875	43.4875	400.0
2017-11-03 04:26:00	AAPL	Stock	43.4875	43.4875	43.4625	43.4625	3236.0
2017-11-03 04:27:00	AAPL	Stock	43.4475	43.4475	43.4325	43.44	5000.0
2017-11-03 04:28:00	AAPL	Stock	43.4175	43.4175	43.4175	43.4175	444.0
2017-11-03 04:30:00	AAPL	Stock	43.4125	43.4125	43.3725	43.3725	7008.0
2017-11-03 04:32:00	AAPL	Stock	43.3625	43.3625	43.3625	43.3625	400.0
2017-11-03 04:34:00	AAPL	Stock	43.3775	43.3775	43.3775	43.3775	400.0
2017-11-03 04:37:00	AAPL	Stock	43.3925	43.3925	43.3925	43.3925	400.0
2017-11-03 04:38:00	AAPL	Stock	43.375	43.375	43.375	43.375	800.0
2017-11-03 04:39:00	AAPL	Stock	43.3625	43.3625	43.35	43.35	5200.0
2017-11-03 04:40:00	AAPL	Stock	43.39	43.39	43.39	43.39	800.0
2017-11-03 04:42:00	AAPL	Stock	43.3925	43.3925	43.3925	43.3925	600.0
2017-11-03 04:45:00	AAPL	Stock	43.4075	43.4225	43.4	43.4	3160.0
2017-11-03 04:48:00	AAPL	Stock	43.4325	43.4325	43.4325	43.4325	1528.0
2017-11-03 04:50:00	AAPL	Stock	43.4375	43.4375	43.4375	43.4375	7904.0
2017-11-03 04:54:00	AAPL	Stock	43.4375	43.4375	43.4375	43.4375	400.0
2017-11-03 04:55:00	AAPL	Stock	43.4375	43.4425	43.4375	43.4425	3600.0
2017-11-03 04:56:00	AAPL	Stock	43.4475	43.4475	43.4475	43.4475	400.0
2017-11-03 05:00:00	AAPL	Stock	43.4375	43.4375	43.4375	43.4375	2000.0
2017-11-03 05:04:00	AAPL	Stock	43.415	43.4175	43.375	43.4025	2016.0
2017-11-03 05:08:00	AAPL	Stock	43.435	43.435	43.435	43.435	520.0
2017-11-03 05:10:00	AAPL	Stock	43.45	43.45	43.45	43.45	912.0
2017-11-03 05:13:00	AAPL	Stock	43.4375	43.4375	43.4375	43.4375	400.0
2017-11-03 05:14:00	AAPL	Stock	43.4175	43.4175	43.4175	43.4175	1836.0
2017-11-03 05:15:00	AAPL	Stock	43.45	43.4525	43.45	43.4525	1288.0
2017-11-03 05:17:00	AAPL	Stock	43.45	43.45	43.45	43.45	1200.0
2017-11-03 05:25:00	AAPL	Stock	43.45	43.45	43.4475	43.45	2800.0
2017-11-03 05:27:00	AAPL	Stock	43.45	43.45	43.395	43.4175	25976.0
2017-11-03 05:28:00	AAPL	Stock	43.4175	43.4175	43.375	43.3875	3160.0
2017-11-03 05:29:00	AAPL	Stock	43.375	43.375	43.375	43.375	900.0
2017-11-03 05:30:00	AAPL	Stock	43.3975	43.4	43.3475	43.3475	2672.0
2017-11-03 05:31:00	AAPL	Stock	43.4025	43.4075	43.4025	43.4075	6000.0
2017-11-03 05:34:00	AAPL	Stock	43.4	43.4	43.375	43.375	2780.0
2017-11-03 05:35:00	AAPL	Stock	43.375	43.4	43.375	43.375	8976.0
2017-11-03 05:36:00	AAPL	Stock	43.375	43.375	43.3725	43.3725	14676.0

> showing 50 of 1,063,415 rows — these rows as CSV

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