PREVIEW / stock_1min / 2017-04-18

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-04-18.parquet
  size:    14.0 MB
  rows:    1,025,767
  symbols: 2,519

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-04-18 04:31:00	AAPL	Stock	35.4075	35.4075	35.4075	35.4075	720.0
2017-04-18 04:40:00	AAPL	Stock	35.42	35.42	35.42	35.42	560.0
2017-04-18 04:41:00	AAPL	Stock	35.42	35.42	35.42	35.42	800.0
2017-04-18 04:52:00	AAPL	Stock	35.4075	35.4075	35.4075	35.4075	880.0
2017-04-18 05:05:00	AAPL	Stock	35.3925	35.3925	35.38	35.38	3200.0
2017-04-18 05:39:00	AAPL	Stock	35.3675	35.3675	35.3675	35.3675	1312.0
2017-04-18 05:43:00	AAPL	Stock	35.355	35.355	35.355	35.355	400.0
2017-04-18 05:55:00	AAPL	Stock	35.3625	35.3625	35.3625	35.3625	780.0
2017-04-18 05:56:00	AAPL	Stock	35.36	35.36	35.355	35.355	2400.0
2017-04-18 05:57:00	AAPL	Stock	35.35	35.35	35.35	35.35	4000.0
2017-04-18 06:00:00	AAPL	Stock	35.385	35.3975	35.385	35.3875	8192.0
2017-04-18 06:03:00	AAPL	Stock	35.35	35.3525	35.35	35.35	4000.0
2017-04-18 06:04:00	AAPL	Stock	35.3525	35.3525	35.3375	35.3375	2592.0
2017-04-18 06:05:00	AAPL	Stock	35.35	35.35	35.35	35.35	800.0
2017-04-18 06:25:00	AAPL	Stock	35.3375	35.3375	35.325	35.33	4060.0
2017-04-18 06:27:00	AAPL	Stock	35.3375	35.3375	35.33	35.33	800.0
2017-04-18 06:34:00	AAPL	Stock	35.365	35.365	35.365	35.365	520.0
2017-04-18 06:35:00	AAPL	Stock	35.37	35.37	35.37	35.37	2000.0
2017-04-18 06:37:00	AAPL	Stock	35.35	35.35	35.35	35.35	3600.0
2017-04-18 07:00:00	AAPL	Stock	35.375	35.375	35.375	35.375	2400.0
2017-04-18 07:05:00	AAPL	Stock	35.36	35.385	35.36	35.385	6300.0
2017-04-18 07:06:00	AAPL	Stock	35.375	35.375	35.375	35.375	2000.0
2017-04-18 07:09:00	AAPL	Stock	35.3775	35.3775	35.375	35.375	1600.0
2017-04-18 07:10:00	AAPL	Stock	35.3825	35.3975	35.3825	35.3975	8200.0
2017-04-18 07:13:00	AAPL	Stock	35.39	35.39	35.39	35.39	1200.0
2017-04-18 07:17:00	AAPL	Stock	35.3875	35.4	35.3875	35.4	6800.0
2017-04-18 07:18:00	AAPL	Stock	35.395	35.395	35.395	35.395	400.0
2017-04-18 07:19:00	AAPL	Stock	35.395	35.395	35.395	35.395	800.0
2017-04-18 07:21:00	AAPL	Stock	35.395	35.395	35.395	35.395	400.0
2017-04-18 07:26:00	AAPL	Stock	35.4	35.4	35.4	35.4	12324.0
2017-04-18 07:28:00	AAPL	Stock	35.4	35.4	35.4	35.4	2000.0
2017-04-18 07:30:00	AAPL	Stock	35.4	35.4	35.4	35.4	2000.0
2017-04-18 07:35:00	AAPL	Stock	35.4	35.4	35.4	35.4	1800.0
2017-04-18 07:40:00	AAPL	Stock	35.4	35.4	35.4	35.4	3484.0
2017-04-18 07:42:00	AAPL	Stock	35.3875	35.3875	35.375	35.375	7000.0
2017-04-18 07:49:00	AAPL	Stock	35.3975	35.4	35.3975	35.4	4952.0
2017-04-18 07:50:00	AAPL	Stock	35.4	35.4	35.4	35.4	1200.0
2017-04-18 07:57:00	AAPL	Stock	35.4	35.4	35.4	35.4	400.0
2017-04-18 08:00:00	AAPL	Stock	35.375	35.4	35.375	35.4	17100.0
2017-04-18 08:03:00	AAPL	Stock	35.3875	35.4	35.3875	35.4	3600.0
2017-04-18 08:05:00	AAPL	Stock	35.3875	35.3875	35.3875	35.3875	1600.0
2017-04-18 08:07:00	AAPL	Stock	35.3875	35.3875	35.3875	35.3875	400.0
2017-04-18 08:08:00	AAPL	Stock	35.3875	35.3875	35.3875	35.3875	6000.0
2017-04-18 08:10:00	AAPL	Stock	35.39	35.39	35.39	35.39	1200.0
2017-04-18 08:15:00	AAPL	Stock	35.4	35.4	35.4	35.4	432.0
2017-04-18 08:17:00	AAPL	Stock	35.39	35.39	35.39	35.39	2000.0
2017-04-18 08:18:00	AAPL	Stock	35.4	35.4	35.4	35.4	2000.0
2017-04-18 08:21:00	AAPL	Stock	35.3925	35.3925	35.3875	35.3875	2800.0
2017-04-18 08:22:00	AAPL	Stock	35.38	35.38	35.38	35.38	4368.0
2017-04-18 08:24:00	AAPL	Stock	35.38	35.38	35.38	35.38	1460.0

> showing 50 of 1,025,767 rows — these rows as CSV

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