PREVIEW / stock_1min / 2019-06-25

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-06-25.parquet
  size:    16.0 MB
  rows:    1,124,029
  symbols: 2,199

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-25 04:00:00	AAPL	Stock	49.5625	49.5625	49.465	49.465	800.0
2019-06-25 04:57:00	AAPL	Stock	49.4	49.4	49.4	49.4	2000.0
2019-06-25 05:02:00	AAPL	Stock	49.395	49.395	49.395	49.395	400.0
2019-06-25 05:03:00	AAPL	Stock	49.4375	49.4525	49.4375	49.4525	1880.0
2019-06-25 05:04:00	AAPL	Stock	49.4525	49.4925	49.4525	49.4925	3600.0
2019-06-25 05:08:00	AAPL	Stock	49.4575	49.4575	49.4575	49.4575	2520.0
2019-06-25 05:11:00	AAPL	Stock	49.455	49.4575	49.455	49.4575	3688.0
2019-06-25 05:31:00	AAPL	Stock	49.4375	49.4375	49.4375	49.4375	652.0
2019-06-25 05:34:00	AAPL	Stock	49.4575	49.4575	49.4575	49.4575	760.0
2019-06-25 05:35:00	AAPL	Stock	49.4725	49.4725	49.4725	49.4725	880.0
2019-06-25 05:36:00	AAPL	Stock	49.4725	49.4725	49.4725	49.4725	828.0
2019-06-25 06:04:00	AAPL	Stock	49.4175	49.4175	49.4175	49.4175	800.0
2019-06-25 06:09:00	AAPL	Stock	49.4175	49.4175	49.4175	49.4175	1196.0
2019-06-25 06:21:00	AAPL	Stock	49.41	49.41	49.41	49.41	400.0
2019-06-25 06:58:00	AAPL	Stock	49.4725	49.4725	49.4725	49.4725	400.0
2019-06-25 07:00:00	AAPL	Stock	49.4725	49.4725	49.4725	49.4725	4024.0
2019-06-25 07:04:00	AAPL	Stock	49.5425	49.56	49.5375	49.56	4376.0
2019-06-25 07:05:00	AAPL	Stock	49.5625	49.5625	49.5625	49.5625	400.0
2019-06-25 07:13:00	AAPL	Stock	49.555	49.555	49.555	49.555	400.0
2019-06-25 07:16:00	AAPL	Stock	49.5525	49.5525	49.5525	49.5525	400.0
2019-06-25 07:17:00	AAPL	Stock	49.5275	49.5275	49.5275	49.5275	1676.0
2019-06-25 07:18:00	AAPL	Stock	49.53	49.53	49.525	49.525	800.0
2019-06-25 07:19:00	AAPL	Stock	49.525	49.525	49.525	49.525	876.0
2019-06-25 07:20:00	AAPL	Stock	49.5525	49.615	49.5275	49.5275	4960.0
2019-06-25 07:31:00	AAPL	Stock	49.5525	49.5525	49.5525	49.5525	1000.0
2019-06-25 07:32:00	AAPL	Stock	49.53	49.53	49.525	49.525	3600.0
2019-06-25 07:34:00	AAPL	Stock	49.525	49.5275	49.525	49.5275	1200.0
2019-06-25 07:39:00	AAPL	Stock	49.5375	49.5375	49.5375	49.5375	400.0
2019-06-25 07:40:00	AAPL	Stock	49.55	49.55	49.55	49.55	400.0
2019-06-25 07:41:00	AAPL	Stock	49.5375	49.5375	49.5375	49.5375	9720.0
2019-06-25 07:42:00	AAPL	Stock	49.525	49.525	49.525	49.525	800.0
2019-06-25 07:43:00	AAPL	Stock	49.525	49.525	49.525	49.525	400.0
2019-06-25 07:44:00	AAPL	Stock	49.5275	49.5275	49.525	49.525	2800.0
2019-06-25 07:46:00	AAPL	Stock	49.5125	49.5225	49.5125	49.5225	1120.0
2019-06-25 07:53:00	AAPL	Stock	49.5375	49.5375	49.5375	49.5375	800.0
2019-06-25 08:00:00	AAPL	Stock	49.55	49.56	49.4725	49.56	16176.0
2019-06-25 08:01:00	AAPL	Stock	49.5725	49.575	49.5725	49.575	4308.0
2019-06-25 08:02:00	AAPL	Stock	49.575	49.575	49.5725	49.575	4692.0
2019-06-25 08:03:00	AAPL	Stock	49.5975	49.5975	49.5975	49.5975	400.0
2019-06-25 08:05:00	AAPL	Stock	49.585	49.585	49.5625	49.5625	11228.0
2019-06-25 08:06:00	AAPL	Stock	49.55	49.55	49.5475	49.5475	800.0
2019-06-25 08:19:00	AAPL	Stock	49.592	49.592	49.592	49.592	400.0
2019-06-25 08:27:00	AAPL	Stock	49.625	49.625	49.5875	49.5875	4520.0
2019-06-25 08:28:00	AAPL	Stock	49.6025	49.6025	49.6025	49.6025	400.0
2019-06-25 08:29:00	AAPL	Stock	49.6125	49.6125	49.6075	49.6075	5608.0
2019-06-25 08:30:00	AAPL	Stock	49.6025	49.6025	49.6025	49.6025	400.0
2019-06-25 08:31:00	AAPL	Stock	49.615	49.615	49.615	49.615	1200.0
2019-06-25 08:32:00	AAPL	Stock	49.6075	49.6375	49.6075	49.6325	10796.0
2019-06-25 08:33:00	AAPL	Stock	49.6325	49.6325	49.6325	49.6325	1220.0
2019-06-25 08:34:00	AAPL	Stock	49.635	49.6375	49.635	49.6375	800.0

> showing 50 of 1,124,029 rows — these rows as CSV

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