PREVIEW / stock_1min / 2017-07-28

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-28.parquet
  size:    13.7 MB
  rows:    993,626
  symbols: 2,455

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-07-28 04:31:00	AAPL	Stock	37.3725	37.3725	37.3725	37.3725	400.0
2017-07-28 04:36:00	AAPL	Stock	37.3025	37.3025	37.3025	37.3025	1236.0
2017-07-28 04:38:00	AAPL	Stock	37.375	37.375	37.37	37.3725	7664.0
2017-07-28 04:49:00	AAPL	Stock	37.3675	37.3675	37.3675	37.3675	400.0
2017-07-28 04:50:00	AAPL	Stock	37.3675	37.3675	37.3675	37.3675	400.0
2017-07-28 05:34:00	AAPL	Stock	37.325	37.325	37.325	37.325	6000.0
2017-07-28 05:45:00	AAPL	Stock	37.3725	37.3725	37.3725	37.3725	400.0
2017-07-28 05:59:00	AAPL	Stock	37.35	37.35	37.325	37.325	3200.0
2017-07-28 06:00:00	AAPL	Stock	37.3725	37.3725	37.3725	37.3725	400.0
2017-07-28 06:35:00	AAPL	Stock	37.325	37.325	37.325	37.325	400.0
2017-07-28 06:42:00	AAPL	Stock	37.35	37.35	37.35	37.35	1952.0
2017-07-28 06:44:00	AAPL	Stock	37.3375	37.3375	37.3375	37.3375	400.0
2017-07-28 06:49:00	AAPL	Stock	37.355	37.355	37.355	37.355	3840.0
2017-07-28 06:50:00	AAPL	Stock	37.3375	37.3375	37.3375	37.3375	400.0
2017-07-28 06:51:00	AAPL	Stock	37.3375	37.3375	37.3375	37.3375	2000.0
2017-07-28 06:56:00	AAPL	Stock	37.3325	37.3325	37.33	37.33	2368.0
2017-07-28 06:58:00	AAPL	Stock	37.3375	37.3375	37.3375	37.3375	5392.0
2017-07-28 07:02:00	AAPL	Stock	37.375	37.375	37.375	37.375	1200.0
2017-07-28 07:03:00	AAPL	Stock	37.375	37.39	37.375	37.39	3028.0
2017-07-28 07:06:00	AAPL	Stock	37.3875	37.3875	37.3875	37.3875	800.0
2017-07-28 07:08:00	AAPL	Stock	37.3875	37.3875	37.3875	37.3875	1100.0
2017-07-28 07:15:00	AAPL	Stock	37.4025	37.4025	37.4025	37.4025	400.0
2017-07-28 07:27:00	AAPL	Stock	37.42	37.4225	37.42	37.4225	1600.0
2017-07-28 07:28:00	AAPL	Stock	37.4175	37.42	37.4175	37.42	2000.0
2017-07-28 07:29:00	AAPL	Stock	37.4075	37.4075	37.4075	37.4075	2000.0
2017-07-28 07:30:00	AAPL	Stock	37.39	37.39	37.39	37.39	1044.0
2017-07-28 07:31:00	AAPL	Stock	37.4075	37.4075	37.4075	37.4075	400.0
2017-07-28 07:39:00	AAPL	Stock	37.4125	37.4125	37.4125	37.4125	400.0
2017-07-28 07:40:00	AAPL	Stock	37.4125	37.4125	37.4125	37.4125	1200.0
2017-07-28 07:42:00	AAPL	Stock	37.4175	37.4175	37.395	37.4075	3748.0
2017-07-28 07:44:00	AAPL	Stock	37.4	37.4325	37.4	37.4325	800.0
2017-07-28 07:58:00	AAPL	Stock	37.4175	37.4175	37.4175	37.4175	400.0
2017-07-28 08:00:00	AAPL	Stock	37.445	37.4475	37.405	37.4125	17664.0
2017-07-28 08:03:00	AAPL	Stock	37.4025	37.4075	37.395	37.4	4560.0
2017-07-28 08:04:00	AAPL	Stock	37.41	37.4125	37.395	37.395	2080.0
2017-07-28 08:05:00	AAPL	Stock	37.41	37.41	37.3975	37.3975	4800.0
2017-07-28 08:06:00	AAPL	Stock	37.395	37.395	37.395	37.395	800.0
2017-07-28 08:08:00	AAPL	Stock	37.395	37.4025	37.395	37.4025	5936.0
2017-07-28 08:09:00	AAPL	Stock	37.41	37.4175	37.4075	37.4175	7616.0
2017-07-28 08:11:00	AAPL	Stock	37.4175	37.4175	37.4175	37.4175	2400.0
2017-07-28 08:12:00	AAPL	Stock	37.4175	37.4175	37.4175	37.4175	980.0
2017-07-28 08:14:00	AAPL	Stock	37.4175	37.4175	37.4175	37.4175	1540.0
2017-07-28 08:15:00	AAPL	Stock	37.4175	37.425	37.4175	37.425	1160.0
2017-07-28 08:16:00	AAPL	Stock	37.425	37.425	37.425	37.425	2400.0
2017-07-28 08:17:00	AAPL	Stock	37.42	37.425	37.4175	37.4175	4368.0
2017-07-28 08:18:00	AAPL	Stock	37.425	37.425	37.4175	37.4175	1548.0
2017-07-28 08:20:00	AAPL	Stock	37.425	37.425	37.425	37.425	1200.0
2017-07-28 08:21:00	AAPL	Stock	37.435	37.435	37.435	37.435	4400.0
2017-07-28 08:23:00	AAPL	Stock	37.435	37.435	37.435	37.435	1200.0
2017-07-28 08:24:00	AAPL	Stock	37.4375	37.4375	37.435	37.435	3244.0

> showing 50 of 993,626 rows — these rows as CSV

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