PREVIEW / stock_1min / 2019-07-05

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-05.parquet
  size:    14.1 MB
  rows:    1,012,424
  symbols: 2,161

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-05 04:00:00	AAPL	Stock	51.1025	51.1025	51.1025	51.1025	404.0
2019-07-05 04:02:00	AAPL	Stock	51.1375	51.1375	51.1375	51.1375	492.0
2019-07-05 04:07:00	AAPL	Stock	51.0875	51.0875	51.0775	51.0775	3508.0
2019-07-05 04:28:00	AAPL	Stock	50.98	50.98	50.98	50.98	448.0
2019-07-05 04:51:00	AAPL	Stock	50.98	50.9875	50.98	50.9825	1308.0
2019-07-05 04:53:00	AAPL	Stock	50.895	50.895	50.895	50.895	400.0
2019-07-05 05:06:00	AAPL	Stock	50.9175	50.9175	50.9175	50.9175	2140.0
2019-07-05 05:07:00	AAPL	Stock	51.0	51.0	51.0	51.0	400.0
2019-07-05 05:58:00	AAPL	Stock	50.95	50.95	50.95	50.95	2000.0
2019-07-05 05:59:00	AAPL	Stock	50.95	50.95	50.95	50.95	1000.0
2019-07-05 06:14:00	AAPL	Stock	50.9675	50.9675	50.9675	50.9675	400.0
2019-07-05 06:17:00	AAPL	Stock	50.97	50.97	50.9625	50.9625	2800.0
2019-07-05 06:19:00	AAPL	Stock	50.9625	50.9625	50.9625	50.9625	400.0
2019-07-05 06:20:00	AAPL	Stock	50.97	50.97	50.97	50.97	600.0
2019-07-05 06:21:00	AAPL	Stock	50.97	50.97	50.97	50.97	400.0
2019-07-05 06:22:00	AAPL	Stock	51.0	51.0	51.0	51.0	400.0
2019-07-05 06:34:00	AAPL	Stock	50.9625	50.9625	50.9625	50.9625	1628.0
2019-07-05 06:55:00	AAPL	Stock	50.9625	50.9625	50.9625	50.9625	400.0
2019-07-05 07:00:00	AAPL	Stock	50.95	51.0225	50.95	51.0	3196.0
2019-07-05 07:02:00	AAPL	Stock	51.02	51.02	51.02	51.02	800.0
2019-07-05 07:03:00	AAPL	Stock	51.0075	51.0075	51.0075	51.0075	800.0
2019-07-05 07:05:00	AAPL	Stock	51.025	51.025	51.025	51.025	800.0
2019-07-05 07:08:00	AAPL	Stock	51.0025	51.0025	51.0025	51.0025	400.0
2019-07-05 07:09:00	AAPL	Stock	51.0025	51.0025	51.0	51.0	928.0
2019-07-05 07:11:00	AAPL	Stock	51.0	51.0175	51.0	51.0175	3592.0
2019-07-05 07:12:00	AAPL	Stock	51.015	51.0225	51.015	51.0225	3600.0
2019-07-05 07:15:00	AAPL	Stock	51.0175	51.0175	51.0175	51.0175	400.0
2019-07-05 07:16:00	AAPL	Stock	51.02	51.02	51.02	51.02	2000.0
2019-07-05 07:17:00	AAPL	Stock	51.02	51.0225	51.0175	51.0225	2296.0
2019-07-05 07:20:00	AAPL	Stock	51.005	51.005	51.005	51.005	404.0
2019-07-05 07:23:00	AAPL	Stock	51.0025	51.0025	51.0	51.0	3188.0
2019-07-05 07:34:00	AAPL	Stock	51.01	51.0225	51.01	51.0225	4064.0
2019-07-05 07:35:00	AAPL	Stock	51.025	51.025	51.025	51.025	1600.0
2019-07-05 07:36:00	AAPL	Stock	51.0275	51.0275	51.025	51.025	1376.0
2019-07-05 07:46:00	AAPL	Stock	51.025	51.025	51.025	51.025	800.0
2019-07-05 07:51:00	AAPL	Stock	51.025	51.025	51.025	51.025	2328.0
2019-07-05 08:00:00	AAPL	Stock	51.01	51.0475	50.9875	51.02	26700.0
2019-07-05 08:01:00	AAPL	Stock	51.005	51.005	51.0	51.0	5912.0
2019-07-05 08:02:00	AAPL	Stock	50.9975	50.9975	50.9775	50.9775	4568.0
2019-07-05 08:03:00	AAPL	Stock	50.995	50.995	50.995	50.995	2080.0
2019-07-05 08:04:00	AAPL	Stock	50.9775	51.02	50.9775	51.02	800.0
2019-07-05 08:06:00	AAPL	Stock	50.9875	50.9875	50.9875	50.9875	600.0
2019-07-05 08:10:00	AAPL	Stock	51.02	51.02	51.02	51.02	800.0
2019-07-05 08:16:00	AAPL	Stock	51.0	51.0	51.0	51.0	2656.0
2019-07-05 08:17:00	AAPL	Stock	51.0	51.0125	51.0	51.0125	1400.0
2019-07-05 08:18:00	AAPL	Stock	51.0	51.0	51.0	51.0	400.0
2019-07-05 08:24:00	AAPL	Stock	51.0125	51.0125	51.0125	51.0125	4656.0
2019-07-05 08:25:00	AAPL	Stock	51.0125	51.0125	51.0125	51.0125	400.0
2019-07-05 08:26:00	AAPL	Stock	51.0125	51.0125	51.0125	51.0125	4400.0
2019-07-05 08:28:00	AAPL	Stock	51.0025	51.0125	51.0025	51.0125	2644.0

> showing 50 of 1,012,424 rows — these rows as CSV

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