PREVIEW / etf_1min / 2017-05-05

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-05-05.parquet
  size:    2.7 MB
  rows:    139,060

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-05-05 04:05:00	SPY	ETF	238.6	238.6	238.6	238.6	203.0
2017-05-05 04:06:00	SPY	ETF	238.57	238.57	238.57	238.57	101.0
2017-05-05 04:08:00	SPY	ETF	238.59	238.59	238.59	238.59	310.0
2017-05-05 04:09:00	SPY	ETF	238.61	238.61	238.61	238.61	301.0
2017-05-05 04:17:00	SPY	ETF	238.69	238.69	238.69	238.69	300.0
2017-05-05 04:25:00	SPY	ETF	238.76	238.76	238.76	238.76	302.0
2017-05-05 04:26:00	SPY	ETF	238.76	238.76	238.76	238.76	300.0
2017-05-05 04:32:00	SPY	ETF	238.79	238.79	238.79	238.79	600.0
2017-05-05 04:36:00	SPY	ETF	238.79	238.79	238.79	238.79	300.0
2017-05-05 04:37:00	SPY	ETF	238.79	238.81	238.79	238.81	1100.0
2017-05-05 04:38:00	SPY	ETF	238.81	238.81	238.81	238.81	300.0
2017-05-05 04:43:00	SPY	ETF	238.76	238.76	238.76	238.76	100.0
2017-05-05 04:44:00	SPY	ETF	238.79	238.79	238.79	238.79	301.0
2017-05-05 04:47:00	SPY	ETF	238.79	238.79	238.79	238.79	100.0
2017-05-05 04:48:00	SPY	ETF	238.79	238.79	238.79	238.79	300.0
2017-05-05 04:56:00	SPY	ETF	238.76	238.76	238.76	238.76	300.0
2017-05-05 04:57:00	SPY	ETF	238.76	238.76	238.76	238.76	1200.0
2017-05-05 04:58:00	SPY	ETF	238.76	238.79	238.76	238.79	302.0
2017-05-05 05:00:00	SPY	ETF	238.81	238.81	238.81	238.81	500.0
2017-05-05 05:05:00	SPY	ETF	238.84	238.84	238.84	238.84	200.0
2017-05-05 05:08:00	SPY	ETF	238.79	238.79	238.79	238.79	302.0
2017-05-05 05:14:00	SPY	ETF	238.79	238.79	238.79	238.79	300.0
2017-05-05 05:19:00	SPY	ETF	238.76	238.76	238.76	238.76	502.0
2017-05-05 05:27:00	SPY	ETF	238.79	238.79	238.79	238.79	303.0
2017-05-05 05:28:00	SPY	ETF	238.76	238.76	238.76	238.76	900.0
2017-05-05 05:32:00	SPY	ETF	238.76	238.76	238.76	238.76	301.0
2017-05-05 05:39:00	SPY	ETF	238.76	238.76	238.76	238.76	400.0
2017-05-05 05:49:00	SPY	ETF	238.79	238.79	238.79	238.79	403.0
2017-05-05 05:50:00	SPY	ETF	238.84	238.84	238.84	238.84	404.0
2017-05-05 05:52:00	SPY	ETF	238.79	238.79	238.79	238.79	300.0
2017-05-05 05:54:00	SPY	ETF	238.79	238.79	238.79	238.79	400.0
2017-05-05 05:56:00	SPY	ETF	238.79	238.79	238.79	238.79	503.0
2017-05-05 06:05:00	SPY	ETF	238.79	238.79	238.79	238.79	390.0
2017-05-05 06:07:00	SPY	ETF	238.81	238.81	238.81	238.81	300.0
2017-05-05 06:14:00	SPY	ETF	238.81	238.81	238.81	238.81	400.0
2017-05-05 06:31:00	SPY	ETF	238.76	238.81	238.76	238.81	4001.0
2017-05-05 06:33:00	SPY	ETF	238.79	238.79	238.79	238.79	400.0
2017-05-05 06:35:00	SPY	ETF	238.75	238.75	238.75	238.75	500.0
2017-05-05 06:37:00	SPY	ETF	238.77	238.77	238.77	238.77	419.0
2017-05-05 06:38:00	SPY	ETF	238.77	238.77	238.77	238.77	300.0
2017-05-05 06:41:00	SPY	ETF	238.77	238.77	238.77	238.77	783.0
2017-05-05 06:47:00	SPY	ETF	238.84	238.84	238.84	238.84	4014.0
2017-05-05 06:58:00	SPY	ETF	238.86	238.86	238.86	238.86	1000.0
2017-05-05 06:59:00	SPY	ETF	238.86	238.86	238.86	238.86	100.0
2017-05-05 07:01:00	SPY	ETF	238.83	238.83	238.82	238.82	5100.0
2017-05-05 07:03:00	SPY	ETF	238.83	238.83	238.83	238.83	100.0
2017-05-05 07:06:00	SPY	ETF	238.82	238.82	238.82	238.82	469.0
2017-05-05 07:08:00	SPY	ETF	238.83	238.85	238.83	238.85	3837.0
2017-05-05 07:13:00	SPY	ETF	238.85	238.89	238.85	238.89	35000.0
2017-05-05 07:14:00	SPY	ETF	238.86	238.86	238.86	238.86	300.0

> showing 50 of 139,060 rows — these rows as CSV

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