PREVIEW / stock_1min / 2017-11-16

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-11-16.parquet
  size:    15.4 MB
  rows:    1,098,007
  symbols: 2,445

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-11-16 04:00:00	AAPL	Stock	42.515	42.525	42.515	42.525	3132.0
2017-11-16 04:49:00	AAPL	Stock	42.5625	42.5625	42.5625	42.5625	800.0
2017-11-16 04:54:00	AAPL	Stock	42.6025	42.6025	42.6025	42.6025	400.0
2017-11-16 05:08:00	AAPL	Stock	42.62	42.63	42.62	42.63	12364.0
2017-11-16 05:09:00	AAPL	Stock	42.635	42.635	42.635	42.635	1268.0
2017-11-16 05:12:00	AAPL	Stock	42.635	42.635	42.635	42.635	6000.0
2017-11-16 05:18:00	AAPL	Stock	42.635	42.635	42.635	42.635	1168.0
2017-11-16 05:25:00	AAPL	Stock	42.635	42.635	42.635	42.635	2024.0
2017-11-16 05:33:00	AAPL	Stock	42.635	42.635	42.635	42.635	5600.0
2017-11-16 05:36:00	AAPL	Stock	42.65	42.6625	42.62	42.62	2492.0
2017-11-16 05:48:00	AAPL	Stock	42.6575	42.6575	42.6575	42.6575	404.0
2017-11-16 05:49:00	AAPL	Stock	42.645	42.645	42.645	42.645	800.0
2017-11-16 06:00:00	AAPL	Stock	42.6475	42.6475	42.6475	42.6475	2000.0
2017-11-16 06:01:00	AAPL	Stock	42.6475	42.6475	42.6475	42.6475	6800.0
2017-11-16 06:02:00	AAPL	Stock	42.6475	42.6475	42.6475	42.6475	400.0
2017-11-16 06:03:00	AAPL	Stock	42.645	42.645	42.6125	42.6125	17052.0
2017-11-16 06:06:00	AAPL	Stock	42.5875	42.5875	42.5875	42.5875	6632.0
2017-11-16 06:07:00	AAPL	Stock	42.6025	42.6025	42.6025	42.6025	2000.0
2017-11-16 06:10:00	AAPL	Stock	42.59	42.59	42.59	42.59	400.0
2017-11-16 06:13:00	AAPL	Stock	42.59	42.59	42.5875	42.5875	800.0
2017-11-16 06:23:00	AAPL	Stock	42.6125	42.6125	42.6125	42.6125	400.0
2017-11-16 06:25:00	AAPL	Stock	42.5925	42.5925	42.5925	42.5925	2644.0
2017-11-16 06:26:00	AAPL	Stock	42.6025	42.605	42.6025	42.605	1524.0
2017-11-16 06:27:00	AAPL	Stock	42.565	42.5875	42.5625	42.5875	4308.0
2017-11-16 06:34:00	AAPL	Stock	42.595	42.595	42.595	42.595	556.0
2017-11-16 06:35:00	AAPL	Stock	42.595	42.6	42.595	42.6	5044.0
2017-11-16 06:36:00	AAPL	Stock	42.6	42.6	42.6	42.6	2756.0
2017-11-16 06:39:00	AAPL	Stock	42.6125	42.6125	42.58	42.58	952.0
2017-11-16 06:41:00	AAPL	Stock	42.61	42.61	42.61	42.61	400.0
2017-11-16 06:43:00	AAPL	Stock	42.6	42.6	42.6	42.6	400.0
2017-11-16 06:45:00	AAPL	Stock	42.5825	42.5825	42.5825	42.5825	400.0
2017-11-16 06:55:00	AAPL	Stock	42.6125	42.6325	42.6125	42.625	6804.0
2017-11-16 06:56:00	AAPL	Stock	42.6025	42.6025	42.6025	42.6025	400.0
2017-11-16 07:00:00	AAPL	Stock	42.5925	42.625	42.5775	42.5775	26420.0
2017-11-16 07:01:00	AAPL	Stock	42.5875	42.6025	42.5875	42.6025	4748.0
2017-11-16 07:02:00	AAPL	Stock	42.6175	42.6175	42.6125	42.6125	13600.0
2017-11-16 07:03:00	AAPL	Stock	42.605	42.605	42.605	42.605	3844.0
2017-11-16 07:04:00	AAPL	Stock	42.59	42.59	42.59	42.59	4000.0
2017-11-16 07:05:00	AAPL	Stock	42.61	42.6125	42.6	42.6	1780.0
2017-11-16 07:06:00	AAPL	Stock	42.6125	42.6125	42.6125	42.6125	3800.0
2017-11-16 07:07:00	AAPL	Stock	42.62	42.62	42.62	42.62	2000.0
2017-11-16 07:08:00	AAPL	Stock	42.6	42.615	42.6	42.6	2980.0
2017-11-16 07:09:00	AAPL	Stock	42.6125	42.6175	42.6025	42.6025	7092.0
2017-11-16 07:10:00	AAPL	Stock	42.6225	42.625	42.61	42.61	6912.0
2017-11-16 07:11:00	AAPL	Stock	42.625	42.6275	42.615	42.6175	30800.0
2017-11-16 07:12:00	AAPL	Stock	42.6175	42.625	42.6175	42.625	5824.0
2017-11-16 07:13:00	AAPL	Stock	42.625	42.625	42.625	42.625	3600.0
2017-11-16 07:14:00	AAPL	Stock	42.625	42.65	42.625	42.65	15288.0
2017-11-16 07:15:00	AAPL	Stock	42.65	42.6525	42.6375	42.6525	21200.0
2017-11-16 07:16:00	AAPL	Stock	42.655	42.655	42.655	42.655	400.0

> showing 50 of 1,098,007 rows — these rows as CSV

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