PREVIEW / etf_1hour / 2004-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-08.parquet
  size:    26 KB
  rows:    767

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
2004-11-08 08:00:00	SPY	ETF	116.95	117.04	116.9	117.03	135300.0
2004-11-08 09:00:00	SPY	ETF	117.0	117.23	116.91	116.96	4036600.0
2004-11-08 10:00:00	SPY	ETF	116.94	117.07	116.79	117.04	8064500.0
2004-11-08 11:00:00	SPY	ETF	117.03	117.12	116.75	116.88	4550300.0
2004-11-08 12:00:00	SPY	ETF	116.88	117.05	116.8	116.93	2224400.0
2004-11-08 13:00:00	SPY	ETF	116.93	117.05	116.72	117.05	3020100.0
2004-11-08 14:00:00	SPY	ETF	117.04	117.13	116.9	117.06	3721300.0
2004-11-08 15:00:00	SPY	ETF	117.06	117.15	116.91	117.0	5159900.0
2004-11-08 16:00:00	SPY	ETF	117.01	117.17	116.99	117.08	1242300.0
2004-11-08 17:00:00	SPY	ETF	117.07	117.11	116.99	117.03	322600.0
2004-11-08 18:00:00	SPY	ETF	117.06	117.06	117.03	117.05	3900.0
2004-11-08 19:00:00	SPY	ETF	117.05	117.07	117.05	117.07	4900.0
2004-11-08 08:00:00	QQQ	ETF	37.93	37.97	37.93	37.97	145500.0
2004-11-08 09:00:00	QQQ	ETF	37.97	38.1	37.89	37.919	9271900.0
2004-11-08 10:00:00	QQQ	ETF	37.92	38.05	37.85	38.023	17471800.0
2004-11-08 11:00:00	QQQ	ETF	38.02	38.07	37.87	37.931	9632300.0
2004-11-08 12:00:00	QQQ	ETF	37.92	37.99	37.88	37.94	4434800.0
2004-11-08 13:00:00	QQQ	ETF	37.94	37.97	37.85	37.95	5537600.0
2004-11-08 14:00:00	QQQ	ETF	37.96	38.03	37.92	38.01	6748700.0
2004-11-08 15:00:00	QQQ	ETF	38.01	38.05	37.9109	37.97	10908900.0
2004-11-08 16:00:00	QQQ	ETF	37.973	38.031	37.94	37.971	1230900.0
2004-11-08 17:00:00	QQQ	ETF	37.98	37.987	37.97	37.97	11800.0
2004-11-08 18:00:00	QQQ	ETF	37.99	38.0	37.98	38.0	12600.0
2004-11-08 19:00:00	QQQ	ETF	38.0	38.02	37.98	37.98	22200.0
2004-11-08 08:00:00	IWM	ETF	60.155	60.155	60.155	60.155	9800.0
2004-11-08 09:00:00	IWM	ETF	60.215	60.435	60.175	60.185	822400.0
2004-11-08 10:00:00	IWM	ETF	60.165	60.25	60.075	60.24	842600.0
2004-11-08 11:00:00	IWM	ETF	60.23	60.235	59.945	60.025	1253600.0
2004-11-08 12:00:00	IWM	ETF	60.015	60.09	59.895	59.96	461800.0
2004-11-08 13:00:00	IWM	ETF	59.95	60.04	59.885	60.03	637400.0
2004-11-08 14:00:00	IWM	ETF	60.035	60.14	59.93	60.065	626000.0
2004-11-08 15:00:00	IWM	ETF	60.08	60.105	59.885	59.94	637400.0
2004-11-08 16:00:00	IWM	ETF	59.95	60.085	59.95	60.05	69200.0
2004-11-08 08:00:00	DIA	ETF	103.94	104.08	103.94	104.06	5600.0
2004-11-08 09:00:00	DIA	ETF	104.04	104.33	103.96	104.04	446000.0
2004-11-08 10:00:00	DIA	ETF	104.09	104.21	103.93	104.2	602100.0
2004-11-08 11:00:00	DIA	ETF	104.18	104.26	103.82	103.98	1132200.0
2004-11-08 12:00:00	DIA	ETF	103.98	104.15	103.91	104.09	639500.0
2004-11-08 13:00:00	DIA	ETF	104.07	104.21	103.93	104.21	614700.0
2004-11-08 14:00:00	DIA	ETF	104.22	104.31	104.1	104.24	503000.0
2004-11-08 15:00:00	DIA	ETF	104.24	104.3	104.06	104.16	1098600.0
2004-11-08 16:00:00	DIA	ETF	104.15	104.29	104.15	104.26	60200.0
2004-11-08 17:00:00	DIA	ETF	104.25	104.25	104.18	104.18	1100.0
2004-11-08 08:00:00	TLT	ETF	87.7	87.7	87.56	87.56	1300.0
2004-11-08 09:00:00	TLT	ETF	87.56	87.56	87.42	87.48	66700.0
2004-11-08 10:00:00	TLT	ETF	87.5	87.6	87.49	87.55	80500.0
2004-11-08 11:00:00	TLT	ETF	87.55	87.59	87.45	87.45	135500.0
2004-11-08 12:00:00	TLT	ETF	87.45	87.5	87.4	87.45	63300.0
2004-11-08 13:00:00	TLT	ETF	87.47	87.59	87.47	87.53	13100.0
2004-11-08 14:00:00	TLT	ETF	87.52	87.52	87.46	87.47	11700.0

> showing 50 of 767 rows — these rows as CSV

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