PREVIEW / stock_1min / 2019-07-23

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-23.parquet
  size:    15.3 MB
  rows:    1,076,885
  symbols: 2,170

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-23 04:00:00	AAPL	Stock	52.0	52.0	51.995	51.995	1200.0
2019-07-23 04:02:00	AAPL	Stock	51.9225	51.925	51.9225	51.925	2000.0
2019-07-23 04:03:00	AAPL	Stock	51.925	51.93	51.925	51.93	800.0
2019-07-23 04:04:00	AAPL	Stock	51.925	51.925	51.8775	51.8775	2000.0
2019-07-23 04:05:00	AAPL	Stock	51.875	51.875	51.875	51.875	2000.0
2019-07-23 04:06:00	AAPL	Stock	51.875	51.875	51.875	51.875	1984.0
2019-07-23 04:15:00	AAPL	Stock	51.9175	51.9175	51.9175	51.9175	3276.0
2019-07-23 04:22:00	AAPL	Stock	51.9125	51.9125	51.9125	51.9125	400.0
2019-07-23 04:25:00	AAPL	Stock	51.935	51.935	51.935	51.935	1000.0
2019-07-23 04:34:00	AAPL	Stock	51.9625	51.9625	51.9625	51.9625	2400.0
2019-07-23 04:40:00	AAPL	Stock	51.925	51.925	51.925	51.925	2400.0
2019-07-23 04:41:00	AAPL	Stock	51.925	51.925	51.925	51.925	1200.0
2019-07-23 04:42:00	AAPL	Stock	51.9	51.9	51.9	51.9	400.0
2019-07-23 04:44:00	AAPL	Stock	51.9	51.9	51.9	51.9	800.0
2019-07-23 04:55:00	AAPL	Stock	51.9	51.9025	51.9	51.9	5724.0
2019-07-23 04:56:00	AAPL	Stock	51.9	51.9	51.885	51.885	3760.0
2019-07-23 04:58:00	AAPL	Stock	51.91	51.91	51.91	51.91	2420.0
2019-07-23 04:59:00	AAPL	Stock	51.9075	51.9075	51.9075	51.9075	800.0
2019-07-23 05:05:00	AAPL	Stock	51.9075	51.9075	51.9075	51.9075	800.0
2019-07-23 05:06:00	AAPL	Stock	51.9075	51.9125	51.9075	51.9125	2800.0
2019-07-23 05:07:00	AAPL	Stock	51.8925	51.8925	51.8875	51.8875	816.0
2019-07-23 05:24:00	AAPL	Stock	51.93	51.93	51.93	51.93	400.0
2019-07-23 06:13:00	AAPL	Stock	51.975	51.975	51.975	51.975	1800.0
2019-07-23 06:14:00	AAPL	Stock	51.9775	51.9775	51.9775	51.9775	400.0
2019-07-23 06:15:00	AAPL	Stock	52.0	52.0	52.0	52.0	800.0
2019-07-23 06:23:00	AAPL	Stock	52.0	52.0	52.0	52.0	1600.0
2019-07-23 06:25:00	AAPL	Stock	52.015	52.015	52.015	52.015	800.0
2019-07-23 06:27:00	AAPL	Stock	52.0125	52.015	52.0125	52.015	1600.0
2019-07-23 06:29:00	AAPL	Stock	52.0325	52.0325	52.0325	52.0325	2000.0
2019-07-23 06:30:00	AAPL	Stock	52.0475	52.0475	52.0475	52.0475	2504.0
2019-07-23 06:33:00	AAPL	Stock	52.025	52.025	52.025	52.025	2400.0
2019-07-23 06:48:00	AAPL	Stock	51.9925	51.9925	51.9925	51.9925	1176.0
2019-07-23 06:54:00	AAPL	Stock	51.975	51.975	51.975	51.975	800.0
2019-07-23 07:00:00	AAPL	Stock	52.0	52.0	51.975	51.975	12068.0
2019-07-23 07:03:00	AAPL	Stock	51.98	51.98	51.975	51.975	10800.0
2019-07-23 07:05:00	AAPL	Stock	51.9725	51.9725	51.96	51.96	13248.0
2019-07-23 07:06:00	AAPL	Stock	51.9625	51.975	51.9625	51.975	4668.0
2019-07-23 07:07:00	AAPL	Stock	51.975	52.0	51.975	52.0	11808.0
2019-07-23 07:09:00	AAPL	Stock	51.98	52.0	51.98	51.9975	3200.0
2019-07-23 07:11:00	AAPL	Stock	51.9875	51.9875	51.9625	51.9625	1220.0
2019-07-23 07:13:00	AAPL	Stock	51.9825	51.9875	51.9825	51.9875	2820.0
2019-07-23 07:15:00	AAPL	Stock	51.975	51.975	51.975	51.975	400.0
2019-07-23 07:16:00	AAPL	Stock	51.9875	52.025	51.9875	52.025	9480.0
2019-07-23 07:17:00	AAPL	Stock	52.0175	52.025	52.0175	52.025	4856.0
2019-07-23 07:18:00	AAPL	Stock	52.0225	52.0225	52.0225	52.0225	600.0
2019-07-23 07:20:00	AAPL	Stock	52.0225	52.0225	52.02	52.02	960.0
2019-07-23 07:21:00	AAPL	Stock	52.0125	52.0125	52.0125	52.0125	1328.0
2019-07-23 07:24:00	AAPL	Stock	52.005	52.025	52.005	52.025	3960.0
2019-07-23 07:25:00	AAPL	Stock	52.0125	52.0125	52.01	52.01	1200.0
2019-07-23 07:26:00	AAPL	Stock	52.0175	52.025	52.0175	52.025	2400.0

> showing 50 of 1,076,885 rows — these rows as CSV

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