PREVIEW / stock_1min / 2017-08-09

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-09.parquet
  size:    14.6 MB
  rows:    1,063,201
  symbols: 2,473

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-08-09 04:02:00	AAPL	Stock	39.845	39.845	39.845	39.845	4400.0
2017-08-09 04:05:00	AAPL	Stock	39.8	39.8	39.8	39.8	400.0
2017-08-09 04:08:00	AAPL	Stock	39.765	39.765	39.7525	39.7525	3480.0
2017-08-09 04:21:00	AAPL	Stock	39.8	39.8	39.8	39.8	748.0
2017-08-09 04:22:00	AAPL	Stock	39.785	39.785	39.785	39.785	516.0
2017-08-09 04:23:00	AAPL	Stock	39.785	39.8	39.785	39.8	4684.0
2017-08-09 05:16:00	AAPL	Stock	39.8625	39.8625	39.8625	39.8625	624.0
2017-08-09 05:46:00	AAPL	Stock	39.8375	39.8375	39.8375	39.8375	1600.0
2017-08-09 05:53:00	AAPL	Stock	39.7875	39.7875	39.7875	39.7875	2400.0
2017-08-09 06:04:00	AAPL	Stock	39.775	39.775	39.775	39.775	3976.0
2017-08-09 06:11:00	AAPL	Stock	39.755	39.755	39.755	39.755	800.0
2017-08-09 06:20:00	AAPL	Stock	39.7525	39.7625	39.75	39.75	3440.0
2017-08-09 06:21:00	AAPL	Stock	39.7525	39.7525	39.75	39.75	6000.0
2017-08-09 06:25:00	AAPL	Stock	39.82	39.82	39.82	39.82	1220.0
2017-08-09 06:40:00	AAPL	Stock	39.7875	39.7875	39.7875	39.7875	400.0
2017-08-09 06:41:00	AAPL	Stock	39.8	39.8	39.8	39.8	1200.0
2017-08-09 06:48:00	AAPL	Stock	39.8	39.8125	39.8	39.8125	2400.0
2017-08-09 06:50:00	AAPL	Stock	39.8125	39.8125	39.8125	39.8125	800.0
2017-08-09 06:51:00	AAPL	Stock	39.81	39.8125	39.81	39.8125	2000.0
2017-08-09 06:52:00	AAPL	Stock	39.8	39.8	39.8	39.8	800.0
2017-08-09 06:53:00	AAPL	Stock	39.8	39.8	39.7975	39.8	2800.0
2017-08-09 06:56:00	AAPL	Stock	39.82	39.82	39.82	39.82	400.0
2017-08-09 06:57:00	AAPL	Stock	39.8	39.8	39.8	39.8	1572.0
2017-08-09 07:01:00	AAPL	Stock	39.79	39.79	39.7875	39.7875	3708.0
2017-08-09 07:02:00	AAPL	Stock	39.8125	39.845	39.8125	39.845	5280.0
2017-08-09 07:04:00	AAPL	Stock	39.825	39.825	39.825	39.825	1200.0
2017-08-09 07:07:00	AAPL	Stock	39.8425	39.8425	39.8425	39.8425	400.0
2017-08-09 07:09:00	AAPL	Stock	39.8425	39.85	39.8425	39.85	5688.0
2017-08-09 07:11:00	AAPL	Stock	39.825	39.8475	39.825	39.825	15640.0
2017-08-09 07:12:00	AAPL	Stock	39.825	39.825	39.825	39.825	6164.0
2017-08-09 07:13:00	AAPL	Stock	39.825	39.825	39.825	39.825	7676.0
2017-08-09 07:14:00	AAPL	Stock	39.8125	39.8125	39.8	39.8125	4440.0
2017-08-09 07:15:00	AAPL	Stock	39.8125	39.8125	39.79	39.79	5552.0
2017-08-09 07:17:00	AAPL	Stock	39.79	39.79	39.7875	39.7875	1600.0
2017-08-09 07:19:00	AAPL	Stock	39.795	39.8	39.795	39.8	2880.0
2017-08-09 07:20:00	AAPL	Stock	39.8	39.8	39.8	39.8	1212.0
2017-08-09 07:21:00	AAPL	Stock	39.8075	39.8075	39.8075	39.8075	800.0
2017-08-09 07:22:00	AAPL	Stock	39.815	39.815	39.815	39.815	1200.0
2017-08-09 07:23:00	AAPL	Stock	39.8175	39.8175	39.8175	39.8175	3600.0
2017-08-09 07:24:00	AAPL	Stock	39.815	39.8225	39.815	39.8225	4068.0
2017-08-09 07:25:00	AAPL	Stock	39.825	39.825	39.825	39.825	5796.0
2017-08-09 07:26:00	AAPL	Stock	39.8475	39.85	39.8475	39.85	1356.0
2017-08-09 07:28:00	AAPL	Stock	39.825	39.825	39.8225	39.8225	4800.0
2017-08-09 07:31:00	AAPL	Stock	39.825	39.825	39.825	39.825	3380.0
2017-08-09 07:33:00	AAPL	Stock	39.815	39.815	39.815	39.815	540.0
2017-08-09 07:36:00	AAPL	Stock	39.825	39.8375	39.825	39.8375	2800.0
2017-08-09 07:38:00	AAPL	Stock	39.8075	39.8475	39.805	39.8475	4868.0
2017-08-09 07:41:00	AAPL	Stock	39.825	39.825	39.7875	39.7875	11132.0
2017-08-09 07:45:00	AAPL	Stock	39.79	39.79	39.79	39.79	400.0
2017-08-09 07:47:00	AAPL	Stock	39.7875	39.7875	39.7875	39.7875	1000.0

> showing 50 of 1,063,201 rows — these rows as CSV

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