PREVIEW / stock_1min / 2018-04-16

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-16.parquet
  size:    14.4 MB
  rows:    1,042,096
  symbols: 2,397

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-04-16 04:00:00	AAPL	Stock	43.7725	43.7725	43.7725	43.7725	400.0
2018-04-16 04:07:00	AAPL	Stock	43.8	43.8	43.8	43.8	400.0
2018-04-16 05:46:00	AAPL	Stock	43.935	43.9375	43.935	43.9375	2800.0
2018-04-16 06:08:00	AAPL	Stock	43.9375	43.9375	43.9375	43.9375	1000.0
2018-04-16 06:31:00	AAPL	Stock	43.87	43.87	43.87	43.87	1600.0
2018-04-16 06:34:00	AAPL	Stock	43.96	43.96	43.96	43.96	600.0
2018-04-16 06:43:00	AAPL	Stock	43.9425	43.9425	43.9425	43.9425	400.0
2018-04-16 06:46:00	AAPL	Stock	43.9325	43.9325	43.9325	43.9325	1200.0
2018-04-16 06:47:00	AAPL	Stock	43.8875	43.9125	43.8875	43.9125	2000.0
2018-04-16 06:58:00	AAPL	Stock	43.9375	43.9475	43.9375	43.9475	2396.0
2018-04-16 07:00:00	AAPL	Stock	43.94	43.9475	43.9125	43.9475	5584.0
2018-04-16 07:01:00	AAPL	Stock	43.9375	43.95	43.9375	43.9475	5232.0
2018-04-16 07:02:00	AAPL	Stock	43.9475	43.9625	43.8625	43.95	16540.0
2018-04-16 07:03:00	AAPL	Stock	43.9175	43.9175	43.9125	43.9125	2028.0
2018-04-16 07:07:00	AAPL	Stock	43.915	43.915	43.915	43.915	400.0
2018-04-16 07:13:00	AAPL	Stock	43.9325	43.9325	43.9325	43.9325	1996.0
2018-04-16 07:14:00	AAPL	Stock	43.9325	43.9375	43.9325	43.9375	3912.0
2018-04-16 07:16:00	AAPL	Stock	43.95	43.95	43.95	43.95	3520.0
2018-04-16 07:22:00	AAPL	Stock	43.9275	43.9275	43.9125	43.9125	5720.0
2018-04-16 07:23:00	AAPL	Stock	43.9125	43.9125	43.9125	43.9125	1572.0
2018-04-16 07:24:00	AAPL	Stock	43.9	43.9	43.9	43.9	400.0
2018-04-16 07:25:00	AAPL	Stock	43.9	43.9	43.9	43.9	3152.0
2018-04-16 07:26:00	AAPL	Stock	43.8875	43.8875	43.8875	43.8875	4000.0
2018-04-16 07:27:00	AAPL	Stock	43.8875	43.8875	43.8775	43.8775	2400.0
2018-04-16 07:28:00	AAPL	Stock	43.8875	43.8875	43.8875	43.8875	2528.0
2018-04-16 07:29:00	AAPL	Stock	43.8875	43.8875	43.8825	43.8875	15400.0
2018-04-16 07:33:00	AAPL	Stock	43.89	43.89	43.875	43.875	2400.0
2018-04-16 07:40:00	AAPL	Stock	43.8875	43.9	43.8875	43.895	4848.0
2018-04-16 07:41:00	AAPL	Stock	43.905	43.91	43.905	43.91	5600.0
2018-04-16 07:43:00	AAPL	Stock	43.91	43.9125	43.91	43.9125	1600.0
2018-04-16 07:44:00	AAPL	Stock	43.9225	43.9225	43.9225	43.9225	400.0
2018-04-16 07:48:00	AAPL	Stock	43.9125	43.9125	43.9125	43.9125	4476.0
2018-04-16 07:50:00	AAPL	Stock	43.9225	43.925	43.9225	43.925	10000.0
2018-04-16 07:53:00	AAPL	Stock	43.9125	43.9125	43.9125	43.9125	800.0
2018-04-16 07:55:00	AAPL	Stock	43.9125	43.9125	43.9125	43.9125	400.0
2018-04-16 07:57:00	AAPL	Stock	43.9125	43.9125	43.9125	43.9125	400.0
2018-04-16 08:00:00	AAPL	Stock	43.925	43.9375	43.9	43.9125	41484.0
2018-04-16 08:01:00	AAPL	Stock	43.9125	43.9125	43.9125	43.9125	604.0
2018-04-16 08:02:00	AAPL	Stock	43.925	43.925	43.9125	43.925	5080.0
2018-04-16 08:03:00	AAPL	Stock	43.93	43.93	43.93	43.93	400.0
2018-04-16 08:04:00	AAPL	Stock	43.9125	43.93	43.9125	43.93	5120.0
2018-04-16 08:05:00	AAPL	Stock	43.915	43.915	43.915	43.915	4000.0
2018-04-16 08:06:00	AAPL	Stock	43.915	43.915	43.9	43.9	6440.0
2018-04-16 08:09:00	AAPL	Stock	43.895	43.895	43.895	43.895	2032.0
2018-04-16 08:18:00	AAPL	Stock	43.9	43.9	43.9	43.9	3600.0
2018-04-16 08:20:00	AAPL	Stock	43.9025	43.9025	43.9025	43.9025	556.0
2018-04-16 08:21:00	AAPL	Stock	43.9025	43.9025	43.9025	43.9025	400.0
2018-04-16 08:24:00	AAPL	Stock	43.9025	43.9025	43.9025	43.9025	1412.0
2018-04-16 08:27:00	AAPL	Stock	43.8825	43.8825	43.8825	43.8825	808.0
2018-04-16 08:28:00	AAPL	Stock	43.8825	43.8825	43.8825	43.8825	4400.0

> showing 50 of 1,042,096 rows — these rows as CSV

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