PREVIEW / etf_1hour / 2012-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-23.parquet
  size:    187 KB
  rows:    5,829

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-04-23 04:00:00	SPY	ETF	137.14	137.14	136.63	136.8	53300.0
2012-04-23 05:00:00	SPY	ETF	136.78	136.79	136.56	136.74	62557.0
2012-04-23 06:00:00	SPY	ETF	136.73	136.76	136.58	136.7	186314.0
2012-04-23 07:00:00	SPY	ETF	136.65	136.78	136.5	136.66	570374.0
2012-04-23 08:00:00	SPY	ETF	136.67	137.8282	136.51	136.7	1511100.0
2012-04-23 09:00:00	SPY	ETF	136.7	136.78	136.1	136.291	23389599.0
2012-04-23 10:00:00	SPY	ETF	136.29	136.35	135.94	136.21	33539629.0
2012-04-23 11:00:00	SPY	ETF	136.21	136.45	136.17	136.435	18494940.0
2012-04-23 12:00:00	SPY	ETF	136.43	136.64	136.32	136.44	12942762.0
2012-04-23 13:00:00	SPY	ETF	136.45	136.6	136.37	136.475	11516937.0
2012-04-23 14:00:00	SPY	ETF	136.48	136.91	136.23	136.57	19828836.0
2012-04-23 15:00:00	SPY	ETF	136.57	136.89	136.54	136.77	26193763.0
2012-04-23 16:00:00	SPY	ETF	136.78	137.9266	136.23	136.96	18931074.0
2012-04-23 17:00:00	SPY	ETF	136.96	136.98	136.9	136.95	203725.0
2012-04-23 18:00:00	SPY	ETF	136.96	137.0	136.89	136.95	87741.0
2012-04-23 19:00:00	SPY	ETF	136.94	136.94	136.84	136.88	46705.0
2012-04-23 04:00:00	QQQ	ETF	65.35	65.35	65.2	65.25	1800.0
2012-04-23 05:00:00	QQQ	ETF	65.08	65.08	65.07	65.08	4200.0
2012-04-23 06:00:00	QQQ	ETF	65.12	65.12	65.06	65.09	3200.0
2012-04-23 07:00:00	QQQ	ETF	65.09	65.16	65.02	65.12	91080.0
2012-04-23 08:00:00	QQQ	ETF	65.14	65.3033	65.08	65.2	281876.0
2012-04-23 09:00:00	QQQ	ETF	65.19	65.65	64.76	64.91	10711783.0
2012-04-23 10:00:00	QQQ	ETF	64.9	64.94	64.49	64.58	15602900.0
2012-04-23 11:00:00	QQQ	ETF	64.59	64.84	64.51	64.84	7449509.0
2012-04-23 12:00:00	QQQ	ETF	64.84	65.05	64.81	64.87	5228148.0
2012-04-23 13:00:00	QQQ	ETF	64.88	65.08	64.86	65.0077	3820295.0
2012-04-23 14:00:00	QQQ	ETF	65.01	65.18	64.8	64.96	10156319.0
2012-04-23 15:00:00	QQQ	ETF	64.96	65.16	64.95	65.1	8504097.0
2012-04-23 16:00:00	QQQ	ETF	65.11	65.624	64.8998	65.22	2321861.0
2012-04-23 17:00:00	QQQ	ETF	65.21	65.22	65.18	65.19	32307.0
2012-04-23 18:00:00	QQQ	ETF	65.2	65.21	65.19	65.21	10177.0
2012-04-23 19:00:00	QQQ	ETF	65.2	65.2	65.15	65.15	11380.0
2012-04-23 04:00:00	IWM	ETF	79.69	79.69	79.26	79.29	2348.0
2012-04-23 05:00:00	IWM	ETF	79.2	79.2	79.11	79.14	1900.0
2012-04-23 06:00:00	IWM	ETF	79.22	79.22	79.02	79.1	7966.0
2012-04-23 07:00:00	IWM	ETF	79.1	79.19	79.0	79.11	92437.0
2012-04-23 08:00:00	IWM	ETF	79.13	79.18	79.02	79.1	270471.0
2012-04-23 09:00:00	IWM	ETF	79.09	79.11	78.4	78.5525	9845179.0
2012-04-23 10:00:00	IWM	ETF	78.55	78.86	78.31	78.53	12407617.0
2012-04-23 11:00:00	IWM	ETF	78.54	78.82	78.47	78.81	4595003.0
2012-04-23 12:00:00	IWM	ETF	78.8	78.99	78.75	78.81	3712221.0
2012-04-23 13:00:00	IWM	ETF	78.81	78.88	78.68	78.75	2962468.0
2012-04-23 14:00:00	IWM	ETF	78.74	79.16	78.58	78.87	6291687.0
2012-04-23 15:00:00	IWM	ETF	78.87	79.13	78.83	79.11	8091407.0
2012-04-23 16:00:00	IWM	ETF	79.11	80.2684	78.686	79.12	1388469.0
2012-04-23 17:00:00	IWM	ETF	79.1	79.1	79.04	79.04	29500.0
2012-04-23 18:00:00	IWM	ETF	79.09	79.09	79.09	79.09	1000.0
2012-04-23 19:00:00	IWM	ETF	79.06	79.06	79.06	79.06	500.0
2012-04-23 07:00:00	DIA	ETF	128.89	128.98	128.88	128.92	6200.0
2012-04-23 08:00:00	DIA	ETF	128.94	128.94	128.78	128.89	26664.0

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

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