PREVIEW / etf_1hour / 2012-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-17.parquet
  size:    182 KB
  rows:    5,565

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
2012-02-17 04:00:00	SPY	ETF	135.95	136.05	135.84	136.04	7670.0
2012-02-17 05:00:00	SPY	ETF	135.99	136.04	135.94	135.96	42408.0
2012-02-17 06:00:00	SPY	ETF	135.96	136.06	135.89	136.06	23000.0
2012-02-17 07:00:00	SPY	ETF	136.02	136.34	136.02	136.19	356570.0
2012-02-17 08:00:00	SPY	ETF	136.2	136.25	136.08	136.15	1222547.0
2012-02-17 09:00:00	SPY	ETF	136.15	136.57	136.14	136.42	23710309.0
2012-02-17 10:00:00	SPY	ETF	136.42	136.6275	136.11	136.19	23449824.0
2012-02-17 11:00:00	SPY	ETF	136.18	136.22	135.96	136.1301	17536083.0
2012-02-17 12:00:00	SPY	ETF	136.14	136.19	136.05	136.1499	6405164.0
2012-02-17 13:00:00	SPY	ETF	136.1499	136.32	136.12	136.29	7465874.0
2012-02-17 14:00:00	SPY	ETF	136.29	136.4	136.27	136.35	7806503.0
2012-02-17 15:00:00	SPY	ETF	136.36	136.54	136.31	136.4	27904954.0
2012-02-17 16:00:00	SPY	ETF	136.41	136.52	136.0527	136.5	12076982.0
2012-02-17 17:00:00	SPY	ETF	136.5	136.6	136.39	136.59	621488.0
2012-02-17 18:00:00	SPY	ETF	136.59	136.83	136.57	136.83	716160.0
2012-02-17 19:00:00	SPY	ETF	136.79	136.8	136.71	136.75	78178.0
2012-02-17 07:00:00	QQQ	ETF	63.69	63.78	63.65	63.69	58769.0
2012-02-17 08:00:00	QQQ	ETF	63.68	63.7	63.62	63.64	91650.0
2012-02-17 09:00:00	QQQ	ETF	63.64	63.7	63.43	63.55	8427583.0
2012-02-17 10:00:00	QQQ	ETF	63.55	63.56	63.4	63.41	5948209.0
2012-02-17 11:00:00	QQQ	ETF	63.41	63.41	63.15	63.336	8936186.0
2012-02-17 12:00:00	QQQ	ETF	63.34	63.36	63.27	63.321	1991340.0
2012-02-17 13:00:00	QQQ	ETF	63.3201	63.42	63.3	63.4	2215844.0
2012-02-17 14:00:00	QQQ	ETF	63.3901	63.46	63.3698	63.43	2638181.0
2012-02-17 15:00:00	QQQ	ETF	63.44	63.53	63.4	63.43	7917193.0
2012-02-17 16:00:00	QQQ	ETF	63.44	63.6451	63.38	63.42	2710185.0
2012-02-17 17:00:00	QQQ	ETF	63.4	63.48	63.31	63.4	17087.0
2012-02-17 18:00:00	QQQ	ETF	63.42	63.51	63.4	63.5	32643.0
2012-02-17 19:00:00	QQQ	ETF	63.5	63.52	63.46	63.52	2652.0
2012-02-17 07:00:00	IWM	ETF	82.91	83.07	82.91	82.96	4500.0
2012-02-17 08:00:00	IWM	ETF	82.96	83.13	82.52	82.9	253526.0
2012-02-17 09:00:00	IWM	ETF	82.93	83.31	82.92	83.08	5233940.0
2012-02-17 10:00:00	IWM	ETF	83.08	83.09	82.83	82.88	4551279.0
2012-02-17 11:00:00	IWM	ETF	82.88	82.89	82.63	82.86	5603238.0
2012-02-17 12:00:00	IWM	ETF	82.86	82.88	82.75	82.8	1616204.0
2012-02-17 13:00:00	IWM	ETF	82.8	82.915	82.765	82.85	1503221.0
2012-02-17 14:00:00	IWM	ETF	82.8499	82.89	82.68	82.754	3346269.0
2012-02-17 15:00:00	IWM	ETF	82.76	82.84	82.68	82.76	5022492.0
2012-02-17 16:00:00	IWM	ETF	82.76	82.84	82.63	82.79	1450581.0
2012-02-17 17:00:00	IWM	ETF	82.79	82.82	82.75	82.82	25448.0
2012-02-17 18:00:00	IWM	ETF	82.83	82.83	82.83	82.83	600.0
2012-02-17 19:00:00	IWM	ETF	82.99	83.5	82.99	83.49	7000.0
2012-02-17 04:00:00	DIA	ETF	128.69	128.72	128.56	128.56	3200.0
2012-02-17 07:00:00	DIA	ETF	129.03	129.03	128.91	128.95	1600.0
2012-02-17 08:00:00	DIA	ETF	129.0	129.06	128.93	128.95	18205.0
2012-02-17 09:00:00	DIA	ETF	128.97	129.34	128.97	129.08	831298.0
2012-02-17 10:00:00	DIA	ETF	129.07	129.14	128.91	128.98	725776.0
2012-02-17 11:00:00	DIA	ETF	128.99	129.07	128.86	129.0	765807.0
2012-02-17 12:00:00	DIA	ETF	129.01	129.059	128.95	129.04	384871.0
2012-02-17 13:00:00	DIA	ETF	129.0423	129.18	129.02	129.17	418490.0

> showing 50 of 5,565 rows — these rows as CSV

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