PREVIEW / stock_1min / 2019-09-09

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-09-09.parquet
  size:    16.4 MB
  rows:    1,131,361
  symbols: 2,160

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-09-09 04:00:00	AAPL	Stock	53.425	53.425	53.415	53.415	800.0
2019-09-09 04:06:00	AAPL	Stock	53.3975	53.3975	53.3475	53.3475	1200.0
2019-09-09 04:35:00	AAPL	Stock	53.3975	53.3975	53.3975	53.3975	400.0
2019-09-09 04:42:00	AAPL	Stock	53.3975	53.44	53.3975	53.44	3280.0
2019-09-09 04:43:00	AAPL	Stock	53.445	53.45	53.445	53.45	972.0
2019-09-09 05:30:00	AAPL	Stock	53.415	53.415	53.415	53.415	400.0
2019-09-09 05:47:00	AAPL	Stock	53.45	53.45	53.45	53.45	1200.0
2019-09-09 06:12:00	AAPL	Stock	53.5325	53.5325	53.5325	53.5325	800.0
2019-09-09 06:13:00	AAPL	Stock	53.5725	53.575	53.5725	53.575	3984.0
2019-09-09 06:24:00	AAPL	Stock	53.5575	53.56	53.5575	53.56	4000.0
2019-09-09 06:37:00	AAPL	Stock	53.55	53.55	53.55	53.55	640.0
2019-09-09 07:00:00	AAPL	Stock	53.5225	53.575	53.5025	53.5325	32228.0
2019-09-09 07:01:00	AAPL	Stock	53.5425	53.545	53.52	53.525	3600.0
2019-09-09 07:02:00	AAPL	Stock	53.515	53.515	53.515	53.515	1924.0
2019-09-09 07:03:00	AAPL	Stock	53.55	53.55	53.55	53.55	800.0
2019-09-09 07:04:00	AAPL	Stock	53.5275	53.5275	53.5275	53.5275	400.0
2019-09-09 07:05:00	AAPL	Stock	53.52	53.52	53.52	53.52	800.0
2019-09-09 07:06:00	AAPL	Stock	53.515	53.515	53.515	53.515	1620.0
2019-09-09 07:07:00	AAPL	Stock	53.515	53.515	53.515	53.515	2400.0
2019-09-09 07:09:00	AAPL	Stock	53.5175	53.5175	53.515	53.515	5600.0
2019-09-09 07:10:00	AAPL	Stock	53.515	53.515	53.515	53.515	1176.0
2019-09-09 07:12:00	AAPL	Stock	53.52	53.52	53.52	53.52	800.0
2019-09-09 07:13:00	AAPL	Stock	53.505	53.505	53.5	53.5	7604.0
2019-09-09 07:18:00	AAPL	Stock	53.52	53.52	53.5075	53.5075	800.0
2019-09-09 07:19:00	AAPL	Stock	53.5075	53.5075	53.5075	53.5075	400.0
2019-09-09 07:20:00	AAPL	Stock	53.5125	53.525	53.51	53.51	2108.0
2019-09-09 07:21:00	AAPL	Stock	53.5225	53.5225	53.5225	53.5225	400.0
2019-09-09 07:23:00	AAPL	Stock	53.5225	53.525	53.5225	53.525	1096.0
2019-09-09 07:24:00	AAPL	Stock	53.5225	53.5225	53.5225	53.5225	400.0
2019-09-09 07:25:00	AAPL	Stock	53.52	53.525	53.52	53.525	5572.0
2019-09-09 07:26:00	AAPL	Stock	53.535	53.54	53.535	53.54	4600.0
2019-09-09 07:27:00	AAPL	Stock	53.5625	53.5725	53.5575	53.5725	5600.0
2019-09-09 07:28:00	AAPL	Stock	53.5725	53.5725	53.5675	53.5675	1752.0
2019-09-09 07:29:00	AAPL	Stock	53.6	53.6	53.6	53.6	1768.0
2019-09-09 07:30:00	AAPL	Stock	53.575	53.595	53.575	53.595	1360.0
2019-09-09 07:31:00	AAPL	Stock	53.5875	53.5925	53.5875	53.5925	2000.0
2019-09-09 07:32:00	AAPL	Stock	53.5925	53.5925	53.5875	53.5925	3480.0
2019-09-09 07:33:00	AAPL	Stock	53.6	53.6	53.6	53.6	4000.0
2019-09-09 07:34:00	AAPL	Stock	53.6	53.61	53.6	53.61	8800.0
2019-09-09 07:37:00	AAPL	Stock	53.61	53.61	53.6	53.61	4800.0
2019-09-09 07:38:00	AAPL	Stock	53.61	53.6125	53.61	53.6125	5344.0
2019-09-09 07:39:00	AAPL	Stock	53.62	53.62	53.62	53.62	680.0
2019-09-09 07:41:00	AAPL	Stock	53.62	53.62	53.62	53.62	400.0
2019-09-09 07:42:00	AAPL	Stock	53.6225	53.625	53.6225	53.625	11152.0
2019-09-09 07:43:00	AAPL	Stock	53.6375	53.64	53.6375	53.64	3700.0
2019-09-09 07:44:00	AAPL	Stock	53.64	53.64	53.625	53.625	2000.0
2019-09-09 07:45:00	AAPL	Stock	53.64	53.64	53.6125	53.6125	3048.0
2019-09-09 07:48:00	AAPL	Stock	53.5825	53.5825	53.5825	53.5825	800.0
2019-09-09 07:49:00	AAPL	Stock	53.6	53.6	53.6	53.6	400.0
2019-09-09 07:50:00	AAPL	Stock	53.6	53.6	53.5825	53.5825	4400.0

> showing 50 of 1,131,361 rows — these rows as CSV

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