PREVIEW / stock_1min / 2019-09-12

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-09-12.parquet
  size:    16.6 MB
  rows:    1,162,014
  symbols: 2,164

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-12 04:00:00	AAPL	Stock	56.3275	56.3275	56.2375	56.24	6444.0
2019-09-12 04:01:00	AAPL	Stock	56.25	56.25	56.21	56.2125	14152.0
2019-09-12 04:02:00	AAPL	Stock	56.175	56.2175	56.175	56.185	9732.0
2019-09-12 04:04:00	AAPL	Stock	56.175	56.175	56.175	56.175	600.0
2019-09-12 04:05:00	AAPL	Stock	56.1475	56.15	56.1475	56.15	1392.0
2019-09-12 04:08:00	AAPL	Stock	56.125	56.125	56.125	56.125	800.0
2019-09-12 04:17:00	AAPL	Stock	56.11	56.11	56.11	56.11	960.0
2019-09-12 04:18:00	AAPL	Stock	56.11	56.11	56.11	56.11	920.0
2019-09-12 04:19:00	AAPL	Stock	56.1	56.1	56.1	56.1	400.0
2019-09-12 04:21:00	AAPL	Stock	56.09	56.09	56.06	56.06	1600.0
2019-09-12 04:22:00	AAPL	Stock	56.075	56.075	56.075	56.075	400.0
2019-09-12 04:23:00	AAPL	Stock	56.1	56.1	56.1	56.1	400.0
2019-09-12 04:24:00	AAPL	Stock	56.1025	56.1025	56.1025	56.1025	792.0
2019-09-12 04:26:00	AAPL	Stock	56.1375	56.1375	56.1375	56.1375	2000.0
2019-09-12 04:27:00	AAPL	Stock	56.1375	56.1375	56.1375	56.1375	800.0
2019-09-12 04:30:00	AAPL	Stock	56.125	56.125	56.125	56.125	400.0
2019-09-12 04:46:00	AAPL	Stock	56.105	56.105	56.105	56.105	400.0
2019-09-12 04:50:00	AAPL	Stock	56.0875	56.0875	56.0875	56.0875	1440.0
2019-09-12 04:52:00	AAPL	Stock	56.0575	56.0575	56.0575	56.0575	1200.0
2019-09-12 04:53:00	AAPL	Stock	56.0525	56.0525	56.0525	56.0525	488.0
2019-09-12 04:56:00	AAPL	Stock	56.0125	56.0125	56.0125	56.0125	400.0
2019-09-12 04:57:00	AAPL	Stock	56.0	56.0	56.0	56.0	400.0
2019-09-12 05:00:00	AAPL	Stock	55.97	56.005	55.9625	55.995	4000.0
2019-09-12 05:01:00	AAPL	Stock	55.9875	55.9875	55.9875	55.9875	1136.0
2019-09-12 05:03:00	AAPL	Stock	55.95	56.0075	55.95	56.0075	10204.0
2019-09-12 05:05:00	AAPL	Stock	55.9975	55.9975	55.9975	55.9975	2000.0
2019-09-12 05:11:00	AAPL	Stock	56.015	56.05	56.015	56.05	1152.0
2019-09-12 05:12:00	AAPL	Stock	56.0175	56.0175	56.0175	56.0175	800.0
2019-09-12 05:18:00	AAPL	Stock	56.015	56.015	56.015	56.015	736.0
2019-09-12 05:19:00	AAPL	Stock	56.01	56.01	56.01	56.01	4000.0
2019-09-12 05:21:00	AAPL	Stock	56.0025	56.0025	56.0025	56.0025	2380.0
2019-09-12 05:35:00	AAPL	Stock	56.0175	56.0175	56.0175	56.0175	960.0
2019-09-12 05:40:00	AAPL	Stock	56.02	56.02	56.015	56.015	848.0
2019-09-12 05:41:00	AAPL	Stock	56.06	56.075	56.06	56.075	9592.0
2019-09-12 05:42:00	AAPL	Stock	56.02	56.02	56.015	56.015	2000.0
2019-09-12 05:43:00	AAPL	Stock	56.015	56.015	56.015	56.015	840.0
2019-09-12 05:47:00	AAPL	Stock	56.015	56.015	56.015	56.015	1156.0
2019-09-12 05:48:00	AAPL	Stock	56.015	56.015	56.015	56.015	11716.0
2019-09-12 05:56:00	AAPL	Stock	55.975	55.975	55.975	55.975	800.0
2019-09-12 05:57:00	AAPL	Stock	55.975	55.975	55.975	55.975	2000.0
2019-09-12 05:58:00	AAPL	Stock	55.9775	55.9775	55.975	55.975	2000.0
2019-09-12 06:00:00	AAPL	Stock	55.975	55.975	55.975	55.975	1692.0
2019-09-12 06:02:00	AAPL	Stock	55.98	56.0	55.98	56.0	2800.0
2019-09-12 06:04:00	AAPL	Stock	56.0	56.0	56.0	56.0	592.0
2019-09-12 06:09:00	AAPL	Stock	56.02	56.02	56.0125	56.0125	4400.0
2019-09-12 06:16:00	AAPL	Stock	56.0475	56.0475	56.0475	56.0475	1192.0
2019-09-12 06:19:00	AAPL	Stock	56.0	56.0	56.0	56.0	400.0
2019-09-12 06:20:00	AAPL	Stock	56.0	56.0	56.0	56.0	4000.0
2019-09-12 06:23:00	AAPL	Stock	56.0	56.0	56.0	56.0	800.0
2019-09-12 06:24:00	AAPL	Stock	56.0	56.0	56.0	56.0	400.0

> showing 50 of 1,162,014 rows — these rows as CSV

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