PREVIEW / stock_1min / 2019-10-23

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-10-23.parquet
  size:    14.8 MB
  rows:    1,061,719
  symbols: 2,116

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-23 04:00:00	AAPL	Stock	59.91	60.0275	59.875	60.0275	7680.0
2019-10-23 04:01:00	AAPL	Stock	60.0275	60.0275	60.0275	60.0275	7200.0
2019-10-23 04:03:00	AAPL	Stock	59.9425	59.9425	59.9175	59.9175	2000.0
2019-10-23 04:04:00	AAPL	Stock	59.975	59.975	59.975	59.975	1600.0
2019-10-23 04:05:00	AAPL	Stock	59.975	59.975	59.95	59.95	5200.0
2019-10-23 04:07:00	AAPL	Stock	60.0175	60.0175	60.0175	60.0175	800.0
2019-10-23 04:13:00	AAPL	Stock	60.04	60.04	60.04	60.04	524.0
2019-10-23 04:29:00	AAPL	Stock	60.05	60.05	60.05	60.05	2176.0
2019-10-23 04:31:00	AAPL	Stock	60.05	60.05	60.05	60.05	2524.0
2019-10-23 04:38:00	AAPL	Stock	60.0275	60.0275	60.0275	60.0275	736.0
2019-10-23 04:39:00	AAPL	Stock	60.04	60.04	60.04	60.04	800.0
2019-10-23 04:41:00	AAPL	Stock	60.075	60.0825	60.075	60.0825	1200.0
2019-10-23 05:01:00	AAPL	Stock	60.12	60.1225	60.12	60.1225	1200.0
2019-10-23 05:15:00	AAPL	Stock	60.12	60.1475	60.12	60.1475	5908.0
2019-10-23 05:22:00	AAPL	Stock	60.22	60.2425	60.1775	60.2425	3068.0
2019-10-23 05:24:00	AAPL	Stock	60.255	60.255	60.2425	60.2425	3804.0
2019-10-23 05:36:00	AAPL	Stock	60.23	60.2425	60.23	60.2425	14340.0
2019-10-23 05:37:00	AAPL	Stock	60.24	60.305	60.24	60.305	8776.0
2019-10-23 05:38:00	AAPL	Stock	60.3125	60.475	60.3125	60.4725	5624.0
2019-10-23 05:40:00	AAPL	Stock	60.3425	60.3425	60.3425	60.3425	792.0
2019-10-23 05:41:00	AAPL	Stock	60.375	60.4025	60.375	60.4025	6740.0
2019-10-23 05:50:00	AAPL	Stock	60.39	60.3975	60.39	60.3975	1020.0
2019-10-23 06:02:00	AAPL	Stock	60.375	60.4	60.375	60.4	16680.0
2019-10-23 06:03:00	AAPL	Stock	60.4	60.4	60.4	60.4	2284.0
2019-10-23 06:04:00	AAPL	Stock	60.375	60.3975	60.375	60.375	5752.0
2019-10-23 06:10:00	AAPL	Stock	60.3125	60.3125	60.3125	60.3125	400.0
2019-10-23 06:11:00	AAPL	Stock	60.3125	60.3125	60.3125	60.3125	800.0
2019-10-23 06:12:00	AAPL	Stock	60.315	60.315	60.3125	60.3125	800.0
2019-10-23 06:31:00	AAPL	Stock	60.305	60.305	60.2875	60.2875	5928.0
2019-10-23 06:35:00	AAPL	Stock	60.28	60.28	60.28	60.28	400.0
2019-10-23 06:43:00	AAPL	Stock	60.3	60.3	60.3	60.3	800.0
2019-10-23 06:44:00	AAPL	Stock	60.29	60.29	60.2875	60.2875	1200.0
2019-10-23 06:47:00	AAPL	Stock	60.31	60.3375	60.31	60.3375	2800.0
2019-10-23 06:48:00	AAPL	Stock	60.345	60.3575	60.28	60.28	14908.0
2019-10-23 06:49:00	AAPL	Stock	60.275	60.275	60.215	60.215	3200.0
2019-10-23 06:50:00	AAPL	Stock	60.22	60.23	60.21	60.21	5232.0
2019-10-23 06:51:00	AAPL	Stock	60.205	60.205	60.205	60.205	1200.0
2019-10-23 06:52:00	AAPL	Stock	60.215	60.215	60.205	60.2075	4400.0
2019-10-23 06:53:00	AAPL	Stock	60.205	60.205	60.205	60.205	400.0
2019-10-23 06:54:00	AAPL	Stock	60.175	60.1875	60.175	60.1875	1200.0
2019-10-23 06:55:00	AAPL	Stock	60.19	60.19	60.1775	60.1875	1736.0
2019-10-23 06:57:00	AAPL	Stock	60.175	60.235	60.175	60.235	3180.0
2019-10-23 07:00:00	AAPL	Stock	60.235	60.235	60.1775	60.1775	5440.0
2019-10-23 07:01:00	AAPL	Stock	60.175	60.1775	60.165	60.165	3056.0
2019-10-23 07:02:00	AAPL	Stock	60.2	60.2375	60.2	60.2375	11880.0
2019-10-23 07:03:00	AAPL	Stock	60.2125	60.22	60.2125	60.2175	1800.0
2019-10-23 07:04:00	AAPL	Stock	60.2175	60.2175	60.2175	60.2175	400.0
2019-10-23 07:05:00	AAPL	Stock	60.235	60.25	60.2225	60.25	11736.0
2019-10-23 07:06:00	AAPL	Stock	60.2475	60.2475	60.23	60.245	3324.0
2019-10-23 07:08:00	AAPL	Stock	60.25	60.25	60.23	60.23	17956.0

> showing 50 of 1,061,719 rows — these rows as CSV

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