PREVIEW / etf_1hour / 2012-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-21.parquet
  size:    192 KB
  rows:    5,935

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-21 04:00:00	SPY	ETF	136.79	137.1	136.78	136.8	11786.0
2012-02-21 05:00:00	SPY	ETF	136.86	136.86	136.66	136.71	39500.0
2012-02-21 06:00:00	SPY	ETF	136.65	136.73	136.53	136.61	150195.0
2012-02-21 07:00:00	SPY	ETF	136.59	136.8	136.54	136.66	229546.0
2012-02-21 08:00:00	SPY	ETF	136.65	137.3	136.5	136.79	2602018.0
2012-02-21 09:00:00	SPY	ETF	136.79	136.89	136.35	136.43	17074376.0
2012-02-21 10:00:00	SPY	ETF	136.4287	136.95	136.37	136.93	19585797.0
2012-02-21 11:00:00	SPY	ETF	136.939	136.97	136.78	136.82	9741105.0
2012-02-21 12:00:00	SPY	ETF	136.82	137.05	136.81	136.83	11012954.0
2012-02-21 13:00:00	SPY	ETF	136.82	136.93	136.64	136.69	13041106.0
2012-02-21 14:00:00	SPY	ETF	136.7	136.73	136.05	136.19	15443268.0
2012-02-21 15:00:00	SPY	ETF	136.18	136.48	136.06	136.47	27829267.0
2012-02-21 16:00:00	SPY	ETF	136.48	136.57	136.37	136.53	11936584.0
2012-02-21 17:00:00	SPY	ETF	136.53	136.54	136.4	136.51	75369.0
2012-02-21 18:00:00	SPY	ETF	136.53	136.56	136.42	136.45	94557.0
2012-02-21 19:00:00	SPY	ETF	136.43	136.46	136.38	136.41	51746.0
2012-02-21 04:00:00	QQQ	ETF	63.5	63.5	63.5	63.5	100.0
2012-02-21 05:00:00	QQQ	ETF	63.46	63.55	63.44	63.45	23900.0
2012-02-21 06:00:00	QQQ	ETF	63.4	63.45	63.4	63.41	3900.0
2012-02-21 07:00:00	QQQ	ETF	63.43	63.49	63.4	63.44	102800.0
2012-02-21 08:00:00	QQQ	ETF	63.45	63.51	63.36	63.51	190618.0
2012-02-21 09:00:00	QQQ	ETF	63.52	63.7	63.42	63.49	5559326.0
2012-02-21 10:00:00	QQQ	ETF	63.5	63.82	63.49	63.82	5579391.0
2012-02-21 11:00:00	QQQ	ETF	63.8186	63.83	63.77	63.806	3496217.0
2012-02-21 12:00:00	QQQ	ETF	63.81	63.89	63.61	63.63	4888904.0
2012-02-21 13:00:00	QQQ	ETF	63.63	63.68	63.48	63.518	2530985.0
2012-02-21 14:00:00	QQQ	ETF	63.5165	63.535	63.21	63.29	5010552.0
2012-02-21 15:00:00	QQQ	ETF	63.29	63.61	63.26	63.61	8105103.0
2012-02-21 16:00:00	QQQ	ETF	63.61	63.64	63.5677	63.62	873804.0
2012-02-21 17:00:00	QQQ	ETF	63.62	63.62	63.59	63.6	3146.0
2012-02-21 18:00:00	QQQ	ETF	63.61	63.64	63.61	63.61	13840.0
2012-02-21 19:00:00	QQQ	ETF	63.61	63.62	63.61	63.62	25960.0
2012-02-21 05:00:00	IWM	ETF	82.87	82.87	82.87	82.87	100.0
2012-02-21 06:00:00	IWM	ETF	82.81	82.81	82.81	82.81	400.0
2012-02-21 07:00:00	IWM	ETF	82.79	82.85	82.76	82.82	33500.0
2012-02-21 08:00:00	IWM	ETF	82.82	82.86	82.72	82.86	112045.0
2012-02-21 09:00:00	IWM	ETF	82.91	82.98	82.36	82.456	5445944.0
2012-02-21 10:00:00	IWM	ETF	82.4503	83.03	82.38	83.02	5279081.0
2012-02-21 11:00:00	IWM	ETF	83.02	83.04	82.78	82.789	1917141.0
2012-02-21 12:00:00	IWM	ETF	82.78	83.0	82.77	82.785	2399065.0
2012-02-21 13:00:00	IWM	ETF	82.78	82.89	82.475	82.54	4216807.0
2012-02-21 14:00:00	IWM	ETF	82.54	82.56	81.83	81.93	6025905.0
2012-02-21 15:00:00	IWM	ETF	81.92	82.31	81.88	82.22	9873590.0
2012-02-21 16:00:00	IWM	ETF	82.23	82.3	82.0832	82.25	2735260.0
2012-02-21 17:00:00	IWM	ETF	82.29	82.35	82.29	82.35	77673.0
2012-02-21 18:00:00	IWM	ETF	82.31	82.31	82.31	82.31	100.0
2012-02-21 19:00:00	IWM	ETF	82.27	82.28	82.25	82.28	600.0
2012-02-21 04:00:00	DIA	ETF	129.7	129.7	129.7	129.7	200.0
2012-02-21 07:00:00	DIA	ETF	129.63	129.68	129.63	129.67	1100.0
2012-02-21 08:00:00	DIA	ETF	129.54	129.6	129.5	129.59	5320.0

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

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