PREVIEW / etf_1hour / 2011-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-01.parquet
  size:    185 KB
  rows:    5,601

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-06-01 04:00:00	SPY	ETF	135.0	135.04	134.85	135.04	1000.0
2011-06-01 05:00:00	SPY	ETF	134.84	134.97	134.8	134.81	5635.0
2011-06-01 06:00:00	SPY	ETF	134.82	134.88	134.5	134.72	63210.0
2011-06-01 07:00:00	SPY	ETF	134.77	134.86	134.65	134.84	291822.0
2011-06-01 08:00:00	SPY	ETF	134.84	134.89	134.27	134.41	4086400.0
2011-06-01 09:00:00	SPY	ETF	134.4	134.89	134.25	134.28	18671095.0
2011-06-01 10:00:00	SPY	ETF	134.28	134.28	133.2	133.5	43013503.0
2011-06-01 11:00:00	SPY	ETF	133.49	133.71	133.36	133.395	17168664.0
2011-06-01 12:00:00	SPY	ETF	133.38	134.9234	132.82	132.98	24352635.0
2011-06-01 13:00:00	SPY	ETF	132.99	134.9234	132.5	132.84	22586474.0
2011-06-01 14:00:00	SPY	ETF	132.83	132.83	132.24	132.55	26715969.0
2011-06-01 15:00:00	SPY	ETF	132.55	132.64	131.76	131.86	43848878.0
2011-06-01 16:00:00	SPY	ETF	131.86	132.427	131.65	131.81	27772933.0
2011-06-01 17:00:00	SPY	ETF	131.8	131.84	131.59	131.64	287204.0
2011-06-01 18:00:00	SPY	ETF	131.64	131.85	131.5	131.73	424525.0
2011-06-01 19:00:00	SPY	ETF	131.73	131.9	131.73	131.75	218088.0
2011-06-01 04:00:00	QQQ	ETF	58.34	58.34	58.18	58.18	2665.0
2011-06-01 06:00:00	QQQ	ETF	58.17	58.17	58.15	58.16	1150.0
2011-06-01 07:00:00	QQQ	ETF	58.17	58.27	58.14	58.27	169864.0
2011-06-01 08:00:00	QQQ	ETF	58.27	58.36	58.01	58.09	1448283.0
2011-06-01 09:00:00	QQQ	ETF	58.09	58.36	58.06	58.23	3436028.0
2011-06-01 10:00:00	QQQ	ETF	58.22	58.22	57.8813	57.96	9666744.0
2011-06-01 11:00:00	QQQ	ETF	57.96	57.97	57.78	57.7999	3583716.0
2011-06-01 12:00:00	QQQ	ETF	57.79	57.84	57.55	57.695	4522992.0
2011-06-01 13:00:00	QQQ	ETF	57.6901	57.765	57.44	57.57	5959361.0
2011-06-01 14:00:00	QQQ	ETF	57.57	57.57	57.24	57.35	7424039.0
2011-06-01 15:00:00	QQQ	ETF	57.34	57.38	57.04	57.08	10681759.0
2011-06-01 16:00:00	QQQ	ETF	57.08	57.11	56.99	57.04	1469955.0
2011-06-01 17:00:00	QQQ	ETF	57.01	57.01	56.9	56.95	117252.0
2011-06-01 18:00:00	QQQ	ETF	56.99	57.09	56.88	56.96	116578.0
2011-06-01 19:00:00	QQQ	ETF	56.97	57.03	56.95	56.95	238223.0
2011-06-01 04:00:00	IWM	ETF	84.87	84.87	84.84	84.84	1000.0
2011-06-01 05:00:00	IWM	ETF	84.85	85.03	84.85	85.03	4200.0
2011-06-01 06:00:00	IWM	ETF	84.83	84.88	84.81	84.81	2400.0
2011-06-01 07:00:00	IWM	ETF	84.86	84.95	84.81	84.95	6800.0
2011-06-01 08:00:00	IWM	ETF	84.95	84.99	84.54	84.66	1323401.0
2011-06-01 09:00:00	IWM	ETF	84.65	84.83	84.34	84.37	6998286.0
2011-06-01 10:00:00	IWM	ETF	84.34	84.36	83.562	83.82	15926392.0
2011-06-01 11:00:00	IWM	ETF	83.82	83.85	83.62	83.68	5472371.0
2011-06-01 12:00:00	IWM	ETF	83.68	83.75	83.17	83.25	7094795.0
2011-06-01 13:00:00	IWM	ETF	83.25	83.37	82.8	83.17	6406152.0
2011-06-01 14:00:00	IWM	ETF	83.17	83.17	82.67	82.81	7207628.0
2011-06-01 15:00:00	IWM	ETF	82.8	82.83	82.03	82.15	15566607.0
2011-06-01 16:00:00	IWM	ETF	82.15	82.21	82.05	82.21	2799556.0
2011-06-01 17:00:00	IWM	ETF	82.18	84.8185	82.05	82.07	4051809.0
2011-06-01 18:00:00	IWM	ETF	82.07	82.12	82.05	82.07	29315.0
2011-06-01 19:00:00	IWM	ETF	82.13	82.18	82.11	82.16	7073.0
2011-06-01 06:00:00	DIA	ETF	125.31	125.31	125.25	125.25	400.0
2011-06-01 07:00:00	DIA	ETF	125.34	125.34	125.34	125.34	600.0
2011-06-01 08:00:00	DIA	ETF	125.4	125.4	124.98	125.0	23050.0

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

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