PREVIEW / stock_1min / 2019-10-01

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-10-01.parquet
  size:    16.0 MB
  rows:    1,127,122
  symbols: 2,122

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-10-01 04:00:00	AAPL	Stock	56.175	56.25	56.175	56.25	11380.0
2019-10-01 04:01:00	AAPL	Stock	56.2475	56.2475	56.2475	56.2475	400.0
2019-10-01 04:02:00	AAPL	Stock	56.25	56.25	56.25	56.25	2000.0
2019-10-01 04:07:00	AAPL	Stock	56.25	56.25	56.25	56.25	5708.0
2019-10-01 04:08:00	AAPL	Stock	56.2175	56.2175	56.2125	56.2125	1868.0
2019-10-01 04:09:00	AAPL	Stock	56.2125	56.2125	56.2125	56.2125	1208.0
2019-10-01 04:15:00	AAPL	Stock	56.1875	56.1875	56.1875	56.1875	1388.0
2019-10-01 04:29:00	AAPL	Stock	56.25	56.25	56.25	56.25	2000.0
2019-10-01 04:42:00	AAPL	Stock	56.31	56.31	56.31	56.31	3284.0
2019-10-01 04:49:00	AAPL	Stock	56.3375	56.3375	56.3375	56.3375	400.0
2019-10-01 05:00:00	AAPL	Stock	56.29	56.29	56.29	56.29	400.0
2019-10-01 05:01:00	AAPL	Stock	56.275	56.275	56.275	56.275	400.0
2019-10-01 05:02:00	AAPL	Stock	56.265	56.265	56.2475	56.2475	1376.0
2019-10-01 05:10:00	AAPL	Stock	56.2325	56.2375	56.2325	56.2375	4000.0
2019-10-01 05:11:00	AAPL	Stock	56.2375	56.2375	56.2375	56.2375	584.0
2019-10-01 05:21:00	AAPL	Stock	56.25	56.25	56.2425	56.2425	4560.0
2019-10-01 05:22:00	AAPL	Stock	56.295	56.295	56.295	56.295	400.0
2019-10-01 05:29:00	AAPL	Stock	56.245	56.245	56.245	56.245	600.0
2019-10-01 05:33:00	AAPL	Stock	56.25	56.25	56.25	56.25	1600.0
2019-10-01 05:35:00	AAPL	Stock	56.25	56.25	56.25	56.25	1816.0
2019-10-01 05:37:00	AAPL	Stock	56.2525	56.2525	56.25	56.25	1600.0
2019-10-01 05:48:00	AAPL	Stock	56.2525	56.2525	56.25	56.25	1960.0
2019-10-01 06:13:00	AAPL	Stock	56.25	56.25	56.25	56.25	652.0
2019-10-01 06:33:00	AAPL	Stock	56.255	56.255	56.25	56.25	1800.0
2019-10-01 06:34:00	AAPL	Stock	56.25	56.25	56.25	56.25	400.0
2019-10-01 06:40:00	AAPL	Stock	56.3375	56.3375	56.3375	56.3375	3888.0
2019-10-01 06:41:00	AAPL	Stock	56.3425	56.3425	56.3425	56.3425	2000.0
2019-10-01 06:42:00	AAPL	Stock	56.3425	56.3425	56.3425	56.3425	800.0
2019-10-01 06:43:00	AAPL	Stock	56.3425	56.3425	56.3425	56.3425	400.0
2019-10-01 06:50:00	AAPL	Stock	56.295	56.295	56.295	56.295	1600.0
2019-10-01 06:51:00	AAPL	Stock	56.295	56.295	56.295	56.295	1476.0
2019-10-01 06:52:00	AAPL	Stock	56.295	56.295	56.26	56.26	10176.0
2019-10-01 06:53:00	AAPL	Stock	56.265	56.265	56.2575	56.2575	1488.0
2019-10-01 06:54:00	AAPL	Stock	56.2575	56.275	56.2575	56.275	800.0
2019-10-01 06:55:00	AAPL	Stock	56.2775	56.2775	56.2775	56.2775	400.0
2019-10-01 07:00:00	AAPL	Stock	56.25	56.3125	56.2125	56.25	43284.0
2019-10-01 07:01:00	AAPL	Stock	56.25	56.27	56.25	56.27	12644.0
2019-10-01 07:02:00	AAPL	Stock	56.27	56.29	56.27	56.27	1600.0
2019-10-01 07:03:00	AAPL	Stock	56.275	56.275	56.275	56.275	1572.0
2019-10-01 07:04:00	AAPL	Stock	56.3075	56.3075	56.275	56.275	5492.0
2019-10-01 07:05:00	AAPL	Stock	56.2625	56.2625	56.25	56.25	5968.0
2019-10-01 07:06:00	AAPL	Stock	56.25	56.25	56.25	56.25	1200.0
2019-10-01 07:07:00	AAPL	Stock	56.2275	56.2275	56.2125	56.2125	2920.0
2019-10-01 07:08:00	AAPL	Stock	56.2	56.21	56.2	56.21	1600.0
2019-10-01 07:09:00	AAPL	Stock	56.2	56.2375	56.2	56.2375	16556.0
2019-10-01 07:10:00	AAPL	Stock	56.195	56.195	56.1725	56.195	12700.0
2019-10-01 07:12:00	AAPL	Stock	56.225	56.25	56.225	56.25	10240.0
2019-10-01 07:13:00	AAPL	Stock	56.2425	56.2425	56.24	56.24	2000.0
2019-10-01 07:14:00	AAPL	Stock	56.2425	56.2425	56.24	56.24	29520.0
2019-10-01 07:15:00	AAPL	Stock	56.25	56.2625	56.25	56.2625	2400.0

> showing 50 of 1,127,122 rows — these rows as CSV

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