PREVIEW / etf_1hour / 2013-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-26.parquet
  size:    193 KB
  rows:    6,065

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-04-26 04:00:00	SPY	ETF	158.3	158.3	158.1	158.2	15299.0
2013-04-26 05:00:00	SPY	ETF	158.16	158.21	158.08	158.21	16735.0
2013-04-26 06:00:00	SPY	ETF	158.18	158.22	158.0	158.16	71820.0
2013-04-26 07:00:00	SPY	ETF	158.18	158.33	158.12	158.2	541250.0
2013-04-26 08:00:00	SPY	ETF	158.2	158.52	157.91	158.2	2258364.0
2013-04-26 09:00:00	SPY	ETF	158.2	158.61	158.1	158.53	13678581.0
2013-04-26 10:00:00	SPY	ETF	158.53	158.6	157.93	158.06	17433227.0
2013-04-26 11:00:00	SPY	ETF	158.05	158.35	157.79	157.879	10802851.0
2013-04-26 12:00:00	SPY	ETF	157.87	158.02	157.73	157.995	9376991.0
2013-04-26 13:00:00	SPY	ETF	157.99	158.35	157.925	158.24	8109015.0
2013-04-26 14:00:00	SPY	ETF	158.24	158.37	158.12	158.24	6563456.0
2013-04-26 15:00:00	SPY	ETF	158.24	158.57	158.2	158.24	18814231.0
2013-04-26 16:00:00	SPY	ETF	158.25	158.4	158.07	158.16	5320445.0
2013-04-26 17:00:00	SPY	ETF	158.15	158.27	158.1	158.26	261858.0
2013-04-26 18:00:00	SPY	ETF	158.26	158.3	158.21	158.26	18368.0
2013-04-26 19:00:00	SPY	ETF	158.31	158.33	158.25	158.28	9115.0
2013-04-26 05:00:00	QQQ	ETF	69.56	69.65	69.56	69.65	10400.0
2013-04-26 06:00:00	QQQ	ETF	69.61	69.62	69.53	69.61	7700.0
2013-04-26 07:00:00	QQQ	ETF	69.56	69.64	69.52	69.57	415900.0
2013-04-26 08:00:00	QQQ	ETF	69.54	69.64	69.45	69.6	846905.0
2013-04-26 09:00:00	QQQ	ETF	69.61	69.72	69.54	69.69	3444268.0
2013-04-26 10:00:00	QQQ	ETF	69.7	69.7199	69.3176	69.48	3803659.0
2013-04-26 11:00:00	QQQ	ETF	69.48	69.55	69.32	69.36	2729547.0
2013-04-26 12:00:00	QQQ	ETF	69.36	69.46	69.27	69.44	2922024.0
2013-04-26 13:00:00	QQQ	ETF	69.44	69.61	69.42	69.588	1606019.0
2013-04-26 14:00:00	QQQ	ETF	69.585	69.67	69.53	69.64	1799101.0
2013-04-26 15:00:00	QQQ	ETF	69.63	69.77	69.56	69.56	3821744.0
2013-04-26 16:00:00	QQQ	ETF	69.56	69.7299	69.51	69.56	1043033.0
2013-04-26 17:00:00	QQQ	ETF	69.56	69.56	69.56	69.56	10315.0
2013-04-26 18:00:00	QQQ	ETF	69.56	69.57	69.55	69.57	4337.0
2013-04-26 19:00:00	QQQ	ETF	69.55	69.57	69.55	69.57	4163.0
2013-04-26 04:00:00	IWM	ETF	93.17	93.2	93.17	93.2	600.0
2013-04-26 05:00:00	IWM	ETF	93.11	93.11	93.11	93.11	100.0
2013-04-26 06:00:00	IWM	ETF	93.12	93.12	93.12	93.12	180.0
2013-04-26 07:00:00	IWM	ETF	93.16	93.28	93.12	93.15	217800.0
2013-04-26 08:00:00	IWM	ETF	93.11	93.18	92.91	93.0	1127240.0
2013-04-26 09:00:00	IWM	ETF	92.99	93.4	92.88	93.28	5065926.0
2013-04-26 10:00:00	IWM	ETF	93.28	93.36	92.76	92.89	6502283.0
2013-04-26 11:00:00	IWM	ETF	92.89	93.06	92.55	92.605	3284621.0
2013-04-26 12:00:00	IWM	ETF	92.6	92.7699	92.5	92.69	2874018.0
2013-04-26 13:00:00	IWM	ETF	92.69	93.02	92.59	92.9	2142788.0
2013-04-26 14:00:00	IWM	ETF	92.9	92.985	92.79	92.83	1849525.0
2013-04-26 15:00:00	IWM	ETF	92.84	93.08	92.83	92.92	6208221.0
2013-04-26 16:00:00	IWM	ETF	92.92	93.0	92.85	92.95	1542007.0
2013-04-26 17:00:00	IWM	ETF	92.93	92.94	92.92	92.94	3300.0
2013-04-26 19:00:00	IWM	ETF	92.95	92.95	92.91	92.91	800.0
2013-04-26 06:00:00	DIA	ETF	146.43	146.43	146.43	146.43	400.0
2013-04-26 07:00:00	DIA	ETF	146.55	146.58	146.55	146.58	6600.0
2013-04-26 08:00:00	DIA	ETF	146.56	146.56	146.33	146.43	8121.0
2013-04-26 09:00:00	DIA	ETF	146.42	146.98	146.42	146.98	579145.0

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

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