PREVIEW / etf_1min / 2013-02-01

all etf 1-min files

  file:    by_date/etf_1min/2013/2013-02-01.parquet
  size:    2.2 MB
  rows:    117,471

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
2013-02-01 04:07:00	SPY	ETF	150.3	150.3	150.3	150.3	100.0
2013-02-01 04:26:00	SPY	ETF	150.3	150.3	150.3	150.3	100.0
2013-02-01 04:35:00	SPY	ETF	150.3	150.3	150.3	150.3	399.0
2013-02-01 04:36:00	SPY	ETF	150.27	150.27	150.27	150.27	1200.0
2013-02-01 04:45:00	SPY	ETF	150.28	150.28	150.28	150.28	300.0
2013-02-01 04:47:00	SPY	ETF	150.27	150.27	150.27	150.27	400.0
2013-02-01 05:03:00	SPY	ETF	150.3	150.3	150.3	150.3	800.0
2013-02-01 05:04:00	SPY	ETF	150.32	150.32	150.32	150.32	800.0
2013-02-01 05:10:00	SPY	ETF	150.3	150.3	150.3	150.3	100.0
2013-02-01 05:12:00	SPY	ETF	150.29	150.29	150.29	150.29	300.0
2013-02-01 05:14:00	SPY	ETF	150.29	150.29	150.29	150.29	1500.0
2013-02-01 05:18:00	SPY	ETF	150.34	150.34	150.34	150.34	800.0
2013-02-01 05:19:00	SPY	ETF	150.32	150.32	150.32	150.32	800.0
2013-02-01 05:25:00	SPY	ETF	150.34	150.34	150.34	150.34	300.0
2013-02-01 05:33:00	SPY	ETF	150.32	150.32	150.32	150.32	400.0
2013-02-01 05:36:00	SPY	ETF	150.25	150.25	150.25	150.25	500.0
2013-02-01 05:37:00	SPY	ETF	150.27	150.27	150.27	150.27	400.0
2013-02-01 05:46:00	SPY	ETF	150.25	150.25	150.25	150.25	500.0
2013-02-01 05:47:00	SPY	ETF	150.25	150.25	150.25	150.25	1500.0
2013-02-01 05:49:00	SPY	ETF	150.24	150.24	150.24	150.24	300.0
2013-02-01 05:51:00	SPY	ETF	150.24	150.24	150.24	150.24	13400.0
2013-02-01 05:54:00	SPY	ETF	150.24	150.24	150.24	150.24	300.0
2013-02-01 05:55:00	SPY	ETF	150.24	150.24	150.24	150.24	273.0
2013-02-01 05:59:00	SPY	ETF	150.21	150.22	150.21	150.22	1500.0
2013-02-01 06:01:00	SPY	ETF	150.13	150.14	150.13	150.14	2500.0
2013-02-01 06:02:00	SPY	ETF	150.14	150.14	149.99	149.99	8853.0
2013-02-01 06:03:00	SPY	ETF	150.09	150.09	150.07	150.07	400.0
2013-02-01 06:04:00	SPY	ETF	150.1	150.1	150.1	150.1	3000.0
2013-02-01 06:06:00	SPY	ETF	150.06	150.06	150.06	150.06	100.0
2013-02-01 06:10:00	SPY	ETF	150.02	150.02	150.02	150.02	100.0
2013-02-01 06:11:00	SPY	ETF	150.04	150.04	150.04	150.04	100.0
2013-02-01 06:15:00	SPY	ETF	150.04	150.04	150.04	150.04	200.0
2013-02-01 06:18:00	SPY	ETF	150.04	150.04	150.04	150.04	500.0
2013-02-01 06:20:00	SPY	ETF	150.06	150.06	150.06	150.06	100.0
2013-02-01 06:21:00	SPY	ETF	150.05	150.05	150.04	150.04	4200.0
2013-02-01 06:26:00	SPY	ETF	150.04	150.07	150.04	150.07	4200.0
2013-02-01 06:40:00	SPY	ETF	150.16	150.16	150.14	150.14	18410.0
2013-02-01 06:47:00	SPY	ETF	150.14	150.14	150.14	150.14	100.0
2013-02-01 06:53:00	SPY	ETF	150.11	150.11	150.11	150.11	8000.0
2013-02-01 06:57:00	SPY	ETF	150.12	150.12	150.12	150.12	5000.0
2013-02-01 07:00:00	SPY	ETF	150.09	150.09	150.09	150.09	1000.0
2013-02-01 07:01:00	SPY	ETF	150.09	150.09	150.09	150.09	1000.0
2013-02-01 07:02:00	SPY	ETF	150.09	150.09	150.09	150.09	100.0
2013-02-01 07:04:00	SPY	ETF	150.12	150.12	150.11	150.11	8149.0
2013-02-01 07:06:00	SPY	ETF	150.14	150.14	150.14	150.14	100.0
2013-02-01 07:08:00	SPY	ETF	150.14	150.14	150.1	150.1	1500.0
2013-02-01 07:09:00	SPY	ETF	150.1	150.1	150.1	150.1	100.0
2013-02-01 07:14:00	SPY	ETF	150.12	150.12	150.12	150.12	200.0
2013-02-01 07:15:00	SPY	ETF	150.1	150.1	150.09	150.09	25000.0
2013-02-01 07:16:00	SPY	ETF	150.1	150.1	150.09	150.1	14800.0

> showing 50 of 117,471 rows — these rows as CSV

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