PREVIEW / etf_1hour / 2012-02-16

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-16.parquet
  size:    188 KB
  rows:    5,714

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-02-16 04:00:00	SPY	ETF	134.13	134.22	134.09	134.1	5100.0
2012-02-16 05:00:00	SPY	ETF	134.12	134.29	134.06	134.29	32605.0
2012-02-16 06:00:00	SPY	ETF	134.28	134.33	134.15	134.23	60600.0
2012-02-16 07:00:00	SPY	ETF	134.22	134.32	133.95	134.05	365474.0
2012-02-16 08:00:00	SPY	ETF	134.05	134.63	133.99	134.43	3309392.0
2012-02-16 09:00:00	SPY	ETF	134.43	134.82	134.33	134.665	22582260.0
2012-02-16 10:00:00	SPY	ETF	134.67	135.15	134.61	134.92	27199234.0
2012-02-16 11:00:00	SPY	ETF	134.92	135.68	134.87	135.58	29174946.0
2012-02-16 12:00:00	SPY	ETF	135.585	135.81	135.55	135.75	18099591.0
2012-02-16 13:00:00	SPY	ETF	135.74	136.1	135.71	135.95	17657499.0
2012-02-16 14:00:00	SPY	ETF	135.95	136.12	135.88	136.02	12551958.0
2012-02-16 15:00:00	SPY	ETF	136.02	136.17	135.85	136.05	30147259.0
2012-02-16 16:00:00	SPY	ETF	136.04	136.09	134.5705	135.95	24288724.0
2012-02-16 17:00:00	SPY	ETF	135.96	136.04	135.95	136.03	256365.0
2012-02-16 18:00:00	SPY	ETF	136.01	136.05	135.95	135.95	239683.0
2012-02-16 19:00:00	SPY	ETF	135.97	136.03	135.97	136.03	141405.0
2012-02-16 04:00:00	QQQ	ETF	62.66	62.66	62.66	62.66	200.0
2012-02-16 05:00:00	QQQ	ETF	62.7	62.7	62.7	62.7	100.0
2012-02-16 06:00:00	QQQ	ETF	62.74	62.77	62.69	62.71	11320.0
2012-02-16 07:00:00	QQQ	ETF	62.73	62.75	62.62	62.64	72240.0
2012-02-16 08:00:00	QQQ	ETF	62.7	62.87	62.6	62.76	1672009.0
2012-02-16 09:00:00	QQQ	ETF	62.76	62.86	62.63	62.79	10937538.0
2012-02-16 10:00:00	QQQ	ETF	62.79	62.98	62.7263	62.77	10952552.0
2012-02-16 11:00:00	QQQ	ETF	62.775	63.18	62.74	63.13	9215117.0
2012-02-16 12:00:00	QQQ	ETF	63.13	63.4	63.12	63.35	8990600.0
2012-02-16 13:00:00	QQQ	ETF	63.35	63.67	63.3302	63.62	6194893.0
2012-02-16 14:00:00	QQQ	ETF	63.63	63.686	63.54	63.61	5390053.0
2012-02-16 15:00:00	QQQ	ETF	63.61	63.7	63.55	63.62	13154843.0
2012-02-16 16:00:00	QQQ	ETF	63.63	63.71	63.4	63.68	3276867.0
2012-02-16 17:00:00	QQQ	ETF	63.67	63.72	63.66	63.72	37492.0
2012-02-16 18:00:00	QQQ	ETF	63.7	63.75	63.66	63.68	34960.0
2012-02-16 19:00:00	QQQ	ETF	63.67	63.73	63.67	63.72	15319.0
2012-02-16 04:00:00	IWM	ETF	81.01	81.01	80.9	80.9	240.0
2012-02-16 07:00:00	IWM	ETF	80.75	81.05	80.75	80.95	12850.0
2012-02-16 08:00:00	IWM	ETF	80.67	81.35	80.67	81.2	571595.0
2012-02-16 09:00:00	IWM	ETF	81.21	81.69	81.21	81.59	4959554.0
2012-02-16 10:00:00	IWM	ETF	81.61	82.32	81.56	82.01	10770304.0
2012-02-16 11:00:00	IWM	ETF	82.0	82.68	81.98	82.6	8098331.0
2012-02-16 12:00:00	IWM	ETF	82.61	82.7	82.44	82.62	5111756.0
2012-02-16 13:00:00	IWM	ETF	82.62	82.83	82.58	82.6926	4635906.0
2012-02-16 14:00:00	IWM	ETF	82.7	82.79	82.66	82.77	2498040.0
2012-02-16 15:00:00	IWM	ETF	82.76	82.9	82.63	82.81	8232081.0
2012-02-16 16:00:00	IWM	ETF	82.8	82.8451	81.2843	82.77	4820074.0
2012-02-16 17:00:00	IWM	ETF	82.79	82.82	82.74	82.82	1434.0
2012-02-16 18:00:00	IWM	ETF	82.85	82.85	82.81	82.81	700.0
2012-02-16 19:00:00	IWM	ETF	82.77	82.8	82.76	82.76	2800.0
2012-02-16 07:00:00	DIA	ETF	127.61	127.61	127.5	127.5	805.0
2012-02-16 08:00:00	DIA	ETF	127.52	127.96	127.3	127.79	31740.0
2012-02-16 09:00:00	DIA	ETF	127.83	128.35	127.8	128.31	1189205.0
2012-02-16 10:00:00	DIA	ETF	128.31	128.5699	128.25	128.36	1535597.0

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

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