PREVIEW / etf_1hour / 2014-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-11.parquet
  size:    211 KB
  rows:    6,773

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-11 04:00:00	SPY	ETF	195.35	195.36	195.31	195.32	1136.0
2014-06-11 05:00:00	SPY	ETF	195.24	195.4	194.99	194.99	15060.0
2014-06-11 06:00:00	SPY	ETF	194.97	195.07	194.81	194.81	93123.0
2014-06-11 07:00:00	SPY	ETF	194.88	194.91	194.6	194.75	602345.0
2014-06-11 08:00:00	SPY	ETF	194.65	194.88	194.65	194.79	720900.0
2014-06-11 09:00:00	SPY	ETF	194.79	195.12	194.75	194.96	7851634.0
2014-06-11 10:00:00	SPY	ETF	194.95	195.11	194.67	194.76	8912164.0
2014-06-11 11:00:00	SPY	ETF	194.765	195.055	194.765	195.05	6181457.0
2014-06-11 12:00:00	SPY	ETF	195.045	195.1	194.96	195.05	3991209.0
2014-06-11 13:00:00	SPY	ETF	195.05	195.055	194.71	194.71	4157155.0
2014-06-11 14:00:00	SPY	ETF	194.71	194.83	194.48	194.75	8193441.0
2014-06-11 15:00:00	SPY	ETF	194.75	195.1	194.745	194.94	17252239.0
2014-06-11 16:00:00	SPY	ETF	194.95	195.5803	194.89	195.0	8511454.0
2014-06-11 17:00:00	SPY	ETF	195.0	195.05	194.99	195.03	78279.0
2014-06-11 18:00:00	SPY	ETF	195.01	195.01	194.89	195.0	41579.0
2014-06-11 19:00:00	SPY	ETF	195.0	195.06	195.0	195.06	27516.0
2014-06-11 04:00:00	QQQ	ETF	92.81	92.81	92.81	92.81	100.0
2014-06-11 05:00:00	QQQ	ETF	92.76	92.76	92.65	92.65	400.0
2014-06-11 06:00:00	QQQ	ETF	92.63	92.7	92.56	92.57	23416.0
2014-06-11 07:00:00	QQQ	ETF	92.55	92.55	92.42	92.49	74500.0
2014-06-11 08:00:00	QQQ	ETF	92.48	92.56	92.47	92.5	69151.0
2014-06-11 09:00:00	QQQ	ETF	92.5	92.92	92.48	92.83	3817461.0
2014-06-11 10:00:00	QQQ	ETF	92.83	92.97	92.74	92.82	2880096.0
2014-06-11 11:00:00	QQQ	ETF	92.82	93.02	92.79	92.975	2472202.0
2014-06-11 12:00:00	QQQ	ETF	92.975	92.99	92.895	92.99	1303308.0
2014-06-11 13:00:00	QQQ	ETF	92.99	92.99	92.69	92.7	1997822.0
2014-06-11 14:00:00	QQQ	ETF	92.7	92.74	92.5	92.7004	2527111.0
2014-06-11 15:00:00	QQQ	ETF	92.705	92.93	92.68	92.86	3560749.0
2014-06-11 16:00:00	QQQ	ETF	92.86	92.9309	92.84	92.89	1759406.0
2014-06-11 17:00:00	QQQ	ETF	92.92	92.92	92.9	92.9	84200.0
2014-06-11 18:00:00	QQQ	ETF	92.9	92.9	92.84	92.87	5850.0
2014-06-11 19:00:00	QQQ	ETF	92.91	92.91	92.9	92.91	3815.0
2014-06-11 05:00:00	IWM	ETF	116.3	116.3	116.3	116.3	250.0
2014-06-11 06:00:00	IWM	ETF	116.0	116.11	116.0	116.05	10300.0
2014-06-11 07:00:00	IWM	ETF	116.05	116.07	115.78	115.88	89425.0
2014-06-11 08:00:00	IWM	ETF	115.88	116.67	115.82	115.9	3112711.0
2014-06-11 09:00:00	IWM	ETF	115.9	116.33	115.86	116.2	2992983.0
2014-06-11 10:00:00	IWM	ETF	116.19	116.33	115.75	115.91	4100537.0
2014-06-11 11:00:00	IWM	ETF	115.91	116.25	115.87	116.13	3057233.0
2014-06-11 12:00:00	IWM	ETF	116.13	116.23	116.07	116.19	1011956.0
2014-06-11 13:00:00	IWM	ETF	116.2	116.2	115.86	115.88	1494330.0
2014-06-11 14:00:00	IWM	ETF	115.88	115.9	115.4	115.83	4578776.0
2014-06-11 15:00:00	IWM	ETF	115.84	116.2	115.83	116.08	4488577.0
2014-06-11 16:00:00	IWM	ETF	116.08	116.3152	116.02	116.06	1334589.0
2014-06-11 17:00:00	IWM	ETF	116.03	116.09	116.02	116.02	73690.0
2014-06-11 18:00:00	IWM	ETF	116.09	116.09	116.0	116.04	2106.0
2014-06-11 19:00:00	IWM	ETF	116.0	116.07	116.0	116.01	2823.0
2014-06-11 06:00:00	DIA	ETF	168.8	168.8	168.8	168.8	100.0
2014-06-11 07:00:00	DIA	ETF	168.61	168.61	168.61	168.61	100.0
2014-06-11 08:00:00	DIA	ETF	168.8	168.88	168.66	168.7	2925.0

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

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