PREVIEW / stock_1min / 2019-06-17

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-06-17.parquet
  size:    15.4 MB
  rows:    1,093,148
  symbols: 2,173

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-17 04:00:00	AAPL	Stock	48.375	48.375	48.16	48.16	1000.0
2019-06-17 04:26:00	AAPL	Stock	48.3375	48.3375	48.3375	48.3375	400.0
2019-06-17 04:27:00	AAPL	Stock	48.3025	48.3025	48.2925	48.2925	1200.0
2019-06-17 04:36:00	AAPL	Stock	48.29	48.29	48.29	48.29	400.0
2019-06-17 04:50:00	AAPL	Stock	48.2625	48.2625	48.2625	48.2625	400.0
2019-06-17 05:03:00	AAPL	Stock	48.2925	48.2925	48.2925	48.2925	1600.0
2019-06-17 05:09:00	AAPL	Stock	48.25	48.25	48.25	48.25	400.0
2019-06-17 05:15:00	AAPL	Stock	48.25	48.25	48.25	48.25	400.0
2019-06-17 05:46:00	AAPL	Stock	48.25	48.25	48.25	48.25	2600.0
2019-06-17 06:10:00	AAPL	Stock	48.2	48.2	48.1875	48.1875	800.0
2019-06-17 06:16:00	AAPL	Stock	48.2475	48.2475	48.2475	48.2475	1500.0
2019-06-17 06:32:00	AAPL	Stock	48.175	48.22	48.175	48.22	1980.0
2019-06-17 06:33:00	AAPL	Stock	48.225	48.225	48.225	48.225	800.0
2019-06-17 06:39:00	AAPL	Stock	48.225	48.225	48.225	48.225	2052.0
2019-06-17 06:40:00	AAPL	Stock	48.225	48.225	48.225	48.225	3600.0
2019-06-17 06:48:00	AAPL	Stock	48.25	48.25	48.25	48.25	400.0
2019-06-17 06:53:00	AAPL	Stock	48.225	48.225	48.225	48.225	400.0
2019-06-17 06:54:00	AAPL	Stock	48.225	48.225	48.225	48.225	2200.0
2019-06-17 06:55:00	AAPL	Stock	48.225	48.25	48.225	48.225	11444.0
2019-06-17 07:00:00	AAPL	Stock	48.225	48.315	48.225	48.315	14516.0
2019-06-17 07:01:00	AAPL	Stock	48.3075	48.3075	48.3075	48.3075	996.0
2019-06-17 07:02:00	AAPL	Stock	48.26	48.26	48.26	48.26	800.0
2019-06-17 07:03:00	AAPL	Stock	48.3075	48.3075	48.3075	48.3075	1396.0
2019-06-17 07:07:00	AAPL	Stock	48.2825	48.2825	48.25	48.25	4884.0
2019-06-17 07:08:00	AAPL	Stock	48.25	48.25	48.225	48.225	3484.0
2019-06-17 07:09:00	AAPL	Stock	48.25	48.25	48.25	48.25	4220.0
2019-06-17 07:10:00	AAPL	Stock	48.2725	48.28	48.2725	48.28	1200.0
2019-06-17 07:11:00	AAPL	Stock	48.275	48.275	48.275	48.275	400.0
2019-06-17 07:16:00	AAPL	Stock	48.3	48.3	48.3	48.3	400.0
2019-06-17 07:19:00	AAPL	Stock	48.3375	48.3375	48.325	48.325	2976.0
2019-06-17 07:20:00	AAPL	Stock	48.345	48.345	48.345	48.345	400.0
2019-06-17 07:26:00	AAPL	Stock	48.3375	48.3375	48.3375	48.3375	400.0
2019-06-17 07:34:00	AAPL	Stock	48.325	48.325	48.325	48.325	2000.0
2019-06-17 07:39:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	2000.0
2019-06-17 07:40:00	AAPL	Stock	48.3	48.3	48.3	48.3	800.0
2019-06-17 07:41:00	AAPL	Stock	48.3	48.3	48.3	48.3	1280.0
2019-06-17 07:45:00	AAPL	Stock	48.3375	48.3375	48.3375	48.3375	1360.0
2019-06-17 07:46:00	AAPL	Stock	48.3375	48.3375	48.3375	48.3375	3600.0
2019-06-17 07:47:00	AAPL	Stock	48.3375	48.3375	48.3375	48.3375	1100.0
2019-06-17 07:50:00	AAPL	Stock	48.3425	48.3425	48.3375	48.3375	4744.0
2019-06-17 07:52:00	AAPL	Stock	48.315	48.315	48.3075	48.3075	9600.0
2019-06-17 07:56:00	AAPL	Stock	48.375	48.375	48.375	48.375	13752.0
2019-06-17 07:58:00	AAPL	Stock	48.38	48.38	48.38	48.38	1592.0
2019-06-17 08:00:00	AAPL	Stock	48.3125	48.3625	48.25	48.3	30376.0
2019-06-17 08:02:00	AAPL	Stock	48.3475	48.3475	48.3475	48.3475	3564.0
2019-06-17 08:12:00	AAPL	Stock	48.37	48.37	48.37	48.37	600.0
2019-06-17 08:14:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	400.0
2019-06-17 08:17:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	5000.0
2019-06-17 08:22:00	AAPL	Stock	48.35	48.35	48.35	48.35	1600.0
2019-06-17 08:27:00	AAPL	Stock	48.3425	48.3425	48.3425	48.3425	400.0

> showing 50 of 1,093,148 rows — these rows as CSV

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