PREVIEW / etf_1hour / 2014-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-26.parquet
  size:    214 KB
  rows:    6,804

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-06-26 04:00:00	SPY	ETF	195.36	195.37	195.25	195.3	6425.0
2014-06-26 05:00:00	SPY	ETF	195.54	195.54	195.38	195.38	2250.0
2014-06-26 06:00:00	SPY	ETF	195.34	195.42	195.25	195.29	9450.0
2014-06-26 07:00:00	SPY	ETF	195.29	195.42	195.24	195.4	91096.0
2014-06-26 08:00:00	SPY	ETF	195.32	195.54	195.32	195.41	455861.0
2014-06-26 09:00:00	SPY	ETF	195.38	195.73	194.13	194.46	27642420.0
2014-06-26 10:00:00	SPY	ETF	194.45	194.84	194.36	194.67	16591605.0
2014-06-26 11:00:00	SPY	ETF	194.67	194.97	194.57	194.89	8646658.0
2014-06-26 12:00:00	SPY	ETF	194.885	194.94	194.71	194.72	3783983.0
2014-06-26 13:00:00	SPY	ETF	194.72	195.35	194.7	195.2285	6552164.0
2014-06-26 14:00:00	SPY	ETF	195.22	195.32	195.09	195.215	5865859.0
2014-06-26 15:00:00	SPY	ETF	195.22	195.48	195.19	195.44	10320991.0
2014-06-26 16:00:00	SPY	ETF	195.45	195.48	194.7914	195.44	3943081.0
2014-06-26 17:00:00	SPY	ETF	195.39	195.39	195.32	195.35	57884.0
2014-06-26 18:00:00	SPY	ETF	195.33	195.38	195.29	195.36	14931.0
2014-06-26 19:00:00	SPY	ETF	195.38	195.39	195.37	195.37	21923.0
2014-06-26 06:00:00	QQQ	ETF	93.17	93.17	93.17	93.17	2500.0
2014-06-26 07:00:00	QQQ	ETF	93.19	93.31	93.19	93.3	6400.0
2014-06-26 08:00:00	QQQ	ETF	93.3	93.35	93.25	93.29	79281.0
2014-06-26 09:00:00	QQQ	ETF	93.28	93.41	92.62	92.83	5232222.0
2014-06-26 10:00:00	QQQ	ETF	92.83	92.98	92.7142	92.875	4853310.0
2014-06-26 11:00:00	QQQ	ETF	92.88	93.04	92.84	93.0	2162272.0
2014-06-26 12:00:00	QQQ	ETF	93.0	93.02	92.871	92.89	1595513.0
2014-06-26 13:00:00	QQQ	ETF	92.892	93.2	92.89	93.14	2486377.0
2014-06-26 14:00:00	QQQ	ETF	93.15	93.21	93.06	93.16	1863168.0
2014-06-26 15:00:00	QQQ	ETF	93.16	93.35	93.145	93.34	2859783.0
2014-06-26 16:00:00	QQQ	ETF	93.34	93.355	93.0051	93.34	1063051.0
2014-06-26 17:00:00	QQQ	ETF	93.32	93.34	93.32	93.34	6067.0
2014-06-26 18:00:00	QQQ	ETF	93.31	93.33	93.31	93.33	1400.0
2014-06-26 19:00:00	QQQ	ETF	93.33	93.34	93.31	93.31	5477.0
2014-06-26 07:00:00	IWM	ETF	117.75	117.75	117.75	117.75	13000.0
2014-06-26 08:00:00	IWM	ETF	117.75	117.83	117.6	117.64	109800.0
2014-06-26 09:00:00	IWM	ETF	117.61	117.87	116.59	117.0	6308539.0
2014-06-26 10:00:00	IWM	ETF	117.0	117.32	116.7	117.07	5969534.0
2014-06-26 11:00:00	IWM	ETF	117.07	117.33	116.9	117.24	2831843.0
2014-06-26 12:00:00	IWM	ETF	117.245	117.28	117.02	117.13	1772398.0
2014-06-26 13:00:00	IWM	ETF	117.14	117.565	117.12	117.395	1656713.0
2014-06-26 14:00:00	IWM	ETF	117.4	117.465	117.23	117.385	1401173.0
2014-06-26 15:00:00	IWM	ETF	117.39	117.63	117.36	117.55	4088810.0
2014-06-26 16:00:00	IWM	ETF	117.56	117.65	117.28	117.64	1399843.0
2014-06-26 17:00:00	IWM	ETF	117.64	117.64	117.58	117.58	3815.0
2014-06-26 18:00:00	IWM	ETF	117.41	117.6	117.41	117.6	400.0
2014-06-26 06:00:00	DIA	ETF	168.05	168.05	168.03	168.03	800.0
2014-06-26 08:00:00	DIA	ETF	168.25	168.29	168.25	168.29	700.0
2014-06-26 09:00:00	DIA	ETF	168.16	168.46	167.06	167.17	1181768.0
2014-06-26 10:00:00	DIA	ETF	167.17	167.54	167.13	167.38	765827.0
2014-06-26 11:00:00	DIA	ETF	167.41	167.7	167.34	167.61	414752.0
2014-06-26 12:00:00	DIA	ETF	167.64	167.65	167.42	167.4299	196741.0
2014-06-26 13:00:00	DIA	ETF	167.421	168.08	167.421	168.01	457865.0
2014-06-26 14:00:00	DIA	ETF	168.0	168.07	167.92	167.985	196646.0

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

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