PREVIEW / stock_1min / 2018-05-01

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-05-01.parquet
  size:    14.7 MB
  rows:    1,067,624
  symbols: 2,373

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
2018-05-01 04:00:00	AAPL	Stock	41.55	41.55	41.55	41.55	1904.0
2018-05-01 04:11:00	AAPL	Stock	41.535	41.55	41.535	41.55	1600.0
2018-05-01 04:14:00	AAPL	Stock	41.55	41.55	41.55	41.55	6000.0
2018-05-01 04:38:00	AAPL	Stock	41.525	41.525	41.5125	41.5125	6800.0
2018-05-01 04:39:00	AAPL	Stock	41.55	41.5975	41.55	41.5975	2708.0
2018-05-01 04:45:00	AAPL	Stock	41.5	41.5	41.5	41.5	400.0
2018-05-01 04:47:00	AAPL	Stock	41.5	41.5	41.5	41.5	400.0
2018-05-01 04:48:00	AAPL	Stock	41.5	41.5	41.5	41.5	400.0
2018-05-01 04:58:00	AAPL	Stock	41.495	41.5	41.495	41.5	1480.0
2018-05-01 06:19:00	AAPL	Stock	41.47	41.47	41.47	41.47	400.0
2018-05-01 06:25:00	AAPL	Stock	41.4275	41.4325	41.425	41.425	2400.0
2018-05-01 06:45:00	AAPL	Stock	41.475	41.475	41.475	41.475	400.0
2018-05-01 06:51:00	AAPL	Stock	41.5275	41.5275	41.5275	41.5275	800.0
2018-05-01 06:54:00	AAPL	Stock	41.5275	41.5275	41.5275	41.5275	1200.0
2018-05-01 06:58:00	AAPL	Stock	41.475	41.475	41.475	41.475	800.0
2018-05-01 07:00:00	AAPL	Stock	41.5	41.55	41.5	41.55	13152.0
2018-05-01 07:01:00	AAPL	Stock	41.5275	41.55	41.525	41.55	2780.0
2018-05-01 07:02:00	AAPL	Stock	41.545	41.5625	41.545	41.56	7784.0
2018-05-01 07:03:00	AAPL	Stock	41.5625	41.5625	41.5625	41.5625	800.0
2018-05-01 07:04:00	AAPL	Stock	41.575	41.5875	41.575	41.5875	2400.0
2018-05-01 07:05:00	AAPL	Stock	41.5875	41.5875	41.5775	41.5775	9420.0
2018-05-01 07:06:00	AAPL	Stock	41.5775	41.5875	41.5775	41.58	4400.0
2018-05-01 07:07:00	AAPL	Stock	41.555	41.555	41.55	41.55	4484.0
2018-05-01 07:08:00	AAPL	Stock	41.5875	41.5975	41.5875	41.5875	1720.0
2018-05-01 07:09:00	AAPL	Stock	41.575	41.575	41.575	41.575	1800.0
2018-05-01 07:10:00	AAPL	Stock	41.5875	41.5875	41.5875	41.5875	3200.0
2018-05-01 07:11:00	AAPL	Stock	41.59	41.59	41.5875	41.5875	7488.0
2018-05-01 07:12:00	AAPL	Stock	41.5925	41.62	41.5925	41.62	1720.0
2018-05-01 07:13:00	AAPL	Stock	41.62	41.62	41.62	41.62	400.0
2018-05-01 07:14:00	AAPL	Stock	41.63	41.685	41.6275	41.6825	7200.0
2018-05-01 07:15:00	AAPL	Stock	41.6625	41.675	41.65	41.675	10400.0
2018-05-01 07:16:00	AAPL	Stock	41.675	41.685	41.675	41.685	4200.0
2018-05-01 07:17:00	AAPL	Stock	41.6625	41.665	41.6275	41.6275	7600.0
2018-05-01 07:18:00	AAPL	Stock	41.6275	41.655	41.6275	41.655	1200.0
2018-05-01 07:19:00	AAPL	Stock	41.655	41.6825	41.655	41.6825	3600.0
2018-05-01 07:20:00	AAPL	Stock	41.68	41.7125	41.68	41.6825	32108.0
2018-05-01 07:21:00	AAPL	Stock	41.6825	41.7125	41.6825	41.7125	1200.0
2018-05-01 07:22:00	AAPL	Stock	41.71	41.71	41.675	41.675	2448.0
2018-05-01 07:23:00	AAPL	Stock	41.675	41.7	41.675	41.6875	9200.0
2018-05-01 07:24:00	AAPL	Stock	41.7	41.7	41.69	41.7	9000.0
2018-05-01 07:25:00	AAPL	Stock	41.69	41.6975	41.685	41.6975	3000.0
2018-05-01 07:27:00	AAPL	Stock	41.6625	41.6625	41.6375	41.6375	3600.0
2018-05-01 07:29:00	AAPL	Stock	41.64	41.6625	41.64	41.6625	9560.0
2018-05-01 07:30:00	AAPL	Stock	41.6575	41.6575	41.6575	41.6575	600.0
2018-05-01 07:31:00	AAPL	Stock	41.6775	41.6825	41.6775	41.6825	3664.0
2018-05-01 07:32:00	AAPL	Stock	41.6875	41.695	41.6875	41.695	1600.0
2018-05-01 07:33:00	AAPL	Stock	41.705	41.74	41.705	41.74	8648.0
2018-05-01 07:34:00	AAPL	Stock	41.74	41.74	41.7125	41.7125	12800.0
2018-05-01 07:37:00	AAPL	Stock	41.7	41.7	41.67	41.7	26364.0
2018-05-01 07:38:00	AAPL	Stock	41.7	41.7	41.665	41.665	6408.0

> showing 50 of 1,067,624 rows — these rows as CSV

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