PREVIEW / etf_1hour / 2005-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-11.parquet
  size:    31 KB
  rows:    933

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-07-11 06:00:00	SPY	ETF	121.44	121.44	121.44	121.44	20000.0
2005-07-11 07:00:00	SPY	ETF	121.43	121.6	121.43	121.54	150400.0
2005-07-11 08:00:00	SPY	ETF	121.5	121.55	121.32	121.39	139500.0
2005-07-11 09:00:00	SPY	ETF	121.35	121.63	121.31	121.5	7733700.0
2005-07-11 10:00:00	SPY	ETF	121.5	121.88	121.41	121.81	12064600.0
2005-07-11 11:00:00	SPY	ETF	121.81	122.06	121.77	121.93	7338500.0
2005-07-11 12:00:00	SPY	ETF	121.92	121.95	121.58	121.61	5112100.0
2005-07-11 13:00:00	SPY	ETF	121.61	121.75	121.44	121.55	4193500.0
2005-07-11 14:00:00	SPY	ETF	121.54	121.91	121.54	121.86	3694200.0
2005-07-11 15:00:00	SPY	ETF	121.86	122.04	121.58	122.01	7286800.0
2005-07-11 16:00:00	SPY	ETF	122.04	122.11	121.94	121.95	1073600.0
2005-07-11 17:00:00	SPY	ETF	121.96	122.0	121.93	121.93	42200.0
2005-07-11 18:00:00	SPY	ETF	121.94	121.95	121.93	121.95	23600.0
2005-07-11 19:00:00	SPY	ETF	121.95	121.95	121.95	121.95	6400.0
2005-07-11 09:00:00	QQQ	ETF	37.87	37.96	37.8	37.88	19149700.0
2005-07-11 10:00:00	QQQ	ETF	37.88	38.07	37.85	38.02	19867900.0
2005-07-11 11:00:00	QQQ	ETF	38.02	38.16	37.99	38.08	16890300.0
2005-07-11 12:00:00	QQQ	ETF	38.08	38.09	37.95	37.96	7646500.0
2005-07-11 13:00:00	QQQ	ETF	37.96	38.06	37.91	37.98	6709900.0
2005-07-11 14:00:00	QQQ	ETF	37.98	38.08	37.95	38.04	8372100.0
2005-07-11 15:00:00	QQQ	ETF	38.04	38.12	37.92	38.12	12840400.0
2005-07-11 07:00:00	IWM	ETF	66.21	66.23	66.2	66.23	32200.0
2005-07-11 08:00:00	IWM	ETF	66.25	66.25	65.97	66.08	1559700.0
2005-07-11 09:00:00	IWM	ETF	66.09	66.49	65.98	66.35	6394700.0
2005-07-11 10:00:00	IWM	ETF	66.35	66.68	66.19	66.61	5795100.0
2005-07-11 11:00:00	IWM	ETF	66.61	66.99	66.6	66.89	5136400.0
2005-07-11 12:00:00	IWM	ETF	66.9	66.9	66.67	66.69	3128800.0
2005-07-11 13:00:00	IWM	ETF	66.69	66.78	66.5	66.67	2042700.0
2005-07-11 14:00:00	IWM	ETF	66.65	66.87	66.57	66.76	2031000.0
2005-07-11 15:00:00	IWM	ETF	66.76	66.86	66.4	66.86	7193100.0
2005-07-11 16:00:00	IWM	ETF	66.85	66.9	65.86	66.78	474700.0
2005-07-11 17:00:00	IWM	ETF	66.8	66.86	66.77	66.8	4300.0
2005-07-11 07:00:00	DIA	ETF	104.84	104.84	104.84	104.84	900.0
2005-07-11 08:00:00	DIA	ETF	104.79	104.79	104.61	104.66	80100.0
2005-07-11 09:00:00	DIA	ETF	104.65	105.01	104.63	104.87	1742300.0
2005-07-11 10:00:00	DIA	ETF	104.87	105.17	104.75	105.14	900900.0
2005-07-11 11:00:00	DIA	ETF	105.15	105.38	105.1	105.2	1295500.0
2005-07-11 12:00:00	DIA	ETF	105.22	105.24	104.96	104.96	341400.0
2005-07-11 13:00:00	DIA	ETF	104.97	105.05	104.83	104.88	937900.0
2005-07-11 14:00:00	DIA	ETF	104.9	105.19	104.9	105.15	407000.0
2005-07-11 15:00:00	DIA	ETF	105.16	105.25	104.87	105.24	819000.0
2005-07-11 16:00:00	DIA	ETF	105.26	105.26	105.2	105.2	162400.0
2005-07-11 17:00:00	DIA	ETF	105.19	105.19	105.18	105.18	600.0
2005-07-11 18:00:00	DIA	ETF	105.18	105.18	105.18	105.18	200.0
2005-07-11 08:00:00	GLD	ETF	42.38	42.38	42.31	42.35	5100.0
2005-07-11 09:00:00	GLD	ETF	42.33	42.34	42.28	42.33	349600.0
2005-07-11 10:00:00	GLD	ETF	42.32	42.47	42.32	42.47	640800.0
2005-07-11 11:00:00	GLD	ETF	42.48	42.55	42.47	42.49	388400.0
2005-07-11 12:00:00	GLD	ETF	42.49	42.57	42.47	42.54	219000.0
2005-07-11 13:00:00	GLD	ETF	42.55	42.55	42.46	42.48	360500.0

> showing 50 of 933 rows — these rows as CSV

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