PREVIEW / etf_1hour / 2008-11-28

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-28.parquet
  size:    73 KB
  rows:    2,224

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
2008-11-28 04:00:00	SPY	ETF	89.11	89.11	88.65	88.65	10600.0
2008-11-28 05:00:00	SPY	ETF	88.7	89.0	88.57	88.8	6200.0
2008-11-28 06:00:00	SPY	ETF	88.92	88.96	88.64	88.64	25300.0
2008-11-28 07:00:00	SPY	ETF	88.58	88.58	88.09	88.37	436933.0
2008-11-28 08:00:00	SPY	ETF	88.18	89.0	88.095	88.52	2330944.0
2008-11-28 09:00:00	SPY	ETF	88.53	89.37	88.38	88.82	19207299.0
2008-11-28 10:00:00	SPY	ETF	88.82	89.08	88.48	88.91	24659546.0
2008-11-28 11:00:00	SPY	ETF	88.9	89.57	88.59	89.52	29109017.0
2008-11-28 12:00:00	SPY	ETF	89.53	90.05	88.85	89.8	36343252.0
2008-11-28 13:00:00	SPY	ETF	89.8	90.15	89.17	90.03	3594209.0
2008-11-28 14:00:00	SPY	ETF	90.05	90.1	89.5	90.08	792628.0
2008-11-28 15:00:00	SPY	ETF	90.04	90.04	89.84	89.9	28707.0
2008-11-28 16:00:00	SPY	ETF	90.0	90.21	89.85	90.01	29537.0
2008-11-28 04:00:00	QQQ	ETF	29.14	29.15	29.11	29.11	1500.0
2008-11-28 05:00:00	QQQ	ETF	29.1	29.22	29.08	29.22	2000.0
2008-11-28 06:00:00	QQQ	ETF	29.12	29.2	29.12	29.2	200.0
2008-11-28 07:00:00	QQQ	ETF	29.1	29.12	28.98	29.08	70276.0
2008-11-28 08:00:00	QQQ	ETF	29.09	29.15	29.01	29.02	1063296.0
2008-11-28 09:00:00	QQQ	ETF	29.03	29.19	28.92	28.94	9514423.0
2008-11-28 10:00:00	QQQ	ETF	28.95	29.05	28.83	28.92	8744649.0
2008-11-28 11:00:00	QQQ	ETF	28.91	29.1	28.85	29.08	6956731.0
2008-11-28 12:00:00	QQQ	ETF	29.07	29.18	28.92	29.14	12909624.0
2008-11-28 13:00:00	QQQ	ETF	29.14	29.18	29.0163	29.09	1709415.0
2008-11-28 14:00:00	QQQ	ETF	29.1	29.13	29.09	29.1	32000.0
2008-11-28 15:00:00	QQQ	ETF	29.07	29.09	29.06	29.09	16400.0
2008-11-28 16:00:00	QQQ	ETF	29.1	29.1	29.04	29.04	4710.0
2008-11-28 07:00:00	IWM	ETF	46.5	46.5	46.26	46.43	23357.0
2008-11-28 08:00:00	IWM	ETF	46.43	46.87	46.23	46.26	247956.0
2008-11-28 09:00:00	IWM	ETF	46.27	46.79	46.16	46.25	3444208.0
2008-11-28 10:00:00	IWM	ETF	46.25	46.74	46.18	46.7	3575853.0
2008-11-28 11:00:00	IWM	ETF	46.7	46.94	46.47	46.81	3984685.0
2008-11-28 12:00:00	IWM	ETF	46.81	47.53	46.53	47.51	9996375.0
2008-11-28 13:00:00	IWM	ETF	47.5	48.26	46.57	47.0	1810546.0
2008-11-28 15:00:00	IWM	ETF	47.05	47.05	47.05	47.05	176.0
2008-11-28 16:00:00	IWM	ETF	46.99	46.99	46.99	46.99	476.0
2008-11-28 06:00:00	DIA	ETF	86.99	87.07	86.84	86.86	17081.0
2008-11-28 07:00:00	DIA	ETF	86.7	86.74	86.45	86.45	7475.0
2008-11-28 08:00:00	DIA	ETF	86.63	86.95	86.57	86.74	61758.0
2008-11-28 09:00:00	DIA	ETF	86.79	87.59	86.6	87.35	1604747.0
2008-11-28 10:00:00	DIA	ETF	87.35	87.55	87.0	87.31	1315426.0
2008-11-28 11:00:00	DIA	ETF	87.3	87.88	87.11	87.85	1436374.0
2008-11-28 12:00:00	DIA	ETF	87.86	88.33	87.62	88.27	2078645.0
2008-11-28 13:00:00	DIA	ETF	88.26	88.38	88.12	88.2	372676.0
2008-11-28 14:00:00	DIA	ETF	88.29	88.29	88.0	88.0	2300.0
2008-11-28 15:00:00	DIA	ETF	88.05	88.3	88.05	88.05	2825.0
2008-11-28 16:00:00	DIA	ETF	88.15	88.15	88.15	88.15	700.0
2008-11-28 07:00:00	GLD	ETF	79.85	80.0	79.85	80.0	800.0
2008-11-28 08:00:00	GLD	ETF	80.09	80.19	79.8	80.1	48920.0
2008-11-28 09:00:00	GLD	ETF	80.12	80.75	79.91	80.38	848961.0
2008-11-28 10:00:00	GLD	ETF	80.36	80.41	79.8	80.19	1024245.0

> showing 50 of 2,224 rows — these rows as CSV

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