PREVIEW / stock_1min / 2017-12-20

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-12-20.parquet
  size:    15.3 MB
  rows:    1,089,237
  symbols: 2,430

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-20 04:45:00	AAPL	Stock	43.775	43.775	43.775	43.775	1200.0
2017-12-20 05:13:00	AAPL	Stock	43.8	43.8125	43.8	43.8125	8000.0
2017-12-20 05:22:00	AAPL	Stock	43.81	43.8125	43.81	43.8125	5092.0
2017-12-20 05:29:00	AAPL	Stock	43.8075	43.8075	43.8075	43.8075	532.0
2017-12-20 06:00:00	AAPL	Stock	43.8	43.8	43.8	43.8	400.0
2017-12-20 06:05:00	AAPL	Stock	43.7525	43.7525	43.7525	43.7525	400.0
2017-12-20 06:09:00	AAPL	Stock	43.775	43.775	43.775	43.775	1000.0
2017-12-20 06:32:00	AAPL	Stock	43.775	43.775	43.775	43.775	400.0
2017-12-20 06:34:00	AAPL	Stock	43.7725	43.7825	43.7725	43.7825	2420.0
2017-12-20 06:40:00	AAPL	Stock	43.76	43.76	43.75	43.75	2052.0
2017-12-20 06:48:00	AAPL	Stock	43.7725	43.775	43.7725	43.775	5716.0
2017-12-20 06:55:00	AAPL	Stock	43.795	43.795	43.795	43.795	800.0
2017-12-20 06:56:00	AAPL	Stock	43.7675	43.7675	43.7675	43.7675	488.0
2017-12-20 06:57:00	AAPL	Stock	43.7675	43.7675	43.7675	43.7675	712.0
2017-12-20 07:00:00	AAPL	Stock	43.7625	43.7625	43.75	43.7625	6832.0
2017-12-20 07:02:00	AAPL	Stock	43.775	43.775	43.7525	43.7525	6384.0
2017-12-20 07:03:00	AAPL	Stock	43.7725	43.7875	43.7725	43.7875	13328.0
2017-12-20 07:04:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	1200.0
2017-12-20 07:05:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	4572.0
2017-12-20 07:08:00	AAPL	Stock	43.7775	43.7925	43.775	43.7925	9564.0
2017-12-20 07:09:00	AAPL	Stock	43.78	43.78	43.78	43.78	2800.0
2017-12-20 07:10:00	AAPL	Stock	43.775	43.78	43.775	43.78	5212.0
2017-12-20 07:11:00	AAPL	Stock	43.7925	43.7925	43.7925	43.7925	400.0
2017-12-20 07:12:00	AAPL	Stock	43.795	43.795	43.795	43.795	3000.0
2017-12-20 07:14:00	AAPL	Stock	43.7925	43.7925	43.7925	43.7925	7644.0
2017-12-20 07:15:00	AAPL	Stock	43.7925	43.7925	43.7925	43.7925	400.0
2017-12-20 07:16:00	AAPL	Stock	43.78	43.78	43.78	43.78	6000.0
2017-12-20 07:17:00	AAPL	Stock	43.78	43.78	43.78	43.78	30744.0
2017-12-20 07:19:00	AAPL	Stock	43.75	43.775	43.75	43.775	1396.0
2017-12-20 07:20:00	AAPL	Stock	43.7775	43.7825	43.7775	43.7825	8024.0
2017-12-20 07:23:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	3772.0
2017-12-20 07:25:00	AAPL	Stock	43.78	43.78	43.78	43.78	2392.0
2017-12-20 07:26:00	AAPL	Stock	43.78	43.78	43.78	43.78	4676.0
2017-12-20 07:29:00	AAPL	Stock	43.78	43.78	43.78	43.78	400.0
2017-12-20 07:36:00	AAPL	Stock	43.765	43.775	43.765	43.775	5316.0
2017-12-20 07:38:00	AAPL	Stock	43.76	43.76	43.76	43.76	716.0
2017-12-20 07:39:00	AAPL	Stock	43.76	43.76	43.755	43.755	6320.0
2017-12-20 07:43:00	AAPL	Stock	43.7625	43.775	43.755	43.775	2904.0
2017-12-20 07:44:00	AAPL	Stock	43.75	43.7525	43.75	43.75	7180.0
2017-12-20 07:48:00	AAPL	Stock	43.75	43.75	43.75	43.75	584.0
2017-12-20 07:49:00	AAPL	Stock	43.75	43.75	43.75	43.75	9504.0
2017-12-20 07:50:00	AAPL	Stock	43.75	43.75	43.75	43.75	800.0
2017-12-20 07:51:00	AAPL	Stock	43.765	43.77	43.765	43.77	2400.0
2017-12-20 07:52:00	AAPL	Stock	43.7675	43.77	43.7675	43.77	2000.0
2017-12-20 07:53:00	AAPL	Stock	43.77	43.77	43.77	43.77	400.0
2017-12-20 07:54:00	AAPL	Stock	43.7575	43.7575	43.7575	43.7575	2000.0
2017-12-20 07:56:00	AAPL	Stock	43.7675	43.7675	43.755	43.755	4000.0
2017-12-20 08:00:00	AAPL	Stock	43.8	43.8	43.7225	43.7625	84980.0
2017-12-20 08:02:00	AAPL	Stock	43.77	43.775	43.77	43.775	1320.0
2017-12-20 08:03:00	AAPL	Stock	43.78	43.78	43.78	43.78	3200.0

> showing 50 of 1,089,237 rows — these rows as CSV

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