PREVIEW / etf_1hour / 2014-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-24.parquet
  size:    225 KB
  rows:    7,434

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-07-24 04:00:00	SPY	ETF	198.47	198.89	198.47	198.89	5830.0
2014-07-24 05:00:00	SPY	ETF	198.88	198.89	198.79	198.79	13839.0
2014-07-24 06:00:00	SPY	ETF	198.83	198.94	198.82	198.93	27878.0
2014-07-24 07:00:00	SPY	ETF	198.9	199.09	198.9	198.99	187495.0
2014-07-24 08:00:00	SPY	ETF	198.96	199.04	198.37	198.96	470670.0
2014-07-24 09:00:00	SPY	ETF	198.94	198.97	198.6	198.65	8570693.0
2014-07-24 10:00:00	SPY	ETF	198.65	198.81	198.45	198.76	8421370.0
2014-07-24 11:00:00	SPY	ETF	198.76	199.06	198.72	198.93	6207276.0
2014-07-24 12:00:00	SPY	ETF	198.935	199.0	198.82	198.83	2937494.0
2014-07-24 13:00:00	SPY	ETF	198.83	198.91	198.6	198.91	6930477.0
2014-07-24 14:00:00	SPY	ETF	198.905	198.94	198.54	198.57	6040609.0
2014-07-24 15:00:00	SPY	ETF	198.56	198.84	198.47	198.65	11215192.0
2014-07-24 16:00:00	SPY	ETF	198.65	198.74	198.32	198.43	4548095.0
2014-07-24 17:00:00	SPY	ETF	198.42	198.44	198.17	198.35	224145.0
2014-07-24 18:00:00	SPY	ETF	198.34	198.38	198.24	198.36	65773.0
2014-07-24 19:00:00	SPY	ETF	198.33	198.38	198.28	198.36	52946.0
2014-07-24 04:00:00	QQQ	ETF	97.4	97.4	97.4	97.4	200.0
2014-07-24 05:00:00	QQQ	ETF	97.43	97.43	97.42	97.42	16200.0
2014-07-24 07:00:00	QQQ	ETF	97.46	97.53	97.45	97.47	84630.0
2014-07-24 08:00:00	QQQ	ETF	97.47	97.5	97.4	97.42	176589.0
2014-07-24 09:00:00	QQQ	ETF	97.42	97.51	97.12	97.17	4787589.0
2014-07-24 10:00:00	QQQ	ETF	97.17	97.19	96.98	97.17	4458319.0
2014-07-24 11:00:00	QQQ	ETF	97.18	97.4	97.13	97.35	2578841.0
2014-07-24 12:00:00	QQQ	ETF	97.355	97.41	97.17	97.17	1915387.0
2014-07-24 13:00:00	QQQ	ETF	97.17	97.26	97.025	97.26	1992700.0
2014-07-24 14:00:00	QQQ	ETF	97.27	97.33	97.08	97.1	2321097.0
2014-07-24 15:00:00	QQQ	ETF	97.095	97.26	97.05	97.13	3898505.0
2014-07-24 16:00:00	QQQ	ETF	97.12	97.2548	96.86	96.93	1439991.0
2014-07-24 17:00:00	QQQ	ETF	96.92	96.93	96.78	96.84	94045.0
2014-07-24 18:00:00	QQQ	ETF	96.86	96.86	96.74	96.78	119525.0
2014-07-24 19:00:00	QQQ	ETF	96.77	96.81	96.75	96.78	26151.0
2014-07-24 05:00:00	IWM	ETF	115.0	115.0	115.0	115.0	300.0
2014-07-24 06:00:00	IWM	ETF	115.0	115.1	115.0	115.1	690.0
2014-07-24 07:00:00	IWM	ETF	115.31	115.34	115.25	115.28	5699.0
2014-07-24 08:00:00	IWM	ETF	115.26	115.37	115.2	115.31	182864.0
2014-07-24 09:00:00	IWM	ETF	115.32	115.65	115.1	115.2	3837739.0
2014-07-24 10:00:00	IWM	ETF	115.21	115.21	114.79	114.99	4548153.0
2014-07-24 11:00:00	IWM	ETF	114.99	115.41	114.97	115.27	3011685.0
2014-07-24 12:00:00	IWM	ETF	115.28	115.34	114.97	114.97	1481931.0
2014-07-24 13:00:00	IWM	ETF	114.97	114.98	114.34	114.78	5040642.0
2014-07-24 14:00:00	IWM	ETF	114.775	114.775	114.53	114.57	2563289.0
2014-07-24 15:00:00	IWM	ETF	114.57	114.81	114.39	114.66	4124522.0
2014-07-24 16:00:00	IWM	ETF	114.66	115.6	114.32	114.4	1579997.0
2014-07-24 17:00:00	IWM	ETF	114.37	114.45	114.35	114.35	51170.0
2014-07-24 18:00:00	IWM	ETF	114.28	114.28	114.14	114.14	7150.0
2014-07-24 19:00:00	IWM	ETF	114.15	114.22	114.07	114.07	14513.0
2014-07-24 05:00:00	DIA	ETF	170.79	170.79	170.79	170.79	400.0
2014-07-24 07:00:00	DIA	ETF	170.86	170.88	170.77	170.78	1900.0
2014-07-24 08:00:00	DIA	ETF	170.79	170.79	170.73	170.75	5400.0
2014-07-24 09:00:00	DIA	ETF	170.79	170.87	170.43	170.63	515980.0

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

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