PREVIEW / stock_1min / 2017-06-09

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-06-09.parquet
  size:    15.3 MB
  rows:    1,092,602
  symbols: 2,511

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
2017-06-09 04:32:00	AAPL	Stock	38.75	38.75	38.75	38.75	460.0
2017-06-09 05:13:00	AAPL	Stock	38.7975	38.7975	38.7975	38.7975	628.0
2017-06-09 05:38:00	AAPL	Stock	38.825	38.825	38.825	38.825	2000.0
2017-06-09 05:41:00	AAPL	Stock	38.825	38.825	38.8125	38.825	3308.0
2017-06-09 05:45:00	AAPL	Stock	38.8	38.8	38.8	38.8	636.0
2017-06-09 05:46:00	AAPL	Stock	38.8	38.8	38.8	38.8	1600.0
2017-06-09 05:51:00	AAPL	Stock	38.81	38.81	38.81	38.81	400.0
2017-06-09 05:52:00	AAPL	Stock	38.81	38.81	38.81	38.81	1600.0
2017-06-09 05:56:00	AAPL	Stock	38.8	38.8	38.8	38.8	800.0
2017-06-09 05:58:00	AAPL	Stock	38.81	38.825	38.81	38.825	972.0
2017-06-09 05:59:00	AAPL	Stock	38.8375	38.8375	38.8375	38.8375	668.0
2017-06-09 06:14:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	756.0
2017-06-09 06:39:00	AAPL	Stock	38.795	38.795	38.795	38.795	2000.0
2017-06-09 06:56:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	2164.0
2017-06-09 07:00:00	AAPL	Stock	38.7825	38.7825	38.7825	38.7825	2600.0
2017-06-09 07:07:00	AAPL	Stock	38.7825	38.7825	38.7825	38.7825	2148.0
2017-06-09 07:08:00	AAPL	Stock	38.7825	38.7825	38.7825	38.7825	800.0
2017-06-09 07:11:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	640.0
2017-06-09 07:17:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	4000.0
2017-06-09 07:33:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	400.0
2017-06-09 07:34:00	AAPL	Stock	38.7825	38.7825	38.7825	38.7825	3600.0
2017-06-09 07:38:00	AAPL	Stock	38.7825	38.7825	38.7825	38.7825	5248.0
2017-06-09 07:42:00	AAPL	Stock	38.775	38.775	38.775	38.775	5756.0
2017-06-09 07:43:00	AAPL	Stock	38.775	38.775	38.775	38.775	800.0
2017-06-09 07:51:00	AAPL	Stock	38.775	38.775	38.775	38.775	3276.0
2017-06-09 07:57:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	400.0
2017-06-09 08:00:00	AAPL	Stock	38.7875	38.805	38.75	38.8	43908.0
2017-06-09 08:01:00	AAPL	Stock	38.79	38.8	38.79	38.8	3600.0
2017-06-09 08:02:00	AAPL	Stock	38.7975	38.7975	38.7975	38.7975	3796.0
2017-06-09 08:03:00	AAPL	Stock	38.805	38.805	38.805	38.805	800.0
2017-06-09 08:04:00	AAPL	Stock	38.805	38.805	38.8	38.8	4400.0
2017-06-09 08:05:00	AAPL	Stock	38.8	38.8	38.8	38.8	2136.0
2017-06-09 08:07:00	AAPL	Stock	38.8	38.8	38.8	38.8	400.0
2017-06-09 08:08:00	AAPL	Stock	38.805	38.805	38.805	38.805	800.0
2017-06-09 08:09:00	AAPL	Stock	38.81	38.81	38.8075	38.8075	1272.0
2017-06-09 08:10:00	AAPL	Stock	38.8075	38.81	38.8075	38.81	7224.0
2017-06-09 08:11:00	AAPL	Stock	38.81	38.81	38.81	38.81	900.0
2017-06-09 08:13:00	AAPL	Stock	38.8125	38.8175	38.81	38.8175	4360.0
2017-06-09 08:14:00	AAPL	Stock	38.815	38.815	38.815	38.815	1000.0
2017-06-09 08:15:00	AAPL	Stock	38.815	38.815	38.815	38.815	1800.0
2017-06-09 08:16:00	AAPL	Stock	38.8125	38.8125	38.8125	38.8125	400.0
2017-06-09 08:17:00	AAPL	Stock	38.8125	38.8125	38.8125	38.8125	2400.0
2017-06-09 08:18:00	AAPL	Stock	38.8125	38.8125	38.8125	38.8125	720.0
2017-06-09 08:20:00	AAPL	Stock	38.8125	38.8125	38.81	38.81	22560.0
2017-06-09 08:29:00	AAPL	Stock	38.8	38.8	38.8	38.8	2412.0
2017-06-09 08:30:00	AAPL	Stock	38.8	38.8	38.795	38.795	8460.0
2017-06-09 08:31:00	AAPL	Stock	38.8	38.8	38.8	38.8	400.0
2017-06-09 08:32:00	AAPL	Stock	38.8	38.8	38.8	38.8	800.0
2017-06-09 08:37:00	AAPL	Stock	38.8025	38.8025	38.8025	38.8025	800.0
2017-06-09 08:39:00	AAPL	Stock	38.8025	38.8025	38.8025	38.8025	800.0

> showing 50 of 1,092,602 rows — these rows as CSV

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