PREVIEW / stock_1min / 2018-02-23

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-02-23.parquet
  size:    14.6 MB
  rows:    1,055,419
  symbols: 2,381

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-02-23 04:11:00	AAPL	Stock	43.325	43.325	43.325	43.325	400.0
2018-02-23 04:19:00	AAPL	Stock	43.4	43.4	43.4	43.4	400.0
2018-02-23 04:20:00	AAPL	Stock	43.375	43.375	43.375	43.375	3760.0
2018-02-23 04:28:00	AAPL	Stock	43.3775	43.3775	43.375	43.375	2400.0
2018-02-23 04:53:00	AAPL	Stock	43.395	43.395	43.395	43.395	6800.0
2018-02-23 05:16:00	AAPL	Stock	43.395	43.395	43.395	43.395	400.0
2018-02-23 05:18:00	AAPL	Stock	43.37	43.37	43.3375	43.3375	3600.0
2018-02-23 05:20:00	AAPL	Stock	43.35	43.35	43.35	43.35	400.0
2018-02-23 05:21:00	AAPL	Stock	43.4	43.4	43.4	43.4	400.0
2018-02-23 05:22:00	AAPL	Stock	43.385	43.385	43.3725	43.375	1200.0
2018-02-23 05:23:00	AAPL	Stock	43.3725	43.3725	43.3725	43.3725	800.0
2018-02-23 05:24:00	AAPL	Stock	43.37	43.37	43.3675	43.3675	1200.0
2018-02-23 05:27:00	AAPL	Stock	43.3625	43.3625	43.3625	43.3625	800.0
2018-02-23 05:28:00	AAPL	Stock	43.36	43.3625	43.36	43.3625	2200.0
2018-02-23 05:29:00	AAPL	Stock	43.395	43.3975	43.395	43.3975	800.0
2018-02-23 05:33:00	AAPL	Stock	43.325	43.325	43.325	43.325	4000.0
2018-02-23 05:39:00	AAPL	Stock	43.325	43.325	43.325	43.325	6400.0
2018-02-23 05:43:00	AAPL	Stock	43.325	43.325	43.325	43.325	4400.0
2018-02-23 05:51:00	AAPL	Stock	43.325	43.325	43.3125	43.3125	5600.0
2018-02-23 06:00:00	AAPL	Stock	43.335	43.335	43.335	43.335	400.0
2018-02-23 06:01:00	AAPL	Stock	43.35	43.35	43.35	43.35	1200.0
2018-02-23 06:04:00	AAPL	Stock	43.3625	43.3625	43.325	43.325	2200.0
2018-02-23 06:08:00	AAPL	Stock	43.375	43.3975	43.375	43.3975	1876.0
2018-02-23 06:11:00	AAPL	Stock	43.4	43.425	43.4	43.425	9200.0
2018-02-23 06:13:00	AAPL	Stock	43.4225	43.4475	43.4225	43.4475	20000.0
2018-02-23 06:15:00	AAPL	Stock	43.39	43.39	43.39	43.39	400.0
2018-02-23 06:17:00	AAPL	Stock	43.4225	43.425	43.4225	43.425	9536.0
2018-02-23 06:20:00	AAPL	Stock	43.3575	43.38	43.3575	43.365	4000.0
2018-02-23 06:28:00	AAPL	Stock	43.4025	43.4025	43.4025	43.4025	3300.0
2018-02-23 06:30:00	AAPL	Stock	43.4025	43.4025	43.4025	43.4025	400.0
2018-02-23 06:42:00	AAPL	Stock	43.425	43.425	43.4	43.4	4400.0
2018-02-23 06:43:00	AAPL	Stock	43.4	43.4	43.4	43.4	8000.0
2018-02-23 06:44:00	AAPL	Stock	43.415	43.415	43.415	43.415	800.0
2018-02-23 06:46:00	AAPL	Stock	43.415	43.415	43.415	43.415	400.0
2018-02-23 06:51:00	AAPL	Stock	43.41	43.41	43.41	43.41	1852.0
2018-02-23 06:52:00	AAPL	Stock	43.45	43.45	43.45	43.45	3484.0
2018-02-23 06:53:00	AAPL	Stock	43.4225	43.4225	43.4225	43.4225	800.0
2018-02-23 06:55:00	AAPL	Stock	43.4075	43.4075	43.4075	43.4075	400.0
2018-02-23 06:57:00	AAPL	Stock	43.42	43.42	43.42	43.42	1048.0
2018-02-23 07:00:00	AAPL	Stock	43.4125	43.45	43.4125	43.45	25200.0
2018-02-23 07:01:00	AAPL	Stock	43.45	43.45	43.45	43.45	6476.0
2018-02-23 07:02:00	AAPL	Stock	43.4475	43.45	43.4475	43.45	2040.0
2018-02-23 07:03:00	AAPL	Stock	43.4475	43.4475	43.425	43.425	2300.0
2018-02-23 07:06:00	AAPL	Stock	43.4475	43.45	43.4475	43.4475	4240.0
2018-02-23 07:07:00	AAPL	Stock	43.4475	43.45	43.445	43.445	5500.0
2018-02-23 07:08:00	AAPL	Stock	43.45	43.45	43.45	43.45	6000.0
2018-02-23 07:09:00	AAPL	Stock	43.4475	43.45	43.425	43.425	12280.0
2018-02-23 07:11:00	AAPL	Stock	43.4175	43.4175	43.415	43.415	3160.0
2018-02-23 07:12:00	AAPL	Stock	43.4025	43.4225	43.4	43.4225	8880.0
2018-02-23 07:13:00	AAPL	Stock	43.4225	43.4225	43.4225	43.4225	2720.0

> showing 50 of 1,055,419 rows — these rows as CSV

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