PREVIEW / stock_1min / 2018-06-14

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-06-14.parquet
  size:    15.4 MB
  rows:    1,096,587
  symbols: 2,355

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-06-14 04:04:00	AAPL	Stock	47.6575	47.6575	47.6575	47.6575	2400.0
2018-06-14 04:05:00	AAPL	Stock	47.6575	47.6575	47.6575	47.6575	400.0
2018-06-14 05:05:00	AAPL	Stock	47.66	47.66	47.66	47.66	2000.0
2018-06-14 05:09:00	AAPL	Stock	47.66	47.66	47.66	47.66	524.0
2018-06-14 05:25:00	AAPL	Stock	47.65	47.6625	47.65	47.6625	4000.0
2018-06-14 05:26:00	AAPL	Stock	47.6625	47.6625	47.6625	47.6625	4000.0
2018-06-14 05:39:00	AAPL	Stock	47.725	47.725	47.725	47.725	400.0
2018-06-14 05:43:00	AAPL	Stock	47.7225	47.7225	47.7225	47.7225	400.0
2018-06-14 05:55:00	AAPL	Stock	47.6225	47.6225	47.6225	47.6225	1600.0
2018-06-14 06:06:00	AAPL	Stock	47.5875	47.5875	47.585	47.585	4000.0
2018-06-14 06:07:00	AAPL	Stock	47.585	47.585	47.585	47.585	2000.0
2018-06-14 06:08:00	AAPL	Stock	47.5875	47.5875	47.5875	47.5875	2000.0
2018-06-14 06:17:00	AAPL	Stock	47.6275	47.6275	47.6275	47.6275	400.0
2018-06-14 06:32:00	AAPL	Stock	47.625	47.625	47.625	47.625	800.0
2018-06-14 06:39:00	AAPL	Stock	47.625	47.625	47.625	47.625	600.0
2018-06-14 07:00:00	AAPL	Stock	47.625	47.65	47.625	47.6275	4800.0
2018-06-14 07:02:00	AAPL	Stock	47.625	47.625	47.625	47.625	400.0
2018-06-14 07:08:00	AAPL	Stock	47.6275	47.6275	47.6275	47.6275	400.0
2018-06-14 07:09:00	AAPL	Stock	47.625	47.625	47.625	47.625	952.0
2018-06-14 07:11:00	AAPL	Stock	47.6275	47.6275	47.6275	47.6275	400.0
2018-06-14 07:12:00	AAPL	Stock	47.6225	47.625	47.61	47.61	8720.0
2018-06-14 07:18:00	AAPL	Stock	47.625	47.625	47.625	47.625	400.0
2018-06-14 07:19:00	AAPL	Stock	47.625	47.625	47.625	47.625	788.0
2018-06-14 07:22:00	AAPL	Stock	47.6475	47.6725	47.6475	47.66	21392.0
2018-06-14 07:26:00	AAPL	Stock	47.6575	47.675	47.6575	47.6725	2400.0
2018-06-14 07:28:00	AAPL	Stock	47.675	47.675	47.675	47.675	800.0
2018-06-14 07:29:00	AAPL	Stock	47.6825	47.6825	47.6825	47.6825	400.0
2018-06-14 07:32:00	AAPL	Stock	47.705	47.705	47.705	47.705	400.0
2018-06-14 07:34:00	AAPL	Stock	47.6975	47.6975	47.6975	47.6975	1132.0
2018-06-14 07:35:00	AAPL	Stock	47.7025	47.7125	47.7025	47.7125	1312.0
2018-06-14 07:36:00	AAPL	Stock	47.7125	47.7125	47.7125	47.7125	400.0
2018-06-14 07:39:00	AAPL	Stock	47.7125	47.7125	47.7125	47.7125	500.0
2018-06-14 07:45:00	AAPL	Stock	47.7325	47.7325	47.71	47.71	4992.0
2018-06-14 07:47:00	AAPL	Stock	47.7125	47.7275	47.7125	47.7275	1276.0
2018-06-14 07:49:00	AAPL	Stock	47.73	47.73	47.73	47.73	2400.0
2018-06-14 07:53:00	AAPL	Stock	47.7625	47.7675	47.75	47.75	3516.0
2018-06-14 07:54:00	AAPL	Stock	47.7675	47.7675	47.7675	47.7675	5600.0
2018-06-14 07:55:00	AAPL	Stock	47.785	47.785	47.785	47.785	400.0
2018-06-14 07:57:00	AAPL	Stock	47.785	47.785	47.785	47.785	3892.0
2018-06-14 08:00:00	AAPL	Stock	47.6775	47.8	47.62	47.8	23424.0
2018-06-14 08:02:00	AAPL	Stock	47.7875	47.7875	47.7725	47.7725	3440.0
2018-06-14 08:04:00	AAPL	Stock	47.7725	47.7725	47.77	47.7725	21600.0
2018-06-14 08:05:00	AAPL	Stock	47.7675	47.77	47.7675	47.77	3660.0
2018-06-14 08:06:00	AAPL	Stock	47.77	47.77	47.7625	47.7675	4648.0
2018-06-14 08:08:00	AAPL	Stock	47.75	47.775	47.75	47.775	2188.0
2018-06-14 08:09:00	AAPL	Stock	47.775	47.7925	47.775	47.7925	2000.0
2018-06-14 08:10:00	AAPL	Stock	47.8	47.8	47.8	47.8	400.0
2018-06-14 08:11:00	AAPL	Stock	47.775	47.7875	47.775	47.775	5684.0
2018-06-14 08:12:00	AAPL	Stock	47.775	47.775	47.775	47.775	4072.0
2018-06-14 08:13:00	AAPL	Stock	47.7875	47.79	47.7875	47.79	15268.0

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

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