PREVIEW / stock_1min / 2018-07-26

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-26.parquet
  size:    14.7 MB
  rows:    1,062,785
  symbols: 2,357

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
2018-07-26 04:00:00	AAPL	Stock	48.205	48.2525	48.205	48.2525	4348.0
2018-07-26 04:07:00	AAPL	Stock	48.245	48.245	48.245	48.245	828.0
2018-07-26 04:11:00	AAPL	Stock	48.2525	48.2525	48.2525	48.2525	512.0
2018-07-26 04:27:00	AAPL	Stock	48.3125	48.3175	48.31	48.31	4192.0
2018-07-26 04:34:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	400.0
2018-07-26 04:50:00	AAPL	Stock	48.25	48.25	48.25	48.25	1964.0
2018-07-26 04:52:00	AAPL	Stock	48.2475	48.25	48.2475	48.25	4000.0
2018-07-26 04:54:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	5900.0
2018-07-26 04:55:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	7700.0
2018-07-26 05:07:00	AAPL	Stock	48.3	48.3	48.3	48.3	888.0
2018-07-26 05:08:00	AAPL	Stock	48.2475	48.2475	48.2475	48.2475	1188.0
2018-07-26 05:11:00	AAPL	Stock	48.2975	48.3125	48.2975	48.3125	4912.0
2018-07-26 05:12:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	620.0
2018-07-26 05:14:00	AAPL	Stock	48.265	48.265	48.265	48.265	400.0
2018-07-26 05:17:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	752.0
2018-07-26 05:21:00	AAPL	Stock	48.25	48.25	48.25	48.25	1916.0
2018-07-26 05:22:00	AAPL	Stock	48.2525	48.2525	48.25	48.25	2400.0
2018-07-26 05:28:00	AAPL	Stock	48.3025	48.3025	48.3025	48.3025	400.0
2018-07-26 05:34:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	20756.0
2018-07-26 05:35:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	2800.0
2018-07-26 06:17:00	AAPL	Stock	48.2875	48.2875	48.2875	48.2875	1100.0
2018-07-26 06:19:00	AAPL	Stock	48.2875	48.2875	48.2875	48.2875	1124.0
2018-07-26 06:22:00	AAPL	Stock	48.2875	48.2875	48.2875	48.2875	1200.0
2018-07-26 06:25:00	AAPL	Stock	48.2875	48.2875	48.2875	48.2875	2000.0
2018-07-26 06:27:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	1200.0
2018-07-26 06:29:00	AAPL	Stock	48.355	48.36	48.355	48.36	4000.0
2018-07-26 06:33:00	AAPL	Stock	48.3575	48.3625	48.3575	48.3625	2000.0
2018-07-26 06:38:00	AAPL	Stock	48.35	48.35	48.35	48.35	4000.0
2018-07-26 06:41:00	AAPL	Stock	48.375	48.375	48.375	48.375	3800.0
2018-07-26 06:42:00	AAPL	Stock	48.375	48.375	48.375	48.375	3200.0
2018-07-26 06:45:00	AAPL	Stock	48.3775	48.3775	48.3775	48.3775	1788.0
2018-07-26 06:46:00	AAPL	Stock	48.375	48.375	48.375	48.375	7792.0
2018-07-26 06:55:00	AAPL	Stock	48.41	48.4125	48.4075	48.41	20120.0
2018-07-26 06:59:00	AAPL	Stock	48.38	48.38	48.375	48.375	5200.0
2018-07-26 07:00:00	AAPL	Stock	48.38	48.3825	48.375	48.375	6864.0
2018-07-26 07:01:00	AAPL	Stock	48.375	48.375	48.375	48.375	400.0
2018-07-26 07:02:00	AAPL	Stock	48.375	48.3825	48.375	48.3825	1928.0
2018-07-26 07:04:00	AAPL	Stock	48.3775	48.4125	48.3625	48.4125	24720.0
2018-07-26 07:06:00	AAPL	Stock	48.4	48.4	48.4	48.4	1352.0
2018-07-26 07:08:00	AAPL	Stock	48.41	48.4125	48.41	48.4125	18448.0
2018-07-26 07:09:00	AAPL	Stock	48.4125	48.4325	48.4125	48.4325	3200.0
2018-07-26 07:10:00	AAPL	Stock	48.445	48.445	48.445	48.445	3600.0
2018-07-26 07:11:00	AAPL	Stock	48.425	48.425	48.425	48.425	2940.0
2018-07-26 07:12:00	AAPL	Stock	48.4375	48.4375	48.4375	48.4375	800.0
2018-07-26 07:13:00	AAPL	Stock	48.4375	48.4375	48.4375	48.4375	400.0
2018-07-26 07:14:00	AAPL	Stock	48.4375	48.4375	48.4375	48.4375	2000.0
2018-07-26 07:15:00	AAPL	Stock	48.4375	48.4375	48.4375	48.4375	2076.0
2018-07-26 07:18:00	AAPL	Stock	48.4	48.4	48.4	48.4	800.0
2018-07-26 07:19:00	AAPL	Stock	48.3975	48.4375	48.3975	48.4375	2800.0
2018-07-26 07:22:00	AAPL	Stock	48.435	48.435	48.435	48.435	400.0

> showing 50 of 1,062,785 rows — these rows as CSV

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