PREVIEW / etf_1hour / 2005-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-12.parquet
  size:    30 KB
  rows:    917

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-12 07:00:00	SPY	ETF	122.04	122.04	122.0	122.01	8000.0
2005-07-12 08:00:00	SPY	ETF	121.94	121.97	121.81	121.87	166100.0
2005-07-12 09:00:00	SPY	ETF	121.86	122.08	121.8	122.04	5105300.0
2005-07-12 10:00:00	SPY	ETF	122.03	122.09	121.64	122.08	11035300.0
2005-07-12 11:00:00	SPY	ETF	122.05	122.08	121.71	121.75	6253800.0
2005-07-12 12:00:00	SPY	ETF	121.75	122.01	121.72	121.91	2911400.0
2005-07-12 13:00:00	SPY	ETF	121.91	122.5	121.88	122.42	7481000.0
2005-07-12 14:00:00	SPY	ETF	122.43	122.52	122.26	122.32	5433400.0
2005-07-12 15:00:00	SPY	ETF	122.32	122.63	122.15	122.22	10882500.0
2005-07-12 16:00:00	SPY	ETF	122.2	122.43	122.17	122.22	1106900.0
2005-07-12 17:00:00	SPY	ETF	122.21	122.21	122.2	122.21	18200.0
2005-07-12 18:00:00	SPY	ETF	122.23	122.24	122.18	122.2	8200.0
2005-07-12 19:00:00	SPY	ETF	122.17	122.23	122.17	122.23	4800.0
2005-07-12 09:00:00	QQQ	ETF	38.12	38.19	38.04	38.17	11113300.0
2005-07-12 10:00:00	QQQ	ETF	38.16	38.2	38.01	38.19	13128500.0
2005-07-12 11:00:00	QQQ	ETF	38.19	38.2	38.04	38.06	6254100.0
2005-07-12 12:00:00	QQQ	ETF	38.06	38.15	38.04	38.12	3955500.0
2005-07-12 13:00:00	QQQ	ETF	38.12	38.38	38.11	38.35	11048200.0
2005-07-12 14:00:00	QQQ	ETF	38.35	38.42	38.32	38.34	13879500.0
2005-07-12 15:00:00	QQQ	ETF	38.35	38.46	38.29	38.29	19767200.0
2005-07-12 07:00:00	IWM	ETF	66.73	66.73	66.73	66.73	200.0
2005-07-12 08:00:00	IWM	ETF	66.77	66.77	66.68	66.72	31300.0
2005-07-12 09:00:00	IWM	ETF	66.71	66.81	66.56	66.65	1703700.0
2005-07-12 10:00:00	IWM	ETF	66.65	66.78	66.33	66.71	3660700.0
2005-07-12 11:00:00	IWM	ETF	66.7092	66.73	66.44	66.49	1724300.0
2005-07-12 12:00:00	IWM	ETF	66.5	66.64	66.4	66.55	1256600.0
2005-07-12 13:00:00	IWM	ETF	66.56	66.97	66.52	66.92	2312200.0
2005-07-12 14:00:00	IWM	ETF	66.92	67.09	66.84	66.98	6506200.0
2005-07-12 15:00:00	IWM	ETF	66.98	67.14	66.63	66.64	6377000.0
2005-07-12 16:00:00	IWM	ETF	66.62	66.67	66.55	66.61	449800.0
2005-07-12 17:00:00	IWM	ETF	66.62	66.62	66.57	66.6	6400.0
2005-07-12 18:00:00	IWM	ETF	66.73	66.73	66.73	66.73	1400000.0
2005-07-12 08:00:00	DIA	ETF	105.16	105.16	105.08	105.11	900.0
2005-07-12 09:00:00	DIA	ETF	105.11	105.24	105.0	105.21	586600.0
2005-07-12 10:00:00	DIA	ETF	105.21	105.22	104.85	105.14	996300.0
2005-07-12 11:00:00	DIA	ETF	105.13	105.13	104.87	104.9	624900.0
2005-07-12 12:00:00	DIA	ETF	104.91	105.11	104.88	105.01	388700.0
2005-07-12 13:00:00	DIA	ETF	105.0	105.42	104.99	105.37	1040200.0
2005-07-12 14:00:00	DIA	ETF	105.36	105.45	105.21	105.26	1046900.0
2005-07-12 15:00:00	DIA	ETF	105.24	105.49	105.09	105.09	1889900.0
2005-07-12 16:00:00	DIA	ETF	105.13	105.17	105.11	105.13	17200.0
2005-07-12 18:00:00	DIA	ETF	105.15	105.15	105.15	105.15	100.0
2005-07-12 19:00:00	DIA	ETF	105.1	105.1	105.1	105.1	100.0
2005-07-12 08:00:00	GLD	ETF	42.59	42.59	42.59	42.59	1000.0
2005-07-12 09:00:00	GLD	ETF	42.61	42.62	42.54	42.57	129500.0
2005-07-12 10:00:00	GLD	ETF	42.59	42.62	42.53	42.62	239900.0
2005-07-12 11:00:00	GLD	ETF	42.6	42.62	42.48	42.48	201300.0
2005-07-12 12:00:00	GLD	ETF	42.46	42.51	42.4	42.42	87300.0
2005-07-12 13:00:00	GLD	ETF	42.41	42.58	42.41	42.55	73800.0
2005-07-12 14:00:00	GLD	ETF	42.532	42.61	42.53	42.58	108400.0

> showing 50 of 917 rows — these rows as CSV

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