PREVIEW / etf_1hour / 2013-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-18.parquet
  size:    202 KB
  rows:    6,263

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-18 04:00:00	SPY	ETF	155.13	155.41	155.13	155.41	18386.0
2013-04-18 05:00:00	SPY	ETF	155.35	155.73	155.35	155.62	56743.0
2013-04-18 06:00:00	SPY	ETF	155.61	155.66	155.44	155.56	71600.0
2013-04-18 07:00:00	SPY	ETF	155.51	155.8	155.51	155.59	351839.0
2013-04-18 08:00:00	SPY	ETF	155.59	155.75	155.0	155.5	1037492.0
2013-04-18 09:00:00	SPY	ETF	155.51	155.53	154.5	154.65	19298124.0
2013-04-18 10:00:00	SPY	ETF	154.64	155.19	154.05	155.02	36253618.0
2013-04-18 11:00:00	SPY	ETF	155.02	155.055	154.2	154.4801	18578797.0
2013-04-18 12:00:00	SPY	ETF	154.49	155.1562	154.25	154.64	12977261.0
2013-04-18 13:00:00	SPY	ETF	154.65	154.86	154.31	154.46	9249444.0
2013-04-18 14:00:00	SPY	ETF	154.465	154.47	153.55	153.75	23819569.0
2013-04-18 15:00:00	SPY	ETF	153.74	155.1562	153.72	154.17	30470480.0
2013-04-18 16:00:00	SPY	ETF	154.18	154.3497	153.81	154.22	13389510.0
2013-04-18 17:00:00	SPY	ETF	154.23	154.28	154.09	154.15	214766.0
2013-04-18 18:00:00	SPY	ETF	154.15	154.31	154.01	154.23	106009.0
2013-04-18 19:00:00	SPY	ETF	154.27	154.34	154.23	154.32	61333.0
2013-04-18 04:00:00	QQQ	ETF	68.21	68.24	68.2	68.21	4100.0
2013-04-18 06:00:00	QQQ	ETF	68.3	68.36	68.3	68.36	1900.0
2013-04-18 07:00:00	QQQ	ETF	68.31	68.43	68.3	68.36	41900.0
2013-04-18 08:00:00	QQQ	ETF	68.38	68.42	68.33	68.34	163071.0
2013-04-18 09:00:00	QQQ	ETF	68.33	68.35	67.71	67.75	6166131.0
2013-04-18 10:00:00	QQQ	ETF	67.73	67.95	67.3	67.84	12632457.0
2013-04-18 11:00:00	QQQ	ETF	67.85	67.85	67.24	67.46	6697670.0
2013-04-18 12:00:00	QQQ	ETF	67.46	67.5011	67.33	67.45	2453858.0
2013-04-18 13:00:00	QQQ	ETF	67.45	67.54	67.27	67.35	3816845.0
2013-04-18 14:00:00	QQQ	ETF	67.35	67.35	66.88	66.975	7223099.0
2013-04-18 15:00:00	QQQ	ETF	66.98	67.24	66.9	67.16	9031236.0
2013-04-18 16:00:00	QQQ	ETF	67.16	68.1342	67.02	67.55	6413481.0
2013-04-18 17:00:00	QQQ	ETF	67.53	67.53	67.45	67.45	116139.0
2013-04-18 18:00:00	QQQ	ETF	67.44	67.54	67.4	67.51	45940.0
2013-04-18 19:00:00	QQQ	ETF	67.49	67.51	67.47	67.48	18759.0
2013-04-18 04:00:00	IWM	ETF	90.2	90.24	90.2	90.24	2000.0
2013-04-18 05:00:00	IWM	ETF	90.37	90.37	90.37	90.37	300.0
2013-04-18 07:00:00	IWM	ETF	90.42	90.58	90.4	90.4	97374.0
2013-04-18 08:00:00	IWM	ETF	90.41	90.51	90.27	90.27	70617.0
2013-04-18 09:00:00	IWM	ETF	90.28	90.32	89.65	89.74	7084403.0
2013-04-18 10:00:00	IWM	ETF	89.73	90.37	89.26	90.23	11988045.0
2013-04-18 11:00:00	IWM	ETF	90.23	90.28	89.49	89.68	7558377.0
2013-04-18 12:00:00	IWM	ETF	89.68	89.87	89.54	89.81	2909882.0
2013-04-18 13:00:00	IWM	ETF	89.8	90.0	89.62	89.67	2832462.0
2013-04-18 14:00:00	IWM	ETF	89.68	89.68	89.13	89.27	5697014.0
2013-04-18 15:00:00	IWM	ETF	89.27	89.59	89.13	89.58	8418762.0
2013-04-18 16:00:00	IWM	ETF	89.59	90.0608	89.37	89.72	1952623.0
2013-04-18 17:00:00	IWM	ETF	89.72	89.75	89.66	89.66	4100.0
2013-04-18 18:00:00	IWM	ETF	89.66	89.67	89.6	89.66	28949.0
2013-04-18 19:00:00	IWM	ETF	89.64	89.64	89.62	89.64	11100.0
2013-04-18 06:00:00	DIA	ETF	146.38	146.39	146.38	146.38	6200.0
2013-04-18 07:00:00	DIA	ETF	146.48	146.58	146.48	146.51	3700.0
2013-04-18 08:00:00	DIA	ETF	146.4	146.42	146.27	146.36	11494.0
2013-04-18 09:00:00	DIA	ETF	146.31	146.31	145.425	145.548	1079591.0

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

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