PREVIEW / etf_1hour / 2005-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-11.parquet
  size:    32 KB
  rows:    1,006

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
2005-11-11 06:00:00	SPY	ETF	123.43	123.44	123.43	123.44	5000.0
2005-11-11 07:00:00	SPY	ETF	123.41	123.41	123.33	123.39	4400.0
2005-11-11 08:00:00	SPY	ETF	123.38	123.41	123.33	123.39	425800.0
2005-11-11 09:00:00	SPY	ETF	123.39	123.49	123.28	123.44	5917000.0
2005-11-11 10:00:00	SPY	ETF	123.44	123.51	123.34	123.43	4201900.0
2005-11-11 11:00:00	SPY	ETF	123.43	123.59	123.41	123.43	5514500.0
2005-11-11 12:00:00	SPY	ETF	123.42	123.55	123.36	123.42	3682500.0
2005-11-11 13:00:00	SPY	ETF	123.42	123.51	123.38	123.48	2958500.0
2005-11-11 14:00:00	SPY	ETF	123.5	123.67	123.46	123.62	3704200.0
2005-11-11 15:00:00	SPY	ETF	123.61	123.84	123.6	123.65	6452000.0
2005-11-11 16:00:00	SPY	ETF	123.66	123.8	123.63	123.78	1222700.0
2005-11-11 17:00:00	SPY	ETF	123.8	123.84	123.8	123.8	5400.0
2005-11-11 18:00:00	SPY	ETF	123.84	123.85	123.84	123.85	300.0
2005-11-11 19:00:00	SPY	ETF	123.81	123.81	123.81	123.81	900.0
2005-11-11 09:00:00	QQQ	ETF	40.77	40.89	40.76	40.88	14269600.0
2005-11-11 10:00:00	QQQ	ETF	40.88	40.88	40.78	40.84	10097100.0
2005-11-11 11:00:00	QQQ	ETF	40.84	40.92	40.77	40.77	8690300.0
2005-11-11 12:00:00	QQQ	ETF	40.77	40.8	40.72	40.76	7768700.0
2005-11-11 13:00:00	QQQ	ETF	40.75	40.77	40.68	40.75	6677700.0
2005-11-11 14:00:00	QQQ	ETF	40.76	40.81	40.71	40.71	8184400.0
2005-11-11 15:00:00	QQQ	ETF	40.71	40.77	40.68	40.71	13160600.0
2005-11-11 07:00:00	IWM	ETF	66.1	66.1	66.1	66.1	3000.0
2005-11-11 08:00:00	IWM	ETF	66.11	66.14	66.11	66.14	15000.0
2005-11-11 09:00:00	IWM	ETF	66.14	66.4	66.05	66.21	2866600.0
2005-11-11 10:00:00	IWM	ETF	66.21	66.25	65.95	66.19	4790900.0
2005-11-11 11:00:00	IWM	ETF	66.21	66.34	66.05	66.06	2514300.0
2005-11-11 12:00:00	IWM	ETF	66.07	66.22	66.01	66.12	744200.0
2005-11-11 13:00:00	IWM	ETF	66.12	66.2	66.07	66.17	632600.0
2005-11-11 14:00:00	IWM	ETF	66.17	66.48	66.15	66.38	3839100.0
2005-11-11 15:00:00	IWM	ETF	66.38	66.49	66.28	66.33	3027300.0
2005-11-11 16:00:00	IWM	ETF	66.32	66.46	66.31	66.35	493700.0
2005-11-11 08:00:00	DIA	ETF	106.56	106.59	106.55	106.57	3400.0
2005-11-11 09:00:00	DIA	ETF	106.57	106.72	106.5	106.7	239800.0
2005-11-11 10:00:00	DIA	ETF	106.69	106.72	106.61	106.7	639500.0
2005-11-11 11:00:00	DIA	ETF	106.71	106.85	106.7	106.79	623100.0
2005-11-11 12:00:00	DIA	ETF	106.8	106.91	106.75	106.83	457100.0
2005-11-11 13:00:00	DIA	ETF	106.83	106.89	106.79	106.85	451600.0
2005-11-11 14:00:00	DIA	ETF	106.86	107.01	106.84	106.93	382500.0
2005-11-11 15:00:00	DIA	ETF	106.94	107.11	106.94	106.96	410500.0
2005-11-11 16:00:00	DIA	ETF	106.95	107.06	106.95	107.06	65000.0
2005-11-11 08:00:00	GLD	ETF	46.43	46.54	46.42	46.5	14000.0
2005-11-11 09:00:00	GLD	ETF	46.51	46.56	46.46	46.46	79200.0
2005-11-11 10:00:00	GLD	ETF	46.46	46.57	46.439	46.53	443500.0
2005-11-11 11:00:00	GLD	ETF	46.51	46.7	46.5	46.67	275100.0
2005-11-11 12:00:00	GLD	ETF	46.69	46.73	46.626	46.72	144500.0
2005-11-11 13:00:00	GLD	ETF	46.72	46.76	46.67	46.7	100800.0
2005-11-11 14:00:00	GLD	ETF	46.72	46.78	46.72	46.75	224800.0
2005-11-11 15:00:00	GLD	ETF	46.75	46.8	46.73	46.8	184700.0
2005-11-11 09:00:00	TLT	ETF	89.6	89.7	89.44	89.6	33000.0
2005-11-11 10:00:00	TLT	ETF	89.55	89.63	89.55	89.63	27000.0

> showing 50 of 1,006 rows — these rows as CSV

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