PREVIEW / etf_1hour / 2011-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-02-08.parquet
  size:    176 KB
  rows:    5,438

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
2011-02-08 04:00:00	SPY	ETF	132.13	132.17	132.13	132.17	900.0
2011-02-08 05:00:00	SPY	ETF	132.3	132.4	131.97	131.97	21340.0
2011-02-08 06:00:00	SPY	ETF	132.0	132.12	132.0	132.04	7600.0
2011-02-08 07:00:00	SPY	ETF	132.04	132.04	131.81	131.98	655541.0
2011-02-08 08:00:00	SPY	ETF	132.29	132.29	131.83	131.94	3068936.0
2011-02-08 09:00:00	SPY	ETF	131.94	132.13	131.73	132.06	14756657.0
2011-02-08 10:00:00	SPY	ETF	132.06	132.35	132.05	132.155	17712980.0
2011-02-08 11:00:00	SPY	ETF	132.16	132.36	131.98	132.3	13894374.0
2011-02-08 12:00:00	SPY	ETF	132.31	132.46	132.23	132.3262	8074654.0
2011-02-08 13:00:00	SPY	ETF	132.33	132.45	132.13	132.21	7177195.0
2011-02-08 14:00:00	SPY	ETF	132.205	132.49	132.205	132.33	8781020.0
2011-02-08 15:00:00	SPY	ETF	132.33	132.64	132.3	132.59	18337715.0
2011-02-08 16:00:00	SPY	ETF	132.58	132.6475	131.9	132.56	4912512.0
2011-02-08 17:00:00	SPY	ETF	132.56	132.63	132.53	132.59	215743.0
2011-02-08 18:00:00	SPY	ETF	132.58	132.6	132.57	132.57	152310.0
2011-02-08 19:00:00	SPY	ETF	132.58	132.59	132.49	132.53	72452.0
2011-02-08 06:00:00	QQQ	ETF	57.67	57.67	57.67	57.67	600.0
2011-02-08 07:00:00	QQQ	ETF	57.61	57.62	57.51	57.58	1223947.0
2011-02-08 08:00:00	QQQ	ETF	57.52	57.66	57.51	57.57	1858391.0
2011-02-08 09:00:00	QQQ	ETF	57.57	57.8	57.56	57.79	7009800.0
2011-02-08 10:00:00	QQQ	ETF	57.79	57.9	57.76	57.77	6924065.0
2011-02-08 11:00:00	QQQ	ETF	57.765	57.85	57.65	57.85	3810125.0
2011-02-08 12:00:00	QQQ	ETF	57.85	57.91	57.83	57.8675	2644680.0
2011-02-08 13:00:00	QQQ	ETF	57.86	57.88	57.78	57.811	2101580.0
2011-02-08 14:00:00	QQQ	ETF	57.82	57.97	57.82	57.91	3626843.0
2011-02-08 15:00:00	QQQ	ETF	57.9	58.07	57.89	58.069	6072806.0
2011-02-08 16:00:00	QQQ	ETF	58.07	58.08	57.98	58.04	1390003.0
2011-02-08 17:00:00	QQQ	ETF	58.03	58.06	58.03	58.05	19436.0
2011-02-08 18:00:00	QQQ	ETF	58.05	58.06	58.03	58.04	13335.0
2011-02-08 19:00:00	QQQ	ETF	58.05	58.06	58.03	58.03	42650.0
2011-02-08 04:00:00	IWM	ETF	80.57	80.57	80.57	80.57	100.0
2011-02-08 05:00:00	IWM	ETF	80.91	80.91	80.81	80.81	6000.0
2011-02-08 06:00:00	IWM	ETF	80.75	80.75	80.75	80.75	2100.0
2011-02-08 07:00:00	IWM	ETF	80.68	80.68	80.48	80.58	97900.0
2011-02-08 08:00:00	IWM	ETF	80.97	80.97	80.48	80.49	1027470.0
2011-02-08 09:00:00	IWM	ETF	80.5	80.76	80.43	80.69	5729280.0
2011-02-08 10:00:00	IWM	ETF	80.7	80.93	80.45	80.55	6485557.0
2011-02-08 11:00:00	IWM	ETF	80.55	80.84	80.34	80.76	3865260.0
2011-02-08 12:00:00	IWM	ETF	80.76	80.88	80.64	80.83	1861926.0
2011-02-08 13:00:00	IWM	ETF	80.83	80.87	80.65	80.68	1514617.0
2011-02-08 14:00:00	IWM	ETF	80.6775	81.04	80.675	80.8801	2821335.0
2011-02-08 15:00:00	IWM	ETF	80.8801	81.25	80.83	81.24	6402522.0
2011-02-08 16:00:00	IWM	ETF	81.24	81.27	80.5198	80.55	3468919.0
2011-02-08 17:00:00	IWM	ETF	81.19	81.23	81.19	81.21	3340.0
2011-02-08 18:00:00	IWM	ETF	81.19	81.22	81.18	81.18	2900.0
2011-02-08 19:00:00	IWM	ETF	81.18	81.23	81.1	81.23	12000.0
2011-02-08 05:00:00	DIA	ETF	121.54	121.54	121.54	121.54	100.0
2011-02-08 07:00:00	DIA	ETF	121.29	121.33	121.29	121.33	600.0
2011-02-08 08:00:00	DIA	ETF	121.38	121.47	121.34	121.34	5354.0
2011-02-08 09:00:00	DIA	ETF	121.43	121.6	121.33	121.59	815762.0

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

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