PREVIEW / stock_1min / 2019-04-23

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-04-23.parquet
  size:    16.4 MB
  rows:    1,126,236
  symbols: 2,217

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-04-23 04:10:00	AAPL	Stock	51.155	51.155	51.155	51.155	3796.0
2019-04-23 04:38:00	AAPL	Stock	51.1	51.1	51.1	51.1	3024.0
2019-04-23 04:39:00	AAPL	Stock	51.0375	51.0375	51.0	51.0	9940.0
2019-04-23 04:41:00	AAPL	Stock	51.04	51.04	51.04	51.04	3008.0
2019-04-23 04:44:00	AAPL	Stock	51.01	51.01	51.0075	51.0075	1200.0
2019-04-23 05:10:00	AAPL	Stock	51.05	51.05	51.0275	51.0275	2000.0
2019-04-23 05:13:00	AAPL	Stock	51.0275	51.0275	51.0275	51.0275	2340.0
2019-04-23 05:30:00	AAPL	Stock	51.075	51.075	51.075	51.075	400.0
2019-04-23 05:36:00	AAPL	Stock	51.01	51.01	51.01	51.01	400.0
2019-04-23 06:18:00	AAPL	Stock	51.0525	51.0525	51.0525	51.0525	400.0
2019-04-23 06:23:00	AAPL	Stock	51.06	51.06	51.06	51.06	1656.0
2019-04-23 06:30:00	AAPL	Stock	51.0575	51.0575	51.0575	51.0575	1200.0
2019-04-23 06:32:00	AAPL	Stock	51.0725	51.0725	51.0725	51.0725	1992.0
2019-04-23 06:35:00	AAPL	Stock	51.05	51.075	51.05	51.075	6384.0
2019-04-23 06:41:00	AAPL	Stock	51.0725	51.075	51.0725	51.075	3624.0
2019-04-23 06:42:00	AAPL	Stock	51.005	51.0275	51.0	51.0	8144.0
2019-04-23 06:43:00	AAPL	Stock	51.0	51.0	50.975	50.98	3200.0
2019-04-23 06:44:00	AAPL	Stock	50.825	50.825	50.825	50.825	400.0
2019-04-23 06:45:00	AAPL	Stock	50.78	50.78	50.78	50.78	1200.0
2019-04-23 06:46:00	AAPL	Stock	50.64	50.8575	50.615	50.8575	6408.0
2019-04-23 06:47:00	AAPL	Stock	50.8575	50.8575	50.7625	50.7625	33928.0
2019-04-23 06:48:00	AAPL	Stock	50.85	50.9	50.85	50.9	8668.0
2019-04-23 06:49:00	AAPL	Stock	50.875	50.9875	50.875	50.8775	16764.0
2019-04-23 06:50:00	AAPL	Stock	50.88	50.88	50.88	50.88	500.0
2019-04-23 06:51:00	AAPL	Stock	50.9225	50.9375	50.9225	50.9375	10000.0
2019-04-23 06:52:00	AAPL	Stock	50.9225	50.925	50.92	50.925	27684.0
2019-04-23 06:53:00	AAPL	Stock	50.92	50.92	50.9	50.9	4000.0
2019-04-23 06:54:00	AAPL	Stock	50.9	50.905	50.9	50.905	5400.0
2019-04-23 06:55:00	AAPL	Stock	50.9075	50.9075	50.9075	50.9075	5616.0
2019-04-23 06:56:00	AAPL	Stock	50.9125	50.92	50.9125	50.92	3884.0
2019-04-23 06:57:00	AAPL	Stock	50.9125	50.9125	50.9125	50.9125	8600.0
2019-04-23 06:58:00	AAPL	Stock	50.9125	50.9125	50.9125	50.9125	2400.0
2019-04-23 07:00:00	AAPL	Stock	50.93	50.9375	50.93	50.9375	3000.0
2019-04-23 07:01:00	AAPL	Stock	50.9375	50.9375	50.9375	50.9375	800.0
2019-04-23 07:03:00	AAPL	Stock	50.9375	50.9475	50.9375	50.9475	3412.0
2019-04-23 07:04:00	AAPL	Stock	50.9675	50.9675	50.9675	50.9675	1160.0
2019-04-23 07:05:00	AAPL	Stock	50.975	50.975	50.975	50.975	400.0
2019-04-23 07:08:00	AAPL	Stock	50.9675	50.99	50.9625	50.99	2000.0
2019-04-23 07:09:00	AAPL	Stock	50.965	50.965	50.9625	50.965	5460.0
2019-04-23 07:10:00	AAPL	Stock	50.96	50.96	50.9475	50.9475	4468.0
2019-04-23 07:11:00	AAPL	Stock	50.9475	50.9475	50.94	50.9475	1600.0
2019-04-23 07:12:00	AAPL	Stock	50.9475	50.965	50.9475	50.965	4000.0
2019-04-23 07:13:00	AAPL	Stock	50.9625	50.9625	50.9625	50.9625	400.0
2019-04-23 07:14:00	AAPL	Stock	50.9625	50.9625	50.94	50.945	4628.0
2019-04-23 07:15:00	AAPL	Stock	50.94	50.9425	50.905	50.905	12632.0
2019-04-23 07:16:00	AAPL	Stock	50.89	50.89	50.8875	50.8875	840.0
2019-04-23 07:17:00	AAPL	Stock	50.9125	50.9125	50.9125	50.9125	400.0
2019-04-23 07:19:00	AAPL	Stock	50.93	50.93	50.93	50.93	960.0
2019-04-23 07:20:00	AAPL	Stock	50.965	50.965	50.9375	50.9375	2960.0
2019-04-23 07:21:00	AAPL	Stock	50.95	50.96	50.95	50.96	1600.0

> showing 50 of 1,126,236 rows — these rows as CSV

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