PREVIEW / stock_1min / 2020-01-16

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-01-16.parquet
  size:    17.8 MB
  rows:    1,145,320
  symbols: 2,074

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
2020-01-16 04:00:00	AAPL	Stock	78.2625	78.2625	78.2625	78.2625	852.0
2020-01-16 04:06:00	AAPL	Stock	78.42	78.42	78.42	78.42	400.0
2020-01-16 04:10:00	AAPL	Stock	78.42	78.42	78.42	78.42	400.0
2020-01-16 04:15:00	AAPL	Stock	78.4475	78.46	78.4475	78.46	1340.0
2020-01-16 04:20:00	AAPL	Stock	78.495	78.495	78.495	78.495	1200.0
2020-01-16 04:24:00	AAPL	Stock	78.525	78.525	78.525	78.525	400.0
2020-01-16 04:25:00	AAPL	Stock	78.525	78.525	78.5125	78.5125	4400.0
2020-01-16 04:26:00	AAPL	Stock	78.4525	78.4525	78.45	78.45	2400.0
2020-01-16 04:27:00	AAPL	Stock	78.35	78.35	78.35	78.35	1480.0
2020-01-16 04:30:00	AAPL	Stock	78.37	78.37	78.37	78.37	1600.0
2020-01-16 04:34:00	AAPL	Stock	78.4375	78.4375	78.4375	78.4375	472.0
2020-01-16 04:38:00	AAPL	Stock	78.45	78.45	78.45	78.45	1600.0
2020-01-16 04:40:00	AAPL	Stock	78.45	78.45	78.45	78.45	800.0
2020-01-16 04:41:00	AAPL	Stock	78.45	78.45	78.45	78.45	800.0
2020-01-16 04:42:00	AAPL	Stock	78.45	78.45	78.45	78.45	8680.0
2020-01-16 04:55:00	AAPL	Stock	78.45	78.45	78.45	78.45	2360.0
2020-01-16 05:04:00	AAPL	Stock	78.4	78.4	78.4	78.4	1920.0
2020-01-16 05:15:00	AAPL	Stock	78.395	78.395	78.395	78.395	400.0
2020-01-16 05:17:00	AAPL	Stock	78.4175	78.4175	78.4175	78.4175	7956.0
2020-01-16 05:18:00	AAPL	Stock	78.4225	78.425	78.42	78.425	2360.0
2020-01-16 05:21:00	AAPL	Stock	78.42	78.42	78.42	78.42	2400.0
2020-01-16 05:22:00	AAPL	Stock	78.42	78.42	78.42	78.42	800.0
2020-01-16 05:32:00	AAPL	Stock	78.4	78.4	78.4	78.4	2000.0
2020-01-16 05:36:00	AAPL	Stock	78.3775	78.3775	78.3775	78.3775	1920.0
2020-01-16 05:45:00	AAPL	Stock	78.445	78.445	78.445	78.445	400.0
2020-01-16 05:46:00	AAPL	Stock	78.405	78.405	78.3875	78.3875	800.0
2020-01-16 05:47:00	AAPL	Stock	78.445	78.445	78.445	78.445	800.0
2020-01-16 05:55:00	AAPL	Stock	78.425	78.425	78.425	78.425	400.0
2020-01-16 05:56:00	AAPL	Stock	78.425	78.425	78.425	78.425	1404.0
2020-01-16 05:59:00	AAPL	Stock	78.4225	78.425	78.4225	78.425	800.0
2020-01-16 06:00:00	AAPL	Stock	78.4275	78.4575	78.4275	78.4575	3196.0
2020-01-16 06:05:00	AAPL	Stock	78.4325	78.4325	78.4325	78.4325	400.0
2020-01-16 06:09:00	AAPL	Stock	78.4325	78.4325	78.4125	78.4125	2000.0
2020-01-16 06:10:00	AAPL	Stock	78.3525	78.3525	78.32	78.32	2060.0
2020-01-16 06:18:00	AAPL	Stock	78.3875	78.4025	78.3875	78.4025	1200.0
2020-01-16 06:23:00	AAPL	Stock	78.4325	78.435	78.4325	78.4325	2932.0
2020-01-16 06:32:00	AAPL	Stock	78.355	78.4325	78.355	78.4325	3520.0
2020-01-16 06:33:00	AAPL	Stock	78.425	78.425	78.425	78.425	400.0
2020-01-16 06:36:00	AAPL	Stock	78.415	78.415	78.415	78.415	1240.0
2020-01-16 06:42:00	AAPL	Stock	78.4	78.4	78.4	78.4	400.0
2020-01-16 06:45:00	AAPL	Stock	78.4475	78.4475	78.4475	78.4475	400.0
2020-01-16 06:54:00	AAPL	Stock	78.45	78.45	78.45	78.45	600.0
2020-01-16 06:59:00	AAPL	Stock	78.425	78.425	78.425	78.425	800.0
2020-01-16 07:00:00	AAPL	Stock	78.4075	78.4975	78.4075	78.4975	26744.0
2020-01-16 07:01:00	AAPL	Stock	78.4725	78.4875	78.45	78.45	5600.0
2020-01-16 07:02:00	AAPL	Stock	78.47	78.47	78.45	78.45	1348.0
2020-01-16 07:03:00	AAPL	Stock	78.4625	78.47	78.45	78.47	6400.0
2020-01-16 07:04:00	AAPL	Stock	78.48	78.4875	78.48	78.4875	1096.0
2020-01-16 07:05:00	AAPL	Stock	78.495	78.55	78.495	78.55	15928.0
2020-01-16 07:06:00	AAPL	Stock	78.55	78.5875	78.5375	78.5875	7672.0

> showing 50 of 1,145,320 rows — these rows as CSV

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