PREVIEW / etf_1hour / 2012-10-16

all etf 1-hour files

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

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-10-16 04:00:00	SPY	ETF	144.25	144.28	144.18	144.26	22000.0
2012-10-16 05:00:00	SPY	ETF	144.24	144.29	144.14	144.29	54800.0
2012-10-16 06:00:00	SPY	ETF	144.32	144.5	144.27	144.45	53719.0
2012-10-16 07:00:00	SPY	ETF	144.47	144.98	144.44	144.92	646366.0
2012-10-16 08:00:00	SPY	ETF	144.92	144.92	144.14	144.85	1256691.0
2012-10-16 09:00:00	SPY	ETF	144.86	145.13	144.66	145.08	16799219.0
2012-10-16 10:00:00	SPY	ETF	145.08	145.28	144.99	145.19	19222541.0
2012-10-16 11:00:00	SPY	ETF	145.19	145.5	145.1	145.43	10653307.0
2012-10-16 12:00:00	SPY	ETF	145.43	145.64	145.38	145.45	12097532.0
2012-10-16 13:00:00	SPY	ETF	145.46	145.6	145.44	145.54	6739444.0
2012-10-16 14:00:00	SPY	ETF	145.541	145.55	145.27	145.37	11134276.0
2012-10-16 15:00:00	SPY	ETF	145.37	145.64	145.19	145.57	19780669.0
2012-10-16 16:00:00	SPY	ETF	145.57	145.71	144.0847	145.57	7945475.0
2012-10-16 17:00:00	SPY	ETF	145.55	145.73	145.54	145.6	321070.0
2012-10-16 18:00:00	SPY	ETF	145.62	145.7	145.57	145.6	63810.0
2012-10-16 19:00:00	SPY	ETF	145.64	145.79	145.61	145.66	170757.0
2012-10-16 04:00:00	QQQ	ETF	67.24	67.24	67.22	67.22	500.0
2012-10-16 06:00:00	QQQ	ETF	67.29	67.36	67.27	67.36	32700.0
2012-10-16 07:00:00	QQQ	ETF	67.32	67.54	67.32	67.54	79735.0
2012-10-16 08:00:00	QQQ	ETF	67.51	67.53	67.41	67.48	247045.0
2012-10-16 09:00:00	QQQ	ETF	67.49	67.5	67.25	67.47	4583955.0
2012-10-16 10:00:00	QQQ	ETF	67.48	67.71	67.41	67.67	4039013.0
2012-10-16 11:00:00	QQQ	ETF	67.67	67.99	67.6	67.95	5043826.0
2012-10-16 12:00:00	QQQ	ETF	67.95	68.19	67.92	68.03	5417970.0
2012-10-16 13:00:00	QQQ	ETF	68.04	68.1	68.0	68.04	1258466.0
2012-10-16 14:00:00	QQQ	ETF	68.04	68.06	67.92	68.04	1983801.0
2012-10-16 15:00:00	QQQ	ETF	68.0336	68.2	67.97	68.13	5313352.0
2012-10-16 16:00:00	QQQ	ETF	68.13	68.28	67.9	67.96	3020243.0
2012-10-16 17:00:00	QQQ	ETF	67.95	68.0	67.1906	67.9	1751682.0
2012-10-16 18:00:00	QQQ	ETF	67.88	67.9	67.81	67.81	31879.0
2012-10-16 19:00:00	QQQ	ETF	67.88	68.0	67.88	67.96	10500.0
2012-10-16 05:00:00	IWM	ETF	82.8	82.8	82.8	82.8	200.0
2012-10-16 06:00:00	IWM	ETF	82.96	83.0	82.96	83.0	2000.0
2012-10-16 07:00:00	IWM	ETF	82.95	83.27	82.95	83.25	47910.0
2012-10-16 08:00:00	IWM	ETF	83.23	83.23	83.04	83.11	63470.0
2012-10-16 09:00:00	IWM	ETF	83.13	83.31	82.88	83.27	4130305.0
2012-10-16 10:00:00	IWM	ETF	83.26	83.33	82.98	83.1	4802817.0
2012-10-16 11:00:00	IWM	ETF	83.09	83.27	83.01	83.221	2759544.0
2012-10-16 12:00:00	IWM	ETF	83.2268	83.36	83.07	83.08	2954166.0
2012-10-16 13:00:00	IWM	ETF	83.085	83.21	83.08	83.19	1573769.0
2012-10-16 14:00:00	IWM	ETF	83.1899	83.2	83.07	83.15	1667125.0
2012-10-16 15:00:00	IWM	ETF	83.16	83.32	83.07	83.26	6591177.0
2012-10-16 16:00:00	IWM	ETF	83.26	83.44	83.17	83.38	1015655.0
2012-10-16 17:00:00	IWM	ETF	83.36	83.44	83.31	83.33	49250.0
2012-10-16 19:00:00	IWM	ETF	83.4	83.42	83.37	83.4	4705.0
2012-10-16 07:00:00	DIA	ETF	134.41	134.45	134.41	134.45	2100.0
2012-10-16 08:00:00	DIA	ETF	134.68	134.71	134.64	134.7	4620.0
2012-10-16 09:00:00	DIA	ETF	134.65	135.07	134.57	135.03	846581.0
2012-10-16 10:00:00	DIA	ETF	135.0	135.27	134.96	135.17	707566.0
2012-10-16 11:00:00	DIA	ETF	135.17	135.33	135.1031	135.24	717342.0

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

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