PREVIEW / etf_1hour / 2014-07-14

all etf 1-hour files

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

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-14 04:00:00	SPY	ETF	196.9	197.43	196.9	197.43	2940.0
2014-07-14 05:00:00	SPY	ETF	197.31	197.38	197.22	197.34	9688.0
2014-07-14 06:00:00	SPY	ETF	197.33	197.4	197.31	197.31	61194.0
2014-07-14 07:00:00	SPY	ETF	197.31	197.5	197.29	197.5	603797.0
2014-07-14 08:00:00	SPY	ETF	197.48	197.62	196.9	197.51	806974.0
2014-07-14 09:00:00	SPY	ETF	197.5	197.78	196.6	197.61	9265171.0
2014-07-14 10:00:00	SPY	ETF	197.6	197.82	197.56	197.745	7988218.0
2014-07-14 11:00:00	SPY	ETF	197.75	197.86	197.68	197.695	5788819.0
2014-07-14 12:00:00	SPY	ETF	197.69	197.79	197.52	197.6	4466811.0
2014-07-14 13:00:00	SPY	ETF	197.6	197.71	197.57	197.665	4808798.0
2014-07-14 14:00:00	SPY	ETF	197.67	197.72	197.57	197.715	6549208.0
2014-07-14 15:00:00	SPY	ETF	197.71	197.72	197.48	197.59	12592781.0
2014-07-14 16:00:00	SPY	ETF	197.59	197.8	197.53	197.58	3837531.0
2014-07-14 17:00:00	SPY	ETF	197.59	197.62	197.59	197.61	655368.0
2014-07-14 18:00:00	SPY	ETF	197.58	197.62	197.57	197.57	17577.0
2014-07-14 19:00:00	SPY	ETF	197.58	197.59	197.53	197.58	69630.0
2014-07-14 04:00:00	QQQ	ETF	95.33	95.69	95.33	95.69	600.0
2014-07-14 05:00:00	QQQ	ETF	95.58	95.71	95.58	95.71	2800.0
2014-07-14 06:00:00	QQQ	ETF	95.75	95.75	95.73	95.73	200.0
2014-07-14 07:00:00	QQQ	ETF	95.65	95.73	95.65	95.73	162500.0
2014-07-14 08:00:00	QQQ	ETF	95.73	95.75	95.67	95.68	166029.0
2014-07-14 09:00:00	QQQ	ETF	95.68	95.76	95.535	95.71	3186631.0
2014-07-14 10:00:00	QQQ	ETF	95.7	95.95	95.7	95.91	2895587.0
2014-07-14 11:00:00	QQQ	ETF	95.92	96.055	95.88	95.91	2369304.0
2014-07-14 12:00:00	QQQ	ETF	95.905	96.03	95.81	95.86	1404872.0
2014-07-14 13:00:00	QQQ	ETF	95.86	96.01	95.85	95.9699	1402561.0
2014-07-14 14:00:00	QQQ	ETF	95.9648	95.98	95.85	95.975	1866510.0
2014-07-14 15:00:00	QQQ	ETF	95.97	95.98	95.785	95.85	3997789.0
2014-07-14 16:00:00	QQQ	ETF	95.85	95.9333	95.6819	95.83	1540858.0
2014-07-14 17:00:00	QQQ	ETF	95.83	95.88	95.8	95.85	141815.0
2014-07-14 18:00:00	QQQ	ETF	95.86	95.86	95.81	95.81	8002.0
2014-07-14 19:00:00	QQQ	ETF	95.82	95.83	95.81	95.83	11600.0
2014-07-14 04:00:00	IWM	ETF	115.55	115.65	115.55	115.65	299.0
2014-07-14 05:00:00	IWM	ETF	116.05	116.05	116.05	116.05	100.0
2014-07-14 06:00:00	IWM	ETF	116.0	116.02	116.0	116.02	800.0
2014-07-14 07:00:00	IWM	ETF	116.03	116.27	116.01	116.27	135337.0
2014-07-14 08:00:00	IWM	ETF	116.23	116.38	116.21	116.26	289673.0
2014-07-14 09:00:00	IWM	ETF	116.27	116.53	115.64	115.79	5544292.0
2014-07-14 10:00:00	IWM	ETF	115.77	115.96	115.4	115.93	5165045.0
2014-07-14 11:00:00	IWM	ETF	115.94	116.17	115.79	115.8	2660815.0
2014-07-14 12:00:00	IWM	ETF	115.79	115.92	115.4	115.51	2319834.0
2014-07-14 13:00:00	IWM	ETF	115.52	115.81	115.49	115.655	1723122.0
2014-07-14 14:00:00	IWM	ETF	115.665	115.8	115.6	115.78	1567335.0
2014-07-14 15:00:00	IWM	ETF	115.78	115.81	115.57	115.68	3442231.0
2014-07-14 16:00:00	IWM	ETF	115.68	115.85	115.63	115.68	1977416.0
2014-07-14 17:00:00	IWM	ETF	115.7	115.74	115.69	115.69	3800.0
2014-07-14 04:00:00	DIA	ETF	169.64	169.64	169.64	169.64	100.0
2014-07-14 06:00:00	DIA	ETF	169.85	169.85	169.85	169.85	2000.0
2014-07-14 07:00:00	DIA	ETF	169.85	169.93	169.83	169.93	30200.0
2014-07-14 08:00:00	DIA	ETF	169.9	170.09	169.85	170.09	45350.0

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

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