PREVIEW / etf_1hour / 2012-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-05.parquet
  size:    185 KB
  rows:    5,759

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-03-05 04:00:00	SPY	ETF	136.8	136.8	136.57	136.61	207573.0
2012-03-05 05:00:00	SPY	ETF	136.72	136.81	136.71	136.81	9715.0
2012-03-05 06:00:00	SPY	ETF	136.76	136.81	136.69	136.69	42900.0
2012-03-05 07:00:00	SPY	ETF	136.7	136.95	136.66	136.93	149014.0
2012-03-05 08:00:00	SPY	ETF	136.95	137.2	136.95	137.09	1005527.0
2012-03-05 09:00:00	SPY	ETF	137.07	137.15	136.8	136.94	13036600.0
2012-03-05 10:00:00	SPY	ETF	136.93	137.2	136.42	136.61	28953352.0
2012-03-05 11:00:00	SPY	ETF	136.6	136.75	136.28	136.4703	19964447.0
2012-03-05 12:00:00	SPY	ETF	136.4715	136.59	136.34	136.3716	6906808.0
2012-03-05 13:00:00	SPY	ETF	136.37	136.61	136.35	136.45	8401590.0
2012-03-05 14:00:00	SPY	ETF	136.45	136.87	136.45	136.8	16018130.0
2012-03-05 15:00:00	SPY	ETF	136.81	136.97	136.74	136.79	23776996.0
2012-03-05 16:00:00	SPY	ETF	136.78	137.3362	136.679	136.81	14387378.0
2012-03-05 17:00:00	SPY	ETF	136.81	136.83	136.74	136.78	173660.0
2012-03-05 18:00:00	SPY	ETF	136.8	136.94	136.8	136.92	83748.0
2012-03-05 19:00:00	SPY	ETF	136.94	137.03	136.91	136.94	141065.0
2012-03-05 04:00:00	QQQ	ETF	64.7	64.7	64.7	64.7	100.0
2012-03-05 07:00:00	QQQ	ETF	64.65	64.73	64.63	64.73	118597.0
2012-03-05 08:00:00	QQQ	ETF	64.73	64.86	64.73	64.81	180391.0
2012-03-05 09:00:00	QQQ	ETF	64.82	64.84	64.72	64.78	3810919.0
2012-03-05 10:00:00	QQQ	ETF	64.78	64.91	64.44	64.47	8749208.0
2012-03-05 11:00:00	QQQ	ETF	64.48	64.53	63.99	64.24	10548631.0
2012-03-05 12:00:00	QQQ	ETF	64.24	64.33	64.05	64.12	4271233.0
2012-03-05 13:00:00	QQQ	ETF	64.12	64.24	64.0	64.06	4087986.0
2012-03-05 14:00:00	QQQ	ETF	64.0699	64.23	64.02	64.21	5430993.0
2012-03-05 15:00:00	QQQ	ETF	64.22	64.37	64.18	64.2	6087899.0
2012-03-05 16:00:00	QQQ	ETF	64.19	64.325	64.17	64.23	778665.0
2012-03-05 17:00:00	QQQ	ETF	64.22	64.24	64.21	64.21	15968.0
2012-03-05 18:00:00	QQQ	ETF	64.21	64.24	64.2	64.23	18562.0
2012-03-05 19:00:00	QQQ	ETF	64.24	64.27	64.24	64.24	14033.0
2012-03-05 04:00:00	IWM	ETF	79.74	79.74	79.74	79.74	1380.0
2012-03-05 07:00:00	IWM	ETF	79.74	79.93	79.7	79.93	86075.0
2012-03-05 08:00:00	IWM	ETF	79.9	80.12	79.9	80.03	152483.0
2012-03-05 09:00:00	IWM	ETF	80.04	80.09	79.79	79.96	6642336.0
2012-03-05 10:00:00	IWM	ETF	79.96	80.16	79.42	79.94	9733707.0
2012-03-05 11:00:00	IWM	ETF	79.94	80.13	79.6	79.96	7091510.0
2012-03-05 12:00:00	IWM	ETF	79.965	80.13	79.82	79.88	2120343.0
2012-03-05 13:00:00	IWM	ETF	79.87	80.14	79.831	80.045	2685302.0
2012-03-05 14:00:00	IWM	ETF	80.04	80.35	79.94	80.32	4103725.0
2012-03-05 15:00:00	IWM	ETF	80.32	80.3999	80.21	80.33	6358448.0
2012-03-05 16:00:00	IWM	ETF	80.32	80.56	80.1748	80.47	3839821.0
2012-03-05 17:00:00	IWM	ETF	80.47	80.49	80.45	80.45	4784.0
2012-03-05 18:00:00	IWM	ETF	80.5	80.5	80.5	80.5	500.0
2012-03-05 19:00:00	IWM	ETF	80.51	80.57	80.5	80.56	11668.0
2012-03-05 05:00:00	DIA	ETF	129.06	129.06	129.06	129.06	300.0
2012-03-05 07:00:00	DIA	ETF	129.06	129.25	129.06	129.25	1125.0
2012-03-05 08:00:00	DIA	ETF	129.27	129.5	129.27	129.46	9360.0
2012-03-05 09:00:00	DIA	ETF	129.48	129.48	129.19	129.28	438204.0
2012-03-05 10:00:00	DIA	ETF	129.32	129.59	128.64	128.94	1993601.0
2012-03-05 11:00:00	DIA	ETF	128.93	129.05	128.77	128.87	752906.0

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

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