PREVIEW / etf_1hour / 2005-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-26.parquet
  size:    28 KB
  rows:    808

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-01-26 08:00:00	SPY	ETF	117.33	117.39	117.29	117.3	121100.0
2005-01-26 09:00:00	SPY	ETF	117.32	117.4	117.22	117.33	5442500.0
2005-01-26 10:00:00	SPY	ETF	117.32	117.56	117.23	117.46	12293900.0
2005-01-26 11:00:00	SPY	ETF	117.46	117.58	117.06	117.17	10216400.0
2005-01-26 12:00:00	SPY	ETF	117.17	117.48	117.04	117.08	4505600.0
2005-01-26 13:00:00	SPY	ETF	117.08	117.48	117.06	117.42	5311900.0
2005-01-26 14:00:00	SPY	ETF	117.43	117.53	117.31	117.41	6667800.0
2005-01-26 15:00:00	SPY	ETF	117.41	117.6	117.21	117.41	8597100.0
2005-01-26 16:00:00	SPY	ETF	117.38	117.41	117.16	117.22	1686400.0
2005-01-26 17:00:00	SPY	ETF	117.2	117.22	117.12	117.21	227800.0
2005-01-26 18:00:00	SPY	ETF	117.18	117.27	117.18	117.22	15000.0
2005-01-26 19:00:00	SPY	ETF	117.18	117.18	117.17	117.18	3000.0
2005-01-26 09:00:00	QQQ	ETF	36.96	37.04	36.83	36.97	9609600.0
2005-01-26 10:00:00	QQQ	ETF	36.96	37.09	36.89	36.96	17441500.0
2005-01-26 11:00:00	QQQ	ETF	36.95	37.09	36.82	36.89	15190800.0
2005-01-26 12:00:00	QQQ	ETF	36.89	36.97	36.86	36.89	5833100.0
2005-01-26 13:00:00	QQQ	ETF	36.88	37.06	36.85	37.03	7714200.0
2005-01-26 14:00:00	QQQ	ETF	37.03	37.08	37.01	37.06	9439500.0
2005-01-26 15:00:00	QQQ	ETF	37.06	37.29	37.0	37.16	28154600.0
2005-01-26 09:00:00	IWM	ETF	60.725	60.815	60.585	60.7	2041200.0
2005-01-26 10:00:00	IWM	ETF	60.7	60.955	60.66	60.815	3280600.0
2005-01-26 11:00:00	IWM	ETF	60.8	60.915	60.56	60.66	1735800.0
2005-01-26 12:00:00	IWM	ETF	60.66	60.775	60.62	60.68	1192400.0
2005-01-26 13:00:00	IWM	ETF	60.68	61.105	60.675	61.085	2143000.0
2005-01-26 14:00:00	IWM	ETF	61.09	61.145	60.995	61.1	1919400.0
2005-01-26 15:00:00	IWM	ETF	61.105	61.45	60.925	61.38	4906800.0
2005-01-26 16:00:00	IWM	ETF	61.415	61.42	61.24	61.24	567000.0
2005-01-26 17:00:00	IWM	ETF	61.265	61.265	61.25	61.25	1000.0
2005-01-26 18:00:00	IWM	ETF	61.25	61.25	61.25	61.25	400.0
2005-01-26 08:00:00	DIA	ETF	104.96	105.01	104.93	104.97	13300.0
2005-01-26 09:00:00	DIA	ETF	104.95	105.07	104.84	105.03	1113300.0
2005-01-26 10:00:00	DIA	ETF	105.02	105.19	104.97	105.1	1531400.0
2005-01-26 11:00:00	DIA	ETF	105.11	105.25	104.77	104.88	1077000.0
2005-01-26 12:00:00	DIA	ETF	104.88	104.94	104.68	104.74	565400.0
2005-01-26 13:00:00	DIA	ETF	104.75	105.07	104.73	105.02	1924600.0
2005-01-26 14:00:00	DIA	ETF	105.02	105.1	104.86	104.97	360500.0
2005-01-26 15:00:00	DIA	ETF	104.98	105.09	104.81	104.94	1158500.0
2005-01-26 16:00:00	DIA	ETF	104.95	104.95	104.73	104.77	43700.0
2005-01-26 17:00:00	DIA	ETF	104.74	104.74	104.71	104.71	1000.0
2005-01-26 18:00:00	DIA	ETF	104.77	104.77	104.71	104.71	600.0
2005-01-26 09:00:00	GLD	ETF	42.59	42.62	42.56	42.59	64400.0
2005-01-26 10:00:00	GLD	ETF	42.6	42.73	42.57	42.7	87100.0
2005-01-26 11:00:00	GLD	ETF	42.69	42.73	42.63	42.69	122500.0
2005-01-26 12:00:00	GLD	ETF	42.69	42.78	42.66	42.76	74000.0
2005-01-26 13:00:00	GLD	ETF	42.74	42.75	42.66	42.69	61000.0
2005-01-26 14:00:00	GLD	ETF	42.68	42.73	42.66	42.68	64000.0
2005-01-26 15:00:00	GLD	ETF	42.68	42.7	42.66	42.69	68800.0
2005-01-26 09:00:00	TLT	ETF	90.7	90.85	90.7	90.79	126100.0
2005-01-26 10:00:00	TLT	ETF	90.79	90.83	90.7	90.702	170200.0
2005-01-26 11:00:00	TLT	ETF	90.76	90.8	90.65	90.8	30500.0

> showing 50 of 808 rows — these rows as CSV

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