PREVIEW / stock_1min / 2018-05-23

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-05-23.parquet
  size:    14.7 MB
  rows:    1,068,663
  symbols: 2,371

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-05-23 04:00:00	AAPL	Stock	46.4975	46.4975	46.4975	46.4975	4248.0
2018-05-23 04:15:00	AAPL	Stock	46.515	46.515	46.515	46.515	800.0
2018-05-23 04:17:00	AAPL	Stock	46.4425	46.4425	46.4425	46.4425	1900.0
2018-05-23 04:20:00	AAPL	Stock	46.3775	46.3775	46.3775	46.3775	400.0
2018-05-23 04:22:00	AAPL	Stock	46.3775	46.3775	46.375	46.375	4060.0
2018-05-23 04:25:00	AAPL	Stock	46.35	46.35	46.35	46.35	1600.0
2018-05-23 04:32:00	AAPL	Stock	46.31	46.31	46.31	46.31	400.0
2018-05-23 04:35:00	AAPL	Stock	46.35	46.35	46.35	46.35	400.0
2018-05-23 04:37:00	AAPL	Stock	46.3375	46.3375	46.3375	46.3375	1600.0
2018-05-23 04:40:00	AAPL	Stock	46.3375	46.3375	46.3375	46.3375	800.0
2018-05-23 04:41:00	AAPL	Stock	46.3	46.3125	46.3	46.3125	16640.0
2018-05-23 04:42:00	AAPL	Stock	46.3125	46.3125	46.3125	46.3125	15400.0
2018-05-23 04:51:00	AAPL	Stock	46.3125	46.3125	46.3125	46.3125	1160.0
2018-05-23 04:56:00	AAPL	Stock	46.3125	46.3125	46.3125	46.3125	1200.0
2018-05-23 04:57:00	AAPL	Stock	46.2625	46.2625	46.2625	46.2625	816.0
2018-05-23 05:02:00	AAPL	Stock	46.2525	46.2525	46.25	46.25	1400.0
2018-05-23 05:07:00	AAPL	Stock	46.2375	46.2375	46.2375	46.2375	400.0
2018-05-23 05:08:00	AAPL	Stock	46.175	46.175	46.175	46.175	3980.0
2018-05-23 05:09:00	AAPL	Stock	46.225	46.225	46.175	46.175	11200.0
2018-05-23 05:10:00	AAPL	Stock	46.175	46.175	46.1625	46.1625	3340.0
2018-05-23 05:12:00	AAPL	Stock	46.2375	46.2375	46.2125	46.2125	2400.0
2018-05-23 05:17:00	AAPL	Stock	46.25	46.25	46.25	46.25	3116.0
2018-05-23 05:23:00	AAPL	Stock	46.25	46.25	46.25	46.25	1212.0
2018-05-23 05:29:00	AAPL	Stock	46.25	46.25	46.25	46.25	508.0
2018-05-23 06:19:00	AAPL	Stock	46.3	46.3	46.3	46.3	2000.0
2018-05-23 06:25:00	AAPL	Stock	46.3	46.3	46.3	46.3	2400.0
2018-05-23 06:33:00	AAPL	Stock	46.3425	46.3425	46.3425	46.3425	400.0
2018-05-23 06:37:00	AAPL	Stock	46.3425	46.3425	46.3425	46.3425	1040.0
2018-05-23 06:41:00	AAPL	Stock	46.32	46.32	46.32	46.32	600.0
2018-05-23 06:44:00	AAPL	Stock	46.32	46.32	46.32	46.32	800.0
2018-05-23 06:45:00	AAPL	Stock	46.32	46.32	46.3025	46.3025	2900.0
2018-05-23 06:49:00	AAPL	Stock	46.355	46.355	46.355	46.355	820.0
2018-05-23 06:55:00	AAPL	Stock	46.33	46.33	46.325	46.325	2800.0
2018-05-23 06:57:00	AAPL	Stock	46.325	46.325	46.325	46.325	800.0
2018-05-23 07:00:00	AAPL	Stock	46.375	46.4875	46.3025	46.3925	68316.0
2018-05-23 07:01:00	AAPL	Stock	46.375	46.375	46.375	46.375	1228.0
2018-05-23 07:02:00	AAPL	Stock	46.45	46.4875	46.45	46.4875	5280.0
2018-05-23 07:03:00	AAPL	Stock	46.3875	46.4475	46.3875	46.4475	3800.0
2018-05-23 07:05:00	AAPL	Stock	46.4025	46.435	46.4025	46.435	6584.0
2018-05-23 07:06:00	AAPL	Stock	46.4325	46.4325	46.4325	46.4325	516.0
2018-05-23 07:07:00	AAPL	Stock	46.43	46.43	46.4	46.4	1200.0
2018-05-23 07:10:00	AAPL	Stock	46.43	46.43	46.43	46.43	2000.0
2018-05-23 07:11:00	AAPL	Stock	46.405	46.405	46.405	46.405	2000.0
2018-05-23 07:12:00	AAPL	Stock	46.43	46.4325	46.3825	46.3825	3000.0
2018-05-23 07:14:00	AAPL	Stock	46.39	46.39	46.3875	46.3875	1252.0
2018-05-23 07:15:00	AAPL	Stock	46.4	46.425	46.3875	46.3875	41604.0
2018-05-23 07:16:00	AAPL	Stock	46.415	46.415	46.415	46.415	400.0
2018-05-23 07:17:00	AAPL	Stock	46.415	46.425	46.415	46.425	21296.0
2018-05-23 07:19:00	AAPL	Stock	46.4	46.4	46.35	46.35	10104.0
2018-05-23 07:20:00	AAPL	Stock	46.36	46.375	46.36	46.3625	2000.0

> showing 50 of 1,068,663 rows — these rows as CSV

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