PREVIEW / stock_1min / 2017-01-31

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-31.parquet
  size:    14.6 MB
  rows:    1,058,549
  symbols: 2,580

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-31 04:24:00	AAPL	Stock	30.3375	30.3375	30.3375	30.3375	400.0
2017-01-31 04:25:00	AAPL	Stock	30.36	30.36	30.305	30.305	1544.0
2017-01-31 05:00:00	AAPL	Stock	30.4	30.4	30.4	30.4	2000.0
2017-01-31 05:21:00	AAPL	Stock	30.395	30.395	30.395	30.395	400.0
2017-01-31 05:36:00	AAPL	Stock	30.3725	30.3725	30.3725	30.3725	2000.0
2017-01-31 05:53:00	AAPL	Stock	30.37	30.37	30.37	30.37	3596.0
2017-01-31 06:13:00	AAPL	Stock	30.375	30.3925	30.345	30.345	8304.0
2017-01-31 06:35:00	AAPL	Stock	30.3875	30.3875	30.3875	30.3875	3200.0
2017-01-31 06:38:00	AAPL	Stock	30.3875	30.3875	30.3875	30.3875	800.0
2017-01-31 06:39:00	AAPL	Stock	30.385	30.385	30.385	30.385	3200.0
2017-01-31 06:40:00	AAPL	Stock	30.4	30.4075	30.4	30.4075	4200.0
2017-01-31 06:47:00	AAPL	Stock	30.4125	30.4125	30.395	30.4125	3960.0
2017-01-31 06:49:00	AAPL	Stock	30.4	30.4	30.4	30.4	400.0
2017-01-31 06:55:00	AAPL	Stock	30.395	30.395	30.395	30.395	820.0
2017-01-31 07:00:00	AAPL	Stock	30.3875	30.3875	30.3875	30.3875	1792.0
2017-01-31 07:03:00	AAPL	Stock	30.3975	30.3975	30.3975	30.3975	3708.0
2017-01-31 07:04:00	AAPL	Stock	30.3975	30.3975	30.3975	30.3975	2000.0
2017-01-31 07:06:00	AAPL	Stock	30.3875	30.3875	30.3875	30.3875	1600.0
2017-01-31 07:07:00	AAPL	Stock	30.3975	30.4	30.3975	30.4	3780.0
2017-01-31 07:10:00	AAPL	Stock	30.4	30.4	30.3875	30.3875	5200.0
2017-01-31 07:12:00	AAPL	Stock	30.385	30.3875	30.3825	30.3875	3000.0
2017-01-31 07:13:00	AAPL	Stock	30.385	30.385	30.385	30.385	400.0
2017-01-31 07:14:00	AAPL	Stock	30.3875	30.3875	30.3875	30.3875	2000.0
2017-01-31 07:15:00	AAPL	Stock	30.3875	30.3875	30.385	30.385	1200.0
2017-01-31 07:16:00	AAPL	Stock	30.425	30.425	30.3775	30.3775	12400.0
2017-01-31 07:26:00	AAPL	Stock	30.375	30.375	30.375	30.375	400.0
2017-01-31 07:28:00	AAPL	Stock	30.3825	30.3825	30.3825	30.3825	400.0
2017-01-31 07:29:00	AAPL	Stock	30.3775	30.3775	30.3775	30.3775	1200.0
2017-01-31 07:30:00	AAPL	Stock	30.38	30.38	30.38	30.38	400.0
2017-01-31 07:32:00	AAPL	Stock	30.3875	30.3875	30.3825	30.3825	6800.0
2017-01-31 07:34:00	AAPL	Stock	30.375	30.375	30.37	30.37	4800.0
2017-01-31 07:40:00	AAPL	Stock	30.365	30.365	30.3625	30.3625	2016.0
2017-01-31 07:42:00	AAPL	Stock	30.365	30.365	30.3625	30.3625	5300.0
2017-01-31 07:44:00	AAPL	Stock	30.355	30.355	30.3525	30.3525	4800.0
2017-01-31 07:53:00	AAPL	Stock	30.34	30.34	30.34	30.34	604.0
2017-01-31 07:56:00	AAPL	Stock	30.3475	30.3475	30.3475	30.3475	400.0
2017-01-31 08:00:00	AAPL	Stock	30.4	30.4	30.3275	30.3375	72964.0
2017-01-31 08:01:00	AAPL	Stock	30.3375	30.3375	30.3375	30.3375	1200.0
2017-01-31 08:02:00	AAPL	Stock	30.35	30.35	30.35	30.35	400.0
2017-01-31 08:03:00	AAPL	Stock	30.35	30.35	30.35	30.35	400.0
2017-01-31 08:04:00	AAPL	Stock	30.355	30.355	30.35	30.355	7444.0
2017-01-31 08:05:00	AAPL	Stock	30.355	30.355	30.355	30.355	400.0
2017-01-31 08:06:00	AAPL	Stock	30.35	30.355	30.35	30.355	6400.0
2017-01-31 08:09:00	AAPL	Stock	30.35	30.35	30.35	30.35	400.0
2017-01-31 08:10:00	AAPL	Stock	30.35	30.355	30.35	30.355	1400.0
2017-01-31 08:11:00	AAPL	Stock	30.35	30.35	30.33	30.33	3936.0
2017-01-31 08:15:00	AAPL	Stock	30.3425	30.3425	30.3425	30.3425	1200.0
2017-01-31 08:17:00	AAPL	Stock	30.3425	30.3425	30.3425	30.3425	4600.0
2017-01-31 08:19:00	AAPL	Stock	30.33	30.33	30.3275	30.3275	3236.0
2017-01-31 08:20:00	AAPL	Stock	30.3275	30.3275	30.3275	30.3275	400.0

> showing 50 of 1,058,549 rows — these rows as CSV

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