PREVIEW / stock_1min / 2020-07-31

all stock 1-min files

  file:    by_date/stock_1min/2020/2020-07-31.parquet
  size:    20.4 MB
  rows:    1,306,221
  symbols: 2,089

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
2020-07-31 04:00:00	AAPL	Stock	102.335	102.335	102.2625	102.3125	14220.0
2020-07-31 04:01:00	AAPL	Stock	102.375	102.375	102.375	102.375	400.0
2020-07-31 04:02:00	AAPL	Stock	102.3725	102.3725	102.3725	102.3725	2400.0
2020-07-31 04:03:00	AAPL	Stock	102.29	102.3325	102.25	102.25	10300.0
2020-07-31 04:04:00	AAPL	Stock	102.23	102.25	102.23	102.24	1200.0
2020-07-31 04:05:00	AAPL	Stock	102.165	102.165	102.0375	102.0375	1112.0
2020-07-31 04:09:00	AAPL	Stock	102.1	102.1	102.1	102.1	1016.0
2020-07-31 04:12:00	AAPL	Stock	102.025	102.06	102.005	102.005	9216.0
2020-07-31 04:13:00	AAPL	Stock	102.005	102.06	102.005	102.01	2468.0
2020-07-31 04:15:00	AAPL	Stock	102.01	102.01	101.9925	101.9925	1380.0
2020-07-31 04:16:00	AAPL	Stock	101.905	102.01	101.8375	101.9925	22868.0
2020-07-31 04:17:00	AAPL	Stock	101.855	101.855	101.855	101.855	800.0
2020-07-31 04:18:00	AAPL	Stock	101.8575	101.8625	101.8325	101.8625	1624.0
2020-07-31 04:21:00	AAPL	Stock	101.925	101.93	101.925	101.93	3420.0
2020-07-31 04:22:00	AAPL	Stock	102.0125	102.0125	102.0125	102.0125	424.0
2020-07-31 04:23:00	AAPL	Stock	102.085	102.1	102.085	102.1	2484.0
2020-07-31 04:27:00	AAPL	Stock	102.1	102.175	102.1	102.17	3952.0
2020-07-31 04:28:00	AAPL	Stock	102.1625	102.2475	102.1625	102.2475	7208.0
2020-07-31 04:30:00	AAPL	Stock	102.195	102.25	102.195	102.25	7188.0
2020-07-31 04:31:00	AAPL	Stock	102.255	102.255	102.255	102.255	524.0
2020-07-31 04:33:00	AAPL	Stock	102.21	102.21	102.21	102.21	400.0
2020-07-31 04:37:00	AAPL	Stock	102.1	102.1675	101.75	102.1675	39252.0
2020-07-31 04:38:00	AAPL	Stock	102.135	102.1925	102.135	102.1925	2228.0
2020-07-31 04:39:00	AAPL	Stock	102.16	102.16	102.1525	102.1525	3592.0
2020-07-31 04:42:00	AAPL	Stock	102.2175	102.2175	102.2175	102.2175	956.0
2020-07-31 04:45:00	AAPL	Stock	102.2475	102.25	102.2475	102.25	1196.0
2020-07-31 04:46:00	AAPL	Stock	102.25	102.25	102.25	102.25	400.0
2020-07-31 04:47:00	AAPL	Stock	102.2	102.2	102.2	102.2	1600.0
2020-07-31 04:48:00	AAPL	Stock	102.2	102.2	102.2	102.2	444.0
2020-07-31 04:51:00	AAPL	Stock	102.275	102.275	102.2175	102.2175	800.0
2020-07-31 04:52:00	AAPL	Stock	102.295	102.295	102.2275	102.2275	1200.0
2020-07-31 04:53:00	AAPL	Stock	102.2975	102.2975	102.2975	102.2975	400.0
2020-07-31 04:55:00	AAPL	Stock	102.23	102.23	102.2	102.2	3924.0
2020-07-31 04:56:00	AAPL	Stock	102.2125	102.2125	102.125	102.125	7200.0
2020-07-31 04:57:00	AAPL	Stock	102.1	102.1	102.0975	102.0975	800.0
2020-07-31 04:58:00	AAPL	Stock	102.0875	102.115	102.0875	102.0875	1200.0
2020-07-31 04:59:00	AAPL	Stock	102.075	102.39	102.0475	102.135	30088.0
2020-07-31 05:00:00	AAPL	Stock	102.1575	102.175	102.1425	102.1425	3876.0
2020-07-31 05:04:00	AAPL	Stock	102.1775	102.1775	102.1775	102.1775	400.0
2020-07-31 05:07:00	AAPL	Stock	102.225	102.225	102.225	102.225	552.0
2020-07-31 05:08:00	AAPL	Stock	102.255	102.255	102.255	102.255	768.0
2020-07-31 05:14:00	AAPL	Stock	102.2625	102.2625	102.2625	102.2625	400.0
2020-07-31 05:16:00	AAPL	Stock	102.26	102.26	102.26	102.26	2136.0
2020-07-31 05:17:00	AAPL	Stock	102.25	102.255	102.225	102.225	3764.0
2020-07-31 05:30:00	AAPL	Stock	102.25	102.25	102.25	102.25	704.0
2020-07-31 05:31:00	AAPL	Stock	102.2225	102.2225	102.2225	102.2225	800.0
2020-07-31 05:32:00	AAPL	Stock	102.225	102.225	102.225	102.225	400.0
2020-07-31 05:33:00	AAPL	Stock	102.225	102.225	102.225	102.225	400.0
2020-07-31 05:34:00	AAPL	Stock	102.275	102.275	102.275	102.275	400.0
2020-07-31 05:39:00	AAPL	Stock	102.2475	102.2475	102.2475	102.2475	400.0

> showing 50 of 1,306,221 rows — these rows as CSV

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