PREVIEW / etf_1hour / 2012-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-18.parquet
  size:    183 KB
  rows:    5,702

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
2012-10-18 04:00:00	SPY	ETF	146.1	146.2	146.02	146.2	1700.0
2012-10-18 05:00:00	SPY	ETF	146.18	146.26	146.18	146.18	28562.0
2012-10-18 06:00:00	SPY	ETF	146.2	146.24	146.06	146.12	29600.0
2012-10-18 07:00:00	SPY	ETF	146.04	146.09	145.93	146.0	126279.0
2012-10-18 08:00:00	SPY	ETF	146.0	146.28	145.81	145.84	1381789.0
2012-10-18 09:00:00	SPY	ETF	145.83	146.0	145.73	145.98	13145661.0
2012-10-18 10:00:00	SPY	ETF	145.98	146.22	145.64	146.0099	20963963.0
2012-10-18 11:00:00	SPY	ETF	146.0	146.44	145.99	146.39	11699365.0
2012-10-18 12:00:00	SPY	ETF	146.39	146.52	145.88	145.97	18582364.0
2012-10-18 13:00:00	SPY	ETF	145.97	146.03	145.52	145.595	17540312.0
2012-10-18 14:00:00	SPY	ETF	145.595	145.91	145.33	145.66	19725747.0
2012-10-18 15:00:00	SPY	ETF	145.66	146.0	145.51	145.87	25527861.0
2012-10-18 16:00:00	SPY	ETF	145.87	146.4075	145.56	145.66	15040442.0
2012-10-18 17:00:00	SPY	ETF	145.68	145.72	145.6	145.69	418776.0
2012-10-18 18:00:00	SPY	ETF	145.66	145.74	145.62	145.71	88442.0
2012-10-18 19:00:00	SPY	ETF	145.72	145.81	145.72	145.8	37415.0
2012-10-18 04:00:00	QQQ	ETF	68.03	68.03	68.02	68.02	2603.0
2012-10-18 06:00:00	QQQ	ETF	68.02	68.06	68.02	68.02	2400.0
2012-10-18 07:00:00	QQQ	ETF	67.97	67.99	67.92	67.92	18542.0
2012-10-18 08:00:00	QQQ	ETF	67.94	68.15	67.78	67.79	483443.0
2012-10-18 09:00:00	QQQ	ETF	67.79	67.95	67.73	67.939	4101126.0
2012-10-18 10:00:00	QQQ	ETF	67.93	68.03	67.61	67.7985	5921849.0
2012-10-18 11:00:00	QQQ	ETF	67.7901	68.03	67.78	68.02	4071580.0
2012-10-18 12:00:00	QQQ	ETF	68.02	68.08	67.35	67.44	13610153.0
2012-10-18 13:00:00	QQQ	ETF	67.4301	67.46	67.05	67.11	8018593.0
2012-10-18 14:00:00	QQQ	ETF	67.11	67.29	67.04	67.185	7740884.0
2012-10-18 15:00:00	QQQ	ETF	67.185	67.395	67.1	67.32	11216605.0
2012-10-18 16:00:00	QQQ	ETF	67.31	68.0661	67.09	67.14	5124940.0
2012-10-18 17:00:00	QQQ	ETF	67.14	67.18	67.13	67.18	9641.0
2012-10-18 18:00:00	QQQ	ETF	67.18	67.22	67.18	67.19	5149.0
2012-10-18 19:00:00	QQQ	ETF	67.21	67.26	67.2	67.23	3743.0
2012-10-18 07:00:00	IWM	ETF	84.0	84.0	83.93	83.93	22600.0
2012-10-18 08:00:00	IWM	ETF	83.99	84.1	83.9	83.95	322813.0
2012-10-18 09:00:00	IWM	ETF	83.93	84.09	83.79	84.0	2598387.0
2012-10-18 10:00:00	IWM	ETF	84.0	84.15	83.54	83.77	5407651.0
2012-10-18 11:00:00	IWM	ETF	83.78	84.04	83.76	83.98	2790500.0
2012-10-18 12:00:00	IWM	ETF	83.98	84.07	83.61	83.6601	3447727.0
2012-10-18 13:00:00	IWM	ETF	83.67	83.86	83.48	83.63	3149375.0
2012-10-18 14:00:00	IWM	ETF	83.62	83.8	83.45	83.616	2648328.0
2012-10-18 15:00:00	IWM	ETF	83.62	83.67	83.47	83.54	5694149.0
2012-10-18 16:00:00	IWM	ETF	83.5	84.0106	83.2	83.27	3413737.0
2012-10-18 17:00:00	IWM	ETF	83.28	83.31	83.28	83.31	8754.0
2012-10-18 18:00:00	IWM	ETF	83.31	83.31	83.28	83.31	993.0
2012-10-18 19:00:00	IWM	ETF	83.33	83.33	83.33	83.33	400.0
2012-10-18 08:00:00	DIA	ETF	135.44	135.44	135.24	135.24	17801.0
2012-10-18 09:00:00	DIA	ETF	135.24	135.5	135.22	135.5	378131.0
2012-10-18 10:00:00	DIA	ETF	135.45	135.63	135.15	135.45	1939844.0
2012-10-18 11:00:00	DIA	ETF	135.45	135.72	135.42	135.66	628525.0
2012-10-18 12:00:00	DIA	ETF	135.65	135.77	135.39	135.45	1307290.0
2012-10-18 13:00:00	DIA	ETF	135.45	135.5	135.14	135.21	494640.0

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

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