PREVIEW / etf_5min / 2011-07-07

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-07-07.parquet
  size:    874 KB
  rows:    37,727

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-07-07 04:00:00	SPY	ETF	134.38	134.38	134.38	134.38	300.0
2011-07-07 04:15:00	SPY	ETF	134.38	134.48	134.38	134.48	1100.0
2011-07-07 04:45:00	SPY	ETF	134.41	134.41	134.41	134.41	100.0
2011-07-07 05:00:00	SPY	ETF	134.45	134.45	134.45	134.45	100.0
2011-07-07 05:05:00	SPY	ETF	134.57	134.57	134.52	134.52	200.0
2011-07-07 05:45:00	SPY	ETF	134.54	134.54	134.5	134.5	200.0
2011-07-07 05:50:00	SPY	ETF	134.45	134.45	134.45	134.45	100.0
2011-07-07 06:00:00	SPY	ETF	134.4	134.4	134.4	134.4	1000.0
2011-07-07 06:05:00	SPY	ETF	134.4	134.4	134.4	134.4	500.0
2011-07-07 06:20:00	SPY	ETF	134.32	134.32	134.32	134.32	1000.0
2011-07-07 06:35:00	SPY	ETF	134.3	134.3	134.3	134.3	100.0
2011-07-07 06:40:00	SPY	ETF	134.39	134.39	134.39	134.39	100.0
2011-07-07 06:45:00	SPY	ETF	134.42	134.42	134.42	134.42	200.0
2011-07-07 06:50:00	SPY	ETF	134.36	134.36	134.36	134.36	200.0
2011-07-07 06:55:00	SPY	ETF	134.36	134.36	134.35	134.35	2500.0
2011-07-07 07:00:00	SPY	ETF	134.42	134.48	134.42	134.48	11200.0
2011-07-07 07:05:00	SPY	ETF	134.45	134.48	134.44	134.44	3800.0
2011-07-07 07:10:00	SPY	ETF	134.47	134.47	134.39	134.39	3500.0
2011-07-07 07:15:00	SPY	ETF	134.43	134.48	134.4	134.44	9500.0
2011-07-07 07:20:00	SPY	ETF	134.43	134.48	134.43	134.48	500.0
2011-07-07 07:25:00	SPY	ETF	134.45	134.52	134.45	134.52	19296.0
2011-07-07 07:30:00	SPY	ETF	134.47	134.49	134.43	134.49	74600.0
2011-07-07 07:35:00	SPY	ETF	134.5	134.52	134.49	134.5	34400.0
2011-07-07 07:40:00	SPY	ETF	134.51	134.55	134.51	134.55	96100.0
2011-07-07 07:45:00	SPY	ETF	134.58	134.6	134.52	134.55	101400.0
2011-07-07 07:50:00	SPY	ETF	134.55	134.57	134.44	134.48	46700.0
2011-07-07 07:55:00	SPY	ETF	134.47	134.51	134.44	134.49	34750.0
2011-07-07 08:00:00	SPY	ETF	134.47	134.49	134.4	134.45	47335.0
2011-07-07 08:05:00	SPY	ETF	134.45	134.479	134.3802	134.43	188687.0
2011-07-07 08:10:00	SPY	ETF	134.43	134.51	134.41	134.44	217276.0
2011-07-07 08:15:00	SPY	ETF	134.46	135.2	134.46	135.14	1874437.0
2011-07-07 08:20:00	SPY	ETF	135.15	135.15	135.03	135.08	560082.0
2011-07-07 08:25:00	SPY	ETF	135.07	135.07	134.95	135.01	354703.0
2011-07-07 08:30:00	SPY	ETF	135.04	135.11	134.96	135.03	301509.0
2011-07-07 08:35:00	SPY	ETF	135.03	135.03	134.9	134.95	336600.0
2011-07-07 08:40:00	SPY	ETF	134.95	135.03	133.95	135.03	642821.0
2011-07-07 08:45:00	SPY	ETF	135.03	135.1	135.01	135.1	346608.0
2011-07-07 08:50:00	SPY	ETF	135.1	135.4	135.03	135.29	861395.0
2011-07-07 08:55:00	SPY	ETF	135.29	135.35	135.24	135.25	457655.0
2011-07-07 09:00:00	SPY	ETF	135.25	135.31	135.2	135.21	396515.0
2011-07-07 09:05:00	SPY	ETF	135.21	135.23	135.17	135.17	122122.0
2011-07-07 09:10:00	SPY	ETF	135.17	135.21	135.14	135.15	205739.0
2011-07-07 09:15:00	SPY	ETF	135.15	135.24	135.13	135.14	226431.0
2011-07-07 09:20:00	SPY	ETF	135.15	135.2	135.12	135.19	389702.0
2011-07-07 09:25:00	SPY	ETF	135.18	135.18	135.11	135.15	288475.0
2011-07-07 09:30:00	SPY	ETF	135.16	135.17	135.03	135.05	4379569.0
2011-07-07 09:35:00	SPY	ETF	135.05	135.1	134.95	135.01	3542042.0
2011-07-07 09:40:00	SPY	ETF	135.0	135.05	134.95	135.03	2465576.0
2011-07-07 09:45:00	SPY	ETF	135.03	135.04	134.88	134.93	2525681.0
2011-07-07 09:50:00	SPY	ETF	134.93	135.12	134.91	135.04	4351255.0

> showing 50 of 37,727 rows — these rows as CSV

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