PREVIEW / etf_1hour / 2005-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-24.parquet
  size:    31 KB
  rows:    945

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-06-24 06:00:00	SPY	ETF	119.91	119.91	119.91	119.91	500.0
2005-06-24 07:00:00	SPY	ETF	119.94	119.99	119.92	119.97	26400.0
2005-06-24 08:00:00	SPY	ETF	119.96	120.08	119.92	119.92	381100.0
2005-06-24 09:00:00	SPY	ETF	119.91	119.93	119.69	119.86	6475700.0
2005-06-24 10:00:00	SPY	ETF	119.862	119.96	119.57	119.78	10310300.0
2005-06-24 11:00:00	SPY	ETF	119.79	120.0078	119.55	119.65	6917900.0
2005-06-24 12:00:00	SPY	ETF	119.65	119.83	119.57	119.67	3883700.0
2005-06-24 13:00:00	SPY	ETF	119.68	119.75	119.32	119.39	8503300.0
2005-06-24 14:00:00	SPY	ETF	119.39	119.51	119.16	119.27	7148600.0
2005-06-24 15:00:00	SPY	ETF	119.27	119.51	119.05	119.09	10339700.0
2005-06-24 16:00:00	SPY	ETF	119.08	119.19	118.84	119.06	3105900.0
2005-06-24 17:00:00	SPY	ETF	119.06	119.09	119.01	119.05	13300.0
2005-06-24 18:00:00	SPY	ETF	119.03	119.03	119.02	119.02	900.0
2005-06-24 19:00:00	SPY	ETF	119.09	119.13	119.09	119.1	4100.0
2005-06-24 09:00:00	QQQ	ETF	37.38	37.41	37.26	37.37	9246900.0
2005-06-24 10:00:00	QQQ	ETF	37.37	37.41	37.1	37.16	16624100.0
2005-06-24 11:00:00	QQQ	ETF	37.16	37.28	37.11	37.15	8830800.0
2005-06-24 12:00:00	QQQ	ETF	37.16	37.21	37.11	37.17	4405200.0
2005-06-24 13:00:00	QQQ	ETF	37.18	37.18	37.02	37.08	10322300.0
2005-06-24 14:00:00	QQQ	ETF	37.08	37.15	37.0	37.03	8560800.0
2005-06-24 15:00:00	QQQ	ETF	37.03	37.11	36.96	36.96	78231500.0
2005-06-24 07:00:00	IWM	ETF	62.91	62.96	62.91	62.96	9100.0
2005-06-24 08:00:00	IWM	ETF	62.97	62.97	62.89	62.9	21000.0
2005-06-24 09:00:00	IWM	ETF	62.89	63.02	62.74	62.76	2430000.0
2005-06-24 10:00:00	IWM	ETF	62.76	62.83	62.42	62.54	3065500.0
2005-06-24 11:00:00	IWM	ETF	62.55	62.67	62.37	62.4	3214800.0
2005-06-24 12:00:00	IWM	ETF	62.39	62.51	62.37	62.46	1694900.0
2005-06-24 13:00:00	IWM	ETF	62.46	62.48	62.15	62.21	2867500.0
2005-06-24 14:00:00	IWM	ETF	62.21	62.3	62.12	62.15	2352400.0
2005-06-24 15:00:00	IWM	ETF	62.15	62.43	62.07	62.29	6749300.0
2005-06-24 16:00:00	IWM	ETF	62.28	62.64	62.1	62.24	1455300.0
2005-06-24 17:00:00	IWM	ETF	62.21	62.21	62.21	62.21	8600.0
2005-06-24 18:00:00	IWM	ETF	62.26	62.26	62.26	62.26	800.0
2005-06-24 08:00:00	DIA	ETF	104.18	104.18	104.1	104.1	2600.0
2005-06-24 09:00:00	DIA	ETF	104.1	104.1	103.77	103.9	795500.0
2005-06-24 10:00:00	DIA	ETF	103.91	104.02	103.6	103.78	1447600.0
2005-06-24 11:00:00	DIA	ETF	103.76	103.96	103.45	103.56	1049100.0
2005-06-24 12:00:00	DIA	ETF	103.56	103.7	103.48	103.54	490400.0
2005-06-24 13:00:00	DIA	ETF	103.55	103.58	103.0	103.15	2410100.0
2005-06-24 14:00:00	DIA	ETF	103.14	103.29	102.96	103.03	1320300.0
2005-06-24 15:00:00	DIA	ETF	103.01	103.26	102.9	102.97	1504100.0
2005-06-24 16:00:00	DIA	ETF	102.95	103.01	102.78	102.95	505300.0
2005-06-24 17:00:00	DIA	ETF	102.9	102.9	102.9	102.9	100.0
2005-06-24 07:00:00	GLD	ETF	44.18	44.18	44.18	44.18	14500.0
2005-06-24 08:00:00	GLD	ETF	44.1	44.1	43.85	43.85	22700.0
2005-06-24 09:00:00	GLD	ETF	43.97	44.0	43.95	43.98	108100.0
2005-06-24 10:00:00	GLD	ETF	43.97	44.06	43.92	43.98	70600.0
2005-06-24 11:00:00	GLD	ETF	43.98	43.98	43.68	43.8	79500.0
2005-06-24 12:00:00	GLD	ETF	43.8	43.88	43.78	43.85	19800.0
2005-06-24 13:00:00	GLD	ETF	43.84	43.98	43.84	43.9	61000.0

> showing 50 of 945 rows — these rows as CSV

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