PREVIEW / stock_1min / 2019-07-24

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-24.parquet
  size:    15.8 MB
  rows:    1,115,683
  symbols: 2,189

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-24 04:04:00	AAPL	Stock	51.95	51.95	51.95	51.95	400.0
2019-07-24 04:13:00	AAPL	Stock	51.8875	51.8875	51.8875	51.8875	400.0
2019-07-24 04:20:00	AAPL	Stock	51.85	51.85	51.85	51.85	400.0
2019-07-24 04:33:00	AAPL	Stock	51.85	51.85	51.85	51.85	3996.0
2019-07-24 04:46:00	AAPL	Stock	51.7475	51.755	51.7475	51.755	800.0
2019-07-24 05:00:00	AAPL	Stock	51.8225	51.8225	51.8225	51.8225	1200.0
2019-07-24 05:03:00	AAPL	Stock	51.775	51.775	51.775	51.775	800.0
2019-07-24 05:05:00	AAPL	Stock	51.77	51.77	51.77	51.77	532.0
2019-07-24 05:07:00	AAPL	Stock	51.8275	51.8275	51.8275	51.8275	400.0
2019-07-24 05:10:00	AAPL	Stock	51.885	51.885	51.885	51.885	1800.0
2019-07-24 05:12:00	AAPL	Stock	51.8425	51.8425	51.8375	51.8375	5600.0
2019-07-24 05:32:00	AAPL	Stock	51.8675	51.8675	51.8675	51.8675	520.0
2019-07-24 05:34:00	AAPL	Stock	51.84	51.84	51.84	51.84	400.0
2019-07-24 05:36:00	AAPL	Stock	51.825	51.825	51.825	51.825	6688.0
2019-07-24 05:37:00	AAPL	Stock	51.8025	51.8025	51.8025	51.8025	520.0
2019-07-24 05:38:00	AAPL	Stock	51.795	51.795	51.795	51.795	640.0
2019-07-24 05:39:00	AAPL	Stock	51.795	51.795	51.795	51.795	920.0
2019-07-24 05:42:00	AAPL	Stock	51.785	51.785	51.775	51.775	800.0
2019-07-24 05:43:00	AAPL	Stock	51.7725	51.7725	51.7725	51.7725	400.0
2019-07-24 05:44:00	AAPL	Stock	51.77	51.77	51.77	51.77	1840.0
2019-07-24 05:45:00	AAPL	Stock	51.77	51.77	51.77	51.77	1600.0
2019-07-24 05:46:00	AAPL	Stock	51.77	51.77	51.77	51.77	2792.0
2019-07-24 06:11:00	AAPL	Stock	51.83	51.83	51.8075	51.8075	5600.0
2019-07-24 06:34:00	AAPL	Stock	51.875	51.875	51.875	51.875	400.0
2019-07-24 06:36:00	AAPL	Stock	51.9225	51.9225	51.9225	51.9225	404.0
2019-07-24 06:38:00	AAPL	Stock	51.98	51.9875	51.98	51.9875	1200.0
2019-07-24 06:39:00	AAPL	Stock	51.9875	51.9875	51.9875	51.9875	400.0
2019-07-24 06:40:00	AAPL	Stock	51.925	51.925	51.925	51.925	800.0
2019-07-24 06:57:00	AAPL	Stock	51.97	51.97	51.97	51.97	648.0
2019-07-24 06:58:00	AAPL	Stock	51.93	51.93	51.93	51.93	400.0
2019-07-24 07:01:00	AAPL	Stock	51.945	51.945	51.9425	51.9425	2856.0
2019-07-24 07:02:00	AAPL	Stock	51.9425	51.975	51.94	51.9525	4400.0
2019-07-24 07:03:00	AAPL	Stock	51.9525	51.9525	51.9225	51.9225	10096.0
2019-07-24 07:05:00	AAPL	Stock	51.9325	51.9375	51.9325	51.9375	984.0
2019-07-24 07:06:00	AAPL	Stock	51.9	51.9075	51.9	51.9	2084.0
2019-07-24 07:12:00	AAPL	Stock	51.9375	51.9375	51.9375	51.9375	400.0
2019-07-24 07:15:00	AAPL	Stock	51.9375	51.9375	51.9375	51.9375	1200.0
2019-07-24 07:16:00	AAPL	Stock	51.9375	51.95	51.9375	51.95	6800.0
2019-07-24 07:17:00	AAPL	Stock	51.95	51.95	51.95	51.95	1188.0
2019-07-24 07:18:00	AAPL	Stock	51.9675	51.975	51.9675	51.975	3200.0
2019-07-24 07:21:00	AAPL	Stock	51.995	51.9975	51.995	51.9975	2396.0
2019-07-24 07:22:00	AAPL	Stock	51.9975	52.025	51.9975	52.025	8404.0
2019-07-24 07:23:00	AAPL	Stock	52.0225	52.03	52.0225	52.03	1600.0
2019-07-24 07:24:00	AAPL	Stock	52.0175	52.025	52.0075	52.0075	2800.0
2019-07-24 07:28:00	AAPL	Stock	52.0075	52.0075	52.0075	52.0075	544.0
2019-07-24 07:29:00	AAPL	Stock	52.0075	52.035	52.0075	52.035	5600.0
2019-07-24 07:30:00	AAPL	Stock	51.9875	51.9875	51.9875	51.9875	3420.0
2019-07-24 07:37:00	AAPL	Stock	52.0225	52.025	52.02	52.02	1200.0
2019-07-24 07:38:00	AAPL	Stock	52.005	52.005	52.005	52.005	800.0
2019-07-24 07:41:00	AAPL	Stock	52.005	52.005	52.005	52.005	400.0

> showing 50 of 1,115,683 rows — these rows as CSV

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