PREVIEW / etf_1hour / 2012-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-08.parquet
  size:    187 KB
  rows:    5,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
2012-02-08 04:00:00	SPY	ETF	135.19	135.2	135.02	135.02	39863.0
2012-02-08 05:00:00	SPY	ETF	135.06	135.06	134.91	134.99	10440.0
2012-02-08 06:00:00	SPY	ETF	134.96	135.07	134.88	135.07	107285.0
2012-02-08 07:00:00	SPY	ETF	135.04	135.09	134.92	135.03	456791.0
2012-02-08 08:00:00	SPY	ETF	135.02	135.09	134.94	134.94	809567.0
2012-02-08 09:00:00	SPY	ETF	134.94	135.18	134.7746	135.13	15970426.0
2012-02-08 10:00:00	SPY	ETF	135.13	135.22	134.79	134.93	19487364.0
2012-02-08 11:00:00	SPY	ETF	134.93	135.0	134.31	134.56	26791259.0
2012-02-08 12:00:00	SPY	ETF	134.56	134.84	134.53	134.83	13318381.0
2012-02-08 13:00:00	SPY	ETF	134.82	134.91	134.69	134.78	11042496.0
2012-02-08 14:00:00	SPY	ETF	134.78	135.16	134.75	135.06	16024271.0
2012-02-08 15:00:00	SPY	ETF	135.07	135.15	134.98	135.13	18528480.0
2012-02-08 16:00:00	SPY	ETF	135.15	135.21	134.46	135.08	12382457.0
2012-02-08 17:00:00	SPY	ETF	135.08	135.09	134.8344	134.87	1428732.0
2012-02-08 18:00:00	SPY	ETF	134.86	134.92	134.73	134.88	464931.0
2012-02-08 19:00:00	SPY	ETF	134.85	134.89	134.65	134.7	414384.0
2012-02-08 05:00:00	QQQ	ETF	62.24	62.24	62.24	62.24	100.0
2012-02-08 06:00:00	QQQ	ETF	62.23	62.24	62.16	62.24	12243.0
2012-02-08 07:00:00	QQQ	ETF	62.22	62.22	62.17	62.19	7166.0
2012-02-08 08:00:00	QQQ	ETF	62.2	62.24	62.18	62.18	217688.0
2012-02-08 09:00:00	QQQ	ETF	62.18	62.285	62.08	62.27	5861470.0
2012-02-08 10:00:00	QQQ	ETF	62.28	62.38	62.11	62.17	5659117.0
2012-02-08 11:00:00	QQQ	ETF	62.17	62.19	61.91	62.06	8321546.0
2012-02-08 12:00:00	QQQ	ETF	62.06	62.25	62.05	62.2325	3637529.0
2012-02-08 13:00:00	QQQ	ETF	62.24	62.32	62.2	62.2501	2163450.0
2012-02-08 14:00:00	QQQ	ETF	62.25	62.43	62.24	62.4	5291153.0
2012-02-08 15:00:00	QQQ	ETF	62.39	62.46	62.36	62.45	4992142.0
2012-02-08 16:00:00	QQQ	ETF	62.45	62.55	62.4	62.4	1691726.0
2012-02-08 17:00:00	QQQ	ETF	62.4	62.42	62.21	62.27	565388.0
2012-02-08 18:00:00	QQQ	ETF	62.27	62.37	62.26	62.36	49150.0
2012-02-08 19:00:00	QQQ	ETF	62.34	62.36	62.32	62.34	32050.0
2012-02-08 04:00:00	IWM	ETF	82.99	83.0	82.99	83.0	547.0
2012-02-08 05:00:00	IWM	ETF	82.9	82.9	82.9	82.9	2800.0
2012-02-08 06:00:00	IWM	ETF	82.97	82.97	82.86	82.94	52100.0
2012-02-08 07:00:00	IWM	ETF	82.9	82.99	82.9	82.97	5092.0
2012-02-08 08:00:00	IWM	ETF	82.97	83.05	82.89	82.89	185350.0
2012-02-08 09:00:00	IWM	ETF	82.87	83.13	82.63	83.06	5324225.0
2012-02-08 10:00:00	IWM	ETF	83.06	83.21	82.707	82.78	6532668.0
2012-02-08 11:00:00	IWM	ETF	82.79	82.81	81.93	82.14	9682406.0
2012-02-08 12:00:00	IWM	ETF	82.1365	82.49	82.11	82.46	3186868.0
2012-02-08 13:00:00	IWM	ETF	82.46	82.465	82.2	82.2	2381585.0
2012-02-08 14:00:00	IWM	ETF	82.2	82.85	82.19	82.71	6392623.0
2012-02-08 15:00:00	IWM	ETF	82.71	82.78	82.48	82.76	6693314.0
2012-02-08 16:00:00	IWM	ETF	82.75	82.88	82.6033	82.78	2650154.0
2012-02-08 17:00:00	IWM	ETF	82.77	82.77	82.66	82.66	69500.0
2012-02-08 18:00:00	IWM	ETF	82.6	82.65	82.48	82.65	4900.0
2012-02-08 19:00:00	IWM	ETF	82.65	82.65	82.58	82.62	7400.0
2012-02-08 08:00:00	DIA	ETF	128.77	128.82	128.69	128.69	14310.0
2012-02-08 09:00:00	DIA	ETF	128.66	128.8	128.52	128.7335	543047.0
2012-02-08 10:00:00	DIA	ETF	128.74	128.8	128.42	128.52	771111.0

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

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