PREVIEW / etf_1hour / 2014-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-22.parquet
  size:    218 KB
  rows:    6,884

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
2014-01-22 04:00:00	SPY	ETF	184.3	184.33	184.16	184.16	4781.0
2014-01-22 05:00:00	SPY	ETF	184.21	184.21	183.97	184.01	21251.0
2014-01-22 06:00:00	SPY	ETF	183.92	184.1	183.9	184.06	5773.0
2014-01-22 07:00:00	SPY	ETF	184.14	184.2	184.01	184.04	129536.0
2014-01-22 08:00:00	SPY	ETF	184.06	184.36	183.99	184.29	276430.0
2014-01-22 09:00:00	SPY	ETF	184.3	184.6	184.11	184.23	8772192.0
2014-01-22 10:00:00	SPY	ETF	184.23	184.45	183.93	183.989	11412470.0
2014-01-22 11:00:00	SPY	ETF	183.98	184.21	183.91	184.099	7481130.0
2014-01-22 12:00:00	SPY	ETF	184.1	184.44	184.02	184.37	5563547.0
2014-01-22 13:00:00	SPY	ETF	184.37	184.52	184.12	184.24	6237978.0
2014-01-22 14:00:00	SPY	ETF	184.24	184.43	184.2	184.34	4528432.0
2014-01-22 15:00:00	SPY	ETF	184.34	184.57	184.31	184.35	11092763.0
2014-01-22 16:00:00	SPY	ETF	184.35	184.4555	183.98	184.31	4330311.0
2014-01-22 17:00:00	SPY	ETF	184.33	184.34	184.17	184.26	281868.0
2014-01-22 18:00:00	SPY	ETF	184.26	184.74	184.26	184.71	341556.0
2014-01-22 19:00:00	SPY	ETF	184.64	184.67	184.54	184.55	160575.0
2014-01-22 04:00:00	QQQ	ETF	88.6	88.62	88.6	88.62	333.0
2014-01-22 06:00:00	QQQ	ETF	88.52	88.54	88.52	88.54	3100.0
2014-01-22 07:00:00	QQQ	ETF	88.55	88.61	88.52	88.52	20900.0
2014-01-22 08:00:00	QQQ	ETF	88.57	88.73	88.51	88.7	99509.0
2014-01-22 09:00:00	QQQ	ETF	88.7	88.8	88.55	88.645	3272573.0
2014-01-22 10:00:00	QQQ	ETF	88.65	88.82	88.52	88.65	4189902.0
2014-01-22 11:00:00	QQQ	ETF	88.65	88.81	88.6166	88.78	2490275.0
2014-01-22 12:00:00	QQQ	ETF	88.78	88.96	88.739	88.9299	1675084.0
2014-01-22 13:00:00	QQQ	ETF	88.92	89.0	88.76	88.82	1976225.0
2014-01-22 14:00:00	QQQ	ETF	88.83	88.92	88.7701	88.81	1658151.0
2014-01-22 15:00:00	QQQ	ETF	88.81	88.93	88.8	88.83	3716161.0
2014-01-22 16:00:00	QQQ	ETF	88.82	89.02	88.5829	88.97	3169405.0
2014-01-22 17:00:00	QQQ	ETF	88.55	88.98	88.55	88.95	223100.0
2014-01-22 18:00:00	QQQ	ETF	88.93	89.16	88.93	89.15	25670.0
2014-01-22 19:00:00	QQQ	ETF	89.12	89.16	89.07	89.08	21632.0
2014-01-22 07:00:00	IWM	ETF	116.55	116.55	116.48	116.48	3250.0
2014-01-22 08:00:00	IWM	ETF	116.47	116.69	116.44	116.63	33645.0
2014-01-22 09:00:00	IWM	ETF	116.65	116.85	116.62	116.73	2503948.0
2014-01-22 10:00:00	IWM	ETF	116.73	116.87	116.5	116.64	3147757.0
2014-01-22 11:00:00	IWM	ETF	116.65	116.97	116.598	116.92	2190584.0
2014-01-22 12:00:00	IWM	ETF	116.93	117.25	116.88	117.18	2676695.0
2014-01-22 13:00:00	IWM	ETF	117.185	117.24	117.0	117.07	1893068.0
2014-01-22 14:00:00	IWM	ETF	117.06	117.21	117.05	117.19	1640891.0
2014-01-22 15:00:00	IWM	ETF	117.19	117.37	117.13	117.21	4998945.0
2014-01-22 16:00:00	IWM	ETF	117.2	117.35	116.8	117.29	1388613.0
2014-01-22 17:00:00	IWM	ETF	117.27	117.27	117.27	117.27	1000.0
2014-01-22 18:00:00	IWM	ETF	117.3	117.45	117.3	117.45	6896.0
2014-01-22 19:00:00	IWM	ETF	117.4	117.44	117.39	117.42	1144.0
2014-01-22 07:00:00	DIA	ETF	163.48	163.48	163.41	163.41	300.0
2014-01-22 08:00:00	DIA	ETF	163.4	163.6	163.4	163.6	1700.0
2014-01-22 09:00:00	DIA	ETF	163.6	163.86	163.34	163.56	941502.0
2014-01-22 10:00:00	DIA	ETF	163.55	163.73	163.1289	163.16	934227.0
2014-01-22 11:00:00	DIA	ETF	163.16	163.29	162.99	163.24	727315.0
2014-01-22 12:00:00	DIA	ETF	163.235	163.53	163.16	163.44	423667.0

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

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