PREVIEW / stock_1min / 2018-01-05

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-01-05.parquet
  size:    16.4 MB
  rows:    1,099,068
  symbols: 2,427

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-01-05 04:00:00	AAPL	Stock	43.175	43.175	43.175	43.175	5476.0
2018-01-05 04:45:00	AAPL	Stock	43.25	43.25	43.25	43.25	3600.0
2018-01-05 04:46:00	AAPL	Stock	43.25	43.25	43.25	43.25	2800.0
2018-01-05 04:48:00	AAPL	Stock	43.25	43.25	43.25	43.25	800.0
2018-01-05 04:57:00	AAPL	Stock	43.25	43.25	43.25	43.25	3600.0
2018-01-05 05:30:00	AAPL	Stock	43.25	43.25	43.25	43.25	800.0
2018-01-05 05:35:00	AAPL	Stock	43.32	43.34	43.32	43.34	4724.0
2018-01-05 05:36:00	AAPL	Stock	43.34	43.35	43.34	43.35	10096.0
2018-01-05 05:41:00	AAPL	Stock	43.35	43.35	43.35	43.35	800.0
2018-01-05 05:42:00	AAPL	Stock	43.36	43.36	43.36	43.36	400.0
2018-01-05 05:49:00	AAPL	Stock	43.36	43.36	43.36	43.36	2000.0
2018-01-05 05:53:00	AAPL	Stock	43.36	43.36	43.36	43.36	5600.0
2018-01-05 06:02:00	AAPL	Stock	43.375	43.375	43.375	43.375	800.0
2018-01-05 06:03:00	AAPL	Stock	43.38	43.38	43.38	43.38	400.0
2018-01-05 06:15:00	AAPL	Stock	43.4	43.4	43.4	43.4	400.0
2018-01-05 06:16:00	AAPL	Stock	43.38	43.38	43.38	43.38	892.0
2018-01-05 06:28:00	AAPL	Stock	43.355	43.355	43.35	43.35	8160.0
2018-01-05 06:45:00	AAPL	Stock	43.33	43.33	43.33	43.33	400.0
2018-01-05 06:46:00	AAPL	Stock	43.33	43.33	43.33	43.33	1600.0
2018-01-05 06:47:00	AAPL	Stock	43.33	43.33	43.315	43.33	5864.0
2018-01-05 06:49:00	AAPL	Stock	43.33	43.33	43.33	43.33	3104.0
2018-01-05 06:51:00	AAPL	Stock	43.33	43.33	43.33	43.33	1812.0
2018-01-05 06:53:00	AAPL	Stock	43.33	43.33	43.33	43.33	6940.0
2018-01-05 06:59:00	AAPL	Stock	43.325	43.325	43.325	43.325	400.0
2018-01-05 07:00:00	AAPL	Stock	43.33	43.33	43.33	43.33	400.0
2018-01-05 07:01:00	AAPL	Stock	43.3325	43.3325	43.3325	43.3325	1464.0
2018-01-05 07:02:00	AAPL	Stock	43.325	43.3375	43.325	43.3375	800.0
2018-01-05 07:03:00	AAPL	Stock	43.325	43.3275	43.3225	43.3275	10480.0
2018-01-05 07:04:00	AAPL	Stock	43.3225	43.3225	43.3125	43.3125	8920.0
2018-01-05 07:05:00	AAPL	Stock	43.3225	43.3225	43.3225	43.3225	2248.0
2018-01-05 07:08:00	AAPL	Stock	43.325	43.325	43.325	43.325	2000.0
2018-01-05 07:09:00	AAPL	Stock	43.325	43.325	43.325	43.325	2000.0
2018-01-05 07:11:00	AAPL	Stock	43.33	43.33	43.33	43.33	1456.0
2018-01-05 07:12:00	AAPL	Stock	43.33	43.33	43.33	43.33	8964.0
2018-01-05 07:15:00	AAPL	Stock	43.3425	43.345	43.3425	43.345	2476.0
2018-01-05 07:17:00	AAPL	Stock	43.3325	43.3325	43.3	43.325	8156.0
2018-01-05 07:18:00	AAPL	Stock	43.2875	43.2875	43.2875	43.2875	2012.0
2018-01-05 07:21:00	AAPL	Stock	43.2925	43.2925	43.2925	43.2925	3840.0
2018-01-05 07:22:00	AAPL	Stock	43.2925	43.325	43.2925	43.325	6800.0
2018-01-05 07:31:00	AAPL	Stock	43.3225	43.325	43.3225	43.325	1600.0
2018-01-05 07:32:00	AAPL	Stock	43.3375	43.3375	43.3375	43.3375	4936.0
2018-01-05 07:33:00	AAPL	Stock	43.345	43.3525	43.345	43.3525	4800.0
2018-01-05 07:36:00	AAPL	Stock	43.3525	43.3575	43.345	43.345	2000.0
2018-01-05 07:40:00	AAPL	Stock	43.35	43.3625	43.35	43.3625	10400.0
2018-01-05 07:41:00	AAPL	Stock	43.3625	43.3625	43.3625	43.3625	800.0
2018-01-05 07:43:00	AAPL	Stock	43.385	43.3875	43.385	43.3875	8400.0
2018-01-05 07:44:00	AAPL	Stock	43.3875	43.3875	43.3875	43.3875	6984.0
2018-01-05 07:46:00	AAPL	Stock	43.3875	43.3875	43.3875	43.3875	400.0
2018-01-05 07:50:00	AAPL	Stock	43.365	43.365	43.3625	43.3625	3200.0
2018-01-05 07:54:00	AAPL	Stock	43.3525	43.3525	43.3525	43.3525	400.0

> showing 50 of 1,099,068 rows — these rows as CSV

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