PREVIEW / stock_1min / 2020-01-24

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-01-24.parquet
  size:    18.5 MB
  rows:    1,151,592
  symbols: 2,061

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-24 04:00:00	AAPL	Stock	80.0825	80.125	80.0825	80.125	2396.0
2020-01-24 04:05:00	AAPL	Stock	80.125	80.125	80.125	80.125	456.0
2020-01-24 04:09:00	AAPL	Stock	80.165	80.165	80.165	80.165	776.0
2020-01-24 04:23:00	AAPL	Stock	80.13	80.13	80.13	80.13	400.0
2020-01-24 04:27:00	AAPL	Stock	80.14	80.14	80.14	80.14	400.0
2020-01-24 04:31:00	AAPL	Stock	80.14	80.16	80.14	80.16	6388.0
2020-01-24 04:32:00	AAPL	Stock	80.14	80.14	80.14	80.14	400.0
2020-01-24 04:53:00	AAPL	Stock	80.1225	80.1225	80.1225	80.1225	500.0
2020-01-24 05:19:00	AAPL	Stock	80.0975	80.0975	80.0975	80.0975	800.0
2020-01-24 05:22:00	AAPL	Stock	80.1	80.1	80.1	80.1	1908.0
2020-01-24 05:25:00	AAPL	Stock	80.075	80.075	80.075	80.075	2000.0
2020-01-24 05:30:00	AAPL	Stock	80.0525	80.0525	80.0525	80.0525	1972.0
2020-01-24 05:34:00	AAPL	Stock	80.0525	80.0525	80.0475	80.0475	9672.0
2020-01-24 05:42:00	AAPL	Stock	80.05	80.05	80.05	80.05	400.0
2020-01-24 05:44:00	AAPL	Stock	80.0475	80.0475	80.0475	80.0475	400.0
2020-01-24 05:48:00	AAPL	Stock	80.0475	80.05	80.0475	80.05	1000.0
2020-01-24 05:56:00	AAPL	Stock	80.0475	80.0475	80.0475	80.0475	444.0
2020-01-24 05:58:00	AAPL	Stock	80.04	80.04	80.04	80.04	1984.0
2020-01-24 06:08:00	AAPL	Stock	80.095	80.095	80.095	80.095	1272.0
2020-01-24 06:11:00	AAPL	Stock	80.05	80.05	80.05	80.05	2800.0
2020-01-24 06:12:00	AAPL	Stock	80.05	80.05	80.05	80.05	2000.0
2020-01-24 06:14:00	AAPL	Stock	80.05	80.05	80.05	80.05	400.0
2020-01-24 06:21:00	AAPL	Stock	80.07	80.0725	80.07	80.0725	2400.0
2020-01-24 06:22:00	AAPL	Stock	80.0475	80.0475	80.0475	80.0475	1108.0
2020-01-24 06:37:00	AAPL	Stock	80.05	80.075	80.05	80.075	5168.0
2020-01-24 06:38:00	AAPL	Stock	80.05	80.05	80.05	80.05	1364.0
2020-01-24 06:39:00	AAPL	Stock	80.025	80.025	80.025	80.025	400.0
2020-01-24 06:40:00	AAPL	Stock	80.05	80.05	80.05	80.05	6216.0
2020-01-24 06:50:00	AAPL	Stock	80.05	80.05	80.05	80.05	2000.0
2020-01-24 06:55:00	AAPL	Stock	80.075	80.075	80.075	80.075	1440.0
2020-01-24 06:59:00	AAPL	Stock	80.075	80.075	80.075	80.075	800.0
2020-01-24 07:00:00	AAPL	Stock	80.075	80.075	80.0	80.025	37064.0
2020-01-24 07:01:00	AAPL	Stock	80.025	80.0325	80.0125	80.0325	6728.0
2020-01-24 07:02:00	AAPL	Stock	80.0175	80.0175	80.0175	80.0175	10400.0
2020-01-24 07:03:00	AAPL	Stock	80.0175	80.025	79.975	80.0125	46052.0
2020-01-24 07:04:00	AAPL	Stock	79.94	80.0	79.94	79.995	2520.0
2020-01-24 07:05:00	AAPL	Stock	79.995	80.0	79.9875	80.0	6800.0
2020-01-24 07:06:00	AAPL	Stock	79.9875	79.9875	79.9875	79.9875	1012.0
2020-01-24 07:07:00	AAPL	Stock	80.0	80.0	79.9875	79.9875	3520.0
2020-01-24 07:08:00	AAPL	Stock	79.9975	80.0	79.9975	80.0	2776.0
2020-01-24 07:09:00	AAPL	Stock	79.9975	79.9975	79.99	79.995	5400.0
2020-01-24 07:10:00	AAPL	Stock	79.99	79.995	79.98	79.98	6880.0
2020-01-24 07:11:00	AAPL	Stock	79.9775	79.9775	79.9775	79.9775	1800.0
2020-01-24 07:13:00	AAPL	Stock	79.9875	79.9875	79.98	79.98	3488.0
2020-01-24 07:14:00	AAPL	Stock	79.98	79.98	79.97	79.97	6800.0
2020-01-24 07:16:00	AAPL	Stock	79.95	79.95	79.95	79.95	400.0
2020-01-24 07:17:00	AAPL	Stock	79.95	79.95	79.95	79.95	1180.0
2020-01-24 07:18:00	AAPL	Stock	79.95	79.95	79.95	79.95	400.0
2020-01-24 07:19:00	AAPL	Stock	79.95	79.95	79.95	79.95	1600.0
2020-01-24 07:20:00	AAPL	Stock	79.94	79.94	79.925	79.925	42340.0

> showing 50 of 1,151,592 rows — these rows as CSV

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