PREVIEW / stock_1min / 2018-09-10

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-09-10.parquet
  size:    14.5 MB
  rows:    1,039,929
  symbols: 2,315

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-09-10 04:00:00	AAPL	Stock	55.25	55.475	55.25	55.475	4140.0
2018-09-10 04:05:00	AAPL	Stock	55.3625	55.375	55.3625	55.375	4720.0
2018-09-10 04:06:00	AAPL	Stock	55.425	55.425	55.425	55.425	1816.0
2018-09-10 04:10:00	AAPL	Stock	55.45	55.45	55.45	55.45	856.0
2018-09-10 04:15:00	AAPL	Stock	55.375	55.375	55.375	55.375	3748.0
2018-09-10 04:16:00	AAPL	Stock	55.3775	55.3775	55.3775	55.3775	868.0
2018-09-10 04:22:00	AAPL	Stock	55.385	55.385	55.3775	55.3775	3864.0
2018-09-10 04:23:00	AAPL	Stock	55.3775	55.3775	55.375	55.375	42400.0
2018-09-10 04:24:00	AAPL	Stock	55.3375	55.3375	55.32	55.32	5200.0
2018-09-10 04:25:00	AAPL	Stock	55.32	55.32	55.2875	55.2875	4636.0
2018-09-10 04:26:00	AAPL	Stock	55.2975	55.2975	55.2825	55.2825	1600.0
2018-09-10 04:27:00	AAPL	Stock	55.2975	55.31	55.2975	55.31	2000.0
2018-09-10 04:28:00	AAPL	Stock	55.3075	55.3075	55.3025	55.3025	956.0
2018-09-10 04:29:00	AAPL	Stock	55.2975	55.3025	55.28	55.3025	3200.0
2018-09-10 04:30:00	AAPL	Stock	55.3025	55.3025	55.3025	55.3025	800.0
2018-09-10 04:31:00	AAPL	Stock	55.29	55.29	55.29	55.29	1960.0
2018-09-10 04:34:00	AAPL	Stock	55.28	55.28	55.2775	55.28	2600.0
2018-09-10 04:51:00	AAPL	Stock	55.375	55.375	55.375	55.375	400.0
2018-09-10 04:52:00	AAPL	Stock	55.375	55.375	55.375	55.375	3368.0
2018-09-10 05:16:00	AAPL	Stock	55.345	55.345	55.345	55.345	1900.0
2018-09-10 05:29:00	AAPL	Stock	55.335	55.335	55.335	55.335	2000.0
2018-09-10 05:30:00	AAPL	Stock	55.25	55.25	55.25	55.25	1808.0
2018-09-10 05:31:00	AAPL	Stock	55.25	55.25	55.25	55.25	400.0
2018-09-10 05:35:00	AAPL	Stock	55.25	55.25	55.25	55.25	400.0
2018-09-10 05:42:00	AAPL	Stock	55.255	55.255	55.25	55.25	2000.0
2018-09-10 05:49:00	AAPL	Stock	55.25	55.25	55.25	55.25	800.0
2018-09-10 05:53:00	AAPL	Stock	55.2525	55.2525	55.25	55.25	1200.0
2018-09-10 05:54:00	AAPL	Stock	55.25	55.25	55.25	55.25	400.0
2018-09-10 06:08:00	AAPL	Stock	55.1775	55.1775	55.175	55.175	1600.0
2018-09-10 06:14:00	AAPL	Stock	55.2475	55.2475	55.2475	55.2475	400.0
2018-09-10 06:15:00	AAPL	Stock	55.3	55.325	55.3	55.325	7600.0
2018-09-10 06:19:00	AAPL	Stock	55.3625	55.365	55.3625	55.365	2680.0
2018-09-10 06:24:00	AAPL	Stock	55.3725	55.375	55.35	55.35	13280.0
2018-09-10 06:26:00	AAPL	Stock	55.39	55.39	55.39	55.39	428.0
2018-09-10 06:27:00	AAPL	Stock	55.445	55.445	55.445	55.445	4000.0
2018-09-10 06:30:00	AAPL	Stock	55.4425	55.46	55.4425	55.46	11200.0
2018-09-10 06:31:00	AAPL	Stock	55.47	55.47	55.47	55.47	3600.0
2018-09-10 06:35:00	AAPL	Stock	55.5	55.5	55.5	55.5	1688.0
2018-09-10 06:37:00	AAPL	Stock	55.5025	55.51	55.5	55.51	4400.0
2018-09-10 06:38:00	AAPL	Stock	55.5225	55.57	55.51	55.51	10400.0
2018-09-10 06:39:00	AAPL	Stock	55.5	55.5	55.4475	55.4975	16800.0
2018-09-10 06:40:00	AAPL	Stock	55.475	55.4975	55.45	55.4975	9068.0
2018-09-10 06:41:00	AAPL	Stock	55.475	55.475	55.475	55.475	2000.0
2018-09-10 06:44:00	AAPL	Stock	55.5	55.5	55.5	55.5	3068.0
2018-09-10 06:45:00	AAPL	Stock	55.5	55.5	55.5	55.5	800.0
2018-09-10 06:46:00	AAPL	Stock	55.5	55.5	55.5	55.5	2000.0
2018-09-10 06:47:00	AAPL	Stock	55.48	55.48	55.48	55.48	816.0
2018-09-10 06:50:00	AAPL	Stock	55.47	55.47	55.47	55.47	2000.0
2018-09-10 06:51:00	AAPL	Stock	55.47	55.47	55.47	55.47	2000.0
2018-09-10 06:52:00	AAPL	Stock	55.49	55.5	55.49	55.5	7560.0

> showing 50 of 1,039,929 rows — these rows as CSV

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