PREVIEW / etf_1hour / 2014-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-29.parquet
  size:    235 KB
  rows:    7,595

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-12-29 04:00:00	SPY	ETF	208.4	208.4	208.05	208.05	24175.0
2014-12-29 05:00:00	SPY	ETF	208.1	208.17	207.64	207.94	120009.0
2014-12-29 06:00:00	SPY	ETF	208.01	208.22	207.91	208.16	225461.0
2014-12-29 07:00:00	SPY	ETF	208.18	208.21	207.8	207.87	141246.0
2014-12-29 08:00:00	SPY	ETF	207.87	208.23	207.81	208.17	519694.0
2014-12-29 09:00:00	SPY	ETF	208.18	208.8	208.0247	208.75	15255975.0
2014-12-29 10:00:00	SPY	ETF	208.75	208.96	208.66	208.89	10281628.0
2014-12-29 11:00:00	SPY	ETF	208.89	208.97	208.78	208.85	5464585.0
2014-12-29 12:00:00	SPY	ETF	208.85	208.95	208.61	208.615	8948974.0
2014-12-29 13:00:00	SPY	ETF	208.61	208.86	208.575	208.7099	5673164.0
2014-12-29 14:00:00	SPY	ETF	208.705	208.84	208.6461	208.8299	11320961.0
2014-12-29 15:00:00	SPY	ETF	208.83	208.92	208.61	208.73	11677124.0
2014-12-29 16:00:00	SPY	ETF	208.75	208.92	208.6395	208.92	6733429.0
2014-12-29 17:00:00	SPY	ETF	208.92	208.92	208.72	208.86	2601784.0
2014-12-29 18:00:00	SPY	ETF	208.89	208.92	208.8	208.88	65128.0
2014-12-29 19:00:00	SPY	ETF	208.88	208.93	208.85	208.93	46821.0
2014-12-29 05:00:00	QQQ	ETF	105.02	105.02	104.79	104.8	6100.0
2014-12-29 06:00:00	QQQ	ETF	104.83	104.86	104.81	104.84	4500.0
2014-12-29 07:00:00	QQQ	ETF	104.94	104.94	104.73	104.77	21800.0
2014-12-29 08:00:00	QQQ	ETF	104.79	104.98	104.72	104.91	77633.0
2014-12-29 09:00:00	QQQ	ETF	104.9	105.17	104.85	105.07	4468196.0
2014-12-29 10:00:00	QQQ	ETF	105.07	105.16	104.93	105.1372	3234501.0
2014-12-29 11:00:00	QQQ	ETF	105.13	105.25	105.0961	105.176	1899299.0
2014-12-29 12:00:00	QQQ	ETF	105.17	105.201	105.08	105.09	1042564.0
2014-12-29 13:00:00	QQQ	ETF	105.09	105.18	104.99	105.0132	903239.0
2014-12-29 14:00:00	QQQ	ETF	105.02	105.11	104.96	105.09	1178306.0
2014-12-29 15:00:00	QQQ	ETF	105.09	105.12	104.99	105.03	1947792.0
2014-12-29 16:00:00	QQQ	ETF	105.04	105.18	104.9974	105.18	710934.0
2014-12-29 17:00:00	QQQ	ETF	105.19	105.19	105.02	105.18	939407.0
2014-12-29 18:00:00	QQQ	ETF	105.17	105.18	105.14	105.15	3812.0
2014-12-29 19:00:00	QQQ	ETF	105.16	105.18	105.16	105.16	12533.0
2014-12-29 05:00:00	IWM	ETF	120.39	120.48	120.39	120.48	1100.0
2014-12-29 06:00:00	IWM	ETF	120.62	120.72	120.62	120.72	600.0
2014-12-29 07:00:00	IWM	ETF	120.76	120.76	120.56	120.57	15100.0
2014-12-29 08:00:00	IWM	ETF	120.59	120.7	120.46	120.7	60277.0
2014-12-29 09:00:00	IWM	ETF	120.69	121.38	120.59	121.18	5032736.0
2014-12-29 10:00:00	IWM	ETF	121.19	121.34	120.86	121.08	3840905.0
2014-12-29 11:00:00	IWM	ETF	121.07	121.15	120.93	120.9999	2147877.0
2014-12-29 12:00:00	IWM	ETF	121.0	121.14	120.97	121.06	1946659.0
2014-12-29 13:00:00	IWM	ETF	121.06	121.11	120.83	120.9	1700156.0
2014-12-29 14:00:00	IWM	ETF	120.8966	121.0	120.75	120.945	2022063.0
2014-12-29 15:00:00	IWM	ETF	120.95	121.12	120.82	121.06	3341048.0
2014-12-29 16:00:00	IWM	ETF	121.07	121.16	120.9944	121.16	1184346.0
2014-12-29 17:00:00	IWM	ETF	121.19	121.21	121.05	121.21	253694.0
2014-12-29 18:00:00	IWM	ETF	121.19	121.19	121.17	121.17	481.0
2014-12-29 19:00:00	IWM	ETF	121.17	121.2	121.17	121.2	1596.0
2014-12-29 05:00:00	DIA	ETF	179.78	179.78	179.78	179.78	150.0
2014-12-29 07:00:00	DIA	ETF	179.8	179.8	179.8	179.8	150.0
2014-12-29 08:00:00	DIA	ETF	179.87	179.88	179.77	179.84	11749.0
2014-12-29 09:00:00	DIA	ETF	179.88	180.38	179.81	180.3	591716.0

> showing 50 of 7,595 rows — these rows as CSV

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