PREVIEW / etf_1min / 2014-07-01

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-01.parquet
  size:    2.2 MB
  rows:    119,518

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-07-01 04:00:00	SPY	ETF	196.08	196.08	196.08	196.08	25000.0
2014-07-01 04:06:00	SPY	ETF	196.08	196.08	196.08	196.08	3850.0
2014-07-01 04:07:00	SPY	ETF	196.09	196.09	196.09	196.09	491.0
2014-07-01 04:13:00	SPY	ETF	196.05	196.05	196.05	196.05	100.0
2014-07-01 04:31:00	SPY	ETF	196.1	196.1	196.1	196.1	100.0
2014-07-01 04:36:00	SPY	ETF	196.17	196.17	196.17	196.17	234.0
2014-07-01 05:00:00	SPY	ETF	196.14	196.16	196.14	196.16	1247.0
2014-07-01 05:35:00	SPY	ETF	196.05	196.05	196.05	196.05	1000.0
2014-07-01 05:36:00	SPY	ETF	196.06	196.06	196.06	196.06	200.0
2014-07-01 05:41:00	SPY	ETF	196.1	196.13	196.1	196.13	600.0
2014-07-01 05:47:00	SPY	ETF	196.07	196.07	196.07	196.07	135.0
2014-07-01 05:49:00	SPY	ETF	196.13	196.13	196.13	196.13	140.0
2014-07-01 05:53:00	SPY	ETF	196.13	196.13	196.13	196.13	300.0
2014-07-01 06:01:00	SPY	ETF	196.13	196.14	196.13	196.14	447.0
2014-07-01 06:03:00	SPY	ETF	196.14	196.14	196.14	196.14	303.0
2014-07-01 06:15:00	SPY	ETF	196.16	196.16	196.16	196.16	200.0
2014-07-01 06:17:00	SPY	ETF	196.18	196.18	196.18	196.18	300.0
2014-07-01 06:19:00	SPY	ETF	196.16	196.16	196.16	196.16	4100.0
2014-07-01 06:22:00	SPY	ETF	196.17	196.2	196.17	196.2	1100.0
2014-07-01 06:24:00	SPY	ETF	196.19	196.19	196.19	196.19	500.0
2014-07-01 06:29:00	SPY	ETF	196.22	196.22	196.22	196.22	201.0
2014-07-01 06:31:00	SPY	ETF	196.25	196.25	196.25	196.25	550.0
2014-07-01 06:33:00	SPY	ETF	196.22	196.22	196.22	196.22	100.0
2014-07-01 06:35:00	SPY	ETF	196.19	196.19	196.19	196.19	100.0
2014-07-01 06:36:00	SPY	ETF	196.2	196.21	196.18	196.21	1000.0
2014-07-01 06:37:00	SPY	ETF	196.2	196.2	196.2	196.2	200.0
2014-07-01 06:42:00	SPY	ETF	196.2	196.2	196.18	196.18	600.0
2014-07-01 06:43:00	SPY	ETF	196.17	196.17	196.17	196.17	100.0
2014-07-01 06:44:00	SPY	ETF	196.18	196.18	196.17	196.17	200.0
2014-07-01 06:53:00	SPY	ETF	196.18	196.18	196.18	196.18	1200.0
2014-07-01 06:54:00	SPY	ETF	196.15	196.15	196.14	196.14	200.0
2014-07-01 06:55:00	SPY	ETF	196.15	196.15	196.15	196.15	100.0
2014-07-01 07:03:00	SPY	ETF	196.16	196.16	196.15	196.15	3000.0
2014-07-01 07:07:00	SPY	ETF	196.18	196.25	196.18	196.18	35800.0
2014-07-01 07:09:00	SPY	ETF	196.18	196.18	196.18	196.18	1600.0
2014-07-01 07:10:00	SPY	ETF	196.19	196.21	196.19	196.21	5400.0
2014-07-01 07:11:00	SPY	ETF	196.22	196.25	196.22	196.22	3200.0
2014-07-01 07:12:00	SPY	ETF	196.22	196.22	196.21	196.21	2200.0
2014-07-01 07:13:00	SPY	ETF	196.21	196.22	196.21	196.21	21125.0
2014-07-01 07:14:00	SPY	ETF	196.22	196.22	196.21	196.21	648.0
2014-07-01 07:17:00	SPY	ETF	196.21	196.21	196.21	196.21	5465.0
2014-07-01 07:18:00	SPY	ETF	196.21	196.23	196.2	196.23	1200.0
2014-07-01 07:19:00	SPY	ETF	196.18	196.21	196.18	196.21	311.0
2014-07-01 07:20:00	SPY	ETF	196.21	196.21	196.21	196.21	100.0
2014-07-01 07:22:00	SPY	ETF	196.21	196.21	196.21	196.21	200.0
2014-07-01 07:23:00	SPY	ETF	196.22	196.23	196.21	196.23	720.0
2014-07-01 07:25:00	SPY	ETF	196.22	196.22	196.22	196.22	100.0
2014-07-01 07:26:00	SPY	ETF	196.19	196.21	196.16	196.21	25200.0
2014-07-01 07:28:00	SPY	ETF	196.21	196.22	196.21	196.22	400.0
2014-07-01 07:29:00	SPY	ETF	196.23	196.24	196.23	196.24	2100.0

> showing 50 of 119,518 rows — these rows as CSV

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