PREVIEW / etf_1hour / 2011-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-06.parquet
  size:    180 KB
  rows:    5,558

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
2011-12-06 04:00:00	SPY	ETF	126.32	126.32	125.76	126.1	32285.0
2011-12-06 05:00:00	SPY	ETF	126.15	126.69	126.11	126.69	13000.0
2011-12-06 06:00:00	SPY	ETF	126.66	126.66	126.3	126.5	133040.0
2011-12-06 07:00:00	SPY	ETF	126.5	126.64	126.24	126.3	579328.0
2011-12-06 08:00:00	SPY	ETF	126.3	126.48	125.98	126.11	3388124.0
2011-12-06 09:00:00	SPY	ETF	126.11	126.42	125.76	126.01	20238783.0
2011-12-06 10:00:00	SPY	ETF	126.0	126.56	125.96	126.12	24794965.0
2011-12-06 11:00:00	SPY	ETF	126.13	126.28	125.83	126.18	14946045.0
2011-12-06 12:00:00	SPY	ETF	126.17	126.27	126.01	126.13	8175741.0
2011-12-06 13:00:00	SPY	ETF	126.14	126.45	125.99	126.2509	17120233.0
2011-12-06 14:00:00	SPY	ETF	126.2508	127.02	126.14	126.89	22173572.0
2011-12-06 15:00:00	SPY	ETF	126.89	127.11	126.3	126.31	34191921.0
2011-12-06 16:00:00	SPY	ETF	126.31	126.5354	126.01	126.24	22152112.0
2011-12-06 17:00:00	SPY	ETF	126.21	126.21	126.13	126.16	257929.0
2011-12-06 18:00:00	SPY	ETF	126.15	126.33	126.04	126.27	239503.0
2011-12-06 19:00:00	SPY	ETF	126.29	126.48	126.22	126.47	410512.0
2011-12-06 04:00:00	QQQ	ETF	57.35	57.35	57.35	57.35	500.0
2011-12-06 05:00:00	QQQ	ETF	57.35	57.54	57.35	57.54	9475.0
2011-12-06 06:00:00	QQQ	ETF	57.53	57.53	57.42	57.42	2046.0
2011-12-06 07:00:00	QQQ	ETF	57.51	57.52	57.33	57.37	140500.0
2011-12-06 08:00:00	QQQ	ETF	57.34	57.41	57.18	57.24	937896.0
2011-12-06 09:00:00	QQQ	ETF	57.24	57.45	57.17	57.255	3640245.0
2011-12-06 10:00:00	QQQ	ETF	57.26	57.3874	57.06	57.08	5870064.0
2011-12-06 11:00:00	QQQ	ETF	57.08	57.15	56.89	57.03	4438333.0
2011-12-06 12:00:00	QQQ	ETF	57.03	57.09	56.93	56.99	3236664.0
2011-12-06 13:00:00	QQQ	ETF	57.0	57.11	56.9175	57.02	2191440.0
2011-12-06 14:00:00	QQQ	ETF	57.02	57.35	56.94	57.304	3927008.0
2011-12-06 15:00:00	QQQ	ETF	57.3	57.4	57.07	57.08	6316421.0
2011-12-06 16:00:00	QQQ	ETF	57.07	57.15	57.04	57.15	1069809.0
2011-12-06 17:00:00	QQQ	ETF	57.13	57.13	57.1	57.12	8545.0
2011-12-06 18:00:00	QQQ	ETF	57.12	57.17	57.09	57.14	25747.0
2011-12-06 19:00:00	QQQ	ETF	57.18	57.26	57.14	57.22	12160.0
2011-12-06 04:00:00	IWM	ETF	74.87	74.87	74.58	74.58	474.0
2011-12-06 06:00:00	IWM	ETF	75.18	75.18	75.02	75.02	450.0
2011-12-06 07:00:00	IWM	ETF	75.12	75.17	74.96	74.97	13631.0
2011-12-06 08:00:00	IWM	ETF	74.93	75.09	74.68	74.78	656241.0
2011-12-06 09:00:00	IWM	ETF	74.77	74.94	74.18	74.47	3362999.0
2011-12-06 10:00:00	IWM	ETF	74.46	74.84	74.37	74.42	5577064.0
2011-12-06 11:00:00	IWM	ETF	74.42	74.49	74.09	74.38	3483999.0
2011-12-06 12:00:00	IWM	ETF	74.38	74.45	74.155	74.405	1961450.0
2011-12-06 13:00:00	IWM	ETF	74.405	74.81	74.35	74.69	3114660.0
2011-12-06 14:00:00	IWM	ETF	74.69	75.1401	74.56	75.05	4901585.0
2011-12-06 15:00:00	IWM	ETF	75.05	75.29	74.65	74.76	9182464.0
2011-12-06 16:00:00	IWM	ETF	74.76	74.85	74.42	74.61	2426063.0
2011-12-06 17:00:00	IWM	ETF	74.6	74.61	74.57	74.6	62198.0
2011-12-06 18:00:00	IWM	ETF	74.6	74.66	74.6	74.66	3700.0
2011-12-06 19:00:00	IWM	ETF	74.75	74.9	74.73	74.9	4900.0
2011-12-06 08:00:00	DIA	ETF	121.04	121.08	120.8	120.85	10300.0
2011-12-06 09:00:00	DIA	ETF	120.88	121.15	120.68	120.97	625051.0
2011-12-06 10:00:00	DIA	ETF	120.98	121.52	120.96	121.23	866320.0

> showing 50 of 5,558 rows — these rows as CSV

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