PREVIEW / stock_1min / 2019-07-18

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-18.parquet
  size:    15.0 MB
  rows:    1,068,818
  symbols: 2,181

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-07-18 04:00:00	AAPL	Stock	51.125	51.1725	51.125	51.125	26772.0
2019-07-18 04:01:00	AAPL	Stock	51.0075	51.0075	51.0075	51.0075	400.0
2019-07-18 04:02:00	AAPL	Stock	51.0025	51.0025	51.0025	51.0025	400.0
2019-07-18 04:04:00	AAPL	Stock	51.0125	51.0125	51.0125	51.0125	400.0
2019-07-18 04:06:00	AAPL	Stock	51.0375	51.095	51.0375	51.065	1200.0
2019-07-18 04:07:00	AAPL	Stock	51.0825	51.0825	51.0775	51.0775	2000.0
2019-07-18 04:16:00	AAPL	Stock	51.1	51.1	51.1	51.1	2680.0
2019-07-18 04:17:00	AAPL	Stock	51.1	51.105	51.1	51.1	1480.0
2019-07-18 04:21:00	AAPL	Stock	51.0975	51.1325	51.0975	51.1325	1712.0
2019-07-18 04:24:00	AAPL	Stock	51.125	51.125	51.125	51.125	8000.0
2019-07-18 04:26:00	AAPL	Stock	51.1	51.1	51.1	51.1	1236.0
2019-07-18 04:37:00	AAPL	Stock	51.11	51.11	51.1025	51.1025	4000.0
2019-07-18 04:56:00	AAPL	Stock	51.115	51.115	51.115	51.115	608.0
2019-07-18 05:02:00	AAPL	Stock	51.075	51.075	51.075	51.075	400.0
2019-07-18 05:04:00	AAPL	Stock	51.12	51.1375	51.12	51.1375	3200.0
2019-07-18 05:08:00	AAPL	Stock	51.1375	51.1375	51.1375	51.1375	400.0
2019-07-18 05:09:00	AAPL	Stock	51.1375	51.15	51.1375	51.15	2428.0
2019-07-18 05:47:00	AAPL	Stock	51.0875	51.0875	51.0775	51.0775	2400.0
2019-07-18 05:48:00	AAPL	Stock	51.05	51.05	51.035	51.035	800.0
2019-07-18 05:50:00	AAPL	Stock	51.0375	51.0375	51.0375	51.0375	2000.0
2019-07-18 05:51:00	AAPL	Stock	51.0275	51.03	51.0275	51.03	1040.0
2019-07-18 05:52:00	AAPL	Stock	51.0275	51.0325	51.0275	51.0325	1800.0
2019-07-18 05:58:00	AAPL	Stock	51.0325	51.0325	51.025	51.025	4400.0
2019-07-18 06:00:00	AAPL	Stock	50.975	51.0325	50.975	50.975	10000.0
2019-07-18 06:03:00	AAPL	Stock	50.98	50.98	50.98	50.98	760.0
2019-07-18 06:05:00	AAPL	Stock	51.0375	51.0375	51.0375	51.0375	800.0
2019-07-18 06:19:00	AAPL	Stock	51.0375	51.0375	51.0375	51.0375	400.0
2019-07-18 06:20:00	AAPL	Stock	51.005	51.005	51.005	51.005	1188.0
2019-07-18 06:30:00	AAPL	Stock	51.025	51.025	51.025	51.025	1200.0
2019-07-18 06:32:00	AAPL	Stock	51.025	51.025	51.025	51.025	400.0
2019-07-18 06:33:00	AAPL	Stock	51.025	51.025	51.025	51.025	2200.0
2019-07-18 06:37:00	AAPL	Stock	51.075	51.075	51.0625	51.0625	3440.0
2019-07-18 06:45:00	AAPL	Stock	51.075	51.0825	51.075	51.0825	4000.0
2019-07-18 06:52:00	AAPL	Stock	51.075	51.0875	51.075	51.0875	2992.0
2019-07-18 06:59:00	AAPL	Stock	51.0625	51.0625	51.0625	51.0625	400.0
2019-07-18 07:00:00	AAPL	Stock	51.0625	51.1125	50.875	50.945	60612.0
2019-07-18 07:01:00	AAPL	Stock	50.9975	51.045	50.9975	51.025	4620.0
2019-07-18 07:02:00	AAPL	Stock	51.02	51.0375	51.02	51.0375	10400.0
2019-07-18 07:03:00	AAPL	Stock	51.0375	51.0375	51.0025	51.0025	20116.0
2019-07-18 07:04:00	AAPL	Stock	51.0025	51.0025	51.0	51.0	8844.0
2019-07-18 07:06:00	AAPL	Stock	51.0	51.0	51.0	51.0	800.0
2019-07-18 07:07:00	AAPL	Stock	51.0	51.0	51.0	51.0	1200.0
2019-07-18 07:08:00	AAPL	Stock	50.975	50.975	50.975	50.975	1268.0
2019-07-18 07:09:00	AAPL	Stock	50.97	50.97	50.95	50.95	3872.0
2019-07-18 07:10:00	AAPL	Stock	50.95	50.95	50.95	50.95	800.0
2019-07-18 07:11:00	AAPL	Stock	50.975	50.975	50.975	50.975	2800.0
2019-07-18 07:12:00	AAPL	Stock	50.975	50.975	50.975	50.975	488.0
2019-07-18 07:13:00	AAPL	Stock	50.975	50.975	50.975	50.975	4000.0
2019-07-18 07:14:00	AAPL	Stock	50.975	51.0275	50.975	51.0275	20872.0
2019-07-18 07:17:00	AAPL	Stock	51.02	51.02	51.02	51.02	1200.0

> showing 50 of 1,068,818 rows — these rows as CSV

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