PREVIEW / etf_1min / 2012-11-28

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-11-28.parquet
  size:    2.0 MB
  rows:    101,595

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
2012-11-28 04:18:00	SPY	ETF	140.26	140.26	140.26	140.26	250.0
2012-11-28 04:22:00	SPY	ETF	140.16	140.16	140.16	140.16	1000.0
2012-11-28 04:25:00	SPY	ETF	140.12	140.12	140.12	140.12	4987.0
2012-11-28 04:56:00	SPY	ETF	140.13	140.13	140.13	140.13	200.0
2012-11-28 05:07:00	SPY	ETF	140.11	140.11	140.11	140.11	18000.0
2012-11-28 05:27:00	SPY	ETF	140.26	140.26	140.26	140.26	10500.0
2012-11-28 05:29:00	SPY	ETF	140.26	140.26	140.26	140.26	9000.0
2012-11-28 05:30:00	SPY	ETF	140.24	140.24	140.24	140.24	500.0
2012-11-28 05:31:00	SPY	ETF	140.21	140.21	140.21	140.21	9000.0
2012-11-28 05:32:00	SPY	ETF	140.21	140.21	140.21	140.21	9000.0
2012-11-28 05:33:00	SPY	ETF	140.2	140.2	140.2	140.2	100.0
2012-11-28 05:34:00	SPY	ETF	140.2	140.2	140.2	140.2	2400.0
2012-11-28 05:55:00	SPY	ETF	140.24	140.24	140.24	140.24	100.0
2012-11-28 06:05:00	SPY	ETF	140.13	140.13	140.13	140.13	400.0
2012-11-28 06:09:00	SPY	ETF	140.16	140.16	140.16	140.16	500.0
2012-11-28 06:20:00	SPY	ETF	140.17	140.17	140.17	140.17	2500.0
2012-11-28 06:33:00	SPY	ETF	140.13	140.13	140.13	140.13	1200.0
2012-11-28 06:39:00	SPY	ETF	140.11	140.11	140.09	140.09	1000.0
2012-11-28 06:46:00	SPY	ETF	140.08	140.08	140.07	140.07	10000.0
2012-11-28 06:52:00	SPY	ETF	140.11	140.12	140.1	140.1	10900.0
2012-11-28 06:54:00	SPY	ETF	140.05	140.05	140.05	140.05	2450.0
2012-11-28 06:55:00	SPY	ETF	140.09	140.09	140.09	140.09	200.0
2012-11-28 06:57:00	SPY	ETF	140.09	140.11	140.05	140.05	245000.0
2012-11-28 06:58:00	SPY	ETF	140.05	140.05	139.96	139.96	19200.0
2012-11-28 06:59:00	SPY	ETF	139.96	139.96	139.91	139.91	2400.0
2012-11-28 07:00:00	SPY	ETF	139.91	139.93	139.91	139.93	900.0
2012-11-28 07:01:00	SPY	ETF	139.91	139.91	139.89	139.9	49300.0
2012-11-28 07:02:00	SPY	ETF	139.9	139.99	139.9	139.98	18186.0
2012-11-28 07:03:00	SPY	ETF	139.99	139.99	139.97	139.98	12000.0
2012-11-28 07:04:00	SPY	ETF	139.98	139.98	139.97	139.98	1900.0
2012-11-28 07:05:00	SPY	ETF	139.99	139.99	139.99	139.99	800.0
2012-11-28 07:06:00	SPY	ETF	139.99	139.99	139.99	139.99	150.0
2012-11-28 07:07:00	SPY	ETF	139.99	139.99	139.98	139.98	10350.0
2012-11-28 07:08:00	SPY	ETF	139.98	140.0	139.98	140.0	8900.0
2012-11-28 07:11:00	SPY	ETF	139.99	140.0	139.99	140.0	1000.0
2012-11-28 07:12:00	SPY	ETF	139.98	140.02	139.98	140.02	6500.0
2012-11-28 07:13:00	SPY	ETF	140.01	140.01	140.0	140.0	5400.0
2012-11-28 07:15:00	SPY	ETF	140.02	140.03	140.02	140.03	200.0
2012-11-28 07:16:00	SPY	ETF	140.03	140.03	140.03	140.03	100.0
2012-11-28 07:17:00	SPY	ETF	140.03	140.04	140.03	140.04	5000.0
2012-11-28 07:18:00	SPY	ETF	140.05	140.05	140.05	140.05	100.0
2012-11-28 07:19:00	SPY	ETF	140.05	140.05	140.05	140.05	100.0
2012-11-28 07:20:00	SPY	ETF	140.04	140.04	140.04	140.04	400.0
2012-11-28 07:21:00	SPY	ETF	140.05	140.07	140.05	140.07	3065.0
2012-11-28 07:22:00	SPY	ETF	140.08	140.08	140.08	140.08	2135.0
2012-11-28 07:23:00	SPY	ETF	140.05	140.05	140.01	140.01	2200.0
2012-11-28 07:24:00	SPY	ETF	140.02	140.07	140.02	140.07	3500.0
2012-11-28 07:25:00	SPY	ETF	140.05	140.06	140.04	140.05	115600.0
2012-11-28 07:26:00	SPY	ETF	140.05	140.05	140.04	140.05	30000.0
2012-11-28 07:27:00	SPY	ETF	140.04	140.05	140.02	140.02	76000.0

> showing 50 of 101,595 rows — these rows as CSV

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