PREVIEW / stock_1min / 2017-12-19

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-12-19.parquet
  size:    15.7 MB
  rows:    1,112,314
  symbols: 2,447

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-12-19 04:00:00	AAPL	Stock	43.845	43.845	43.7825	43.7825	15460.0
2017-12-19 04:01:00	AAPL	Stock	43.8175	43.8175	43.75	43.75	1176.0
2017-12-19 04:02:00	AAPL	Stock	43.775	43.775	43.625	43.625	3732.0
2017-12-19 04:03:00	AAPL	Stock	43.6675	43.6675	43.6675	43.6675	400.0
2017-12-19 04:04:00	AAPL	Stock	43.665	43.665	43.665	43.665	400.0
2017-12-19 04:05:00	AAPL	Stock	43.6525	43.6525	43.6525	43.6525	2000.0
2017-12-19 04:06:00	AAPL	Stock	43.675	43.675	43.675	43.675	1000.0
2017-12-19 04:07:00	AAPL	Stock	43.675	43.675	43.675	43.675	400.0
2017-12-19 04:08:00	AAPL	Stock	43.6725	43.675	43.6725	43.675	1200.0
2017-12-19 04:09:00	AAPL	Stock	43.625	43.625	43.625	43.625	496.0
2017-12-19 04:13:00	AAPL	Stock	43.59	43.59	43.59	43.59	800.0
2017-12-19 04:14:00	AAPL	Stock	43.7125	43.7125	43.7125	43.7125	2796.0
2017-12-19 04:16:00	AAPL	Stock	43.7075	43.7075	43.7075	43.7075	400.0
2017-12-19 05:02:00	AAPL	Stock	43.6975	43.6975	43.6975	43.6975	736.0
2017-12-19 05:03:00	AAPL	Stock	43.7075	43.7075	43.7075	43.7075	732.0
2017-12-19 05:09:00	AAPL	Stock	43.7125	43.7125	43.7125	43.7125	1376.0
2017-12-19 05:13:00	AAPL	Stock	43.7125	43.7125	43.7125	43.7125	1600.0
2017-12-19 05:14:00	AAPL	Stock	43.7125	43.7125	43.7125	43.7125	1600.0
2017-12-19 05:15:00	AAPL	Stock	43.7125	43.7125	43.7125	43.7125	800.0
2017-12-19 05:17:00	AAPL	Stock	43.7125	43.7125	43.7125	43.7125	19200.0
2017-12-19 05:47:00	AAPL	Stock	43.675	43.675	43.6625	43.6625	4000.0
2017-12-19 06:01:00	AAPL	Stock	43.69	43.69	43.69	43.69	400.0
2017-12-19 06:03:00	AAPL	Stock	43.74	43.74	43.74	43.74	400.0
2017-12-19 06:04:00	AAPL	Stock	43.715	43.715	43.6975	43.6975	9788.0
2017-12-19 06:05:00	AAPL	Stock	43.7425	43.7475	43.6975	43.6975	11844.0
2017-12-19 06:06:00	AAPL	Stock	43.695	43.695	43.695	43.695	800.0
2017-12-19 06:07:00	AAPL	Stock	43.695	43.695	43.695	43.695	800.0
2017-12-19 06:08:00	AAPL	Stock	43.685	43.685	43.665	43.665	3076.0
2017-12-19 06:13:00	AAPL	Stock	43.6875	43.6875	43.6875	43.6875	400.0
2017-12-19 06:14:00	AAPL	Stock	43.675	43.6875	43.675	43.6875	1200.0
2017-12-19 06:15:00	AAPL	Stock	43.6875	43.6875	43.6875	43.6875	400.0
2017-12-19 06:16:00	AAPL	Stock	43.695	43.695	43.695	43.695	4000.0
2017-12-19 06:18:00	AAPL	Stock	43.6575	43.695	43.655	43.695	5600.0
2017-12-19 06:22:00	AAPL	Stock	43.6825	43.6825	43.6825	43.6825	1400.0
2017-12-19 06:25:00	AAPL	Stock	43.6725	43.6725	43.67	43.67	4400.0
2017-12-19 06:26:00	AAPL	Stock	43.67	43.67	43.67	43.67	400.0
2017-12-19 06:28:00	AAPL	Stock	43.645	43.645	43.645	43.645	400.0
2017-12-19 06:31:00	AAPL	Stock	43.625	43.625	43.625	43.625	800.0
2017-12-19 06:32:00	AAPL	Stock	43.59	43.6	43.5775	43.5775	13820.0
2017-12-19 06:33:00	AAPL	Stock	43.5975	43.6	43.5975	43.6	6272.0
2017-12-19 06:34:00	AAPL	Stock	43.6	43.6	43.585	43.6	2000.0
2017-12-19 06:35:00	AAPL	Stock	43.5725	43.5725	43.5725	43.5725	400.0
2017-12-19 06:37:00	AAPL	Stock	43.5725	43.5725	43.57	43.57	2748.0
2017-12-19 06:39:00	AAPL	Stock	43.595	43.6	43.595	43.6	14212.0
2017-12-19 06:46:00	AAPL	Stock	43.63	43.63	43.63	43.63	1940.0
2017-12-19 06:48:00	AAPL	Stock	43.63	43.6375	43.63	43.6375	4400.0
2017-12-19 06:49:00	AAPL	Stock	43.6325	43.6475	43.6325	43.6475	3200.0
2017-12-19 06:54:00	AAPL	Stock	43.645	43.645	43.645	43.645	1200.0
2017-12-19 06:55:00	AAPL	Stock	43.645	43.66	43.645	43.66	7200.0
2017-12-19 06:56:00	AAPL	Stock	43.6575	43.66	43.6575	43.66	3600.0

> showing 50 of 1,112,314 rows — these rows as CSV

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