PREVIEW / etf_1min / 2012-09-20

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-09-20.parquet
  size:    1.9 MB
  rows:    100,582

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-09-20 04:00:00	SPY	ETF	146.19	146.19	146.0	146.0	2800.0
2012-09-20 04:01:00	SPY	ETF	146.0	146.0	146.0	146.0	316.0
2012-09-20 04:30:00	SPY	ETF	146.19	146.19	146.19	146.19	100.0
2012-09-20 04:32:00	SPY	ETF	146.15	146.15	146.15	146.15	200.0
2012-09-20 04:50:00	SPY	ETF	146.12	146.12	146.12	146.12	100.0
2012-09-20 04:53:00	SPY	ETF	146.14	146.14	146.14	146.14	100.0
2012-09-20 05:01:00	SPY	ETF	146.15	146.15	146.15	146.15	1120.0
2012-09-20 05:02:00	SPY	ETF	146.07	146.07	146.07	146.07	100.0
2012-09-20 05:10:00	SPY	ETF	146.03	146.03	146.03	146.03	100.0
2012-09-20 05:15:00	SPY	ETF	146.03	146.03	146.01	146.01	10200.0
2012-09-20 05:20:00	SPY	ETF	145.98	145.99	145.98	145.99	15000.0
2012-09-20 05:25:00	SPY	ETF	146.03	146.03	146.03	146.03	5000.0
2012-09-20 05:35:00	SPY	ETF	146.09	146.1	146.09	146.1	500.0
2012-09-20 05:41:00	SPY	ETF	146.15	146.15	146.15	146.15	500.0
2012-09-20 05:42:00	SPY	ETF	146.15	146.15	146.15	146.15	2000.0
2012-09-20 05:44:00	SPY	ETF	146.15	146.15	146.15	146.15	1000.0
2012-09-20 06:04:00	SPY	ETF	146.15	146.15	146.15	146.15	5000.0
2012-09-20 06:11:00	SPY	ETF	146.14	146.14	146.14	146.14	7000.0
2012-09-20 06:14:00	SPY	ETF	146.15	146.15	146.15	146.15	1400.0
2012-09-20 06:15:00	SPY	ETF	146.15	146.2	146.15	146.2	600.0
2012-09-20 06:16:00	SPY	ETF	146.18	146.18	146.16	146.16	8000.0
2012-09-20 06:24:00	SPY	ETF	146.15	146.15	146.15	146.15	100.0
2012-09-20 06:26:00	SPY	ETF	146.17	146.17	146.17	146.17	3000.0
2012-09-20 06:27:00	SPY	ETF	146.18	146.18	146.18	146.18	1000.0
2012-09-20 06:31:00	SPY	ETF	146.21	146.21	146.2	146.2	3100.0
2012-09-20 06:33:00	SPY	ETF	146.21	146.23	146.21	146.23	2300.0
2012-09-20 06:34:00	SPY	ETF	146.25	146.25	146.23	146.23	5400.0
2012-09-20 06:35:00	SPY	ETF	146.25	146.25	146.25	146.25	2750.0
2012-09-20 06:38:00	SPY	ETF	146.23	146.23	146.21	146.21	6200.0
2012-09-20 06:39:00	SPY	ETF	146.25	146.25	146.25	146.25	2500.0
2012-09-20 06:40:00	SPY	ETF	146.23	146.23	146.23	146.23	1300.0
2012-09-20 06:43:00	SPY	ETF	146.21	146.21	146.21	146.21	500.0
2012-09-20 06:44:00	SPY	ETF	146.21	146.22	146.21	146.21	3200.0
2012-09-20 06:48:00	SPY	ETF	146.19	146.19	146.19	146.19	500.0
2012-09-20 06:50:00	SPY	ETF	146.19	146.19	146.18	146.19	23889.0
2012-09-20 06:52:00	SPY	ETF	146.18	146.18	146.18	146.18	1000.0
2012-09-20 06:58:00	SPY	ETF	146.2	146.2	146.2	146.2	700.0
2012-09-20 06:59:00	SPY	ETF	146.19	146.19	146.19	146.19	400.0
2012-09-20 07:00:00	SPY	ETF	146.17	146.19	146.17	146.19	800.0
2012-09-20 07:01:00	SPY	ETF	146.18	146.19	146.18	146.18	9900.0
2012-09-20 07:02:00	SPY	ETF	146.19	146.19	146.18	146.19	40000.0
2012-09-20 07:03:00	SPY	ETF	146.19	146.19	146.19	146.19	400.0
2012-09-20 07:05:00	SPY	ETF	146.19	146.19	146.19	146.19	125.0
2012-09-20 07:09:00	SPY	ETF	146.23	146.23	146.22	146.22	6000.0
2012-09-20 07:10:00	SPY	ETF	146.22	146.22	146.22	146.22	1900.0
2012-09-20 07:11:00	SPY	ETF	146.22	146.22	146.22	146.22	100.0
2012-09-20 07:12:00	SPY	ETF	146.25	146.25	146.23	146.23	400.0
2012-09-20 07:13:00	SPY	ETF	146.22	146.26	146.22	146.26	13675.0
2012-09-20 07:14:00	SPY	ETF	146.28	146.28	146.24	146.27	10100.0
2012-09-20 07:15:00	SPY	ETF	146.24	146.25	146.24	146.25	1100.0

> showing 50 of 100,582 rows — these rows as CSV

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