PREVIEW / stock_1min / 2019-03-27

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-03-27.parquet
  size:    16.1 MB
  rows:    1,129,551
  symbols: 2,219

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-03-27 04:00:00	AAPL	Stock	46.9625	47.22	46.9625	47.22	1900.0
2019-03-27 04:01:00	AAPL	Stock	47.14	47.14	47.14	47.14	400.0
2019-03-27 04:11:00	AAPL	Stock	47.1775	47.1775	47.1775	47.1775	400.0
2019-03-27 04:13:00	AAPL	Stock	47.1925	47.1925	47.1925	47.1925	400.0
2019-03-27 04:20:00	AAPL	Stock	47.215	47.215	47.215	47.215	400.0
2019-03-27 04:26:00	AAPL	Stock	47.1575	47.1575	47.1475	47.1475	3952.0
2019-03-27 04:27:00	AAPL	Stock	47.1475	47.1475	47.1475	47.1475	2500.0
2019-03-27 04:28:00	AAPL	Stock	47.15	47.19	47.15	47.19	1568.0
2019-03-27 04:46:00	AAPL	Stock	47.1275	47.1275	47.1275	47.1275	400.0
2019-03-27 04:57:00	AAPL	Stock	47.065	47.065	47.065	47.065	400.0
2019-03-27 05:32:00	AAPL	Stock	47.1	47.1	47.1	47.1	5776.0
2019-03-27 05:48:00	AAPL	Stock	47.005	47.005	47.0025	47.0025	888.0
2019-03-27 05:51:00	AAPL	Stock	47.0	47.0	47.0	47.0	400.0
2019-03-27 05:52:00	AAPL	Stock	46.9975	46.9975	46.995	46.9975	1200.0
2019-03-27 05:57:00	AAPL	Stock	46.9625	46.9625	46.9625	46.9625	2076.0
2019-03-27 06:02:00	AAPL	Stock	46.915	46.915	46.915	46.915	400.0
2019-03-27 06:07:00	AAPL	Stock	46.8625	46.8625	46.8625	46.8625	400.0
2019-03-27 06:10:00	AAPL	Stock	46.8375	46.85	46.8375	46.85	1200.0
2019-03-27 06:12:00	AAPL	Stock	46.875	46.875	46.875	46.875	800.0
2019-03-27 06:13:00	AAPL	Stock	46.875	46.875	46.875	46.875	400.0
2019-03-27 06:19:00	AAPL	Stock	46.875	46.875	46.875	46.875	400.0
2019-03-27 06:34:00	AAPL	Stock	46.95	46.95	46.95	46.95	400.0
2019-03-27 06:35:00	AAPL	Stock	46.95	46.95	46.95	46.95	800.0
2019-03-27 06:37:00	AAPL	Stock	46.9075	46.9075	46.9075	46.9075	724.0
2019-03-27 06:41:00	AAPL	Stock	46.93	46.93	46.93	46.93	1000.0
2019-03-27 06:44:00	AAPL	Stock	46.95	46.95	46.95	46.95	400.0
2019-03-27 06:51:00	AAPL	Stock	46.9375	46.9375	46.9225	46.9225	3444.0
2019-03-27 06:54:00	AAPL	Stock	46.9375	46.9375	46.9375	46.9375	3500.0
2019-03-27 07:00:00	AAPL	Stock	46.9425	47.0	46.9025	46.975	11620.0
2019-03-27 07:01:00	AAPL	Stock	46.975	46.975	46.93	46.94	3512.0
2019-03-27 07:02:00	AAPL	Stock	46.975	46.975	46.975	46.975	944.0
2019-03-27 07:03:00	AAPL	Stock	46.9475	46.975	46.945	46.975	4172.0
2019-03-27 07:05:00	AAPL	Stock	46.9825	46.9825	46.96	46.96	4328.0
2019-03-27 07:06:00	AAPL	Stock	46.995	46.995	46.96	46.96	5348.0
2019-03-27 07:07:00	AAPL	Stock	46.9375	46.9375	46.93	46.93	2000.0
2019-03-27 07:09:00	AAPL	Stock	46.9375	46.9425	46.9225	46.9425	4712.0
2019-03-27 07:12:00	AAPL	Stock	46.885	46.885	46.885	46.885	400.0
2019-03-27 07:13:00	AAPL	Stock	46.875	46.8775	46.875	46.875	1600.0
2019-03-27 07:14:00	AAPL	Stock	46.9075	46.915	46.8825	46.8825	5560.0
2019-03-27 07:17:00	AAPL	Stock	46.9125	46.925	46.9125	46.925	1480.0
2019-03-27 07:18:00	AAPL	Stock	46.9375	46.9375	46.9375	46.9375	7620.0
2019-03-27 07:19:00	AAPL	Stock	46.95	46.9575	46.95	46.9575	2000.0
2019-03-27 07:26:00	AAPL	Stock	46.99	47.0	46.9575	46.9575	22796.0
2019-03-27 07:27:00	AAPL	Stock	46.9575	46.975	46.9575	46.975	3200.0
2019-03-27 07:28:00	AAPL	Stock	46.9825	46.9825	46.9825	46.9825	800.0
2019-03-27 07:29:00	AAPL	Stock	46.96	46.96	46.96	46.96	400.0
2019-03-27 07:30:00	AAPL	Stock	46.9925	47.0025	46.975	47.0025	7892.0
2019-03-27 07:31:00	AAPL	Stock	47.0475	47.0675	47.005	47.005	1600.0
2019-03-27 07:32:00	AAPL	Stock	47.015	47.015	47.015	47.015	5200.0
2019-03-27 07:35:00	AAPL	Stock	47.0325	47.0375	47.0325	47.0375	800.0

> showing 50 of 1,129,551 rows — these rows as CSV

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