PREVIEW / etf_5min / 2011-07-19

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-07-19.parquet
  size:    883 KB
  rows:    36,748

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-19 04:00:00	SPY	ETF	131.21	131.25	131.21	131.21	2500.0
2011-07-19 04:05:00	SPY	ETF	131.25	131.25	131.2	131.2	200.0
2011-07-19 04:30:00	SPY	ETF	131.3	131.3	131.25	131.25	283.0
2011-07-19 04:40:00	SPY	ETF	131.35	131.35	131.35	131.35	1225.0
2011-07-19 05:00:00	SPY	ETF	131.37	131.41	131.35	131.35	650.0
2011-07-19 05:05:00	SPY	ETF	131.46	131.46	131.46	131.46	100.0
2011-07-19 05:10:00	SPY	ETF	131.46	131.58	131.46	131.58	900.0
2011-07-19 05:15:00	SPY	ETF	131.58	131.58	131.53	131.53	300.0
2011-07-19 05:20:00	SPY	ETF	131.53	131.53	131.51	131.51	900.0
2011-07-19 05:25:00	SPY	ETF	131.45	131.45	131.45	131.45	300.0
2011-07-19 05:35:00	SPY	ETF	131.39	131.39	131.39	131.39	100.0
2011-07-19 05:45:00	SPY	ETF	131.36	131.36	131.36	131.36	200.0
2011-07-19 05:50:00	SPY	ETF	131.36	131.36	131.36	131.36	400.0
2011-07-19 05:55:00	SPY	ETF	131.3	131.3	131.3	131.3	100.0
2011-07-19 06:00:00	SPY	ETF	131.3	131.3	131.3	131.3	4000.0
2011-07-19 06:10:00	SPY	ETF	131.42	131.44	131.42	131.44	200.0
2011-07-19 06:15:00	SPY	ETF	131.44	131.44	131.44	131.44	100.0
2011-07-19 06:20:00	SPY	ETF	131.43	131.43	131.43	131.43	100.0
2011-07-19 06:25:00	SPY	ETF	131.41	131.41	131.41	131.41	100.0
2011-07-19 06:40:00	SPY	ETF	131.32	131.33	131.32	131.33	700.0
2011-07-19 06:45:00	SPY	ETF	131.34	131.34	131.32	131.32	2800.0
2011-07-19 06:50:00	SPY	ETF	131.38	131.43	131.36	131.43	1900.0
2011-07-19 06:55:00	SPY	ETF	131.44	131.45	131.38	131.38	8900.0
2011-07-19 07:00:00	SPY	ETF	131.39	131.49	131.39	131.45	56200.0
2011-07-19 07:05:00	SPY	ETF	131.45	131.53	131.42	131.43	21349.0
2011-07-19 07:10:00	SPY	ETF	131.45	131.49	131.45	131.48	29200.0
2011-07-19 07:15:00	SPY	ETF	131.46	131.49	131.38	131.38	38400.0
2011-07-19 07:20:00	SPY	ETF	131.4	131.49	131.4	131.43	44900.0
2011-07-19 07:25:00	SPY	ETF	131.41	131.44	131.4	131.44	100700.0
2011-07-19 07:30:00	SPY	ETF	131.41	131.41	131.35	131.39	29901.0
2011-07-19 07:35:00	SPY	ETF	131.38	131.44	131.35	131.4	41800.0
2011-07-19 07:40:00	SPY	ETF	131.37	131.42	131.35	131.35	134700.0
2011-07-19 07:45:00	SPY	ETF	131.34	131.35	131.28	131.3	144200.0
2011-07-19 07:50:00	SPY	ETF	131.3	131.35	131.27	131.34	190730.0
2011-07-19 07:55:00	SPY	ETF	131.34	131.48	131.33	131.44	112500.0
2011-07-19 08:00:00	SPY	ETF	131.42	131.42	131.0	131.07	306355.0
2011-07-19 08:05:00	SPY	ETF	131.08	131.29	131.05	131.27	1694042.0
2011-07-19 08:10:00	SPY	ETF	131.28	131.28	131.2	131.25	86700.0
2011-07-19 08:15:00	SPY	ETF	131.26	131.44	131.25	131.33	160477.0
2011-07-19 08:20:00	SPY	ETF	131.33	131.37	131.32	131.33	398108.0
2011-07-19 08:25:00	SPY	ETF	131.33	131.34	131.25	131.3	100819.0
2011-07-19 08:30:00	SPY	ETF	131.32	131.56	131.32	131.47	1114869.0
2011-07-19 08:35:00	SPY	ETF	131.47	131.52	131.43	131.48	392506.0
2011-07-19 08:40:00	SPY	ETF	131.48	131.52	131.43	131.49	211108.0
2011-07-19 08:45:00	SPY	ETF	131.5	131.57	131.5	131.52	66437.0
2011-07-19 08:50:00	SPY	ETF	131.52	131.52	131.22	131.26	289434.0
2011-07-19 08:55:00	SPY	ETF	131.24	131.34	131.12	131.32	1284955.0
2011-07-19 09:00:00	SPY	ETF	131.32	131.41	131.2	131.31	236564.0
2011-07-19 09:05:00	SPY	ETF	131.33	131.36	131.17	131.21	445941.0
2011-07-19 09:10:00	SPY	ETF	131.2	131.32	131.19	131.32	276123.0

> showing 50 of 36,748 rows — these rows as CSV

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