PREVIEW / etf_1hour / 2013-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-22.parquet
  size:    202 KB
  rows:    6,304

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-01-22 04:00:00	SPY	ETF	148.2	148.2	147.94	148.11	18021.0
2013-01-22 05:00:00	SPY	ETF	148.18	148.48	148.14	148.37	68711.0
2013-01-22 06:00:00	SPY	ETF	148.49	148.49	148.15	148.31	159501.0
2013-01-22 07:00:00	SPY	ETF	148.27	148.41	148.14	148.19	247549.0
2013-01-22 08:00:00	SPY	ETF	148.18	148.51	148.05	148.22	646191.0
2013-01-22 09:00:00	SPY	ETF	148.23	148.54	148.22	148.41	13540562.0
2013-01-22 10:00:00	SPY	ETF	148.42	148.484	147.98	148.27	18382402.0
2013-01-22 11:00:00	SPY	ETF	148.26	148.49	148.14	148.445	10057015.0
2013-01-22 12:00:00	SPY	ETF	148.44	148.77	148.43	148.62	9543411.0
2013-01-22 13:00:00	SPY	ETF	148.6201	148.84	148.61	148.71	8492656.0
2013-01-22 14:00:00	SPY	ETF	148.71	149.02	148.68	149.0	8973500.0
2013-01-22 15:00:00	SPY	ETF	149.0	149.13	148.81	149.0901	18001224.0
2013-01-22 16:00:00	SPY	ETF	149.09	149.39	148.1883	149.37	15406036.0
2013-01-22 17:00:00	SPY	ETF	149.38	149.5	148.0983	149.45	2858904.0
2013-01-22 18:00:00	SPY	ETF	149.44	149.49	149.36	149.38	85172.0
2013-01-22 19:00:00	SPY	ETF	149.38	149.43	149.34	149.42	32167.0
2013-01-22 04:00:00	QQQ	ETF	66.94	66.94	66.94	66.94	100.0
2013-01-22 05:00:00	QQQ	ETF	66.98	67.2	66.98	67.2	700.0
2013-01-22 06:00:00	QQQ	ETF	67.1	67.1	67.1	67.1	200.0
2013-01-22 07:00:00	QQQ	ETF	67.1	67.18	67.07	67.07	12629.0
2013-01-22 08:00:00	QQQ	ETF	67.09	67.15	67.0	67.14	170792.0
2013-01-22 09:00:00	QQQ	ETF	67.14	67.23	66.985	67.04	3832369.0
2013-01-22 10:00:00	QQQ	ETF	67.03	67.03	66.76	66.86	5235896.0
2013-01-22 11:00:00	QQQ	ETF	66.85	66.89	66.73	66.83	3569211.0
2013-01-22 12:00:00	QQQ	ETF	66.83	66.99	66.82	66.894	2561952.0
2013-01-22 13:00:00	QQQ	ETF	66.89	67.01	66.89	66.97	2794149.0
2013-01-22 14:00:00	QQQ	ETF	66.97	67.15	66.96	67.13	2027012.0
2013-01-22 15:00:00	QQQ	ETF	67.1299	67.21	66.98	67.2	4041983.0
2013-01-22 16:00:00	QQQ	ETF	67.2	67.55	66.97	67.52	5295300.0
2013-01-22 17:00:00	QQQ	ETF	67.53	67.61	67.53	67.55	80864.0
2013-01-22 18:00:00	QQQ	ETF	67.6	67.6	67.57	67.58	8860.0
2013-01-22 19:00:00	QQQ	ETF	67.58	67.6	67.57	67.6	10600.0
2013-01-22 04:00:00	IWM	ETF	88.44	88.44	88.44	88.44	207.0
2013-01-22 05:00:00	IWM	ETF	88.55	88.55	88.55	88.55	400.0
2013-01-22 07:00:00	IWM	ETF	88.6	88.61	88.49	88.51	27700.0
2013-01-22 08:00:00	IWM	ETF	88.63	88.63	88.46	88.54	106599.0
2013-01-22 09:00:00	IWM	ETF	88.58	88.76	88.53	88.53	4702109.0
2013-01-22 10:00:00	IWM	ETF	88.53	88.66	88.381	88.65	4769036.0
2013-01-22 11:00:00	IWM	ETF	88.65	88.98	88.59	88.87	3586331.0
2013-01-22 12:00:00	IWM	ETF	88.88	89.07	88.8799	88.93	2668039.0
2013-01-22 13:00:00	IWM	ETF	88.923	89.1	88.91	89.03	2007815.0
2013-01-22 14:00:00	IWM	ETF	89.03	89.15	88.99	89.129	1816726.0
2013-01-22 15:00:00	IWM	ETF	89.12	89.26	88.96	89.21	6522004.0
2013-01-22 16:00:00	IWM	ETF	89.22	89.43	89.19	89.35	1390961.0
2013-01-22 17:00:00	IWM	ETF	89.39	89.45	89.37	89.4	20480.0
2013-01-22 18:00:00	IWM	ETF	89.42	89.49	89.39	89.42	2800.0
2013-01-22 19:00:00	IWM	ETF	89.46	89.46	89.41	89.41	826.0
2013-01-22 05:00:00	DIA	ETF	136.0	136.0	136.0	136.0	200.0
2013-01-22 07:00:00	DIA	ETF	136.08	136.08	135.97	135.97	2792.0
2013-01-22 08:00:00	DIA	ETF	136.0	136.0	135.85	135.9	2800.0

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

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