PREVIEW / etf_1hour / 2012-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-31.parquet
  size:    181 KB
  rows:    5,657

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-31 04:00:00	SPY	ETF	138.78	138.94	138.77	138.88	4694.0
2012-07-31 05:00:00	SPY	ETF	138.9	139.02	138.9	139.01	4150.0
2012-07-31 06:00:00	SPY	ETF	139.06	139.11	138.85	138.85	2654.0
2012-07-31 07:00:00	SPY	ETF	138.88	139.0	138.77	138.92	172393.0
2012-07-31 08:00:00	SPY	ETF	138.92	138.96	138.63	138.73	1859274.0
2012-07-31 09:00:00	SPY	ETF	138.71	138.85	138.38	138.58	16637899.0
2012-07-31 10:00:00	SPY	ETF	138.58	138.77	138.25	138.61	20213001.0
2012-07-31 11:00:00	SPY	ETF	138.61	138.87	138.509	138.65	12864258.0
2012-07-31 12:00:00	SPY	ETF	138.65	138.65	138.13	138.18	12494571.0
2012-07-31 13:00:00	SPY	ETF	138.175	138.42	138.1	138.25	9110365.0
2012-07-31 14:00:00	SPY	ETF	138.25	138.65	138.2	138.34	11168662.0
2012-07-31 15:00:00	SPY	ETF	138.33	138.45	137.95	137.98	22053149.0
2012-07-31 16:00:00	SPY	ETF	137.97	138.816	137.71	137.89	12506817.0
2012-07-31 17:00:00	SPY	ETF	137.89	137.92	137.82	137.89	141264.0
2012-07-31 18:00:00	SPY	ETF	137.88	137.89	137.79	137.86	27051.0
2012-07-31 19:00:00	SPY	ETF	137.84	137.87	137.8	137.85	41512.0
2012-07-31 05:00:00	QQQ	ETF	65.0	65.0	64.99	64.99	3150.0
2012-07-31 06:00:00	QQQ	ETF	65.0	65.0	65.0	65.0	2400.0
2012-07-31 07:00:00	QQQ	ETF	64.96	65.04	64.96	65.01	63900.0
2012-07-31 08:00:00	QQQ	ETF	65.0	65.05	64.9	64.96	968344.0
2012-07-31 09:00:00	QQQ	ETF	64.97	65.18	64.81	64.96	4676971.0
2012-07-31 10:00:00	QQQ	ETF	64.94	65.14	64.75	65.0145	6379871.0
2012-07-31 11:00:00	QQQ	ETF	65.02	65.1501	64.94	65.02	2721405.0
2012-07-31 12:00:00	QQQ	ETF	65.01	65.01	64.75	64.78	4773902.0
2012-07-31 13:00:00	QQQ	ETF	64.78	64.98	64.74	64.8901	3605886.0
2012-07-31 14:00:00	QQQ	ETF	64.8999	65.08	64.87	64.9	3842719.0
2012-07-31 15:00:00	QQQ	ETF	64.89	64.96	64.79	64.79	5431484.0
2012-07-31 16:00:00	QQQ	ETF	64.79	64.916	64.67	64.77	852291.0
2012-07-31 17:00:00	QQQ	ETF	64.78	64.79	64.76	64.78	9700.0
2012-07-31 18:00:00	QQQ	ETF	64.79	64.79	64.74	64.74	30183.0
2012-07-31 19:00:00	QQQ	ETF	64.75	64.78	64.74	64.77	3300.0
2012-07-31 08:00:00	IWM	ETF	79.01	80.68	78.83	78.88	251377.0
2012-07-31 09:00:00	IWM	ETF	78.87	79.47	78.65	79.12	5814350.0
2012-07-31 10:00:00	IWM	ETF	79.13	79.32	78.74	79.12	5829867.0
2012-07-31 11:00:00	IWM	ETF	79.12	79.435	79.03	79.21	2824088.0
2012-07-31 12:00:00	IWM	ETF	79.21	79.215	78.59	78.65	5337900.0
2012-07-31 13:00:00	IWM	ETF	78.64	78.85	78.49	78.66	3470235.0
2012-07-31 14:00:00	IWM	ETF	78.66	78.97	78.65	78.7674	2948714.0
2012-07-31 15:00:00	IWM	ETF	78.76	78.84	78.37	78.4	10952221.0
2012-07-31 16:00:00	IWM	ETF	78.4	78.67	78.31	78.41	1643418.0
2012-07-31 17:00:00	IWM	ETF	78.38	78.42	78.35	78.35	62350.0
2012-07-31 18:00:00	IWM	ETF	78.39	78.42	78.39	78.42	2100.0
2012-07-31 19:00:00	IWM	ETF	78.42	78.42	78.4	78.42	3462.0
2012-07-31 08:00:00	DIA	ETF	130.51	130.51	130.41	130.41	3300.0
2012-07-31 09:00:00	DIA	ETF	130.43	130.43	130.12	130.2499	671829.0
2012-07-31 10:00:00	DIA	ETF	130.25	130.433	129.98	130.31	825338.0
2012-07-31 11:00:00	DIA	ETF	130.32	130.53	130.22	130.366	509186.0
2012-07-31 12:00:00	DIA	ETF	130.35	130.35	129.92	129.98	579750.0
2012-07-31 13:00:00	DIA	ETF	129.97	130.18	129.95	130.03	269118.0
2012-07-31 14:00:00	DIA	ETF	130.02	130.38	129.99	130.09	600134.0

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

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