PREVIEW / etf_1min / 2011-05-27

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-05-27.parquet
  size:    1.7 MB
  rows:    95,298

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
2011-05-27 04:00:00	SPY	ETF	133.35	133.4	133.35	133.4	300.0
2011-05-27 04:03:00	SPY	ETF	133.39	133.42	133.39	133.42	1600.0
2011-05-27 04:12:00	SPY	ETF	133.47	133.47	133.47	133.47	200.0
2011-05-27 04:23:00	SPY	ETF	133.53	133.53	133.53	133.53	200.0
2011-05-27 04:26:00	SPY	ETF	133.48	133.48	133.47	133.47	400.0
2011-05-27 04:32:00	SPY	ETF	133.43	133.43	133.43	133.43	200.0
2011-05-27 04:53:00	SPY	ETF	133.25	133.25	133.25	133.25	115.0
2011-05-27 04:59:00	SPY	ETF	133.12	133.12	133.12	133.12	200.0
2011-05-27 05:04:00	SPY	ETF	133.18	133.18	133.18	133.18	200.0
2011-05-27 05:14:00	SPY	ETF	133.24	133.24	133.24	133.24	1200.0
2011-05-27 05:15:00	SPY	ETF	133.24	133.24	133.24	133.24	800.0
2011-05-27 05:16:00	SPY	ETF	133.22	133.22	133.22	133.22	100.0
2011-05-27 05:24:00	SPY	ETF	133.17	133.17	133.17	133.17	100.0
2011-05-27 05:26:00	SPY	ETF	133.03	133.03	133.03	133.03	100.0
2011-05-27 05:27:00	SPY	ETF	133.03	133.03	133.0	133.0	1900.0
2011-05-27 05:29:00	SPY	ETF	133.01	133.02	133.0	133.02	2600.0
2011-05-27 05:30:00	SPY	ETF	133.0	133.0	133.0	133.0	600.0
2011-05-27 05:35:00	SPY	ETF	133.1	133.1	133.1	133.1	200.0
2011-05-27 05:38:00	SPY	ETF	133.13	133.13	133.13	133.13	200.0
2011-05-27 05:39:00	SPY	ETF	133.12	133.12	133.11	133.11	200.0
2011-05-27 05:40:00	SPY	ETF	133.13	133.17	133.13	133.17	800.0
2011-05-27 05:43:00	SPY	ETF	133.17	133.17	133.17	133.17	500.0
2011-05-27 05:50:00	SPY	ETF	133.09	133.09	133.09	133.09	1900.0
2011-05-27 05:54:00	SPY	ETF	133.1	133.1	133.1	133.1	2000.0
2011-05-27 05:58:00	SPY	ETF	133.16	133.16	133.16	133.16	100.0
2011-05-27 06:09:00	SPY	ETF	133.13	133.13	133.13	133.13	100.0
2011-05-27 06:14:00	SPY	ETF	133.16	133.16	133.16	133.16	15000.0
2011-05-27 06:16:00	SPY	ETF	133.17	133.17	133.17	133.17	100.0
2011-05-27 06:25:00	SPY	ETF	133.18	133.23	133.18	133.23	400.0
2011-05-27 06:30:00	SPY	ETF	133.3	133.31	133.3	133.31	200.0
2011-05-27 06:33:00	SPY	ETF	133.27	133.27	133.25	133.25	200.0
2011-05-27 06:35:00	SPY	ETF	133.28	133.28	133.28	133.28	100.0
2011-05-27 06:37:00	SPY	ETF	133.3	133.33	133.3	133.33	200.0
2011-05-27 06:40:00	SPY	ETF	133.35	133.35	133.35	133.35	150.0
2011-05-27 06:46:00	SPY	ETF	133.33	133.33	133.33	133.33	100.0
2011-05-27 06:57:00	SPY	ETF	133.2	133.2	133.2	133.2	15000.0
2011-05-27 06:59:00	SPY	ETF	133.2	133.2	133.2	133.2	100.0
2011-05-27 07:00:00	SPY	ETF	133.17	133.17	133.16	133.17	500.0
2011-05-27 07:02:00	SPY	ETF	133.17	133.17	133.17	133.17	100.0
2011-05-27 07:03:00	SPY	ETF	133.17	133.17	133.17	133.17	300.0
2011-05-27 07:10:00	SPY	ETF	133.25	133.32	133.25	133.32	6700.0
2011-05-27 07:11:00	SPY	ETF	133.28	133.28	133.28	133.28	200.0
2011-05-27 07:13:00	SPY	ETF	133.28	133.28	133.28	133.28	1000.0
2011-05-27 07:14:00	SPY	ETF	133.26	133.26	133.26	133.26	100.0
2011-05-27 07:17:00	SPY	ETF	133.2	133.2	133.2	133.2	847.0
2011-05-27 07:20:00	SPY	ETF	133.25	133.26	133.25	133.26	3000.0
2011-05-27 07:23:00	SPY	ETF	133.28	133.28	133.28	133.28	100.0
2011-05-27 07:24:00	SPY	ETF	133.3	133.3	133.3	133.3	100.0
2011-05-27 07:27:00	SPY	ETF	133.26	133.26	133.26	133.26	3100.0
2011-05-27 07:30:00	SPY	ETF	133.28	133.29	133.28	133.29	1900.0

> showing 50 of 95,298 rows — these rows as CSV

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