PREVIEW / stock_1min / 2018-09-27

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-09-27.parquet
  size:    14.7 MB
  rows:    1,050,378
  symbols: 2,311

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-09-27 04:05:00	AAPL	Stock	55.37	55.37	55.37	55.37	400.0
2018-09-27 04:20:00	AAPL	Stock	55.455	55.455	55.455	55.455	400.0
2018-09-27 04:24:00	AAPL	Stock	55.455	55.455	55.455	55.455	400.0
2018-09-27 04:32:00	AAPL	Stock	55.495	55.495	55.495	55.495	400.0
2018-09-27 04:34:00	AAPL	Stock	55.55	55.55	55.55	55.55	400.0
2018-09-27 04:36:00	AAPL	Stock	55.59	55.6	55.59	55.6	4760.0
2018-09-27 04:39:00	AAPL	Stock	55.6	55.6	55.6	55.6	400.0
2018-09-27 04:41:00	AAPL	Stock	55.6	55.6	55.6	55.6	400.0
2018-09-27 04:42:00	AAPL	Stock	55.6	55.6	55.6	55.6	400.0
2018-09-27 04:51:00	AAPL	Stock	55.575	55.575	55.575	55.575	800.0
2018-09-27 04:55:00	AAPL	Stock	55.6125	55.6125	55.6125	55.6125	400.0
2018-09-27 05:03:00	AAPL	Stock	55.625	55.625	55.625	55.625	1600.0
2018-09-27 05:07:00	AAPL	Stock	55.6625	55.6625	55.6625	55.6625	1812.0
2018-09-27 05:08:00	AAPL	Stock	55.6625	55.6625	55.6625	55.6625	2000.0
2018-09-27 05:09:00	AAPL	Stock	55.6625	55.6625	55.6625	55.6625	400.0
2018-09-27 05:10:00	AAPL	Stock	55.6625	55.6625	55.6625	55.6625	400.0
2018-09-27 05:11:00	AAPL	Stock	55.65	55.6625	55.65	55.65	4848.0
2018-09-27 05:12:00	AAPL	Stock	55.6625	55.6625	55.65	55.65	1400.0
2018-09-27 05:14:00	AAPL	Stock	55.64	55.69	55.64	55.69	860.0
2018-09-27 05:23:00	AAPL	Stock	55.64	55.64	55.6	55.6	2000.0
2018-09-27 05:26:00	AAPL	Stock	55.625	55.6625	55.625	55.6625	8360.0
2018-09-27 05:29:00	AAPL	Stock	55.6025	55.6025	55.6025	55.6025	1060.0
2018-09-27 05:39:00	AAPL	Stock	55.6625	55.6725	55.6625	55.6725	1000.0
2018-09-27 05:44:00	AAPL	Stock	55.6025	55.6025	55.6025	55.6025	400.0
2018-09-27 05:46:00	AAPL	Stock	55.6125	55.6125	55.6125	55.6125	400.0
2018-09-27 05:48:00	AAPL	Stock	55.625	55.645	55.625	55.645	2512.0
2018-09-27 05:49:00	AAPL	Stock	55.6475	55.6475	55.6475	55.6475	400.0
2018-09-27 05:51:00	AAPL	Stock	55.6725	55.6725	55.6725	55.6725	400.0
2018-09-27 05:53:00	AAPL	Stock	55.665	55.665	55.665	55.665	1844.0
2018-09-27 05:58:00	AAPL	Stock	55.6925	55.6925	55.6925	55.6925	5976.0
2018-09-27 06:06:00	AAPL	Stock	55.65	55.65	55.65	55.65	968.0
2018-09-27 06:08:00	AAPL	Stock	55.685	55.6975	55.685	55.6975	3516.0
2018-09-27 06:09:00	AAPL	Stock	55.6325	55.6325	55.6275	55.6275	1800.0
2018-09-27 06:11:00	AAPL	Stock	55.63	55.63	55.63	55.63	400.0
2018-09-27 06:13:00	AAPL	Stock	55.685	55.69	55.685	55.69	4016.0
2018-09-27 06:15:00	AAPL	Stock	55.7	55.7	55.6975	55.7	6536.0
2018-09-27 06:22:00	AAPL	Stock	55.6975	55.6975	55.6975	55.6975	800.0
2018-09-27 06:23:00	AAPL	Stock	55.6975	55.7	55.6975	55.7	9200.0
2018-09-27 06:24:00	AAPL	Stock	55.7	55.72	55.7	55.71	3600.0
2018-09-27 06:30:00	AAPL	Stock	55.71	55.71	55.71	55.71	1548.0
2018-09-27 06:34:00	AAPL	Stock	55.71	55.72	55.71	55.72	4988.0
2018-09-27 06:35:00	AAPL	Stock	55.72	55.7375	55.71	55.7375	10388.0
2018-09-27 06:36:00	AAPL	Stock	55.7275	55.7275	55.7275	55.7275	1200.0
2018-09-27 06:37:00	AAPL	Stock	55.75	55.75	55.75	55.75	576.0
2018-09-27 06:40:00	AAPL	Stock	55.71	55.71	55.71	55.71	400.0
2018-09-27 06:41:00	AAPL	Stock	55.7475	55.7475	55.7475	55.7475	572.0
2018-09-27 06:42:00	AAPL	Stock	55.7175	55.7175	55.7175	55.7175	400.0
2018-09-27 07:00:00	AAPL	Stock	55.725	55.74	55.65	55.655	31624.0
2018-09-27 07:01:00	AAPL	Stock	55.67	55.6775	55.67	55.6775	4768.0
2018-09-27 07:02:00	AAPL	Stock	55.7	55.7375	55.7	55.7275	12724.0

> showing 50 of 1,050,378 rows — these rows as CSV

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