PREVIEW / stock_1min / 2019-07-31

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-31.parquet
  size:    16.9 MB
  rows:    1,189,296
  symbols: 2,201

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
2019-07-31 04:00:00	AAPL	Stock	54.5325	54.5325	54.35	54.375	24200.0
2019-07-31 04:01:00	AAPL	Stock	54.4375	54.4375	54.4375	54.4375	400.0
2019-07-31 04:02:00	AAPL	Stock	54.41	54.4125	54.41	54.4125	2380.0
2019-07-31 04:03:00	AAPL	Stock	54.4	54.4	54.375	54.375	1304.0
2019-07-31 04:04:00	AAPL	Stock	54.4125	54.4225	54.4125	54.4225	2176.0
2019-07-31 04:06:00	AAPL	Stock	54.4	54.4225	54.4	54.4225	1200.0
2019-07-31 04:08:00	AAPL	Stock	54.4	54.455	54.4	54.455	7172.0
2019-07-31 04:09:00	AAPL	Stock	54.4125	54.4125	54.4125	54.4125	1600.0
2019-07-31 04:11:00	AAPL	Stock	54.4125	54.4125	54.4125	54.4125	760.0
2019-07-31 04:14:00	AAPL	Stock	54.41	54.41	54.41	54.41	800.0
2019-07-31 04:15:00	AAPL	Stock	54.41	54.41	54.41	54.41	1200.0
2019-07-31 04:17:00	AAPL	Stock	54.41	54.41	54.41	54.41	11192.0
2019-07-31 04:18:00	AAPL	Stock	54.4125	54.4125	54.4125	54.4125	7200.0
2019-07-31 04:19:00	AAPL	Stock	54.42	54.42	54.42	54.42	400.0
2019-07-31 04:20:00	AAPL	Stock	54.46	54.4925	54.46	54.4925	6044.0
2019-07-31 04:22:00	AAPL	Stock	54.47	54.47	54.47	54.47	800.0
2019-07-31 04:23:00	AAPL	Stock	54.475	54.5325	54.475	54.5325	12104.0
2019-07-31 04:24:00	AAPL	Stock	54.525	54.5475	54.525	54.5375	3140.0
2019-07-31 04:25:00	AAPL	Stock	54.55	54.575	54.55	54.575	5396.0
2019-07-31 04:26:00	AAPL	Stock	54.5375	54.5525	54.525	54.525	3820.0
2019-07-31 04:27:00	AAPL	Stock	54.525	54.55	54.525	54.55	2180.0
2019-07-31 04:28:00	AAPL	Stock	54.55	54.55	54.55	54.55	1200.0
2019-07-31 04:30:00	AAPL	Stock	54.5075	54.5075	54.5075	54.5075	1600.0
2019-07-31 04:31:00	AAPL	Stock	54.5075	54.5075	54.5075	54.5075	3684.0
2019-07-31 04:32:00	AAPL	Stock	54.5075	54.5075	54.5	54.5	3336.0
2019-07-31 04:33:00	AAPL	Stock	54.5225	54.525	54.5225	54.525	2400.0
2019-07-31 04:34:00	AAPL	Stock	54.545	54.545	54.545	54.545	1200.0
2019-07-31 04:35:00	AAPL	Stock	54.5275	54.5275	54.5275	54.5275	400.0
2019-07-31 04:40:00	AAPL	Stock	54.475	54.4975	54.45	54.4875	1788.0
2019-07-31 04:41:00	AAPL	Stock	54.5	54.5	54.5	54.5	400.0
2019-07-31 04:44:00	AAPL	Stock	54.4425	54.4425	54.4425	54.4425	400.0
2019-07-31 04:45:00	AAPL	Stock	54.4975	54.4975	54.4975	54.4975	400.0
2019-07-31 04:50:00	AAPL	Stock	54.5	54.5025	54.5	54.5025	844.0
2019-07-31 04:53:00	AAPL	Stock	54.4875	54.4875	54.4875	54.4875	400.0
2019-07-31 04:54:00	AAPL	Stock	54.4925	54.495	54.4925	54.495	2880.0
2019-07-31 04:59:00	AAPL	Stock	54.5	54.5	54.5	54.5	800.0
2019-07-31 05:00:00	AAPL	Stock	54.5	54.5	54.5	54.5	3600.0
2019-07-31 05:01:00	AAPL	Stock	54.5125	54.525	54.5125	54.525	8948.0
2019-07-31 05:03:00	AAPL	Stock	54.53	54.5475	54.53	54.5475	2756.0
2019-07-31 05:04:00	AAPL	Stock	54.5475	54.5475	54.5475	54.5475	4000.0
2019-07-31 05:07:00	AAPL	Stock	54.525	54.5375	54.525	54.5375	2400.0
2019-07-31 05:08:00	AAPL	Stock	54.535	54.5475	54.505	54.505	2420.0
2019-07-31 05:12:00	AAPL	Stock	54.545	54.55	54.545	54.55	8400.0
2019-07-31 05:13:00	AAPL	Stock	54.5375	54.5375	54.5375	54.5375	800.0
2019-07-31 05:15:00	AAPL	Stock	54.505	54.525	54.505	54.525	880.0
2019-07-31 05:18:00	AAPL	Stock	54.525	54.525	54.525	54.525	400.0
2019-07-31 05:19:00	AAPL	Stock	54.525	54.525	54.4825	54.4875	7200.0
2019-07-31 05:20:00	AAPL	Stock	54.4575	54.4575	54.4525	54.4525	4000.0
2019-07-31 05:22:00	AAPL	Stock	54.4575	54.4575	54.4575	54.4575	400.0
2019-07-31 05:26:00	AAPL	Stock	54.4725	54.4725	54.4725	54.4725	400.0

> showing 50 of 1,189,296 rows — these rows as CSV

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