PREVIEW / stock_1min / 2018-08-07

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-08-07.parquet
  size:    14.6 MB
  rows:    1,052,537
  symbols: 2,317

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-08-07 04:00:00	AAPL	Stock	52.3125	52.3125	52.3125	52.3125	1200.0
2018-08-07 04:01:00	AAPL	Stock	52.28	52.28	52.28	52.28	400.0
2018-08-07 04:11:00	AAPL	Stock	52.3725	52.3825	52.3725	52.3825	1200.0
2018-08-07 04:12:00	AAPL	Stock	52.3825	52.39	52.3825	52.3825	6492.0
2018-08-07 04:14:00	AAPL	Stock	52.375	52.3825	52.375	52.3825	7600.0
2018-08-07 04:18:00	AAPL	Stock	52.3825	52.3825	52.3825	52.3825	420.0
2018-08-07 04:32:00	AAPL	Stock	52.385	52.385	52.385	52.385	400.0
2018-08-07 04:43:00	AAPL	Stock	52.44	52.44	52.4375	52.4375	8176.0
2018-08-07 04:56:00	AAPL	Stock	52.4375	52.4375	52.4375	52.4375	5600.0
2018-08-07 05:03:00	AAPL	Stock	52.4375	52.4625	52.4375	52.4625	5600.0
2018-08-07 05:04:00	AAPL	Stock	52.46	52.4675	52.45	52.45	6548.0
2018-08-07 05:08:00	AAPL	Stock	52.45	52.45	52.45	52.45	800.0
2018-08-07 05:12:00	AAPL	Stock	52.45	52.45	52.45	52.45	496.0
2018-08-07 05:23:00	AAPL	Stock	52.425	52.425	52.425	52.425	800.0
2018-08-07 05:29:00	AAPL	Stock	52.425	52.425	52.425	52.425	400.0
2018-08-07 05:42:00	AAPL	Stock	52.445	52.445	52.445	52.445	540.0
2018-08-07 05:44:00	AAPL	Stock	52.445	52.45	52.445	52.45	4000.0
2018-08-07 05:50:00	AAPL	Stock	52.415	52.4225	52.4125	52.4225	3260.0
2018-08-07 05:55:00	AAPL	Stock	52.4225	52.4225	52.4225	52.4225	1200.0
2018-08-07 06:07:00	AAPL	Stock	52.42	52.4225	52.42	52.4225	5032.0
2018-08-07 06:09:00	AAPL	Stock	52.3825	52.3825	52.375	52.3825	3540.0
2018-08-07 06:16:00	AAPL	Stock	52.365	52.365	52.36	52.36	1352.0
2018-08-07 06:20:00	AAPL	Stock	52.36	52.36	52.36	52.36	1448.0
2018-08-07 06:29:00	AAPL	Stock	52.365	52.365	52.36	52.36	1244.0
2018-08-07 06:34:00	AAPL	Stock	52.41	52.41	52.41	52.41	400.0
2018-08-07 06:37:00	AAPL	Stock	52.4125	52.4125	52.4125	52.4125	1156.0
2018-08-07 06:38:00	AAPL	Stock	52.4125	52.4125	52.4125	52.4125	2808.0
2018-08-07 06:40:00	AAPL	Stock	52.4125	52.4125	52.4125	52.4125	1152.0
2018-08-07 06:42:00	AAPL	Stock	52.41	52.41	52.41	52.41	900.0
2018-08-07 06:44:00	AAPL	Stock	52.385	52.385	52.375	52.375	1300.0
2018-08-07 06:55:00	AAPL	Stock	52.4075	52.4125	52.4075	52.4125	3788.0
2018-08-07 07:00:00	AAPL	Stock	52.4125	52.4125	52.365	52.375	13896.0
2018-08-07 07:01:00	AAPL	Stock	52.36	52.375	52.36	52.375	5184.0
2018-08-07 07:02:00	AAPL	Stock	52.375	52.375	52.375	52.375	800.0
2018-08-07 07:04:00	AAPL	Stock	52.375	52.375	52.375	52.375	3200.0
2018-08-07 07:05:00	AAPL	Stock	52.3725	52.375	52.36	52.375	14328.0
2018-08-07 07:06:00	AAPL	Stock	52.375	52.3775	52.375	52.3775	1200.0
2018-08-07 07:07:00	AAPL	Stock	52.375	52.38	52.375	52.375	7960.0
2018-08-07 07:11:00	AAPL	Stock	52.395	52.395	52.395	52.395	3300.0
2018-08-07 07:12:00	AAPL	Stock	52.3825	52.3825	52.3825	52.3825	400.0
2018-08-07 07:13:00	AAPL	Stock	52.39	52.39	52.39	52.39	400.0
2018-08-07 07:14:00	AAPL	Stock	52.3925	52.3925	52.375	52.375	4204.0
2018-08-07 07:15:00	AAPL	Stock	52.3825	52.395	52.3825	52.395	2440.0
2018-08-07 07:16:00	AAPL	Stock	52.395	52.3975	52.395	52.3975	2800.0
2018-08-07 07:17:00	AAPL	Stock	52.4	52.4	52.4	52.4	3600.0
2018-08-07 07:18:00	AAPL	Stock	52.4075	52.4075	52.4075	52.4075	400.0
2018-08-07 07:19:00	AAPL	Stock	52.4075	52.4075	52.4075	52.4075	400.0
2018-08-07 07:20:00	AAPL	Stock	52.4	52.4	52.395	52.395	3500.0
2018-08-07 07:22:00	AAPL	Stock	52.4125	52.415	52.4125	52.415	2280.0
2018-08-07 07:26:00	AAPL	Stock	52.405	52.405	52.405	52.405	400.0

> showing 50 of 1,052,537 rows — these rows as CSV

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