PREVIEW / stock_1min / 2019-08-06

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-08-06.parquet
  size:    16.5 MB
  rows:    1,153,036
  symbols: 2,164

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-08-06 04:00:00	AAPL	Stock	48.175	48.2025	48.175	48.2	9244.0
2019-08-06 04:01:00	AAPL	Stock	48.2025	48.2025	48.1775	48.1775	1200.0
2019-08-06 04:02:00	AAPL	Stock	48.1325	48.1325	48.13	48.13	3436.0
2019-08-06 04:03:00	AAPL	Stock	48.13	48.13	48.1	48.1	2684.0
2019-08-06 04:05:00	AAPL	Stock	48.1	48.1	48.1	48.1	400.0
2019-08-06 04:06:00	AAPL	Stock	48.1	48.1	48.1	48.1	400.0
2019-08-06 04:07:00	AAPL	Stock	48.085	48.1	48.085	48.1	800.0
2019-08-06 04:08:00	AAPL	Stock	48.1	48.1275	48.1	48.1275	1120.0
2019-08-06 04:09:00	AAPL	Stock	48.175	48.2	48.175	48.175	1720.0
2019-08-06 04:10:00	AAPL	Stock	48.2325	48.2325	48.2325	48.2325	1788.0
2019-08-06 04:11:00	AAPL	Stock	48.25	48.25	48.25	48.25	748.0
2019-08-06 04:12:00	AAPL	Stock	48.25	48.25	48.25	48.25	1380.0
2019-08-06 04:13:00	AAPL	Stock	48.3225	48.3225	48.3225	48.3225	3200.0
2019-08-06 04:14:00	AAPL	Stock	48.3225	48.3225	48.3225	48.3225	420.0
2019-08-06 04:15:00	AAPL	Stock	48.335	48.34	48.335	48.34	2800.0
2019-08-06 04:17:00	AAPL	Stock	48.3725	48.3975	48.3725	48.3975	1240.0
2019-08-06 04:18:00	AAPL	Stock	48.3975	48.3975	48.345	48.395	9552.0
2019-08-06 04:19:00	AAPL	Stock	48.3925	48.3975	48.3925	48.3925	3200.0
2019-08-06 04:20:00	AAPL	Stock	48.3925	48.3925	48.3925	48.3925	400.0
2019-08-06 04:21:00	AAPL	Stock	48.4	48.4475	48.3975	48.4475	9704.0
2019-08-06 04:22:00	AAPL	Stock	48.4525	48.4525	48.4525	48.4525	1536.0
2019-08-06 04:23:00	AAPL	Stock	48.45	48.4575	48.45	48.4575	2400.0
2019-08-06 04:26:00	AAPL	Stock	48.45	48.4975	48.45	48.4975	10832.0
2019-08-06 04:27:00	AAPL	Stock	48.4975	48.5475	48.4925	48.545	13948.0
2019-08-06 04:28:00	AAPL	Stock	48.545	48.6225	48.5225	48.6225	14848.0
2019-08-06 04:29:00	AAPL	Stock	48.625	48.67	48.625	48.67	1200.0
2019-08-06 04:30:00	AAPL	Stock	48.65	48.65	48.565	48.57	2124.0
2019-08-06 04:31:00	AAPL	Stock	48.5625	48.565	48.5625	48.565	800.0
2019-08-06 04:33:00	AAPL	Stock	48.565	48.595	48.505	48.595	3312.0
2019-08-06 04:34:00	AAPL	Stock	48.51	48.51	48.5	48.5	3044.0
2019-08-06 04:35:00	AAPL	Stock	48.5025	48.575	48.4925	48.525	15940.0
2019-08-06 04:36:00	AAPL	Stock	48.52	48.525	48.52	48.525	1984.0
2019-08-06 04:37:00	AAPL	Stock	48.5625	48.5825	48.55	48.5825	2780.0
2019-08-06 04:38:00	AAPL	Stock	48.61	48.62	48.6075	48.62	2400.0
2019-08-06 04:39:00	AAPL	Stock	48.6225	48.6575	48.5875	48.63	13792.0
2019-08-06 04:40:00	AAPL	Stock	48.63	48.635	48.63	48.635	800.0
2019-08-06 04:42:00	AAPL	Stock	48.6225	48.6225	48.55	48.55	10572.0
2019-08-06 04:43:00	AAPL	Stock	48.575	48.575	48.575	48.575	1200.0
2019-08-06 04:45:00	AAPL	Stock	48.605	48.63	48.6	48.6	4588.0
2019-08-06 04:46:00	AAPL	Stock	48.56	48.56	48.4925	48.4925	6968.0
2019-08-06 04:47:00	AAPL	Stock	48.525	48.5475	48.525	48.5475	2520.0
2019-08-06 04:48:00	AAPL	Stock	48.545	48.56	48.52	48.525	4520.0
2019-08-06 04:49:00	AAPL	Stock	48.525	48.57	48.525	48.57	2916.0
2019-08-06 04:50:00	AAPL	Stock	48.575	48.625	48.5525	48.5525	2520.0
2019-08-06 04:51:00	AAPL	Stock	48.5375	48.5375	48.5375	48.5375	1096.0
2019-08-06 04:52:00	AAPL	Stock	48.5475	48.56	48.5475	48.5475	5204.0
2019-08-06 04:53:00	AAPL	Stock	48.525	48.525	48.525	48.525	1200.0
2019-08-06 04:54:00	AAPL	Stock	48.5325	48.5325	48.475	48.5	10868.0
2019-08-06 04:55:00	AAPL	Stock	48.5	48.5	48.475	48.4925	5600.0
2019-08-06 04:56:00	AAPL	Stock	48.5	48.5	48.495	48.5	2624.0

> showing 50 of 1,153,036 rows — these rows as CSV

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