PREVIEW / etf_1hour / 2013-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-22.parquet
  size:    199 KB
  rows:    6,181

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-22 04:00:00	SPY	ETF	155.69	156.01	155.65	156.0	11524.0
2013-04-22 05:00:00	SPY	ETF	156.04	156.15	156.03	156.12	146540.0
2013-04-22 06:00:00	SPY	ETF	156.12	156.15	156.01	156.07	588348.0
2013-04-22 07:00:00	SPY	ETF	156.09	156.11	155.78	155.82	654677.0
2013-04-22 08:00:00	SPY	ETF	155.82	156.08	155.55	155.69	576809.0
2013-04-22 09:00:00	SPY	ETF	155.68	155.99	155.19	155.54	14483299.0
2013-04-22 10:00:00	SPY	ETF	155.53	155.56	154.75	155.26	25619124.0
2013-04-22 11:00:00	SPY	ETF	155.26	155.65	155.05	155.56	10454542.0
2013-04-22 12:00:00	SPY	ETF	155.56	156.0	155.56	155.8	7176079.0
2013-04-22 13:00:00	SPY	ETF	155.809	155.99	155.7	155.82	8996583.0
2013-04-22 14:00:00	SPY	ETF	155.81	156.54	155.81	156.29	11683644.0
2013-04-22 15:00:00	SPY	ETF	156.29	156.43	156.12	156.18	13532949.0
2013-04-22 16:00:00	SPY	ETF	156.18	156.27	155.8793	156.26	6356244.0
2013-04-22 17:00:00	SPY	ETF	156.25	156.3	156.21	156.25	172544.0
2013-04-22 18:00:00	SPY	ETF	156.2	156.2	156.06	156.08	62419.0
2013-04-22 19:00:00	SPY	ETF	156.08	156.08	156.0	156.03	30495.0
2013-04-22 04:00:00	QQQ	ETF	68.24	68.39	68.24	68.39	1348.0
2013-04-22 05:00:00	QQQ	ETF	68.42	68.47	68.42	68.47	500.0
2013-04-22 06:00:00	QQQ	ETF	68.48	68.48	68.43	68.43	1600.0
2013-04-22 07:00:00	QQQ	ETF	68.43	68.46	68.27	68.32	25042.0
2013-04-22 08:00:00	QQQ	ETF	68.33	68.39	68.18	68.22	136995.0
2013-04-22 09:00:00	QQQ	ETF	68.21	68.57	68.17	68.49	5146623.0
2013-04-22 10:00:00	QQQ	ETF	68.49	68.5	68.08	68.35	5933112.0
2013-04-22 11:00:00	QQQ	ETF	68.36	68.55	68.279	68.5	3221025.0
2013-04-22 12:00:00	QQQ	ETF	68.51	68.75	68.49	68.64	2319383.0
2013-04-22 13:00:00	QQQ	ETF	68.64	68.74	68.57	68.62	1823121.0
2013-04-22 14:00:00	QQQ	ETF	68.6101	68.98	68.61	68.9201	2964803.0
2013-04-22 15:00:00	QQQ	ETF	68.92	69.04	68.79	68.8	4639878.0
2013-04-22 16:00:00	QQQ	ETF	68.8	68.94	68.426	68.8	3620847.0
2013-04-22 17:00:00	QQQ	ETF	68.8	68.81	68.79	68.8	27553.0
2013-04-22 18:00:00	QQQ	ETF	68.78	68.78	68.71	68.71	40015.0
2013-04-22 19:00:00	QQQ	ETF	68.74	68.75	68.71	68.73	13961.0
2013-04-22 04:00:00	IWM	ETF	90.9	91.0	90.9	91.0	2100.0
2013-04-22 06:00:00	IWM	ETF	91.11	91.11	91.05	91.06	2500.0
2013-04-22 07:00:00	IWM	ETF	91.03	91.11	90.9	90.9	98250.0
2013-04-22 08:00:00	IWM	ETF	90.88	91.01	90.67	90.72	115831.0
2013-04-22 09:00:00	IWM	ETF	90.72	90.92	89.56	89.91	9242674.0
2013-04-22 10:00:00	IWM	ETF	89.91	89.96	89.2	89.9	11395863.0
2013-04-22 11:00:00	IWM	ETF	89.91	90.2	89.72	90.16	3631554.0
2013-04-22 12:00:00	IWM	ETF	90.17	90.66	90.17	90.57	4708888.0
2013-04-22 13:00:00	IWM	ETF	90.58	90.86	90.44	90.64	3803316.0
2013-04-22 14:00:00	IWM	ETF	90.635	91.07	90.6301	90.86	3530602.0
2013-04-22 15:00:00	IWM	ETF	90.855	91.05	90.72	90.84	5523553.0
2013-04-22 16:00:00	IWM	ETF	90.85	90.97	90.83	90.96	2501923.0
2013-04-22 17:00:00	IWM	ETF	91.01	91.03	90.99	90.99	38982.0
2013-04-22 18:00:00	IWM	ETF	90.93	90.93	90.93	90.93	1000.0
2013-04-22 19:00:00	IWM	ETF	90.95	90.95	90.91	90.91	2400.0
2013-04-22 04:00:00	DIA	ETF	145.43	145.48	145.43	145.48	1200.0
2013-04-22 05:00:00	DIA	ETF	145.65	145.65	145.65	145.65	200.0
2013-04-22 06:00:00	DIA	ETF	145.64	145.7	145.64	145.7	800.0

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

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