PREVIEW / stock_1min / 2018-07-16

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-16.parquet
  size:    14.3 MB
  rows:    1,029,667
  symbols: 2,339

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
2018-07-16 05:05:00	AAPL	Stock	48.0	48.0	48.0	48.0	400.0
2018-07-16 05:26:00	AAPL	Stock	48.0	48.0	48.0	48.0	2400.0
2018-07-16 07:00:00	AAPL	Stock	47.92	47.9425	47.92	47.9375	26032.0
2018-07-16 07:02:00	AAPL	Stock	47.9425	47.9675	47.9425	47.9675	12828.0
2018-07-16 07:03:00	AAPL	Stock	47.95	47.95	47.9425	47.9425	2760.0
2018-07-16 07:04:00	AAPL	Stock	47.94	47.9425	47.94	47.9425	13576.0
2018-07-16 07:07:00	AAPL	Stock	47.9425	47.9425	47.9425	47.9425	1200.0
2018-07-16 07:13:00	AAPL	Stock	47.9425	47.9425	47.9325	47.9325	4212.0
2018-07-16 07:15:00	AAPL	Stock	47.925	47.925	47.925	47.925	800.0
2018-07-16 07:19:00	AAPL	Stock	47.9	47.9	47.9	47.9	400.0
2018-07-16 07:20:00	AAPL	Stock	47.9	47.9	47.9	47.9	400.0
2018-07-16 07:24:00	AAPL	Stock	47.8875	47.8875	47.8875	47.8875	400.0
2018-07-16 07:29:00	AAPL	Stock	47.89	47.89	47.89	47.89	7688.0
2018-07-16 07:30:00	AAPL	Stock	47.9	47.9	47.8875	47.8875	7600.0
2018-07-16 07:31:00	AAPL	Stock	47.875	47.875	47.875	47.875	3600.0
2018-07-16 07:33:00	AAPL	Stock	47.8625	47.9125	47.85	47.9125	15540.0
2018-07-16 07:40:00	AAPL	Stock	47.9075	47.9075	47.9075	47.9075	1340.0
2018-07-16 07:49:00	AAPL	Stock	47.8775	47.8775	47.8775	47.8775	400.0
2018-07-16 07:51:00	AAPL	Stock	47.885	47.8875	47.885	47.8875	3396.0
2018-07-16 07:52:00	AAPL	Stock	47.9	47.9125	47.9	47.9125	9300.0
2018-07-16 07:53:00	AAPL	Stock	47.905	47.91	47.905	47.91	1900.0
2018-07-16 08:00:00	AAPL	Stock	47.9425	47.9725	47.8775	47.9125	29764.0
2018-07-16 08:01:00	AAPL	Stock	47.9025	47.9025	47.8925	47.8925	3200.0
2018-07-16 08:04:00	AAPL	Stock	47.885	47.885	47.8825	47.8825	4628.0
2018-07-16 08:08:00	AAPL	Stock	47.885	47.885	47.885	47.885	800.0
2018-07-16 08:10:00	AAPL	Stock	47.885	47.8975	47.885	47.8975	4148.0
2018-07-16 08:12:00	AAPL	Stock	47.8825	47.8825	47.875	47.875	20988.0
2018-07-16 08:14:00	AAPL	Stock	47.875	47.875	47.875	47.875	516.0
2018-07-16 08:15:00	AAPL	Stock	47.885	47.885	47.885	47.885	1352.0
2018-07-16 08:16:00	AAPL	Stock	47.885	47.885	47.885	47.885	1448.0
2018-07-16 08:18:00	AAPL	Stock	47.8975	47.9	47.8975	47.9	6608.0
2018-07-16 08:20:00	AAPL	Stock	47.9	47.9	47.9	47.9	840.0
2018-07-16 08:22:00	AAPL	Stock	47.9025	47.9025	47.9025	47.9025	424.0
2018-07-16 08:25:00	AAPL	Stock	47.915	47.915	47.915	47.915	792.0
2018-07-16 08:28:00	AAPL	Stock	47.905	47.905	47.905	47.905	2000.0
2018-07-16 08:29:00	AAPL	Stock	47.905	47.905	47.905	47.905	2188.0
2018-07-16 08:31:00	AAPL	Stock	47.905	47.905	47.905	47.905	1200.0
2018-07-16 08:32:00	AAPL	Stock	47.9025	47.9025	47.9025	47.9025	1188.0
2018-07-16 08:33:00	AAPL	Stock	47.9122	47.9122	47.9122	47.9122	1400.0
2018-07-16 08:34:00	AAPL	Stock	47.9025	47.9025	47.9025	47.9025	400.0
2018-07-16 08:35:00	AAPL	Stock	47.9	47.9025	47.9	47.9025	6828.0
2018-07-16 08:38:00	AAPL	Stock	47.9075	47.915	47.9075	47.915	5896.0
2018-07-16 08:40:00	AAPL	Stock	47.9075	47.9075	47.9075	47.9075	800.0
2018-07-16 08:42:00	AAPL	Stock	47.9075	47.9075	47.9075	47.9075	832.0
2018-07-16 08:43:00	AAPL	Stock	47.9025	47.9025	47.9025	47.9025	400.0
2018-07-16 08:45:00	AAPL	Stock	47.9025	47.9025	47.8975	47.8975	12800.0
2018-07-16 08:48:00	AAPL	Stock	47.875	47.875	47.8675	47.8675	2400.0
2018-07-16 08:49:00	AAPL	Stock	47.8625	47.8725	47.8625	47.8625	2400.0
2018-07-16 08:50:00	AAPL	Stock	47.895	47.9075	47.895	47.9075	3600.0
2018-07-16 08:51:00	AAPL	Stock	47.8975	47.8975	47.8975	47.8975	400.0

> showing 50 of 1,029,667 rows — these rows as CSV

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