PREVIEW / etf_1min / 2017-10-18

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-10-18.parquet
  size:    2.6 MB
  rows:    136,437

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-10-18 04:17:00	SPY	ETF	255.5	255.5	255.49	255.49	5000.0
2017-10-18 05:23:00	SPY	ETF	255.54	255.54	255.54	255.54	1000.0
2017-10-18 05:24:00	SPY	ETF	255.54	255.54	255.54	255.54	2000.0
2017-10-18 05:29:00	SPY	ETF	255.57	255.57	255.57	255.57	500.0
2017-10-18 05:36:00	SPY	ETF	255.57	255.57	255.57	255.57	400.0
2017-10-18 05:38:00	SPY	ETF	255.57	255.57	255.57	255.57	200.0
2017-10-18 05:41:00	SPY	ETF	255.57	255.58	255.57	255.58	4000.0
2017-10-18 05:47:00	SPY	ETF	255.62	255.62	255.62	255.62	5080.0
2017-10-18 05:52:00	SPY	ETF	255.77	255.77	255.77	255.77	100.0
2017-10-18 06:04:00	SPY	ETF	255.73	255.73	255.73	255.73	2500.0
2017-10-18 06:07:00	SPY	ETF	255.73	255.73	255.73	255.73	100.0
2017-10-18 06:24:00	SPY	ETF	255.67	255.67	255.67	255.67	100.0
2017-10-18 06:25:00	SPY	ETF	255.7	255.72	255.7	255.72	400.0
2017-10-18 06:40:00	SPY	ETF	255.73	255.73	255.73	255.73	300.0
2017-10-18 06:44:00	SPY	ETF	255.73	255.76	255.73	255.76	1500.0
2017-10-18 06:46:00	SPY	ETF	255.78	255.78	255.78	255.78	500.0
2017-10-18 06:47:00	SPY	ETF	255.78	255.78	255.78	255.78	2500.0
2017-10-18 06:49:00	SPY	ETF	255.78	255.78	255.78	255.78	300.0
2017-10-18 06:53:00	SPY	ETF	255.78	255.78	255.78	255.78	2000.0
2017-10-18 06:54:00	SPY	ETF	255.77	255.82	255.77	255.79	5100.0
2017-10-18 06:57:00	SPY	ETF	255.83	255.83	255.83	255.83	100.0
2017-10-18 06:59:00	SPY	ETF	255.83	255.83	255.83	255.83	1900.0
2017-10-18 07:00:00	SPY	ETF	255.85	255.85	255.85	255.85	500.0
2017-10-18 07:01:00	SPY	ETF	255.83	255.83	255.82	255.82	1850.0
2017-10-18 07:02:00	SPY	ETF	255.83	255.84	255.83	255.84	3000.0
2017-10-18 07:03:00	SPY	ETF	255.84	255.84	255.84	255.84	1000.0
2017-10-18 07:04:00	SPY	ETF	255.84	255.84	255.84	255.84	1000.0
2017-10-18 07:08:00	SPY	ETF	255.82	255.82	255.82	255.82	190.0
2017-10-18 07:10:00	SPY	ETF	255.8	255.8	255.8	255.8	500.0
2017-10-18 07:12:00	SPY	ETF	255.8	255.8	255.8	255.8	2528.0
2017-10-18 07:17:00	SPY	ETF	255.8	255.8	255.8	255.8	100.0
2017-10-18 07:18:00	SPY	ETF	255.83	255.85	255.83	255.85	1350.0
2017-10-18 07:19:00	SPY	ETF	255.85	255.85	255.85	255.85	7500.0
2017-10-18 07:20:00	SPY	ETF	255.86	255.86	255.86	255.86	200.0
2017-10-18 07:22:00	SPY	ETF	255.85	255.85	255.85	255.85	100.0
2017-10-18 07:24:00	SPY	ETF	255.82	255.82	255.82	255.82	11065.0
2017-10-18 07:25:00	SPY	ETF	255.82	255.82	255.81	255.81	2400.0
2017-10-18 07:26:00	SPY	ETF	255.81	255.82	255.8	255.82	2300.0
2017-10-18 07:28:00	SPY	ETF	255.82	255.82	255.81	255.82	935.0
2017-10-18 07:30:00	SPY	ETF	255.83	255.83	255.83	255.83	100.0
2017-10-18 07:31:00	SPY	ETF	255.83	255.83	255.83	255.83	526.0
2017-10-18 07:32:00	SPY	ETF	255.83	255.83	255.83	255.83	400.0
2017-10-18 07:33:00	SPY	ETF	255.8	255.8	255.8	255.8	100.0
2017-10-18 07:34:00	SPY	ETF	255.83	255.83	255.82	255.83	25100.0
2017-10-18 07:37:00	SPY	ETF	255.85	255.85	255.79	255.79	1169.0
2017-10-18 07:41:00	SPY	ETF	255.8	255.8	255.8	255.8	300.0
2017-10-18 07:45:00	SPY	ETF	255.81	255.81	255.81	255.81	128.0
2017-10-18 07:46:00	SPY	ETF	255.8	255.8	255.8	255.8	400.0
2017-10-18 07:47:00	SPY	ETF	255.8	255.81	255.8	255.8	3600.0
2017-10-18 07:53:00	SPY	ETF	255.82	255.82	255.82	255.82	200.0

> showing 50 of 136,437 rows — these rows as CSV

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