PREVIEW / etf_1min / 2014-02-24

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-02-24.parquet
  size:    2.3 MB
  rows:    120,691

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
2014-02-24 04:00:00	SPY	ETF	184.0	184.17	184.0	184.17	1158.0
2014-02-24 04:01:00	SPY	ETF	184.18	184.19	184.18	184.19	958.0
2014-02-24 04:02:00	SPY	ETF	184.18	184.18	184.18	184.18	100.0
2014-02-24 04:05:00	SPY	ETF	184.16	184.16	184.16	184.16	129.0
2014-02-24 04:12:00	SPY	ETF	184.2	184.23	184.2	184.23	200.0
2014-02-24 04:14:00	SPY	ETF	184.28	184.28	184.28	184.28	200.0
2014-02-24 04:19:00	SPY	ETF	184.34	184.35	184.34	184.35	200.0
2014-02-24 04:20:00	SPY	ETF	184.36	184.4	184.36	184.4	1418.0
2014-02-24 04:37:00	SPY	ETF	184.28	184.28	184.28	184.28	587.0
2014-02-24 04:45:00	SPY	ETF	184.3	184.3	184.3	184.3	500.0
2014-02-24 04:49:00	SPY	ETF	184.31	184.31	184.28	184.28	1026.0
2014-02-24 04:58:00	SPY	ETF	184.17	184.17	184.15	184.15	2200.0
2014-02-24 04:59:00	SPY	ETF	184.19	184.19	184.19	184.19	100.0
2014-02-24 05:00:00	SPY	ETF	184.15	184.15	184.14	184.14	1500.0
2014-02-24 05:01:00	SPY	ETF	184.11	184.11	184.11	184.11	100.0
2014-02-24 05:03:00	SPY	ETF	184.04	184.04	184.04	184.04	100.0
2014-02-24 05:06:00	SPY	ETF	183.98	183.98	183.98	183.98	1000.0
2014-02-24 05:08:00	SPY	ETF	184.0	184.0	184.0	184.0	600.0
2014-02-24 05:09:00	SPY	ETF	183.95	183.95	183.95	183.95	1200.0
2014-02-24 05:12:00	SPY	ETF	184.02	184.02	184.02	184.02	100.0
2014-02-24 05:15:00	SPY	ETF	183.97	183.97	183.97	183.97	5000.0
2014-02-24 05:17:00	SPY	ETF	183.97	184.04	183.97	184.04	2111.0
2014-02-24 05:23:00	SPY	ETF	184.02	184.02	184.02	184.02	200.0
2014-02-24 05:26:00	SPY	ETF	183.98	183.98	183.98	183.98	202.0
2014-02-24 05:27:00	SPY	ETF	184.0	184.02	184.0	184.02	15540.0
2014-02-24 05:31:00	SPY	ETF	184.0	184.0	184.0	184.0	20500.0
2014-02-24 05:34:00	SPY	ETF	184.04	184.04	184.04	184.04	2000.0
2014-02-24 05:51:00	SPY	ETF	184.05	184.05	184.05	184.05	100.0
2014-02-24 05:52:00	SPY	ETF	184.0	184.0	184.0	184.0	100.0
2014-02-24 05:54:00	SPY	ETF	184.04	184.04	184.04	184.04	200.0
2014-02-24 05:57:00	SPY	ETF	183.98	183.98	183.98	183.98	500.0
2014-02-24 06:02:00	SPY	ETF	183.98	183.98	183.98	183.98	2800.0
2014-02-24 06:03:00	SPY	ETF	184.03	184.03	184.03	184.03	1100.0
2014-02-24 06:04:00	SPY	ETF	184.0	184.0	184.0	184.0	400.0
2014-02-24 06:06:00	SPY	ETF	184.01	184.01	184.01	184.01	500.0
2014-02-24 06:08:00	SPY	ETF	183.98	183.98	183.98	183.98	191.0
2014-02-24 06:10:00	SPY	ETF	184.01	184.01	184.01	184.01	289.0
2014-02-24 06:15:00	SPY	ETF	184.0	184.0	184.0	184.0	500.0
2014-02-24 06:18:00	SPY	ETF	184.03	184.03	184.03	184.03	300.0
2014-02-24 06:20:00	SPY	ETF	184.03	184.03	184.03	184.03	1040.0
2014-02-24 06:21:00	SPY	ETF	184.06	184.06	184.06	184.06	100.0
2014-02-24 06:24:00	SPY	ETF	184.08	184.08	184.08	184.08	500.0
2014-02-24 06:25:00	SPY	ETF	184.09	184.09	184.09	184.09	15000.0
2014-02-24 06:28:00	SPY	ETF	184.07	184.07	184.06	184.06	468.0
2014-02-24 06:32:00	SPY	ETF	184.06	184.06	184.06	184.06	200.0
2014-02-24 06:35:00	SPY	ETF	184.1	184.1	184.1	184.1	250.0
2014-02-24 06:37:00	SPY	ETF	184.1	184.11	184.1	184.11	1500.0
2014-02-24 06:38:00	SPY	ETF	184.13	184.13	184.13	184.13	500.0
2014-02-24 06:42:00	SPY	ETF	184.16	184.16	184.16	184.16	600.0
2014-02-24 06:43:00	SPY	ETF	184.18	184.18	184.18	184.18	1010.0

> showing 50 of 120,691 rows — these rows as CSV

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