PREVIEW / etf_1min / 2012-11-01

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-11-01.parquet
  size:    1.9 MB
  rows:    104,095

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-01 04:00:00	SPY	ETF	141.15	141.15	140.79	140.79	400.0
2012-11-01 04:01:00	SPY	ETF	140.77	140.77	140.77	140.77	100.0
2012-11-01 04:17:00	SPY	ETF	141.02	141.04	141.02	141.04	20910.0
2012-11-01 04:18:00	SPY	ETF	141.05	141.07	141.05	141.07	7650.0
2012-11-01 04:35:00	SPY	ETF	140.93	140.93	140.93	140.93	100.0
2012-11-01 05:08:00	SPY	ETF	140.94	140.94	140.94	140.94	100.0
2012-11-01 05:31:00	SPY	ETF	140.74	140.74	140.74	140.74	100.0
2012-11-01 05:37:00	SPY	ETF	140.83	140.83	140.83	140.83	800.0
2012-11-01 06:10:00	SPY	ETF	140.89	140.89	140.89	140.89	100.0
2012-11-01 06:15:00	SPY	ETF	140.98	140.98	140.98	140.98	500.0
2012-11-01 06:18:00	SPY	ETF	141.01	141.06	141.01	141.06	20880.0
2012-11-01 06:19:00	SPY	ETF	141.06	141.16	141.06	141.16	17999.0
2012-11-01 06:20:00	SPY	ETF	141.14	141.14	141.14	141.14	100.0
2012-11-01 06:22:00	SPY	ETF	141.07	141.07	141.07	141.07	700.0
2012-11-01 06:29:00	SPY	ETF	141.12	141.14	141.09	141.09	19000.0
2012-11-01 06:30:00	SPY	ETF	141.14	141.14	141.14	141.14	1000.0
2012-11-01 06:36:00	SPY	ETF	141.14	141.19	141.14	141.19	8700.0
2012-11-01 06:38:00	SPY	ETF	141.14	141.19	141.14	141.19	3156.0
2012-11-01 06:39:00	SPY	ETF	141.19	141.19	141.19	141.19	15000.0
2012-11-01 06:40:00	SPY	ETF	141.15	141.15	141.15	141.15	100.0
2012-11-01 06:41:00	SPY	ETF	141.12	141.14	141.12	141.14	2400.0
2012-11-01 06:42:00	SPY	ETF	141.12	141.12	141.12	141.12	2400.0
2012-11-01 06:43:00	SPY	ETF	141.12	141.12	141.12	141.12	1000.0
2012-11-01 06:44:00	SPY	ETF	141.15	141.15	141.15	141.15	600.0
2012-11-01 06:45:00	SPY	ETF	141.18	141.19	141.18	141.19	600.0
2012-11-01 06:53:00	SPY	ETF	141.14	141.14	141.14	141.14	100.0
2012-11-01 06:54:00	SPY	ETF	141.14	141.14	141.14	141.14	100.0
2012-11-01 06:59:00	SPY	ETF	141.17	141.17	141.17	141.17	1000.0
2012-11-01 07:00:00	SPY	ETF	141.17	141.19	141.17	141.19	1999.0
2012-11-01 07:01:00	SPY	ETF	141.19	141.19	141.14	141.14	711.0
2012-11-01 07:02:00	SPY	ETF	141.19	141.19	141.19	141.19	500.0
2012-11-01 07:03:00	SPY	ETF	141.24	141.24	141.24	141.24	100.0
2012-11-01 07:04:00	SPY	ETF	141.24	141.25	141.23	141.23	700.0
2012-11-01 07:05:00	SPY	ETF	141.21	141.25	141.21	141.22	7600.0
2012-11-01 07:06:00	SPY	ETF	141.24	141.24	141.24	141.24	100.0
2012-11-01 07:09:00	SPY	ETF	141.16	141.18	141.16	141.18	8500.0
2012-11-01 07:10:00	SPY	ETF	141.15	141.17	141.15	141.17	200.0
2012-11-01 07:11:00	SPY	ETF	141.17	141.17	141.17	141.17	690.0
2012-11-01 07:12:00	SPY	ETF	141.16	141.16	141.16	141.16	100.0
2012-11-01 07:14:00	SPY	ETF	141.16	141.2	141.16	141.2	12100.0
2012-11-01 07:16:00	SPY	ETF	141.19	141.19	141.19	141.19	300.0
2012-11-01 07:17:00	SPY	ETF	141.22	141.22	141.19	141.19	800.0
2012-11-01 07:18:00	SPY	ETF	141.19	141.19	141.16	141.16	505.0
2012-11-01 07:22:00	SPY	ETF	141.14	141.15	141.12	141.12	6280.0
2012-11-01 07:23:00	SPY	ETF	141.14	141.14	141.14	141.14	400.0
2012-11-01 07:24:00	SPY	ETF	141.15	141.15	141.14	141.14	2230.0
2012-11-01 07:27:00	SPY	ETF	141.14	141.14	141.14	141.14	705.0
2012-11-01 07:28:00	SPY	ETF	141.14	141.14	141.14	141.14	695.0
2012-11-01 07:29:00	SPY	ETF	141.16	141.19	141.16	141.19	900.0
2012-11-01 07:31:00	SPY	ETF	141.2	141.2	141.2	141.2	2100.0

> showing 50 of 104,095 rows — these rows as CSV

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