PREVIEW / etf_5min / 2011-05-27

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-05-27.parquet
  size:    794 KB
  rows:    33,980

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.42	133.35	133.42	1900.0
2011-05-27 04:10:00	SPY	ETF	133.47	133.47	133.47	133.47	200.0
2011-05-27 04:20:00	SPY	ETF	133.53	133.53	133.53	133.53	200.0
2011-05-27 04:25:00	SPY	ETF	133.48	133.48	133.47	133.47	400.0
2011-05-27 04:30:00	SPY	ETF	133.43	133.43	133.43	133.43	200.0
2011-05-27 04:50:00	SPY	ETF	133.25	133.25	133.25	133.25	115.0
2011-05-27 04:55:00	SPY	ETF	133.12	133.12	133.12	133.12	200.0
2011-05-27 05:00:00	SPY	ETF	133.18	133.18	133.18	133.18	200.0
2011-05-27 05:10: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.22	133.22	900.0
2011-05-27 05:20:00	SPY	ETF	133.17	133.17	133.17	133.17	100.0
2011-05-27 05:25:00	SPY	ETF	133.03	133.03	133.0	133.02	4600.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.13	133.1	133.11	600.0
2011-05-27 05:40:00	SPY	ETF	133.13	133.17	133.13	133.17	1300.0
2011-05-27 05:50:00	SPY	ETF	133.09	133.1	133.09	133.1	3900.0
2011-05-27 05:55:00	SPY	ETF	133.16	133.16	133.16	133.16	100.0
2011-05-27 06:05:00	SPY	ETF	133.13	133.13	133.13	133.13	100.0
2011-05-27 06:10:00	SPY	ETF	133.16	133.16	133.16	133.16	15000.0
2011-05-27 06:15: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.25	133.25	400.0
2011-05-27 06:35:00	SPY	ETF	133.28	133.33	133.28	133.33	300.0
2011-05-27 06:40:00	SPY	ETF	133.35	133.35	133.35	133.35	150.0
2011-05-27 06:45:00	SPY	ETF	133.33	133.33	133.33	133.33	100.0
2011-05-27 06:55:00	SPY	ETF	133.2	133.2	133.2	133.2	15100.0
2011-05-27 07:00:00	SPY	ETF	133.17	133.17	133.16	133.17	900.0
2011-05-27 07:10:00	SPY	ETF	133.25	133.32	133.25	133.26	8000.0
2011-05-27 07:15:00	SPY	ETF	133.2	133.2	133.2	133.2	847.0
2011-05-27 07:20:00	SPY	ETF	133.25	133.3	133.25	133.3	3200.0
2011-05-27 07:25: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.24	133.24	6400.0
2011-05-27 07:35:00	SPY	ETF	133.22	133.29	133.2	133.25	25500.0
2011-05-27 07:40:00	SPY	ETF	133.25	133.35	133.25	133.35	14700.0
2011-05-27 07:45:00	SPY	ETF	133.35	133.36	133.34	133.34	53300.0
2011-05-27 07:50:00	SPY	ETF	133.34	133.4	133.3	133.36	66800.0
2011-05-27 07:55:00	SPY	ETF	133.36	133.39	133.27	133.27	5450.0
2011-05-27 08:00:00	SPY	ETF	133.55	133.55	133.27	133.3	66799.0
2011-05-27 08:05:00	SPY	ETF	133.3	133.35	133.3	133.32	14729.0
2011-05-27 08:10:00	SPY	ETF	133.35	133.55	133.35	133.38	42989.0
2011-05-27 08:15:00	SPY	ETF	133.38	133.39	133.32	133.39	127340.0
2011-05-27 08:20:00	SPY	ETF	133.37	133.46	133.36	133.41	252341.0
2011-05-27 08:25:00	SPY	ETF	133.42	133.5	133.42	133.45	104212.0
2011-05-27 08:30:00	SPY	ETF	133.45	133.61	133.44	133.54	220919.0
2011-05-27 08:35:00	SPY	ETF	133.54	133.57	133.49	133.5	124647.0
2011-05-27 08:40:00	SPY	ETF	133.49	133.52	133.46	133.49	135428.0
2011-05-27 08:45:00	SPY	ETF	133.49	133.52	133.46	133.46	90380.0
2011-05-27 08:50:00	SPY	ETF	133.47	133.48	133.44	133.44	48750.0
2011-05-27 08:55:00	SPY	ETF	133.45	133.45	133.42	133.44	107042.0
2011-05-27 09:00:00	SPY	ETF	133.44	133.48	133.44	133.46	24044.0

> showing 50 of 33,980 rows — these rows as CSV

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