PREVIEW / etf_1hour / 2013-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-12.parquet
  size:    204 KB
  rows:    6,443

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
2013-07-12 04:00:00	SPY	ETF	167.42	167.42	167.21	167.31	178400.0
2013-07-12 05:00:00	SPY	ETF	167.31	167.51	167.26	167.51	33200.0
2013-07-12 06:00:00	SPY	ETF	167.52	167.65	167.51	167.61	44300.0
2013-07-12 07:00:00	SPY	ETF	167.66	167.67	167.39	167.61	442830.0
2013-07-12 08:00:00	SPY	ETF	167.6	167.62	167.29	167.34	1317547.0
2013-07-12 09:00:00	SPY	ETF	167.35	167.54	167.16	167.38	13872314.0
2013-07-12 10:00:00	SPY	ETF	167.38	167.69	167.21	167.43	15361765.0
2013-07-12 11:00:00	SPY	ETF	167.4393	167.5	167.15	167.2	10311966.0
2013-07-12 12:00:00	SPY	ETF	167.2	167.33	167.13	167.3	6625691.0
2013-07-12 13:00:00	SPY	ETF	167.3	167.48	167.14	167.4	8823899.0
2013-07-12 14:00:00	SPY	ETF	167.4	167.46	167.24	167.42	6147399.0
2013-07-12 15:00:00	SPY	ETF	167.42	167.85	167.28	167.7	21824973.0
2013-07-12 16:00:00	SPY	ETF	167.7	167.9276	167.2969	167.49	9581650.0
2013-07-12 17:00:00	SPY	ETF	167.49	167.55	167.45	167.52	304164.0
2013-07-12 18:00:00	SPY	ETF	167.5	167.54	167.4106	167.47	1557450.0
2013-07-12 19:00:00	SPY	ETF	167.48	167.52	167.46	167.49	17126.0
2013-07-12 04:00:00	QQQ	ETF	74.94	74.97	74.93	74.95	4216.0
2013-07-12 05:00:00	QQQ	ETF	74.93	75.0	74.93	75.0	3600.0
2013-07-12 06:00:00	QQQ	ETF	75.03	75.1	75.03	75.06	5530.0
2013-07-12 07:00:00	QQQ	ETF	75.09	75.11	75.04	75.08	28046.0
2013-07-12 08:00:00	QQQ	ETF	75.09	75.12	74.94	75.0	81915.0
2013-07-12 09:00:00	QQQ	ETF	75.02	75.11	74.92	75.0	4506365.0
2013-07-12 10:00:00	QQQ	ETF	75.01	75.15	74.961	75.0	4635174.0
2013-07-12 11:00:00	QQQ	ETF	75.0	75.03	74.83	74.8801	2646050.0
2013-07-12 12:00:00	QQQ	ETF	74.88	74.93	74.82	74.9	2098400.0
2013-07-12 13:00:00	QQQ	ETF	74.9001	75.01	74.83	74.96	2187994.0
2013-07-12 14:00:00	QQQ	ETF	74.965	75.14	74.96	75.13	2932740.0
2013-07-12 15:00:00	QQQ	ETF	75.13	75.35	75.07	75.34	8454476.0
2013-07-12 16:00:00	QQQ	ETF	75.34	75.4314	75.0	75.24	3120634.0
2013-07-12 17:00:00	QQQ	ETF	75.24	75.24	75.24	75.24	200.0
2013-07-12 18:00:00	QQQ	ETF	75.24	75.24	75.2	75.2	1528.0
2013-07-12 19:00:00	QQQ	ETF	75.23	75.26	75.23	75.25	4171.0
2013-07-12 04:00:00	IWM	ETF	102.47	102.47	102.47	102.47	100.0
2013-07-12 06:00:00	IWM	ETF	102.5	102.5	102.5	102.5	200.0
2013-07-12 07:00:00	IWM	ETF	102.54	102.54	102.45	102.48	7200.0
2013-07-12 08:00:00	IWM	ETF	102.45	102.52	102.33	102.39	55521.0
2013-07-12 09:00:00	IWM	ETF	102.4	102.74	102.26	102.68	3208859.0
2013-07-12 10:00:00	IWM	ETF	102.67	103.11	102.53	102.88	4691176.0
2013-07-12 11:00:00	IWM	ETF	102.875	102.89	102.556	102.65	3379144.0
2013-07-12 12:00:00	IWM	ETF	102.64	102.7	102.6	102.645	1112182.0
2013-07-12 13:00:00	IWM	ETF	102.65	102.83	102.54	102.7	1825390.0
2013-07-12 14:00:00	IWM	ETF	102.7	102.84	102.612	102.82	1825834.0
2013-07-12 15:00:00	IWM	ETF	102.82	103.09	102.75	102.77	6663138.0
2013-07-12 16:00:00	IWM	ETF	102.78	102.9413	102.58	102.7	1678388.0
2013-07-12 17:00:00	IWM	ETF	102.7	102.79	102.7	102.79	5599.0
2013-07-12 18:00:00	IWM	ETF	102.81	102.81	102.81	102.81	100.0
2013-07-12 19:00:00	IWM	ETF	102.8	102.8	102.69	102.69	2600.0
2013-07-12 06:00:00	DIA	ETF	154.48	154.48	154.48	154.48	200.0
2013-07-12 07:00:00	DIA	ETF	154.59	154.59	154.45	154.51	1992.0
2013-07-12 08:00:00	DIA	ETF	154.5	154.54	154.32	154.4	4930.0

> showing 50 of 6,443 rows — these rows as CSV

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