PREVIEW / etf_1min / 2017-07-19

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-07-19.parquet
  size:    2.6 MB
  rows:    136,956

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-07-19 04:02:00	SPY	ETF	245.91	245.91	245.91	245.91	300.0
2017-07-19 04:13:00	SPY	ETF	245.8	245.8	245.8	245.8	100.0
2017-07-19 04:40:00	SPY	ETF	245.78	245.78	245.78	245.78	100.0
2017-07-19 04:54:00	SPY	ETF	245.81	245.83	245.81	245.83	901.0
2017-07-19 05:06:00	SPY	ETF	245.82	245.82	245.82	245.82	100.0
2017-07-19 05:11:00	SPY	ETF	245.82	245.82	245.82	245.82	800.0
2017-07-19 05:16:00	SPY	ETF	245.82	245.82	245.82	245.82	200.0
2017-07-19 05:24:00	SPY	ETF	245.84	245.84	245.84	245.84	4000.0
2017-07-19 05:25:00	SPY	ETF	245.82	245.82	245.82	245.82	4000.0
2017-07-19 05:28:00	SPY	ETF	245.85	245.85	245.85	245.85	300.0
2017-07-19 05:39:00	SPY	ETF	245.82	245.82	245.82	245.82	300.0
2017-07-19 05:41:00	SPY	ETF	245.82	245.82	245.82	245.82	1700.0
2017-07-19 05:43:00	SPY	ETF	245.82	245.82	245.82	245.82	1800.0
2017-07-19 05:46:00	SPY	ETF	245.85	245.85	245.83	245.83	330.0
2017-07-19 06:05:00	SPY	ETF	245.83	245.83	245.83	245.83	1000.0
2017-07-19 06:27:00	SPY	ETF	245.79	245.79	245.79	245.79	400.0
2017-07-19 06:33:00	SPY	ETF	245.79	245.79	245.79	245.79	400.0
2017-07-19 06:35:00	SPY	ETF	245.79	245.79	245.79	245.79	3303.0
2017-07-19 06:45:00	SPY	ETF	245.78	245.78	245.78	245.78	300.0
2017-07-19 06:52:00	SPY	ETF	245.78	245.78	245.78	245.78	4000.0
2017-07-19 06:53:00	SPY	ETF	245.77	245.77	245.77	245.77	101.0
2017-07-19 06:54:00	SPY	ETF	245.76	245.76	245.76	245.76	4000.0
2017-07-19 07:03:00	SPY	ETF	245.75	245.75	245.75	245.75	500.0
2017-07-19 07:10:00	SPY	ETF	245.75	245.76	245.75	245.76	3000.0
2017-07-19 07:11:00	SPY	ETF	245.75	245.75	245.72	245.73	3703.0
2017-07-19 07:13:00	SPY	ETF	245.78	245.78	245.78	245.78	400.0
2017-07-19 07:19:00	SPY	ETF	245.78	245.78	245.78	245.78	500.0
2017-07-19 07:21:00	SPY	ETF	245.8	245.8	245.8	245.8	110.0
2017-07-19 07:23:00	SPY	ETF	245.78	245.78	245.78	245.78	400.0
2017-07-19 07:29:00	SPY	ETF	245.8	245.8	245.8	245.8	100.0
2017-07-19 07:30:00	SPY	ETF	245.82	245.82	245.82	245.82	301.0
2017-07-19 07:34:00	SPY	ETF	245.81	245.81	245.81	245.81	2118.0
2017-07-19 07:35:00	SPY	ETF	245.81	245.81	245.81	245.81	740.0
2017-07-19 07:36:00	SPY	ETF	245.82	245.82	245.82	245.82	1000.0
2017-07-19 07:40:00	SPY	ETF	245.78	245.78	245.78	245.78	4000.0
2017-07-19 07:50:00	SPY	ETF	245.77	245.78	245.77	245.78	600.0
2017-07-19 07:55:00	SPY	ETF	245.78	245.78	245.78	245.78	400.0
2017-07-19 07:57:00	SPY	ETF	245.78	245.78	245.78	245.78	300.0
2017-07-19 07:58:00	SPY	ETF	245.76	245.76	245.76	245.76	200.0
2017-07-19 08:00:00	SPY	ETF	245.8	245.8	245.75	245.75	9314.0
2017-07-19 08:02:00	SPY	ETF	245.76	245.76	245.76	245.76	2300.0
2017-07-19 08:03:00	SPY	ETF	245.76	245.76	245.76	245.76	2300.0
2017-07-19 08:05:00	SPY	ETF	245.78	245.78	245.78	245.78	101.0
2017-07-19 08:07:00	SPY	ETF	245.8	245.82	245.8	245.82	6970.0
2017-07-19 08:08:00	SPY	ETF	245.81	245.81	245.81	245.81	1000.0
2017-07-19 08:10:00	SPY	ETF	245.83	245.83	245.83	245.83	2000.0
2017-07-19 08:16:00	SPY	ETF	245.81	245.84	245.8	245.84	6902.0
2017-07-19 08:17:00	SPY	ETF	245.84	245.85	245.84	245.85	3500.0
2017-07-19 08:18:00	SPY	ETF	245.85	245.85	245.85	245.85	200.0
2017-07-19 08:19:00	SPY	ETF	245.83	245.83	245.82	245.82	1500.0

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

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