PREVIEW / etf_1min / 2018-07-26

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-07-26.parquet
  size:    2.8 MB
  rows:    151,313

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-07-26 04:03:00	SPY	ETF	283.02	283.02	283.02	283.02	290.0
2018-07-26 04:14:00	SPY	ETF	283.07	283.07	283.07	283.07	500.0
2018-07-26 04:15:00	SPY	ETF	283.07	283.07	283.07	283.07	100.0
2018-07-26 04:25:00	SPY	ETF	283.0	283.0	283.0	283.0	300.0
2018-07-26 04:27:00	SPY	ETF	282.94	282.95	282.94	282.94	2926.0
2018-07-26 04:31:00	SPY	ETF	283.05	283.05	282.94	282.94	6033.0
2018-07-26 04:32:00	SPY	ETF	282.94	282.94	282.94	282.94	100.0
2018-07-26 04:40:00	SPY	ETF	283.07	283.07	283.07	283.07	250.0
2018-07-26 04:45:00	SPY	ETF	283.03	283.03	283.03	283.03	1700.0
2018-07-26 04:46:00	SPY	ETF	283.06	283.06	283.03	283.03	700.0
2018-07-26 04:47:00	SPY	ETF	283.01	283.01	283.01	283.01	200.0
2018-07-26 04:48:00	SPY	ETF	282.96	282.98	282.96	282.98	1200.0
2018-07-26 04:51:00	SPY	ETF	282.93	282.93	282.89	282.89	1000.0
2018-07-26 04:54:00	SPY	ETF	282.89	282.92	282.89	282.92	800.0
2018-07-26 04:56:00	SPY	ETF	282.94	282.96	282.94	282.96	800.0
2018-07-26 05:02:00	SPY	ETF	282.96	282.98	282.96	282.98	1000.0
2018-07-26 05:05:00	SPY	ETF	282.96	282.96	282.96	282.96	600.0
2018-07-26 05:07:00	SPY	ETF	282.96	282.96	282.96	282.96	400.0
2018-07-26 05:09:00	SPY	ETF	283.03	283.03	283.03	283.03	300.0
2018-07-26 05:11:00	SPY	ETF	283.06	283.06	283.06	283.06	300.0
2018-07-26 05:13:00	SPY	ETF	283.06	283.06	283.06	283.06	400.0
2018-07-26 05:16:00	SPY	ETF	283.08	283.08	283.08	283.08	800.0
2018-07-26 05:19:00	SPY	ETF	283.05	283.05	283.05	283.05	1000.0
2018-07-26 05:20:00	SPY	ETF	283.08	283.08	283.08	283.08	156.0
2018-07-26 05:24:00	SPY	ETF	283.05	283.08	283.0	283.08	2700.0
2018-07-26 05:25:00	SPY	ETF	283.1	283.1	283.1	283.1	300.0
2018-07-26 05:27:00	SPY	ETF	283.04	283.08	283.04	283.08	300.0
2018-07-26 05:28:00	SPY	ETF	283.04	283.08	283.04	283.06	600.0
2018-07-26 05:29:00	SPY	ETF	283.05	283.06	283.05	283.06	920.0
2018-07-26 05:30:00	SPY	ETF	283.16	283.16	283.16	283.16	700.0
2018-07-26 05:31:00	SPY	ETF	283.15	283.16	283.15	283.16	400.0
2018-07-26 05:32:00	SPY	ETF	283.12	283.12	283.12	283.12	100.0
2018-07-26 05:33:00	SPY	ETF	283.1	283.15	283.1	283.15	500.0
2018-07-26 05:35:00	SPY	ETF	283.18	283.18	283.18	283.18	1000.0
2018-07-26 05:36:00	SPY	ETF	283.18	283.18	283.18	283.18	654.0
2018-07-26 05:37:00	SPY	ETF	283.15	283.15	283.15	283.15	300.0
2018-07-26 05:41:00	SPY	ETF	283.2	283.23	283.2	283.23	402.0
2018-07-26 05:42:00	SPY	ETF	283.21	283.21	283.18	283.18	600.0
2018-07-26 05:43:00	SPY	ETF	283.18	283.18	283.13	283.18	4599.0
2018-07-26 05:44:00	SPY	ETF	283.18	283.18	283.18	283.18	700.0
2018-07-26 05:46:00	SPY	ETF	283.08	283.08	283.08	283.08	150.0
2018-07-26 05:47:00	SPY	ETF	283.08	283.08	283.05	283.05	627.0
2018-07-26 05:50:00	SPY	ETF	283.1	283.13	283.1	283.13	300.0
2018-07-26 05:51:00	SPY	ETF	283.08	283.08	283.08	283.08	300.0
2018-07-26 05:52:00	SPY	ETF	283.08	283.1	283.06	283.08	1200.0
2018-07-26 05:53:00	SPY	ETF	283.1	283.1	283.1	283.1	1000.0
2018-07-26 05:54:00	SPY	ETF	283.11	283.11	283.1	283.1	700.0
2018-07-26 05:59:00	SPY	ETF	283.18	283.18	283.18	283.18	300.0
2018-07-26 06:00:00	SPY	ETF	283.15	283.15	283.15	283.15	100.0
2018-07-26 06:02:00	SPY	ETF	283.15	283.15	283.15	283.15	500.0

> showing 50 of 151,313 rows — these rows as CSV

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