PREVIEW / stock_1min / 2018-08-09

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-08-09.parquet
  size:    14.6 MB
  rows:    1,049,136
  symbols: 2,319

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-08-09 04:22:00	AAPL	Stock	51.725	51.725	51.7	51.7	1348.0
2018-08-09 04:26:00	AAPL	Stock	51.6325	51.6325	51.6325	51.6325	3600.0
2018-08-09 04:32:00	AAPL	Stock	51.6125	51.65	51.6125	51.65	5780.0
2018-08-09 04:36:00	AAPL	Stock	51.675	51.675	51.675	51.675	3600.0
2018-08-09 04:39:00	AAPL	Stock	51.65	51.65	51.65	51.65	3720.0
2018-08-09 04:49:00	AAPL	Stock	51.7225	51.7225	51.7225	51.7225	2000.0
2018-08-09 04:51:00	AAPL	Stock	51.7225	51.7225	51.7225	51.7225	2000.0
2018-08-09 05:23:00	AAPL	Stock	51.725	51.725	51.725	51.725	5112.0
2018-08-09 05:42:00	AAPL	Stock	51.735	51.735	51.735	51.735	3200.0
2018-08-09 05:45:00	AAPL	Stock	51.75	51.75	51.75	51.75	400.0
2018-08-09 05:49:00	AAPL	Stock	51.7725	51.8	51.7725	51.8	10800.0
2018-08-09 05:51:00	AAPL	Stock	51.8	51.8	51.8	51.8	29312.0
2018-08-09 06:10:00	AAPL	Stock	51.8	51.8	51.8	51.8	400.0
2018-08-09 06:11:00	AAPL	Stock	51.8	51.8	51.8	51.8	600.0
2018-08-09 06:46:00	AAPL	Stock	51.81	51.81	51.81	51.81	800.0
2018-08-09 07:00:00	AAPL	Stock	51.745	51.7875	51.745	51.745	7408.0
2018-08-09 07:01:00	AAPL	Stock	51.7375	51.7375	51.7375	51.7375	400.0
2018-08-09 07:02:00	AAPL	Stock	51.7625	51.7725	51.7625	51.7725	800.0
2018-08-09 07:03:00	AAPL	Stock	51.7725	51.775	51.7725	51.775	800.0
2018-08-09 07:06:00	AAPL	Stock	51.775	51.7875	51.775	51.7875	19188.0
2018-08-09 07:07:00	AAPL	Stock	51.7875	51.7875	51.7875	51.7875	800.0
2018-08-09 07:09:00	AAPL	Stock	51.8025	51.8025	51.8025	51.8025	400.0
2018-08-09 07:12:00	AAPL	Stock	51.7975	51.8025	51.7925	51.8025	3600.0
2018-08-09 07:18:00	AAPL	Stock	51.775	51.775	51.775	51.775	800.0
2018-08-09 07:30:00	AAPL	Stock	51.775	51.775	51.775	51.775	400.0
2018-08-09 07:33:00	AAPL	Stock	51.765	51.765	51.765	51.765	400.0
2018-08-09 07:35:00	AAPL	Stock	51.785	51.785	51.765	51.765	7576.0
2018-08-09 07:36:00	AAPL	Stock	51.765	51.765	51.765	51.765	800.0
2018-08-09 07:37:00	AAPL	Stock	51.7525	51.7525	51.7525	51.7525	800.0
2018-08-09 07:41:00	AAPL	Stock	51.7625	51.7625	51.7625	51.7625	400.0
2018-08-09 07:42:00	AAPL	Stock	51.7525	51.7525	51.7525	51.7525	3200.0
2018-08-09 07:43:00	AAPL	Stock	51.745	51.745	51.7375	51.7375	6304.0
2018-08-09 07:44:00	AAPL	Stock	51.75	51.7525	51.75	51.7525	2000.0
2018-08-09 07:45:00	AAPL	Stock	51.75	51.75	51.75	51.75	800.0
2018-08-09 07:48:00	AAPL	Stock	51.75	51.7525	51.75	51.7525	2800.0
2018-08-09 07:49:00	AAPL	Stock	51.785	51.785	51.785	51.785	548.0
2018-08-09 07:53:00	AAPL	Stock	51.785	51.785	51.785	51.785	624.0
2018-08-09 07:55:00	AAPL	Stock	51.785	51.785	51.785	51.785	400.0
2018-08-09 07:56:00	AAPL	Stock	51.785	51.785	51.785	51.785	1600.0
2018-08-09 07:59:00	AAPL	Stock	51.785	51.785	51.785	51.785	400.0
2018-08-09 08:00:00	AAPL	Stock	51.7725	51.805	51.7488	51.752	20728.0
2018-08-09 08:02:00	AAPL	Stock	51.765	51.765	51.7525	51.7525	1200.0
2018-08-09 08:03:00	AAPL	Stock	51.765	51.7725	51.75	51.75	2000.0
2018-08-09 08:06:00	AAPL	Stock	51.7625	51.7625	51.7625	51.7625	448.0
2018-08-09 08:11:00	AAPL	Stock	51.75	51.75	51.75	51.75	400.0
2018-08-09 08:12:00	AAPL	Stock	51.775	51.775	51.775	51.775	1200.0
2018-08-09 08:13:00	AAPL	Stock	51.77	51.785	51.77	51.785	2512.0
2018-08-09 08:15:00	AAPL	Stock	51.78	51.785	51.78	51.7825	2700.0
2018-08-09 08:18:00	AAPL	Stock	51.775	51.775	51.775	51.775	8000.0
2018-08-09 08:19:00	AAPL	Stock	51.7825	51.7825	51.7825	51.7825	800.0

> showing 50 of 1,049,136 rows — these rows as CSV

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