PREVIEW / stock_1min / 2017-08-25

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-25.parquet
  size:    13.3 MB
  rows:    970,178
  symbols: 2,458

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-25 05:43:00	AAPL	Stock	39.875	39.875	39.875	39.875	4000.0
2017-08-25 06:01:00	AAPL	Stock	39.9225	39.9225	39.9225	39.9225	800.0
2017-08-25 06:24:00	AAPL	Stock	39.9475	39.9475	39.9475	39.9475	800.0
2017-08-25 06:35:00	AAPL	Stock	39.9625	39.9625	39.9625	39.9625	400.0
2017-08-25 06:45:00	AAPL	Stock	39.985	39.9925	39.985	39.9925	1196.0
2017-08-25 06:59:00	AAPL	Stock	39.9875	39.9925	39.9875	39.9925	6676.0
2017-08-25 07:00:00	AAPL	Stock	39.965	39.965	39.965	39.965	1200.0
2017-08-25 07:04:00	AAPL	Stock	39.99	39.99	39.9875	39.9875	1076.0
2017-08-25 07:07:00	AAPL	Stock	39.985	39.985	39.985	39.985	4000.0
2017-08-25 07:08:00	AAPL	Stock	39.9975	39.9975	39.9975	39.9975	400.0
2017-08-25 07:09:00	AAPL	Stock	40.0	40.0	39.9975	40.0	5080.0
2017-08-25 07:10:00	AAPL	Stock	40.025	40.025	40.025	40.025	3916.0
2017-08-25 07:11:00	AAPL	Stock	40.0375	40.04	40.0375	40.04	1600.0
2017-08-25 07:12:00	AAPL	Stock	40.04	40.05	40.04	40.04	6676.0
2017-08-25 07:13:00	AAPL	Stock	40.0	40.0	40.0	40.0	6000.0
2017-08-25 07:18:00	AAPL	Stock	40.025	40.025	40.025	40.025	400.0
2017-08-25 07:19:00	AAPL	Stock	40.025	40.025	40.025	40.025	800.0
2017-08-25 07:23:00	AAPL	Stock	40.025	40.025	40.025	40.025	800.0
2017-08-25 07:27:00	AAPL	Stock	40.025	40.025	40.025	40.025	1200.0
2017-08-25 07:31:00	AAPL	Stock	40.025	40.025	40.025	40.025	400.0
2017-08-25 07:32:00	AAPL	Stock	40.025	40.025	40.025	40.025	1548.0
2017-08-25 07:35:00	AAPL	Stock	40.03	40.0375	40.03	40.0375	1996.0
2017-08-25 07:36:00	AAPL	Stock	40.0375	40.0375	40.0375	40.0375	2800.0
2017-08-25 07:38:00	AAPL	Stock	40.0425	40.0425	40.0425	40.0425	800.0
2017-08-25 07:39:00	AAPL	Stock	40.04	40.04	40.04	40.04	400.0
2017-08-25 07:40:00	AAPL	Stock	40.0425	40.05	40.0375	40.0375	10100.0
2017-08-25 07:42:00	AAPL	Stock	40.0375	40.0375	40.0375	40.0375	600.0
2017-08-25 07:43:00	AAPL	Stock	40.04	40.0875	40.04	40.0875	12268.0
2017-08-25 07:44:00	AAPL	Stock	40.0875	40.0875	40.0875	40.0875	3600.0
2017-08-25 07:45:00	AAPL	Stock	40.0875	40.0975	40.0875	40.0975	9152.0
2017-08-25 07:49:00	AAPL	Stock	40.0625	40.075	40.0575	40.075	4788.0
2017-08-25 07:51:00	AAPL	Stock	40.075	40.075	40.075	40.075	400.0
2017-08-25 07:53:00	AAPL	Stock	40.075	40.075	40.075	40.075	400.0
2017-08-25 07:54:00	AAPL	Stock	40.075	40.075	40.075	40.075	400.0
2017-08-25 08:00:00	AAPL	Stock	40.0	40.0625	39.9975	40.055	13976.0
2017-08-25 08:01:00	AAPL	Stock	40.0575	40.0575	40.05	40.055	8244.0
2017-08-25 08:02:00	AAPL	Stock	40.0675	40.075	40.065	40.07	12400.0
2017-08-25 08:03:00	AAPL	Stock	40.05	40.055	40.05	40.05	1600.0
2017-08-25 08:04:00	AAPL	Stock	40.065	40.07	40.05	40.07	13600.0
2017-08-25 08:06:00	AAPL	Stock	40.05	40.0625	40.05	40.0625	5860.0
2017-08-25 08:07:00	AAPL	Stock	40.06	40.065	40.06	40.065	3872.0
2017-08-25 08:08:00	AAPL	Stock	40.0625	40.0625	40.0625	40.0625	800.0
2017-08-25 08:09:00	AAPL	Stock	40.07	40.07	40.07	40.07	4000.0
2017-08-25 08:10:00	AAPL	Stock	40.0625	40.0625	40.06	40.06	7648.0
2017-08-25 08:11:00	AAPL	Stock	40.055	40.055	40.055	40.055	800.0
2017-08-25 08:12:00	AAPL	Stock	40.0525	40.055	40.0525	40.055	3900.0
2017-08-25 08:13:00	AAPL	Stock	40.04	40.055	40.04	40.0475	2800.0
2017-08-25 08:14:00	AAPL	Stock	40.0475	40.0475	40.0475	40.0475	2800.0
2017-08-25 08:15:00	AAPL	Stock	40.04	40.04	40.0375	40.0375	2000.0
2017-08-25 08:16:00	AAPL	Stock	40.045	40.045	40.03	40.03	8800.0

> showing 50 of 970,178 rows — these rows as CSV

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