PREVIEW / stock_1min / 2018-07-06

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-06.parquet
  size:    14.3 MB
  rows:    1,038,459
  symbols: 2,340

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-06 04:00:00	AAPL	Stock	46.2125	46.2125	46.2125	46.2125	1264.0
2018-07-06 04:26:00	AAPL	Stock	46.2375	46.2375	46.2375	46.2375	400.0
2018-07-06 04:27:00	AAPL	Stock	46.2375	46.2375	46.2375	46.2375	400.0
2018-07-06 04:31:00	AAPL	Stock	46.15	46.15	46.15	46.15	800.0
2018-07-06 04:42:00	AAPL	Stock	46.25	46.25	46.25	46.25	416.0
2018-07-06 05:01:00	AAPL	Stock	46.325	46.325	46.325	46.325	600.0
2018-07-06 05:02:00	AAPL	Stock	46.325	46.325	46.325	46.325	536.0
2018-07-06 05:14:00	AAPL	Stock	46.2625	46.2625	46.2625	46.2625	800.0
2018-07-06 06:05:00	AAPL	Stock	46.2875	46.2975	46.2875	46.2975	1956.0
2018-07-06 06:31:00	AAPL	Stock	46.25	46.25	46.25	46.25	532.0
2018-07-06 07:00:00	AAPL	Stock	46.275	46.275	46.275	46.275	2128.0
2018-07-06 07:02:00	AAPL	Stock	46.285	46.285	46.27	46.285	19828.0
2018-07-06 07:03:00	AAPL	Stock	46.3175	46.3175	46.3175	46.3175	20000.0
2018-07-06 07:14:00	AAPL	Stock	46.27	46.27	46.27	46.27	680.0
2018-07-06 07:30:00	AAPL	Stock	46.275	46.275	46.275	46.275	776.0
2018-07-06 07:35:00	AAPL	Stock	46.2975	46.3	46.2975	46.3	2800.0
2018-07-06 07:40:00	AAPL	Stock	46.2975	46.3	46.2975	46.3	1600.0
2018-07-06 07:43:00	AAPL	Stock	46.28	46.28	46.2625	46.2625	800.0
2018-07-06 07:44:00	AAPL	Stock	46.2725	46.2725	46.2725	46.2725	4000.0
2018-07-06 07:48:00	AAPL	Stock	46.245	46.245	46.245	46.245	400.0
2018-07-06 07:52:00	AAPL	Stock	46.255	46.2625	46.255	46.2625	800.0
2018-07-06 07:58:00	AAPL	Stock	46.265	46.265	46.2625	46.2625	2000.0
2018-07-06 07:59:00	AAPL	Stock	46.2625	46.2625	46.2625	46.2625	2492.0
2018-07-06 08:00:00	AAPL	Stock	46.275	46.33	46.25	46.275	12620.0
2018-07-06 08:02:00	AAPL	Stock	46.28	46.28	46.2775	46.2775	1300.0
2018-07-06 08:03:00	AAPL	Stock	46.275	46.275	46.275	46.275	1600.0
2018-07-06 08:04:00	AAPL	Stock	46.3	46.3	46.3	46.3	1384.0
2018-07-06 08:06:00	AAPL	Stock	46.315	46.315	46.315	46.315	2000.0
2018-07-06 08:07:00	AAPL	Stock	46.315	46.315	46.315	46.315	4752.0
2018-07-06 08:11:00	AAPL	Stock	46.3	46.3	46.3	46.3	400.0
2018-07-06 08:12:00	AAPL	Stock	46.3	46.3	46.3	46.3	3728.0
2018-07-06 08:14:00	AAPL	Stock	46.3	46.3	46.3	46.3	3480.0
2018-07-06 08:17:00	AAPL	Stock	46.295	46.295	46.295	46.295	400.0
2018-07-06 08:18:00	AAPL	Stock	46.2975	46.2975	46.275	46.275	1600.0
2018-07-06 08:21:00	AAPL	Stock	46.2975	46.2975	46.2975	46.2975	10000.0
2018-07-06 08:22:00	AAPL	Stock	46.295	46.3	46.295	46.3	1480.0
2018-07-06 08:25:00	AAPL	Stock	46.295	46.3	46.295	46.3	1260.0
2018-07-06 08:27:00	AAPL	Stock	46.2975	46.3	46.2775	46.2775	2656.0
2018-07-06 08:30:00	AAPL	Stock	46.315	46.395	46.315	46.395	19104.0
2018-07-06 08:31:00	AAPL	Stock	46.35	46.4	46.35	46.4	10400.0
2018-07-06 08:32:00	AAPL	Stock	46.35	46.44	46.35	46.44	14972.0
2018-07-06 08:33:00	AAPL	Stock	46.4575	46.5	46.45	46.5	4636.0
2018-07-06 08:34:00	AAPL	Stock	46.4775	46.495	46.4525	46.495	5072.0
2018-07-06 08:36:00	AAPL	Stock	46.49	46.4925	46.49	46.4925	1372.0
2018-07-06 08:37:00	AAPL	Stock	46.496	46.5	46.4775	46.5	8260.0
2018-07-06 08:38:00	AAPL	Stock	46.48	46.5088	46.4775	46.4775	2000.0
2018-07-06 08:39:00	AAPL	Stock	46.4675	46.4675	46.4175	46.4175	31200.0
2018-07-06 08:40:00	AAPL	Stock	46.4225	46.4335	46.4225	46.4335	1400.0
2018-07-06 08:41:00	AAPL	Stock	46.425	46.425	46.4	46.4	6400.0
2018-07-06 08:42:00	AAPL	Stock	46.4025	46.4025	46.4025	46.4025	2584.0

> showing 50 of 1,038,459 rows — these rows as CSV

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