PREVIEW / etf_1hour / 2005-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-14.parquet
  size:    31 KB
  rows:    949

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-09-14 07:00:00	SPY	ETF	123.7	123.7	123.6	123.6	3200.0
2005-09-14 08:00:00	SPY	ETF	123.64	123.81	123.57	123.71	2962900.0
2005-09-14 09:00:00	SPY	ETF	123.74	123.92	123.58	123.6	6241100.0
2005-09-14 10:00:00	SPY	ETF	123.6	123.77	123.35	123.56	8844700.0
2005-09-14 11:00:00	SPY	ETF	123.56	123.9	123.54	123.76	4418500.0
2005-09-14 12:00:00	SPY	ETF	123.76	123.83	123.66	123.78	3528100.0
2005-09-14 13:00:00	SPY	ETF	123.78	123.92	123.5	123.6	4661500.0
2005-09-14 14:00:00	SPY	ETF	123.61	123.63	123.17	123.26	7119600.0
2005-09-14 15:00:00	SPY	ETF	123.26	123.3	123.02	123.18	11505100.0
2005-09-14 16:00:00	SPY	ETF	123.23	123.5824	123.14	123.24	1029100.0
2005-09-14 17:00:00	SPY	ETF	123.24	123.8	123.18	123.25	599300.0
2005-09-14 18:00:00	SPY	ETF	123.21	123.25	123.21	123.25	2500500.0
2005-09-14 19:00:00	SPY	ETF	123.23	123.26	123.23	123.23	1300.0
2005-09-14 09:00:00	QQQ	ETF	39.65	39.68	39.45	39.51	24986900.0
2005-09-14 10:00:00	QQQ	ETF	39.5	39.57	39.45	39.5	17383400.0
2005-09-14 11:00:00	QQQ	ETF	39.5	39.6	39.49	39.55	6045200.0
2005-09-14 12:00:00	QQQ	ETF	39.55	39.6	39.47	39.53	5196800.0
2005-09-14 13:00:00	QQQ	ETF	39.53	39.56	39.38	39.42	9394700.0
2005-09-14 14:00:00	QQQ	ETF	39.42	39.43	39.25	39.28	12660300.0
2005-09-14 15:00:00	QQQ	ETF	39.28	39.28	39.15	39.19	17716100.0
2005-09-14 08:00:00	IWM	ETF	67.19	67.22	67.12	67.22	9300.0
2005-09-14 09:00:00	IWM	ETF	67.23	67.3	66.96	66.96	3851900.0
2005-09-14 10:00:00	IWM	ETF	66.96	67.07	66.79	66.89	2162500.0
2005-09-14 11:00:00	IWM	ETF	66.9	67.04	66.86	66.86	1280900.0
2005-09-14 12:00:00	IWM	ETF	66.86	66.92	66.69	66.75	2576200.0
2005-09-14 13:00:00	IWM	ETF	66.75	66.82	66.55	66.62	2782300.0
2005-09-14 14:00:00	IWM	ETF	66.61	66.65	66.42	66.44	2967900.0
2005-09-14 15:00:00	IWM	ETF	66.44	66.45	66.2515	66.37	4984800.0
2005-09-14 16:00:00	IWM	ETF	66.37	66.44	66.37	66.44	136100.0
2005-09-14 17:00:00	IWM	ETF	66.4	66.41	66.4	66.4	2900.0
2005-09-14 08:00:00	DIA	ETF	106.14	106.24	106.14	106.17	6300.0
2005-09-14 09:00:00	DIA	ETF	106.23	106.41	106.08	106.09	718800.0
2005-09-14 10:00:00	DIA	ETF	106.09	106.27	105.96	106.09	1570100.0
2005-09-14 11:00:00	DIA	ETF	106.09	106.29	106.08	106.17	731900.0
2005-09-14 12:00:00	DIA	ETF	106.17	106.25	106.09	106.22	389200.0
2005-09-14 13:00:00	DIA	ETF	106.21	106.28	105.95	106.02	414500.0
2005-09-14 14:00:00	DIA	ETF	106.02	106.02	105.65	105.69	1173500.0
2005-09-14 15:00:00	DIA	ETF	105.66	105.68	105.43	105.5	1697300.0
2005-09-14 16:00:00	DIA	ETF	105.54	105.6	105.53	105.58	120700.0
2005-09-14 17:00:00	DIA	ETF	105.55	105.55	105.55	105.55	100.0
2005-09-14 18:00:00	DIA	ETF	105.59	105.63	105.55	105.55	1600.0
2005-09-14 08:00:00	GLD	ETF	44.81	44.82	44.81	44.82	4400.0
2005-09-14 09:00:00	GLD	ETF	44.85	44.87	44.79	44.85	153100.0
2005-09-14 10:00:00	GLD	ETF	44.85	44.88	44.72	44.78	253700.0
2005-09-14 11:00:00	GLD	ETF	44.75	44.78	44.66	44.77	191000.0
2005-09-14 12:00:00	GLD	ETF	44.78	44.85	44.77	44.82	140600.0
2005-09-14 13:00:00	GLD	ETF	44.83	44.9	44.794	44.88	254500.0
2005-09-14 14:00:00	GLD	ETF	44.9	44.92	44.84	44.92	176000.0
2005-09-14 15:00:00	GLD	ETF	44.92	44.96	44.89	44.95	453400.0
2005-09-14 08:00:00	TLT	ETF	93.96	93.96	93.96	93.96	5000.0

> showing 50 of 949 rows — these rows as CSV

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