PREVIEW / etf_1hour / 2013-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-01.parquet
  size:    207 KB
  rows:    6,505

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-08-01 04:00:00	SPY	ETF	169.06	169.48	169.06	169.48	47800.0
2013-08-01 05:00:00	SPY	ETF	169.5	169.82	169.47	169.77	64500.0
2013-08-01 06:00:00	SPY	ETF	169.81	169.81	169.61	169.61	65640.0
2013-08-01 07:00:00	SPY	ETF	169.62	169.73	169.56	169.63	253444.0
2013-08-01 08:00:00	SPY	ETF	169.63	169.91	169.62	169.74	1294847.0
2013-08-01 09:00:00	SPY	ETF	169.73	170.28	169.64	170.12	15281153.0
2013-08-01 10:00:00	SPY	ETF	170.1	170.53	170.07	170.2	20167571.0
2013-08-01 11:00:00	SPY	ETF	170.2	170.4	170.11	170.33	9648996.0
2013-08-01 12:00:00	SPY	ETF	170.325	170.5	170.17	170.35	6542705.0
2013-08-01 13:00:00	SPY	ETF	170.35	170.48	170.26	170.455	5687377.0
2013-08-01 14:00:00	SPY	ETF	170.45	170.68	170.425	170.57	12005569.0
2013-08-01 15:00:00	SPY	ETF	170.58	170.81	170.34	170.66	26281399.0
2013-08-01 16:00:00	SPY	ETF	170.65	170.73	170.42	170.71	7010476.0
2013-08-01 17:00:00	SPY	ETF	170.71	170.73	170.6	170.65	254737.0
2013-08-01 18:00:00	SPY	ETF	170.66	170.66	170.51	170.55	177294.0
2013-08-01 19:00:00	SPY	ETF	170.55	170.65	170.54	170.63	49946.0
2013-08-01 04:00:00	QQQ	ETF	76.05	76.09	76.01	76.09	12700.0
2013-08-01 05:00:00	QQQ	ETF	76.1	76.21	76.1	76.21	7700.0
2013-08-01 06:00:00	QQQ	ETF	76.19	76.2	76.15	76.15	6200.0
2013-08-01 07:00:00	QQQ	ETF	76.13	76.17	76.13	76.15	34000.0
2013-08-01 08:00:00	QQQ	ETF	76.15	76.26	76.15	76.21	117436.0
2013-08-01 09:00:00	QQQ	ETF	76.21	76.3999	75.77	76.25	2524389.0
2013-08-01 10:00:00	QQQ	ETF	76.25	76.4355	76.23	76.32	2836271.0
2013-08-01 11:00:00	QQQ	ETF	76.32	76.3899	76.26	76.35	1474198.0
2013-08-01 12:00:00	QQQ	ETF	76.351	76.4299	76.28	76.33	1180248.0
2013-08-01 13:00:00	QQQ	ETF	76.32	76.39	76.2826	76.381	1051196.0
2013-08-01 14:00:00	QQQ	ETF	76.38	76.53	76.37	76.49	1361928.0
2013-08-01 15:00:00	QQQ	ETF	76.5	76.65	76.4199	76.54	4232534.0
2013-08-01 16:00:00	QQQ	ETF	76.54	76.5916	76.296	76.54	1531320.0
2013-08-01 17:00:00	QQQ	ETF	76.54	76.57	76.5	76.57	28214.0
2013-08-01 18:00:00	QQQ	ETF	76.54	76.54	76.47	76.48	11285.0
2013-08-01 19:00:00	QQQ	ETF	76.48	76.52	76.48	76.52	9030.0
2013-08-01 07:00:00	IWM	ETF	104.4	104.44	104.4	104.43	56800.0
2013-08-01 08:00:00	IWM	ETF	104.43	104.72	104.41	104.57	236999.0
2013-08-01 09:00:00	IWM	ETF	104.55	105.04	104.53	104.921	4663372.0
2013-08-01 10:00:00	IWM	ETF	104.93	105.28	104.88	105.08	5741986.0
2013-08-01 11:00:00	IWM	ETF	105.08	105.115	104.78	105.06	3576077.0
2013-08-01 12:00:00	IWM	ETF	105.06	105.19	104.94	105.15	1872645.0
2013-08-01 13:00:00	IWM	ETF	105.15	105.16	104.9	105.02	2166490.0
2013-08-01 14:00:00	IWM	ETF	105.01	105.1399	104.96	105.04	2603233.0
2013-08-01 15:00:00	IWM	ETF	105.04	105.35	104.89	105.1	8329416.0
2013-08-01 16:00:00	IWM	ETF	105.09	105.244	104.96	105.11	1316255.0
2013-08-01 17:00:00	IWM	ETF	105.13	105.19	105.04	105.06	8966.0
2013-08-01 18:00:00	IWM	ETF	105.05	105.15	105.05	105.13	7700.0
2013-08-01 19:00:00	IWM	ETF	105.1	105.19	105.1	105.18	8167.0
2013-08-01 05:00:00	DIA	ETF	155.41	155.61	155.41	155.61	15200.0
2013-08-01 07:00:00	DIA	ETF	155.58	155.67	155.58	155.67	9400.0
2013-08-01 08:00:00	DIA	ETF	155.6	155.81	155.56	155.69	15002.0
2013-08-01 09:00:00	DIA	ETF	155.68	156.13	155.65	155.86	719727.0
2013-08-01 10:00:00	DIA	ETF	155.81	156.16	155.8	155.87	978910.0

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

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