PREVIEW / stock_1min / 2018-03-23

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-03-23.parquet
  size:    15.7 MB
  rows:    1,114,415
  symbols: 2,395

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-03-23 04:01:00	AAPL	Stock	42.0275	42.0275	42.0275	42.0275	400.0
2018-03-23 04:02:00	AAPL	Stock	42.1125	42.1125	42.1125	42.1125	7316.0
2018-03-23 04:04:00	AAPL	Stock	42.0375	42.0375	42.025	42.025	4184.0
2018-03-23 04:06:00	AAPL	Stock	42.0	42.0	42.0	42.0	400.0
2018-03-23 04:14:00	AAPL	Stock	41.9575	41.9575	41.9575	41.9575	400.0
2018-03-23 04:15:00	AAPL	Stock	41.935	41.935	41.9	41.9	2088.0
2018-03-23 04:20:00	AAPL	Stock	41.9	41.9	41.9	41.9	8000.0
2018-03-23 04:22:00	AAPL	Stock	41.865	41.865	41.8575	41.8575	7240.0
2018-03-23 04:23:00	AAPL	Stock	41.9	41.9	41.9	41.9	1200.0
2018-03-23 04:28:00	AAPL	Stock	41.875	41.875	41.85	41.85	800.0
2018-03-23 04:29:00	AAPL	Stock	41.85	41.85	41.85	41.85	400.0
2018-03-23 04:34:00	AAPL	Stock	41.845	41.845	41.845	41.845	1428.0
2018-03-23 04:41:00	AAPL	Stock	41.845	41.845	41.8425	41.8425	4000.0
2018-03-23 04:54:00	AAPL	Stock	41.7775	41.7775	41.7775	41.7775	3600.0
2018-03-23 04:55:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	2000.0
2018-03-23 04:56:00	AAPL	Stock	41.76	41.8125	41.75	41.8125	4400.0
2018-03-23 05:00:00	AAPL	Stock	41.8	41.8	41.8	41.8	400.0
2018-03-23 05:07:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	400.0
2018-03-23 05:16:00	AAPL	Stock	41.8725	41.8725	41.8725	41.8725	400.0
2018-03-23 05:18:00	AAPL	Stock	41.7775	41.7775	41.7775	41.7775	400.0
2018-03-23 05:22:00	AAPL	Stock	41.79	41.79	41.7775	41.7775	2400.0
2018-03-23 05:23:00	AAPL	Stock	41.7775	41.7775	41.775	41.775	5496.0
2018-03-23 05:28:00	AAPL	Stock	41.7975	41.7975	41.7925	41.7925	800.0
2018-03-23 05:30:00	AAPL	Stock	41.78	41.78	41.78	41.78	400.0
2018-03-23 05:33:00	AAPL	Stock	41.755	41.755	41.7525	41.7525	3808.0
2018-03-23 05:45:00	AAPL	Stock	41.7075	41.7075	41.7075	41.7075	1968.0
2018-03-23 05:52:00	AAPL	Stock	41.7075	41.7075	41.675	41.675	2760.0
2018-03-23 05:54:00	AAPL	Stock	41.7	41.7	41.7	41.7	9408.0
2018-03-23 05:55:00	AAPL	Stock	41.6775	41.6775	41.6775	41.6775	800.0
2018-03-23 05:56:00	AAPL	Stock	41.675	41.675	41.675	41.675	2800.0
2018-03-23 06:09:00	AAPL	Stock	41.6325	41.6325	41.6325	41.6325	400.0
2018-03-23 06:10:00	AAPL	Stock	41.65	41.65	41.65	41.65	3524.0
2018-03-23 06:13:00	AAPL	Stock	41.68	41.68	41.6775	41.6775	1840.0
2018-03-23 06:14:00	AAPL	Stock	41.7375	41.7375	41.7375	41.7375	5728.0
2018-03-23 06:17:00	AAPL	Stock	41.7725	41.7725	41.7725	41.7725	2000.0
2018-03-23 06:19:00	AAPL	Stock	41.7575	41.7925	41.7575	41.7925	8296.0
2018-03-23 06:20:00	AAPL	Stock	41.7925	41.7925	41.7925	41.7925	3600.0
2018-03-23 06:21:00	AAPL	Stock	41.7925	41.7925	41.7925	41.7925	3600.0
2018-03-23 06:22:00	AAPL	Stock	41.805	41.805	41.805	41.805	2400.0
2018-03-23 06:23:00	AAPL	Stock	41.805	41.805	41.805	41.805	800.0
2018-03-23 06:24:00	AAPL	Stock	41.7925	41.7925	41.7925	41.7925	37200.0
2018-03-23 06:25:00	AAPL	Stock	41.7925	41.8075	41.7925	41.805	17220.0
2018-03-23 06:31:00	AAPL	Stock	41.85	41.85	41.85	41.85	6604.0
2018-03-23 06:34:00	AAPL	Stock	41.8975	41.8975	41.8975	41.8975	1840.0
2018-03-23 06:36:00	AAPL	Stock	41.9	41.9075	41.85	41.8525	11936.0
2018-03-23 06:38:00	AAPL	Stock	41.9075	41.9075	41.9075	41.9075	2400.0
2018-03-23 06:41:00	AAPL	Stock	41.8925	41.8925	41.8925	41.8925	1096.0
2018-03-23 06:42:00	AAPL	Stock	41.9075	41.9075	41.9075	41.9075	1200.0
2018-03-23 06:43:00	AAPL	Stock	41.9075	41.9075	41.9075	41.9075	6252.0
2018-03-23 06:47:00	AAPL	Stock	41.9075	41.9375	41.9075	41.9375	2400.0

> showing 50 of 1,114,415 rows — these rows as CSV

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