PREVIEW / stock_1min / 2018-10-04

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-10-04.parquet
  size:    17.1 MB
  rows:    1,108,539
  symbols: 2,335

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-10-04 04:00:00	AAPL	Stock	57.625	57.7	57.625	57.7	7600.0
2018-10-04 04:01:00	AAPL	Stock	57.7	57.7	57.7	57.7	2400.0
2018-10-04 04:12:00	AAPL	Stock	57.65	57.65	57.65	57.65	400.0
2018-10-04 04:13:00	AAPL	Stock	57.63	57.6375	57.63	57.6375	2056.0
2018-10-04 04:15:00	AAPL	Stock	57.7	57.7	57.6375	57.6375	904.0
2018-10-04 04:17:00	AAPL	Stock	57.64	57.64	57.6375	57.6375	2076.0
2018-10-04 04:18:00	AAPL	Stock	57.625	57.625	57.625	57.625	700.0
2018-10-04 04:35:00	AAPL	Stock	57.675	57.675	57.675	57.675	400.0
2018-10-04 04:42:00	AAPL	Stock	57.6725	57.6725	57.6725	57.6725	800.0
2018-10-04 04:43:00	AAPL	Stock	57.675	57.675	57.675	57.675	4400.0
2018-10-04 04:56:00	AAPL	Stock	57.63	57.63	57.6275	57.6275	2008.0
2018-10-04 05:00:00	AAPL	Stock	57.6325	57.6325	57.6125	57.6125	6764.0
2018-10-04 05:01:00	AAPL	Stock	57.6325	57.6325	57.6325	57.6325	400.0
2018-10-04 05:02:00	AAPL	Stock	57.56	57.56	57.5	57.5	3912.0
2018-10-04 05:03:00	AAPL	Stock	57.625	57.625	57.625	57.625	400.0
2018-10-04 05:05:00	AAPL	Stock	57.5	57.5	57.5	57.5	708.0
2018-10-04 05:06:00	AAPL	Stock	57.5275	57.5275	57.5275	57.5275	800.0
2018-10-04 05:07:00	AAPL	Stock	57.5	57.5	57.445	57.5	10164.0
2018-10-04 05:09:00	AAPL	Stock	57.575	57.6125	57.575	57.6125	3200.0
2018-10-04 05:13:00	AAPL	Stock	57.6175	57.6175	57.6175	57.6175	400.0
2018-10-04 05:14:00	AAPL	Stock	57.625	57.625	57.625	57.625	800.0
2018-10-04 05:24:00	AAPL	Stock	57.625	57.625	57.625	57.625	1200.0
2018-10-04 05:25:00	AAPL	Stock	57.575	57.575	57.575	57.575	968.0
2018-10-04 05:26:00	AAPL	Stock	57.575	57.575	57.575	57.575	1844.0
2018-10-04 05:28:00	AAPL	Stock	57.575	57.575	57.575	57.575	932.0
2018-10-04 06:12:00	AAPL	Stock	57.6625	57.6625	57.6625	57.6625	800.0
2018-10-04 06:13:00	AAPL	Stock	57.6625	57.6625	57.6625	57.6625	2704.0
2018-10-04 06:20:00	AAPL	Stock	57.6625	57.6625	57.6625	57.6625	1656.0
2018-10-04 06:21:00	AAPL	Stock	57.625	57.625	57.625	57.625	760.0
2018-10-04 06:25:00	AAPL	Stock	57.625	57.625	57.625	57.625	704.0
2018-10-04 06:30:00	AAPL	Stock	57.625	57.625	57.5875	57.5875	7436.0
2018-10-04 06:32:00	AAPL	Stock	57.6	57.6	57.6	57.6	400.0
2018-10-04 06:33:00	AAPL	Stock	57.6	57.6	57.6	57.6	11496.0
2018-10-04 06:34:00	AAPL	Stock	57.6	57.6	57.6	57.6	2000.0
2018-10-04 06:37:00	AAPL	Stock	57.6	57.6	57.6	57.6	400.0
2018-10-04 06:42:00	AAPL	Stock	57.6	57.6	57.6	57.6	1204.0
2018-10-04 06:43:00	AAPL	Stock	57.6	57.6	57.6	57.6	400.0
2018-10-04 06:45:00	AAPL	Stock	57.625	57.625	57.625	57.625	5200.0
2018-10-04 06:47:00	AAPL	Stock	57.625	57.625	57.625	57.625	2000.0
2018-10-04 06:48:00	AAPL	Stock	57.6625	57.6625	57.625	57.625	800.0
2018-10-04 06:50:00	AAPL	Stock	57.625	57.625	57.6225	57.625	2000.0
2018-10-04 06:51:00	AAPL	Stock	57.625	57.625	57.625	57.625	4000.0
2018-10-04 06:59:00	AAPL	Stock	57.6625	57.675	57.6625	57.675	2800.0
2018-10-04 07:00:00	AAPL	Stock	57.72	57.7475	57.65	57.745	18480.0
2018-10-04 07:01:00	AAPL	Stock	57.7475	57.7525	57.7475	57.75	6868.0
2018-10-04 07:02:00	AAPL	Stock	57.7825	57.7875	57.7825	57.7875	2000.0
2018-10-04 07:03:00	AAPL	Stock	57.785	57.785	57.75	57.75	800.0
2018-10-04 07:04:00	AAPL	Stock	57.7825	57.7825	57.75	57.75	3200.0
2018-10-04 07:05:00	AAPL	Stock	57.77	57.775	57.7675	57.775	5600.0
2018-10-04 07:06:00	AAPL	Stock	57.775	57.785	57.775	57.785	1200.0

> showing 50 of 1,108,539 rows — these rows as CSV

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