PREVIEW / etf_1hour / 2005-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-26.parquet
  size:    30 KB
  rows:    919

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-26 07:00:00	SPY	ETF	123.35	123.35	123.25	123.28	12900.0
2005-07-26 08:00:00	SPY	ETF	123.25	123.31	123.23	123.23	124100.0
2005-07-26 09:00:00	SPY	ETF	123.22	123.33	123.03	123.26	3840700.0
2005-07-26 10:00:00	SPY	ETF	123.27	123.5	123.02	123.21	12021300.0
2005-07-26 11:00:00	SPY	ETF	123.24	123.3	123.05	123.24	5229300.0
2005-07-26 12:00:00	SPY	ETF	123.24	123.28	122.95	123.13	3934500.0
2005-07-26 13:00:00	SPY	ETF	123.13	123.45	123.08	123.45	5247000.0
2005-07-26 14:00:00	SPY	ETF	123.45	123.53	123.24	123.41	5486500.0
2005-07-26 15:00:00	SPY	ETF	123.4	123.44	123.21	123.25	5018600.0
2005-07-26 16:00:00	SPY	ETF	123.22	123.34	123.18	123.3	491400.0
2005-07-26 17:00:00	SPY	ETF	123.29	123.29	123.2	123.2	40800.0
2005-07-26 18:00:00	SPY	ETF	123.19	123.22	123.18	123.22	24800.0
2005-07-26 19:00:00	SPY	ETF	123.2	123.24	123.2	123.21	4700.0
2005-07-26 09:00:00	QQQ	ETF	39.37	39.41	39.31	39.39	10064700.0
2005-07-26 10:00:00	QQQ	ETF	39.39	39.46	39.19	39.29	17586600.0
2005-07-26 11:00:00	QQQ	ETF	39.29	39.39	39.25	39.37	5871400.0
2005-07-26 12:00:00	QQQ	ETF	39.37	39.39	39.25	39.32	5119300.0
2005-07-26 13:00:00	QQQ	ETF	39.32	39.48	39.3	39.48	6249800.0
2005-07-26 14:00:00	QQQ	ETF	39.48	39.53	39.43	39.48	7097600.0
2005-07-26 15:00:00	QQQ	ETF	39.48	39.5	39.4	39.4	8467800.0
2005-07-26 08:00:00	IWM	ETF	66.99	66.99	66.99	66.99	3000.0
2005-07-26 09:00:00	IWM	ETF	66.95	67.07	66.76	66.96	3972100.0
2005-07-26 10:00:00	IWM	ETF	66.96	67.15	66.69	66.9	3704800.0
2005-07-26 11:00:00	IWM	ETF	66.91	67.03	66.8	66.97	2629400.0
2005-07-26 12:00:00	IWM	ETF	66.97	67.0	66.59	66.79	1135500.0
2005-07-26 13:00:00	IWM	ETF	66.8	67.32	66.78	67.3	3521000.0
2005-07-26 14:00:00	IWM	ETF	67.3	67.37	67.14	67.21	2976800.0
2005-07-26 15:00:00	IWM	ETF	67.22	67.29	67.04	67.05	3252100.0
2005-07-26 16:00:00	IWM	ETF	67.05	67.15	67.01	67.11	468000.0
2005-07-26 17:00:00	IWM	ETF	67.1	67.1	67.05	67.05	1500.0
2005-07-26 18:00:00	IWM	ETF	67.06	67.06	67.06	67.06	200.0
2005-07-26 19:00:00	IWM	ETF	67.06	67.06	67.05	67.05	1300.0
2005-07-26 08:00:00	DIA	ETF	106.15	106.15	106.09	106.09	1300.0
2005-07-26 09:00:00	DIA	ETF	106.07	106.11	105.86	106.0	446700.0
2005-07-26 10:00:00	DIA	ETF	106.0	106.14	105.76	105.91	1382400.0
2005-07-26 11:00:00	DIA	ETF	105.9	105.96	105.78	105.94	836700.0
2005-07-26 12:00:00	DIA	ETF	105.95	105.95	105.64	105.84	661600.0
2005-07-26 13:00:00	DIA	ETF	105.91	106.08	105.78	106.08	287100.0
2005-07-26 14:00:00	DIA	ETF	106.08	106.2	105.97	106.09	731800.0
2005-07-26 15:00:00	DIA	ETF	106.08	106.09	105.77	105.77	1231600.0
2005-07-26 16:00:00	DIA	ETF	105.8	105.82	105.79	105.82	6800.0
2005-07-26 17:00:00	DIA	ETF	105.82	105.82	105.78	105.8	500.0
2005-07-26 18:00:00	DIA	ETF	105.8	105.8	105.8	105.8	200.0
2005-07-26 19:00:00	DIA	ETF	105.77	105.77	105.76	105.76	200.0
2005-07-26 08:00:00	GLD	ETF	42.26	42.29	42.24	42.24	2200.0
2005-07-26 09:00:00	GLD	ETF	42.28	42.28	42.22	42.222	105800.0
2005-07-26 10:00:00	GLD	ETF	42.22	42.33	42.22	42.32	95200.0
2005-07-26 11:00:00	GLD	ETF	42.32	42.37	42.14	42.16	202500.0
2005-07-26 12:00:00	GLD	ETF	42.16	42.26	42.16	42.24	103700.0
2005-07-26 13:00:00	GLD	ETF	42.22	42.28	42.22	42.27	18900.0

> showing 50 of 919 rows — these rows as CSV

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