PREVIEW / etf_1hour / 2011-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-22.parquet
  size:    179 KB
  rows:    5,533

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
2011-07-22 04:00:00	SPY	ETF	134.88	135.16	134.88	135.16	2178.0
2011-07-22 05:00:00	SPY	ETF	135.13	135.13	135.0	135.0	21330.0
2011-07-22 06:00:00	SPY	ETF	135.04	135.1	134.85	134.91	8250.0
2011-07-22 07:00:00	SPY	ETF	134.9	135.15	134.64	134.68	1669144.0
2011-07-22 08:00:00	SPY	ETF	134.71	134.93	134.49	134.49	2769525.0
2011-07-22 09:00:00	SPY	ETF	134.48	134.64	134.0	134.07	17209879.0
2011-07-22 10:00:00	SPY	ETF	134.07	134.29	133.76	134.25	21905303.0
2011-07-22 11:00:00	SPY	ETF	134.25	134.5	134.17	134.435	16718362.0
2011-07-22 12:00:00	SPY	ETF	134.435	134.72	134.34	134.67	15503785.0
2011-07-22 13:00:00	SPY	ETF	134.68	134.7	134.53	134.64	6441228.0
2011-07-22 14:00:00	SPY	ETF	134.645	134.67	134.48	134.64	9100140.0
2011-07-22 15:00:00	SPY	ETF	134.64	134.72	134.32	134.58	22855118.0
2011-07-22 16:00:00	SPY	ETF	134.58	134.71	134.2	134.6	9331360.0
2011-07-22 17:00:00	SPY	ETF	134.62	134.66	134.53	134.6	71185.0
2011-07-22 18:00:00	SPY	ETF	134.52	134.61	133.81	133.85	666963.0
2011-07-22 19:00:00	SPY	ETF	133.86	134.12	133.77	134.07	142791.0
2011-07-22 04:00:00	QQQ	ETF	59.26	59.31	59.26	59.31	1100.0
2011-07-22 06:00:00	QQQ	ETF	59.29	59.3	59.24	59.3	5400.0
2011-07-22 07:00:00	QQQ	ETF	59.21	59.28	59.04	59.07	157599.0
2011-07-22 08:00:00	QQQ	ETF	59.06	59.14	58.92	58.93	263809.0
2011-07-22 09:00:00	QQQ	ETF	58.92	59.2681	58.88	59.02	6857590.0
2011-07-22 10:00:00	QQQ	ETF	59.01	59.17	58.92	59.16	5003661.0
2011-07-22 11:00:00	QQQ	ETF	59.17	59.27	59.11	59.2499	5337073.0
2011-07-22 12:00:00	QQQ	ETF	59.245	59.54	59.21	59.53	5386480.0
2011-07-22 13:00:00	QQQ	ETF	59.54	59.63	59.46	59.62	4428467.0
2011-07-22 14:00:00	QQQ	ETF	59.6105	59.7	59.53	59.65	5131600.0
2011-07-22 15:00:00	QQQ	ETF	59.66	59.699	59.47	59.61	7264160.0
2011-07-22 16:00:00	QQQ	ETF	59.61	59.69	59.53	59.56	928842.0
2011-07-22 17:00:00	QQQ	ETF	59.56	59.62	59.56	59.61	18156.0
2011-07-22 18:00:00	QQQ	ETF	59.54	59.61	59.38	59.38	97866.0
2011-07-22 19:00:00	QQQ	ETF	59.38	59.47	59.34	59.45	36756.0
2011-07-22 04:00:00	IWM	ETF	84.31	84.31	84.31	84.31	100.0
2011-07-22 06:00:00	IWM	ETF	84.08	84.08	84.08	84.08	2000.0
2011-07-22 07:00:00	IWM	ETF	84.27	84.38	84.01	84.02	68400.0
2011-07-22 08:00:00	IWM	ETF	84.09	84.21	83.83	83.89	446410.0
2011-07-22 09:00:00	IWM	ETF	83.87	84.1	83.58	83.63	5684292.0
2011-07-22 10:00:00	IWM	ETF	83.6312	83.85	83.4	83.77	6318101.0
2011-07-22 11:00:00	IWM	ETF	83.7684	84.04	83.72	84.01	3623139.0
2011-07-22 12:00:00	IWM	ETF	84.01	84.24	83.93	84.23	2010237.0
2011-07-22 13:00:00	IWM	ETF	84.23	84.2487	84.12	84.19	1463770.0
2011-07-22 14:00:00	IWM	ETF	84.2	84.22	84.049	84.199	2796907.0
2011-07-22 15:00:00	IWM	ETF	84.19	84.26	83.98	84.02	4611312.0
2011-07-22 16:00:00	IWM	ETF	84.02	84.1473	83.96	84.0	2982967.0
2011-07-22 17:00:00	IWM	ETF	84.01	84.01	83.96	83.96	13936.0
2011-07-22 18:00:00	IWM	ETF	83.81	83.83	83.68	83.69	41917.0
2011-07-22 19:00:00	IWM	ETF	83.65	83.8	83.5	83.72	8100.0
2011-07-22 04:00:00	DIA	ETF	127.45	127.53	127.45	127.53	600.0
2011-07-22 06:00:00	DIA	ETF	127.76	127.76	127.76	127.76	100.0
2011-07-22 07:00:00	DIA	ETF	127.68	127.68	126.85	126.95	204900.0
2011-07-22 08:00:00	DIA	ETF	127.65	127.65	126.8	126.81	639530.0

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

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