PREVIEW / stock_1min / 2019-07-29

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-29.parquet
  size:    15.3 MB
  rows:    1,084,706
  symbols: 2,191

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-29 04:00:00	AAPL	Stock	51.9625	51.9625	51.9625	51.9625	872.0
2019-07-29 04:11:00	AAPL	Stock	51.975	51.975	51.975	51.975	1968.0
2019-07-29 04:34:00	AAPL	Stock	51.885	51.885	51.885	51.885	1200.0
2019-07-29 04:56:00	AAPL	Stock	51.9075	51.9075	51.8825	51.8825	800.0
2019-07-29 05:01:00	AAPL	Stock	51.875	51.875	51.875	51.875	400.0
2019-07-29 05:03:00	AAPL	Stock	51.9425	51.9425	51.9425	51.9425	400.0
2019-07-29 05:15:00	AAPL	Stock	51.95	51.95	51.94	51.94	1200.0
2019-07-29 05:16:00	AAPL	Stock	51.9	51.9	51.9	51.9	1200.0
2019-07-29 05:24:00	AAPL	Stock	51.8625	51.8625	51.8625	51.8625	4000.0
2019-07-29 05:25:00	AAPL	Stock	51.86	51.86	51.86	51.86	400.0
2019-07-29 05:44:00	AAPL	Stock	51.9075	51.9075	51.9075	51.9075	400.0
2019-07-29 05:47:00	AAPL	Stock	51.875	51.875	51.875	51.875	400.0
2019-07-29 05:49:00	AAPL	Stock	51.875	51.875	51.875	51.875	400.0
2019-07-29 05:51:00	AAPL	Stock	51.875	51.875	51.875	51.875	400.0
2019-07-29 05:55:00	AAPL	Stock	51.875	51.875	51.875	51.875	400.0
2019-07-29 06:00:00	AAPL	Stock	51.88	51.88	51.88	51.88	400.0
2019-07-29 06:32:00	AAPL	Stock	51.95	51.95	51.95	51.95	800.0
2019-07-29 06:34:00	AAPL	Stock	51.9375	51.9375	51.9375	51.9375	400.0
2019-07-29 06:38:00	AAPL	Stock	51.9375	51.9375	51.9375	51.9375	800.0
2019-07-29 06:57:00	AAPL	Stock	51.8475	51.8875	51.8475	51.8875	1200.0
2019-07-29 07:00:00	AAPL	Stock	51.8975	51.92	51.8975	51.92	2140.0
2019-07-29 07:05:00	AAPL	Stock	51.9125	51.92	51.9125	51.92	2400.0
2019-07-29 07:07:00	AAPL	Stock	51.9375	51.9375	51.9375	51.9375	400.0
2019-07-29 07:10:00	AAPL	Stock	51.9575	51.9725	51.9575	51.9725	3808.0
2019-07-29 07:11:00	AAPL	Stock	51.9525	51.9525	51.9375	51.9375	4000.0
2019-07-29 07:12:00	AAPL	Stock	51.9625	51.9625	51.9625	51.9625	800.0
2019-07-29 07:16:00	AAPL	Stock	51.9525	51.9525	51.95	51.95	1132.0
2019-07-29 07:18:00	AAPL	Stock	51.9525	51.9525	51.9525	51.9525	1200.0
2019-07-29 07:25:00	AAPL	Stock	51.975	51.975	51.975	51.975	476.0
2019-07-29 07:26:00	AAPL	Stock	51.9825	51.9875	51.9825	51.9875	2000.0
2019-07-29 07:27:00	AAPL	Stock	51.995	51.995	51.995	51.995	1600.0
2019-07-29 07:30:00	AAPL	Stock	51.9925	52.0	51.9925	52.0	1256.0
2019-07-29 07:33:00	AAPL	Stock	52.0	52.0025	52.0	52.0025	1932.0
2019-07-29 07:35:00	AAPL	Stock	52.0375	52.0475	52.0375	52.0475	1480.0
2019-07-29 07:36:00	AAPL	Stock	52.045	52.05	52.045	52.05	4420.0
2019-07-29 07:39:00	AAPL	Stock	52.035	52.035	52.035	52.035	400.0
2019-07-29 07:41:00	AAPL	Stock	52.065	52.065	52.065	52.065	800.0
2019-07-29 07:45:00	AAPL	Stock	52.075	52.075	52.075	52.075	400.0
2019-07-29 07:47:00	AAPL	Stock	52.085	52.095	52.075	52.095	2700.0
2019-07-29 07:52:00	AAPL	Stock	52.0725	52.0875	52.0725	52.08	1200.0
2019-07-29 08:00:00	AAPL	Stock	51.925	52.0875	51.881	52.0375	60820.0
2019-07-29 08:01:00	AAPL	Stock	52.07	52.07	52.07	52.07	1200.0
2019-07-29 08:04:00	AAPL	Stock	52.056	52.056	52.056	52.056	400.0
2019-07-29 08:07:00	AAPL	Stock	52.03	52.03	52.03	52.03	472.0
2019-07-29 08:08:00	AAPL	Stock	52.03	52.03	52.03	52.03	3528.0
2019-07-29 08:09:00	AAPL	Stock	52.0425	52.0425	52.0425	52.0425	400.0
2019-07-29 08:11:00	AAPL	Stock	52.0425	52.0425	52.0425	52.0425	400.0
2019-07-29 08:14:00	AAPL	Stock	52.025	52.0425	52.025	52.0425	1600.0
2019-07-29 08:15:00	AAPL	Stock	52.0375	52.0425	52.0275	52.0375	5252.0
2019-07-29 08:16:00	AAPL	Stock	52.0375	52.05	52.0325	52.0375	8464.0

> showing 50 of 1,084,706 rows — these rows as CSV

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