PREVIEW / stock_1min / 2019-07-19

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-19.parquet
  size:    14.8 MB
  rows:    1,062,944
  symbols: 2,172

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-19 04:01:00	AAPL	Stock	51.5875	51.5875	51.5875	51.5875	1868.0
2019-07-19 04:10:00	AAPL	Stock	51.5875	51.5875	51.5875	51.5875	2336.0
2019-07-19 04:15:00	AAPL	Stock	51.675	51.675	51.675	51.675	3760.0
2019-07-19 04:17:00	AAPL	Stock	51.65	51.65	51.65	51.65	1988.0
2019-07-19 04:21:00	AAPL	Stock	51.59	51.59	51.59	51.59	400.0
2019-07-19 04:54:00	AAPL	Stock	51.5325	51.5325	51.5325	51.5325	472.0
2019-07-19 04:56:00	AAPL	Stock	51.5325	51.5325	51.5325	51.5325	832.0
2019-07-19 05:03:00	AAPL	Stock	51.525	51.525	51.525	51.525	400.0
2019-07-19 05:15:00	AAPL	Stock	51.5475	51.5475	51.5475	51.5475	400.0
2019-07-19 05:18:00	AAPL	Stock	51.545	51.545	51.545	51.545	400.0
2019-07-19 05:25:00	AAPL	Stock	51.5725	51.5725	51.5725	51.5725	7000.0
2019-07-19 05:31:00	AAPL	Stock	51.5375	51.5375	51.5375	51.5375	400.0
2019-07-19 05:32:00	AAPL	Stock	51.5375	51.5375	51.5375	51.5375	1420.0
2019-07-19 05:34:00	AAPL	Stock	51.575	51.575	51.575	51.575	2516.0
2019-07-19 05:36:00	AAPL	Stock	51.545	51.545	51.545	51.545	400.0
2019-07-19 05:38:00	AAPL	Stock	51.5125	51.5125	51.5075	51.5075	5696.0
2019-07-19 05:40:00	AAPL	Stock	51.5075	51.5075	51.5075	51.5075	400.0
2019-07-19 05:47:00	AAPL	Stock	51.51	51.51	51.5075	51.5075	5704.0
2019-07-19 05:49:00	AAPL	Stock	51.535	51.5475	51.535	51.5475	3360.0
2019-07-19 05:51:00	AAPL	Stock	51.515	51.515	51.5075	51.5075	3160.0
2019-07-19 05:59:00	AAPL	Stock	51.505	51.505	51.505	51.505	800.0
2019-07-19 06:19:00	AAPL	Stock	51.4975	51.4975	51.4975	51.4975	400.0
2019-07-19 06:24:00	AAPL	Stock	51.475	51.475	51.475	51.475	400.0
2019-07-19 06:37:00	AAPL	Stock	51.4775	51.4775	51.4775	51.4775	996.0
2019-07-19 06:40:00	AAPL	Stock	51.4775	51.4775	51.4775	51.4775	400.0
2019-07-19 06:42:00	AAPL	Stock	51.4875	51.4875	51.475	51.475	7736.0
2019-07-19 06:43:00	AAPL	Stock	51.475	51.475	51.4575	51.4575	1552.0
2019-07-19 06:44:00	AAPL	Stock	51.4575	51.4575	51.4125	51.4125	3312.0
2019-07-19 06:45:00	AAPL	Stock	51.4125	51.4125	51.3	51.3	800.0
2019-07-19 06:48:00	AAPL	Stock	51.38	51.38	51.38	51.38	400.0
2019-07-19 06:49:00	AAPL	Stock	51.375	51.375	51.3475	51.3475	800.0
2019-07-19 06:52:00	AAPL	Stock	51.3525	51.3525	51.3525	51.3525	400.0
2019-07-19 06:54:00	AAPL	Stock	51.35	51.35	51.35	51.35	400.0
2019-07-19 06:57:00	AAPL	Stock	51.4125	51.4125	51.4125	51.4125	400.0
2019-07-19 06:58:00	AAPL	Stock	51.375	51.375	51.36	51.36	800.0
2019-07-19 06:59:00	AAPL	Stock	51.39	51.39	51.39	51.39	2000.0
2019-07-19 07:00:00	AAPL	Stock	51.4625	51.48	51.42	51.42	12944.0
2019-07-19 07:01:00	AAPL	Stock	51.445	51.445	51.445	51.445	1120.0
2019-07-19 07:02:00	AAPL	Stock	51.4375	51.46	51.41	51.41	2568.0
2019-07-19 07:03:00	AAPL	Stock	51.4175	51.45	51.4175	51.45	2000.0
2019-07-19 07:04:00	AAPL	Stock	51.415	51.415	51.415	51.415	920.0
2019-07-19 07:05:00	AAPL	Stock	51.415	51.4175	51.415	51.4175	2296.0
2019-07-19 07:06:00	AAPL	Stock	51.41	51.415	51.4025	51.4025	7068.0
2019-07-19 07:07:00	AAPL	Stock	51.4	51.405	51.4	51.405	2720.0
2019-07-19 07:08:00	AAPL	Stock	51.405	51.405	51.39	51.39	1800.0
2019-07-19 07:09:00	AAPL	Stock	51.395	51.395	51.39	51.39	852.0
2019-07-19 07:10:00	AAPL	Stock	51.4125	51.425	51.4125	51.4125	6900.0
2019-07-19 07:11:00	AAPL	Stock	51.4125	51.4175	51.4125	51.4175	3056.0
2019-07-19 07:12:00	AAPL	Stock	51.4175	51.4175	51.4175	51.4175	400.0
2019-07-19 07:13:00	AAPL	Stock	51.41	51.41	51.41	51.41	456.0

> showing 50 of 1,062,944 rows — these rows as CSV

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