PREVIEW / stock_1min / 2019-06-28

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-06-28.parquet
  size:    16.6 MB
  rows:    1,170,192
  symbols: 2,200

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-06-28 04:00:00	AAPL	Stock	49.65	49.69	49.65	49.69	5216.0
2019-06-28 04:03:00	AAPL	Stock	49.61	49.61	49.61	49.61	1200.0
2019-06-28 04:05:00	AAPL	Stock	49.5025	49.5025	49.5025	49.5025	800.0
2019-06-28 04:06:00	AAPL	Stock	49.4375	49.4375	49.4375	49.4375	872.0
2019-06-28 04:10:00	AAPL	Stock	49.4775	49.4775	49.4775	49.4775	400.0
2019-06-28 04:18:00	AAPL	Stock	49.55	49.55	49.55	49.55	892.0
2019-06-28 04:20:00	AAPL	Stock	49.5625	49.5625	49.55	49.55	1108.0
2019-06-28 04:21:00	AAPL	Stock	49.55	49.55	49.55	49.55	1200.0
2019-06-28 04:41:00	AAPL	Stock	49.5775	49.5775	49.5775	49.5775	1160.0
2019-06-28 04:42:00	AAPL	Stock	49.5625	49.5625	49.5625	49.5625	400.0
2019-06-28 04:44:00	AAPL	Stock	49.5125	49.5125	49.5	49.5	1652.0
2019-06-28 04:48:00	AAPL	Stock	49.4625	49.4625	49.4375	49.4375	1372.0
2019-06-28 04:52:00	AAPL	Stock	49.495	49.495	49.495	49.495	400.0
2019-06-28 04:53:00	AAPL	Stock	49.5	49.5	49.5	49.5	800.0
2019-06-28 05:03:00	AAPL	Stock	49.5	49.5	49.5	49.5	640.0
2019-06-28 05:12:00	AAPL	Stock	49.4675	49.4675	49.4675	49.4675	1200.0
2019-06-28 05:16:00	AAPL	Stock	49.4675	49.4675	49.4675	49.4675	2248.0
2019-06-28 05:39:00	AAPL	Stock	49.48	49.48	49.48	49.48	1080.0
2019-06-28 06:17:00	AAPL	Stock	49.5225	49.5225	49.52	49.52	2800.0
2019-06-28 06:22:00	AAPL	Stock	49.5	49.5	49.475	49.475	2040.0
2019-06-28 06:48:00	AAPL	Stock	49.5	49.515	49.5	49.515	1600.0
2019-06-28 06:55:00	AAPL	Stock	49.51	49.51	49.51	49.51	400.0
2019-06-28 07:00:00	AAPL	Stock	49.5	49.575	49.475	49.55	9964.0
2019-06-28 07:01:00	AAPL	Stock	49.55	49.55	49.55	49.55	600.0
2019-06-28 07:03:00	AAPL	Stock	49.57	49.575	49.57	49.575	1220.0
2019-06-28 07:04:00	AAPL	Stock	49.575	49.575	49.575	49.575	400.0
2019-06-28 07:06:00	AAPL	Stock	49.5725	49.595	49.5725	49.595	4404.0
2019-06-28 07:07:00	AAPL	Stock	49.575	49.575	49.575	49.575	1656.0
2019-06-28 07:08:00	AAPL	Stock	49.585	49.5875	49.585	49.5875	800.0
2019-06-28 07:09:00	AAPL	Stock	49.5975	49.6175	49.5975	49.61	3944.0
2019-06-28 07:10:00	AAPL	Stock	49.6225	49.6475	49.6225	49.6475	6800.0
2019-06-28 07:11:00	AAPL	Stock	49.635	49.6375	49.6325	49.6325	1500.0
2019-06-28 07:13:00	AAPL	Stock	49.6375	49.6375	49.6375	49.6375	840.0
2019-06-28 07:14:00	AAPL	Stock	49.64	49.64	49.6375	49.64	3868.0
2019-06-28 07:15:00	AAPL	Stock	49.64	49.6625	49.64	49.6625	2164.0
2019-06-28 07:16:00	AAPL	Stock	49.6725	49.685	49.665	49.685	5400.0
2019-06-28 07:17:00	AAPL	Stock	49.685	49.6875	49.685	49.6875	1600.0
2019-06-28 07:18:00	AAPL	Stock	49.685	49.685	49.6625	49.6625	2000.0
2019-06-28 07:20:00	AAPL	Stock	49.6375	49.6375	49.6375	49.6375	1260.0
2019-06-28 07:22:00	AAPL	Stock	49.6675	49.6675	49.6675	49.6675	400.0
2019-06-28 07:23:00	AAPL	Stock	49.65	49.65	49.65	49.65	1200.0
2019-06-28 07:24:00	AAPL	Stock	49.65	49.65	49.65	49.65	400.0
2019-06-28 07:25:00	AAPL	Stock	49.64	49.6425	49.625	49.625	24640.0
2019-06-28 07:26:00	AAPL	Stock	49.6	49.6025	49.5825	49.5825	5464.0
2019-06-28 07:28:00	AAPL	Stock	49.5875	49.5875	49.5875	49.5875	400.0
2019-06-28 07:29:00	AAPL	Stock	49.565	49.5675	49.5525	49.5525	2400.0
2019-06-28 07:30:00	AAPL	Stock	49.6125	49.6125	49.6125	49.6125	480.0
2019-06-28 07:33:00	AAPL	Stock	49.6	49.6	49.6	49.6	800.0
2019-06-28 07:34:00	AAPL	Stock	49.6	49.6	49.6	49.6	400.0
2019-06-28 07:35:00	AAPL	Stock	49.5875	49.5875	49.5875	49.5875	400.0

> showing 50 of 1,170,192 rows — these rows as CSV

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