PREVIEW / etf_1min / 2012-05-23

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-05-23.parquet
  size:    2.3 MB
  rows:    116,028

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-05-23 04:07:00	SPY	ETF	131.67	131.67	131.67	131.67	100.0
2012-05-23 04:20:00	SPY	ETF	131.38	131.38	131.38	131.38	500.0
2012-05-23 04:21:00	SPY	ETF	131.34	131.34	131.34	131.34	100.0
2012-05-23 04:23:00	SPY	ETF	131.3	131.3	131.3	131.3	100.0
2012-05-23 04:26:00	SPY	ETF	131.2	131.2	131.2	131.2	190.0
2012-05-23 04:59:00	SPY	ETF	131.27	131.27	131.27	131.27	260.0
2012-05-23 05:00:00	SPY	ETF	131.24	131.25	131.24	131.25	500.0
2012-05-23 05:11:00	SPY	ETF	131.12	131.12	131.12	131.12	200.0
2012-05-23 05:14:00	SPY	ETF	131.26	131.26	131.26	131.26	200.0
2012-05-23 05:20:00	SPY	ETF	131.19	131.19	131.19	131.19	100.0
2012-05-23 05:23:00	SPY	ETF	131.21	131.22	131.21	131.21	20400.0
2012-05-23 05:24:00	SPY	ETF	131.13	131.13	131.13	131.13	200.0
2012-05-23 05:25:00	SPY	ETF	131.16	131.16	131.16	131.16	500.0
2012-05-23 05:28:00	SPY	ETF	131.1	131.1	131.1	131.1	100.0
2012-05-23 05:44:00	SPY	ETF	131.21	131.21	131.21	131.21	400.0
2012-05-23 05:48:00	SPY	ETF	131.16	131.17	131.16	131.17	1200.0
2012-05-23 05:49:00	SPY	ETF	131.17	131.17	131.17	131.17	200.0
2012-05-23 05:51:00	SPY	ETF	131.19	131.19	131.15	131.15	10100.0
2012-05-23 05:54:00	SPY	ETF	131.13	131.13	131.13	131.13	200.0
2012-05-23 06:00:00	SPY	ETF	131.07	131.08	131.07	131.08	300.0
2012-05-23 06:01:00	SPY	ETF	131.07	131.07	131.07	131.07	100.0
2012-05-23 06:05:00	SPY	ETF	131.06	131.07	131.06	131.07	3000.0
2012-05-23 06:08:00	SPY	ETF	131.05	131.05	131.05	131.05	1000.0
2012-05-23 06:09:00	SPY	ETF	131.04	131.04	131.0	131.0	3923.0
2012-05-23 06:10:00	SPY	ETF	131.03	131.03	131.03	131.03	242.0
2012-05-23 06:12:00	SPY	ETF	131.08	131.16	131.08	131.12	77242.0
2012-05-23 06:13:00	SPY	ETF	131.12	131.16	131.12	131.14	5858.0
2012-05-23 06:15:00	SPY	ETF	131.16	131.16	131.16	131.16	1000.0
2012-05-23 06:21:00	SPY	ETF	131.16	131.16	131.14	131.14	900.0
2012-05-23 06:22:00	SPY	ETF	131.1	131.1	131.1	131.1	100.0
2012-05-23 06:25:00	SPY	ETF	131.11	131.11	131.11	131.11	1000.0
2012-05-23 06:33:00	SPY	ETF	131.05	131.06	131.05	131.06	1100.0
2012-05-23 06:34:00	SPY	ETF	131.06	131.06	131.02	131.02	8120.0
2012-05-23 06:35:00	SPY	ETF	131.0	131.0	130.99	130.99	6090.0
2012-05-23 06:36:00	SPY	ETF	131.03	131.04	131.03	131.04	10000.0
2012-05-23 06:39:00	SPY	ETF	131.01	131.04	131.01	131.04	200.0
2012-05-23 06:40:00	SPY	ETF	131.02	131.02	131.02	131.02	100.0
2012-05-23 06:41:00	SPY	ETF	130.97	130.97	130.97	130.97	100.0
2012-05-23 06:42:00	SPY	ETF	131.01	131.01	131.01	131.01	5000.0
2012-05-23 06:43:00	SPY	ETF	131.07	131.09	131.05	131.06	21550.0
2012-05-23 06:44:00	SPY	ETF	131.09	131.09	131.08	131.08	1450.0
2012-05-23 06:45:00	SPY	ETF	131.09	131.09	131.09	131.09	100.0
2012-05-23 06:47:00	SPY	ETF	131.01	131.01	131.01	131.01	100.0
2012-05-23 06:48:00	SPY	ETF	131.06	131.06	131.06	131.06	25000.0
2012-05-23 06:49:00	SPY	ETF	131.06	131.06	131.06	131.06	5000.0
2012-05-23 06:50:00	SPY	ETF	131.04	131.06	131.04	131.06	5100.0
2012-05-23 06:51:00	SPY	ETF	131.08	131.09	131.08	131.09	5000.0
2012-05-23 06:52:00	SPY	ETF	131.13	131.14	131.12	131.12	11200.0
2012-05-23 06:55:00	SPY	ETF	131.18	131.18	131.18	131.18	100.0
2012-05-23 06:57:00	SPY	ETF	131.17	131.17	131.17	131.17	4800.0

> showing 50 of 116,028 rows — these rows as CSV

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