PREVIEW / etf_1hour / 2014-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-25.parquet
  size:    217 KB
  rows:    6,908

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-25 04:00:00	SPY	ETF	194.8	194.91	194.65	194.91	4956.0
2014-06-25 05:00:00	SPY	ETF	194.89	195.04	194.86	194.86	6105.0
2014-06-25 06:00:00	SPY	ETF	194.85	195.04	194.83	195.04	44818.0
2014-06-25 07:00:00	SPY	ETF	195.01	195.06	194.82	194.85	188385.0
2014-06-25 08:00:00	SPY	ETF	194.85	194.9	194.25	194.52	2055688.0
2014-06-25 09:00:00	SPY	ETF	194.52	195.1	194.24	194.91	12632882.0
2014-06-25 10:00:00	SPY	ETF	194.92	195.35	194.67	195.32	14192228.0
2014-06-25 11:00:00	SPY	ETF	195.31	195.38	194.96	195.1	12397138.0
2014-06-25 12:00:00	SPY	ETF	195.1001	195.21	195.04	195.115	6267109.0
2014-06-25 13:00:00	SPY	ETF	195.11	195.51	195.11	195.46	5207125.0
2014-06-25 14:00:00	SPY	ETF	195.47	195.58	195.35	195.39	8151428.0
2014-06-25 15:00:00	SPY	ETF	195.38	195.781	195.32	195.56	15044681.0
2014-06-25 16:00:00	SPY	ETF	195.56	195.6	194.6727	195.39	4823012.0
2014-06-25 17:00:00	SPY	ETF	195.38	195.58	195.32	195.35	523781.0
2014-06-25 18:00:00	SPY	ETF	195.34	195.45	195.31	195.43	49548.0
2014-06-25 19:00:00	SPY	ETF	195.43	195.44	195.4	195.42	36192.0
2014-06-25 08:00:00	QQQ	ETF	92.71	92.74	92.47	92.6	354499.0
2014-06-25 09:00:00	QQQ	ETF	92.61	92.92	92.48	92.73	4616178.0
2014-06-25 10:00:00	QQQ	ETF	92.74	92.94	92.6	92.92	4879047.0
2014-06-25 11:00:00	QQQ	ETF	92.92	93.08	92.84	92.92	3422676.0
2014-06-25 12:00:00	QQQ	ETF	92.915	93.01	92.89	92.98	1436154.0
2014-06-25 13:00:00	QQQ	ETF	92.98	93.25	92.975	93.22	2298848.0
2014-06-25 14:00:00	QQQ	ETF	93.22	93.29	93.15	93.21	2250102.0
2014-06-25 15:00:00	QQQ	ETF	93.21	93.45	92.79	92.79	4609491.0
2014-06-25 16:00:00	QQQ	ETF	93.29	93.3696	92.8966	93.23	2631656.0
2014-06-25 17:00:00	QQQ	ETF	93.3282	93.3282	93.2	93.29	2852734.0
2014-06-25 18:00:00	QQQ	ETF	93.19	93.22	93.19	93.22	16899.0
2014-06-25 19:00:00	QQQ	ETF	93.22	93.23	93.21	93.21	6441.0
2014-06-25 04:00:00	IWM	ETF	116.59	116.59	116.59	116.59	200.0
2014-06-25 07:00:00	IWM	ETF	116.83	116.83	116.67	116.69	3500.0
2014-06-25 08:00:00	IWM	ETF	116.69	116.74	115.66	116.08	1269573.0
2014-06-25 09:00:00	IWM	ETF	116.08	117.14	115.94	116.83	6650484.0
2014-06-25 10:00:00	IWM	ETF	116.85	117.09	116.345	117.03	6725477.0
2014-06-25 11:00:00	IWM	ETF	117.04	117.1	116.54	116.82	3738491.0
2014-06-25 12:00:00	IWM	ETF	116.83	117.07	116.75	116.98	1792976.0
2014-06-25 13:00:00	IWM	ETF	116.99	117.43	116.97	117.42	1938285.0
2014-06-25 14:00:00	IWM	ETF	117.42	117.67	117.3	117.43	2666298.0
2014-06-25 15:00:00	IWM	ETF	117.44	117.79	117.34	117.74	4430021.0
2014-06-25 16:00:00	IWM	ETF	117.74	117.8	116.4358	117.63	1026733.0
2014-06-25 17:00:00	IWM	ETF	117.64	117.75	117.62	117.7	242230.0
2014-06-25 08:00:00	DIA	ETF	167.93	168.0	167.5	167.61	10225.0
2014-06-25 09:00:00	DIA	ETF	167.67	168.23	167.5	168.05	778118.0
2014-06-25 10:00:00	DIA	ETF	168.07	168.47	167.9301	168.45	682665.0
2014-06-25 11:00:00	DIA	ETF	168.44	168.48	168.09	168.15	534048.0
2014-06-25 12:00:00	DIA	ETF	168.13	168.17	167.97	167.99	256750.0
2014-06-25 13:00:00	DIA	ETF	168.02	168.32	168.02	168.28	296544.0
2014-06-25 14:00:00	DIA	ETF	168.27	168.29	168.11	168.12	283072.0
2014-06-25 15:00:00	DIA	ETF	168.13	168.42	168.07	168.29	511488.0
2014-06-25 16:00:00	DIA	ETF	168.3	168.357	168.18	168.18	98375.0
2014-06-25 19:00:00	DIA	ETF	168.23	168.23	168.23	168.23	600.0

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

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