PREVIEW / stock_1min / 2019-07-09

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-09.parquet
  size:    14.8 MB
  rows:    1,059,917
  symbols: 2,194

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-07-09 04:00:00	AAPL	Stock	49.4	49.55	49.4	49.55	16456.0
2019-07-09 04:01:00	AAPL	Stock	49.55	49.565	49.55	49.565	1200.0
2019-07-09 04:02:00	AAPL	Stock	49.6	49.6	49.565	49.565	3200.0
2019-07-09 04:03:00	AAPL	Stock	49.58	49.5825	49.58	49.5825	1520.0
2019-07-09 04:04:00	AAPL	Stock	49.5825	49.5875	49.5	49.5	3200.0
2019-07-09 04:05:00	AAPL	Stock	49.5	49.5025	49.5	49.5025	1200.0
2019-07-09 04:07:00	AAPL	Stock	49.4175	49.4175	49.4175	49.4175	400.0
2019-07-09 04:09:00	AAPL	Stock	49.4275	49.4275	49.4275	49.4275	1200.0
2019-07-09 04:12:00	AAPL	Stock	49.495	49.495	49.495	49.495	644.0
2019-07-09 04:13:00	AAPL	Stock	49.5375	49.5875	49.5375	49.5875	2600.0
2019-07-09 04:14:00	AAPL	Stock	49.575	49.5875	49.575	49.5875	3372.0
2019-07-09 04:15:00	AAPL	Stock	49.5375	49.5375	49.5375	49.5375	4000.0
2019-07-09 04:20:00	AAPL	Stock	49.52	49.52	49.5025	49.5025	2200.0
2019-07-09 04:25:00	AAPL	Stock	49.5425	49.5425	49.5425	49.5425	400.0
2019-07-09 04:27:00	AAPL	Stock	49.55	49.5625	49.55	49.5625	3400.0
2019-07-09 04:29:00	AAPL	Stock	49.5275	49.5275	49.5275	49.5275	656.0
2019-07-09 04:34:00	AAPL	Stock	49.575	49.575	49.575	49.575	2000.0
2019-07-09 04:38:00	AAPL	Stock	49.5275	49.5275	49.5275	49.5275	616.0
2019-07-09 04:44:00	AAPL	Stock	49.5275	49.5275	49.51	49.51	8400.0
2019-07-09 04:45:00	AAPL	Stock	49.5	49.5	49.5	49.5	2400.0
2019-07-09 04:48:00	AAPL	Stock	49.4825	49.4825	49.4825	49.4825	800.0
2019-07-09 04:50:00	AAPL	Stock	49.5	49.5325	49.5	49.5025	2188.0
2019-07-09 04:51:00	AAPL	Stock	49.505	49.505	49.4825	49.4825	800.0
2019-07-09 04:57:00	AAPL	Stock	49.5125	49.5125	49.5125	49.5125	2000.0
2019-07-09 05:03:00	AAPL	Stock	49.555	49.575	49.555	49.575	3040.0
2019-07-09 05:05:00	AAPL	Stock	49.575	49.575	49.575	49.575	560.0
2019-07-09 05:06:00	AAPL	Stock	49.6	49.625	49.6	49.625	16400.0
2019-07-09 05:09:00	AAPL	Stock	49.625	49.675	49.625	49.66	10720.0
2019-07-09 05:10:00	AAPL	Stock	49.6625	49.6625	49.6625	49.6625	400.0
2019-07-09 05:11:00	AAPL	Stock	49.625	49.625	49.625	49.625	1600.0
2019-07-09 05:21:00	AAPL	Stock	49.65	49.65	49.65	49.65	2000.0
2019-07-09 05:25:00	AAPL	Stock	49.655	49.655	49.655	49.655	400.0
2019-07-09 05:26:00	AAPL	Stock	49.675	49.695	49.675	49.695	6000.0
2019-07-09 05:31:00	AAPL	Stock	49.65	49.65	49.65	49.65	3000.0
2019-07-09 05:32:00	AAPL	Stock	49.65	49.65	49.65	49.65	1600.0
2019-07-09 05:35:00	AAPL	Stock	49.65	49.65	49.65	49.65	800.0
2019-07-09 05:36:00	AAPL	Stock	49.675	49.675	49.675	49.675	1600.0
2019-07-09 05:37:00	AAPL	Stock	49.6975	49.6975	49.6975	49.6975	400.0
2019-07-09 05:39:00	AAPL	Stock	49.7425	49.7425	49.6925	49.6925	2400.0
2019-07-09 05:40:00	AAPL	Stock	49.6925	49.6925	49.6925	49.6925	2000.0
2019-07-09 05:42:00	AAPL	Stock	49.73	49.73	49.73	49.73	1764.0
2019-07-09 05:53:00	AAPL	Stock	49.7	49.7	49.7	49.7	400.0
2019-07-09 05:54:00	AAPL	Stock	49.7325	49.7325	49.7325	49.7325	400.0
2019-07-09 05:55:00	AAPL	Stock	49.74	49.825	49.74	49.825	4952.0
2019-07-09 05:56:00	AAPL	Stock	49.85	49.85	49.85	49.85	400.0
2019-07-09 06:04:00	AAPL	Stock	49.8375	49.8375	49.7775	49.7775	7048.0
2019-07-09 06:05:00	AAPL	Stock	49.78	49.78	49.78	49.78	1200.0
2019-07-09 06:08:00	AAPL	Stock	49.785	49.785	49.785	49.785	400.0
2019-07-09 06:11:00	AAPL	Stock	49.845	49.8475	49.845	49.8475	1604.0
2019-07-09 06:13:00	AAPL	Stock	49.845	49.845	49.845	49.845	400.0

> showing 50 of 1,059,917 rows — these rows as CSV

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