PREVIEW / stock_1min / 2018-01-08

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-01-08.parquet
  size:    16.6 MB
  rows:    1,107,246
  symbols: 2,421

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-01-08 04:53:00	AAPL	Stock	43.775	43.775	43.775	43.775	764.0
2018-01-08 04:58:00	AAPL	Stock	43.775	43.775	43.775	43.775	1124.0
2018-01-08 06:40:00	AAPL	Stock	43.825	43.825	43.825	43.825	400.0
2018-01-08 06:53:00	AAPL	Stock	43.7725	43.7725	43.7725	43.7725	400.0
2018-01-08 06:58:00	AAPL	Stock	43.725	43.725	43.725	43.725	2084.0
2018-01-08 07:00:00	AAPL	Stock	43.7725	43.7725	43.74	43.77	12848.0
2018-01-08 07:03:00	AAPL	Stock	43.7675	43.7675	43.7675	43.7675	2400.0
2018-01-08 07:05:00	AAPL	Stock	43.755	43.755	43.755	43.755	2400.0
2018-01-08 07:06:00	AAPL	Stock	43.7525	43.7525	43.7525	43.7525	600.0
2018-01-08 07:07:00	AAPL	Stock	43.7525	43.755	43.7525	43.755	836.0
2018-01-08 07:08:00	AAPL	Stock	43.7525	43.7525	43.7525	43.7525	2000.0
2018-01-08 07:09:00	AAPL	Stock	43.755	43.755	43.75	43.75	8508.0
2018-01-08 07:14:00	AAPL	Stock	43.75	43.75	43.75	43.75	1708.0
2018-01-08 07:18:00	AAPL	Stock	43.74	43.74	43.74	43.74	400.0
2018-01-08 07:19:00	AAPL	Stock	43.74	43.75	43.74	43.75	3200.0
2018-01-08 07:20:00	AAPL	Stock	43.74	43.75	43.74	43.75	1300.0
2018-01-08 07:21:00	AAPL	Stock	43.75	43.75	43.75	43.75	2000.0
2018-01-08 07:26:00	AAPL	Stock	43.7375	43.7375	43.7375	43.7375	6000.0
2018-01-08 07:27:00	AAPL	Stock	43.735	43.735	43.735	43.735	400.0
2018-01-08 07:28:00	AAPL	Stock	43.715	43.715	43.715	43.715	3928.0
2018-01-08 07:29:00	AAPL	Stock	43.71	43.71	43.7075	43.7075	2800.0
2018-01-08 07:32:00	AAPL	Stock	43.72	43.7225	43.72	43.7225	1220.0
2018-01-08 07:34:00	AAPL	Stock	43.7225	43.7225	43.7225	43.7225	400.0
2018-01-08 07:38:00	AAPL	Stock	43.705	43.705	43.705	43.705	800.0
2018-01-08 07:41:00	AAPL	Stock	43.705	43.705	43.705	43.705	788.0
2018-01-08 07:43:00	AAPL	Stock	43.705	43.705	43.705	43.705	812.0
2018-01-08 07:44:00	AAPL	Stock	43.705	43.705	43.705	43.705	1400.0
2018-01-08 07:45:00	AAPL	Stock	43.7075	43.7075	43.705	43.705	2000.0
2018-01-08 07:46:00	AAPL	Stock	43.705	43.705	43.705	43.705	800.0
2018-01-08 07:48:00	AAPL	Stock	43.705	43.705	43.7	43.7	6320.0
2018-01-08 07:49:00	AAPL	Stock	43.7	43.7	43.6875	43.6875	9340.0
2018-01-08 07:54:00	AAPL	Stock	43.7025	43.7025	43.7	43.7	2400.0
2018-01-08 07:55:00	AAPL	Stock	43.7025	43.7025	43.7025	43.7025	1456.0
2018-01-08 07:56:00	AAPL	Stock	43.7025	43.7025	43.7025	43.7025	2256.0
2018-01-08 07:57:00	AAPL	Stock	43.7025	43.705	43.7025	43.7025	2000.0
2018-01-08 07:58:00	AAPL	Stock	43.7125	43.7125	43.7125	43.7125	1480.0
2018-01-08 08:00:00	AAPL	Stock	43.755	43.77	43.69	43.705	34024.0
2018-01-08 08:02:00	AAPL	Stock	43.705	43.705	43.7	43.7	7872.0
2018-01-08 08:04:00	AAPL	Stock	43.71	43.71	43.7	43.7	1424.0
2018-01-08 08:05:00	AAPL	Stock	43.7	43.7	43.6875	43.7	11824.0
2018-01-08 08:06:00	AAPL	Stock	43.7025	43.7075	43.7025	43.7075	1000.0
2018-01-08 08:07:00	AAPL	Stock	43.71	43.71	43.71	43.71	400.0
2018-01-08 08:08:00	AAPL	Stock	43.72	43.72	43.72	43.72	420.0
2018-01-08 08:09:00	AAPL	Stock	43.72	43.72	43.72	43.72	400.0
2018-01-08 08:10:00	AAPL	Stock	43.72	43.72	43.72	43.72	400.0
2018-01-08 08:11:00	AAPL	Stock	43.72	43.72	43.72	43.72	400.0
2018-01-08 08:12:00	AAPL	Stock	43.7	43.7	43.6875	43.6875	4000.0
2018-01-08 08:13:00	AAPL	Stock	43.6875	43.6875	43.685	43.685	4108.0
2018-01-08 08:14:00	AAPL	Stock	43.705	43.705	43.705	43.705	400.0
2018-01-08 08:17:00	AAPL	Stock	43.7025	43.7025	43.7025	43.7025	1200.0

> showing 50 of 1,107,246 rows — these rows as CSV

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