PREVIEW / etf_1hour / 2012-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-03.parquet
  size:    122 KB
  rows:    3,605

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-07-03 04:00:00	SPY	ETF	136.31	136.33	136.15	136.31	3100.0
2012-07-03 05:00:00	SPY	ETF	136.43	136.43	136.43	136.43	120.0
2012-07-03 06:00:00	SPY	ETF	136.36	136.36	136.22	136.22	13000.0
2012-07-03 07:00:00	SPY	ETF	136.3	136.5	136.3	136.44	213182.0
2012-07-03 08:00:00	SPY	ETF	136.43	136.51	136.34	136.47	455720.0
2012-07-03 09:00:00	SPY	ETF	136.49	136.87	136.34	136.79	11800459.0
2012-07-03 10:00:00	SPY	ETF	136.79	137.16	136.79	137.095	16851251.0
2012-07-03 11:00:00	SPY	ETF	137.09	137.51	137.09	137.36	17184570.0
2012-07-03 12:00:00	SPY	ETF	137.35	137.43	136.98	137.42	27015778.0
2012-07-03 13:00:00	SPY	ETF	137.42	137.6	136.5649	137.44	4676623.0
2012-07-03 14:00:00	SPY	ETF	137.44	137.56	137.43	137.54	177430.0
2012-07-03 15:00:00	SPY	ETF	137.51	137.54	137.37	137.38	50322.0
2012-07-03 16:00:00	SPY	ETF	137.36	137.43	137.26	137.37	19400.0
2012-07-03 05:00:00	QQQ	ETF	64.34	64.34	64.3	64.3	264.0
2012-07-03 06:00:00	QQQ	ETF	64.28	64.28	64.28	64.28	300.0
2012-07-03 07:00:00	QQQ	ETF	64.31	64.38	64.31	64.35	41605.0
2012-07-03 08:00:00	QQQ	ETF	64.34	64.42	64.33	64.4	77757.0
2012-07-03 09:00:00	QQQ	ETF	64.39	64.47	64.29	64.43	2494304.0
2012-07-03 10:00:00	QQQ	ETF	64.44	64.67	64.43	64.64	3374874.0
2012-07-03 11:00:00	QQQ	ETF	64.64	64.85	64.64	64.7692	4031198.0
2012-07-03 12:00:00	QQQ	ETF	64.77	64.89	64.69	64.88	4728679.0
2012-07-03 13:00:00	QQQ	ETF	64.88	64.96	64.84	64.93	391652.0
2012-07-03 14:00:00	QQQ	ETF	64.91	64.96	64.89	64.9	13475.0
2012-07-03 15:00:00	QQQ	ETF	64.88	64.92	64.88	64.9	6200.0
2012-07-03 16:00:00	QQQ	ETF	64.85	64.92	64.85	64.92	5100.0
2012-07-03 07:00:00	IWM	ETF	80.52	80.59	80.52	80.59	8400.0
2012-07-03 08:00:00	IWM	ETF	80.54	80.6	80.46	80.53	164720.0
2012-07-03 09:00:00	IWM	ETF	80.53	80.88	80.43	80.85	4325926.0
2012-07-03 10:00:00	IWM	ETF	80.86	81.27	80.86	81.21	6739811.0
2012-07-03 11:00:00	IWM	ETF	81.22	81.55	81.17	81.5	6728762.0
2012-07-03 12:00:00	IWM	ETF	81.51	81.56	81.2	81.56	7959159.0
2012-07-03 13:00:00	IWM	ETF	81.55	81.68	81.4317	81.56	1703452.0
2012-07-03 14:00:00	IWM	ETF	81.56	81.6	81.52	81.53	29815.0
2012-07-03 15:00:00	IWM	ETF	81.54	81.57	81.51	81.51	16827.0
2012-07-03 16:00:00	IWM	ETF	81.5	81.5	81.5	81.5	200.0
2012-07-03 08:00:00	DIA	ETF	128.16	128.36	127.9	128.36	11130.0
2012-07-03 09:00:00	DIA	ETF	128.36	128.69	128.24	128.6499	486485.0
2012-07-03 10:00:00	DIA	ETF	128.65	128.92	128.64	128.85	701756.0
2012-07-03 11:00:00	DIA	ETF	128.87	129.23	128.87	129.1	696425.0
2012-07-03 12:00:00	DIA	ETF	129.11	129.2	128.81	129.19	755533.0
2012-07-03 13:00:00	DIA	ETF	129.18	129.2	129.12	129.19	32777.0
2012-07-03 14:00:00	DIA	ETF	129.18	129.19	129.18	129.19	1800.0
2012-07-03 15:00:00	DIA	ETF	129.11	129.11	129.11	129.11	100.0
2012-07-03 04:00:00	GLD	ETF	156.0	156.0	156.0	156.0	100.0
2012-07-03 06:00:00	GLD	ETF	156.11	156.19	156.11	156.16	929.0
2012-07-03 07:00:00	GLD	ETF	156.1	156.56	156.1	156.4	8989.0
2012-07-03 08:00:00	GLD	ETF	156.36	156.89	156.36	156.81	41369.0
2012-07-03 09:00:00	GLD	ETF	156.83	157.21	156.77	157.11	911290.0
2012-07-03 10:00:00	GLD	ETF	157.125	157.16	156.79	157.08	806512.0
2012-07-03 11:00:00	GLD	ETF	157.08	157.72	157.02	157.45	836364.0

> showing 50 of 3,605 rows — these rows as CSV

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