PREVIEW / etf_1hour / 2014-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-04.parquet
  size:    225 KB
  rows:    7,060

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-02-04 04:00:00	SPY	ETF	174.6	174.8	174.49	174.66	511288.0
2014-02-04 05:00:00	SPY	ETF	174.67	174.73	174.27	174.35	79025.0
2014-02-04 06:00:00	SPY	ETF	174.33	174.5	174.23	174.36	116910.0
2014-02-04 07:00:00	SPY	ETF	174.38	174.5	174.24	174.43	374937.0
2014-02-04 08:00:00	SPY	ETF	174.44	175.06	174.24	175.02	1830049.0
2014-02-04 09:00:00	SPY	ETF	174.99	175.295	174.34	175.15	27089473.0
2014-02-04 10:00:00	SPY	ETF	175.15	175.26	174.64	174.78	26373441.0
2014-02-04 11:00:00	SPY	ETF	174.78	175.59	174.68	175.57	18312445.0
2014-02-04 12:00:00	SPY	ETF	175.58	175.76	175.39	175.63	13672333.0
2014-02-04 13:00:00	SPY	ETF	175.64	175.84	175.01	175.1	15624622.0
2014-02-04 14:00:00	SPY	ETF	175.1	175.61	174.96	175.53	11836062.0
2014-02-04 15:00:00	SPY	ETF	175.52	175.65	174.84	175.39	34674552.0
2014-02-04 16:00:00	SPY	ETF	175.37	175.4353	174.1055	174.94	8623861.0
2014-02-04 17:00:00	SPY	ETF	174.94	174.94	174.68	174.92	1883853.0
2014-02-04 18:00:00	SPY	ETF	174.94	175.08	174.94	175.07	123012.0
2014-02-04 19:00:00	SPY	ETF	175.05	175.05	174.78	174.96	139496.0
2014-02-04 04:00:00	QQQ	ETF	84.53	84.53	84.53	84.53	100.0
2014-02-04 05:00:00	QQQ	ETF	84.44	84.44	84.39	84.39	8000.0
2014-02-04 06:00:00	QQQ	ETF	84.3	84.38	84.3	84.36	1900.0
2014-02-04 07:00:00	QQQ	ETF	84.38	84.48	84.36	84.44	17800.0
2014-02-04 08:00:00	QQQ	ETF	84.43	84.74	84.42	84.73	330522.0
2014-02-04 09:00:00	QQQ	ETF	84.73	84.91	84.46	84.86	6340962.0
2014-02-04 10:00:00	QQQ	ETF	84.86	84.94	84.54	84.62	7006769.0
2014-02-04 11:00:00	QQQ	ETF	84.63	85.18	84.58	85.17	4135015.0
2014-02-04 12:00:00	QQQ	ETF	85.16	85.2	85.01	85.16	2688949.0
2014-02-04 13:00:00	QQQ	ETF	85.16	85.25	84.9	84.91	3604271.0
2014-02-04 14:00:00	QQQ	ETF	84.91	85.14	84.84	85.13	2721891.0
2014-02-04 15:00:00	QQQ	ETF	85.13	85.18	84.76	84.95	7710417.0
2014-02-04 16:00:00	QQQ	ETF	84.94	85.084	84.7	84.75	993704.0
2014-02-04 17:00:00	QQQ	ETF	84.29	84.7	84.29	84.63	120288.0
2014-02-04 18:00:00	QQQ	ETF	84.65	84.77	84.64	84.73	68024.0
2014-02-04 19:00:00	QQQ	ETF	84.71	84.73	84.65	84.7	42330.0
2014-02-04 07:00:00	IWM	ETF	108.9	108.9	108.64	108.83	33194.0
2014-02-04 08:00:00	IWM	ETF	108.78	109.34	108.73	109.34	1005393.0
2014-02-04 09:00:00	IWM	ETF	109.34	109.51	108.4	109.45	9017705.0
2014-02-04 10:00:00	IWM	ETF	109.46	109.61	108.87	109.08	7511583.0
2014-02-04 11:00:00	IWM	ETF	109.08	109.83	108.995	109.81	4579727.0
2014-02-04 12:00:00	IWM	ETF	109.81	109.9205	109.6	109.8	5027194.0
2014-02-04 13:00:00	IWM	ETF	109.8	109.95	109.31	109.33	3981079.0
2014-02-04 14:00:00	IWM	ETF	109.34	109.655	109.19	109.595	3963490.0
2014-02-04 15:00:00	IWM	ETF	109.59	109.67	109.14	109.5	7942847.0
2014-02-04 16:00:00	IWM	ETF	109.5	109.7409	108.6435	109.07	2894333.0
2014-02-04 17:00:00	IWM	ETF	109.04	109.04	108.94	109.04	17690.0
2014-02-04 18:00:00	IWM	ETF	109.04	109.1	108.99	109.1	17570.0
2014-02-04 19:00:00	IWM	ETF	109.1	109.1	108.99	109.08	11956.0
2014-02-04 08:00:00	DIA	ETF	153.89	154.04	153.8	154.04	16220.0
2014-02-04 09:00:00	DIA	ETF	154.0	154.15	153.26	154.0	1754281.0
2014-02-04 10:00:00	DIA	ETF	154.0	154.15	153.63	153.77	1876608.0
2014-02-04 11:00:00	DIA	ETF	153.75	154.37	153.67	154.365	1567041.0
2014-02-04 12:00:00	DIA	ETF	154.34	154.48	154.18	154.37	895648.0

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

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