PREVIEW / etf_1hour / 2004-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-07.parquet
  size:    25 KB
  rows:    707

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-10-07 08:00:00	SPY	ETF	114.4	114.5	114.35	114.45	68700.0
2004-10-07 09:00:00	SPY	ETF	114.43	114.43	114.17	114.24	4048400.0
2004-10-07 10:00:00	SPY	ETF	114.23	114.27	114.06	114.12	5623800.0
2004-10-07 11:00:00	SPY	ETF	114.11	114.13	113.73	113.82	6261300.0
2004-10-07 12:00:00	SPY	ETF	113.83	113.92	113.59	113.74	4178200.0
2004-10-07 13:00:00	SPY	ETF	113.75	113.86	113.66	113.81	3395800.0
2004-10-07 14:00:00	SPY	ETF	113.81	113.97	113.79	113.81	3582500.0
2004-10-07 15:00:00	SPY	ETF	113.82	113.83	113.36	113.38	7223800.0
2004-10-07 16:00:00	SPY	ETF	113.38	114.5848	113.38	113.45	3714600.0
2004-10-07 17:00:00	SPY	ETF	113.45	113.47	113.42	113.45	13500.0
2004-10-07 18:00:00	SPY	ETF	113.47	113.48	113.43	113.43	7500.0
2004-10-07 19:00:00	SPY	ETF	113.49	113.49	113.49	113.49	300.0
2004-10-07 08:00:00	QQQ	ETF	36.55	36.63	36.54	36.61	156300.0
2004-10-07 09:00:00	QQQ	ETF	36.59	36.641	36.5	36.56	12093500.0
2004-10-07 10:00:00	QQQ	ETF	36.56	36.67	36.47	36.55	12787400.0
2004-10-07 11:00:00	QQQ	ETF	36.54	36.56	36.33	36.4	16877100.0
2004-10-07 12:00:00	QQQ	ETF	36.4	36.47	36.31	36.36	7791500.0
2004-10-07 13:00:00	QQQ	ETF	36.36	36.47	36.34	36.41	6279100.0
2004-10-07 14:00:00	QQQ	ETF	36.4	36.5	36.38	36.392	6853100.0
2004-10-07 15:00:00	QQQ	ETF	36.393	36.41	36.17	36.207	15693800.0
2004-10-07 16:00:00	QQQ	ETF	36.206	36.298	36.17	36.29	2074900.0
2004-10-07 17:00:00	QQQ	ETF	36.28	36.3	36.24	36.24	34100.0
2004-10-07 18:00:00	QQQ	ETF	36.24	36.27	36.21	36.25	66300.0
2004-10-07 19:00:00	QQQ	ETF	36.25	36.25	36.25	36.25	12600.0
2004-10-07 09:00:00	IWM	ETF	58.925	58.935	58.77	58.845	1249600.0
2004-10-07 10:00:00	IWM	ETF	58.835	58.88	58.69	58.755	1094200.0
2004-10-07 11:00:00	IWM	ETF	58.74	58.74	58.265	58.36	2227800.0
2004-10-07 12:00:00	IWM	ETF	58.37	58.465	58.29	58.35	1106400.0
2004-10-07 13:00:00	IWM	ETF	58.345	58.43	58.3	58.365	455800.0
2004-10-07 14:00:00	IWM	ETF	58.36	58.535	58.355	58.435	823200.0
2004-10-07 15:00:00	IWM	ETF	58.43	58.43	58.025	58.035	2625000.0
2004-10-07 16:00:00	IWM	ETF	58.03	58.2	58.02	58.16	521600.0
2004-10-07 08:00:00	DIA	ETF	102.45	102.55	102.45	102.52	5500.0
2004-10-07 09:00:00	DIA	ETF	102.5	102.5	102.23	102.27	716300.0
2004-10-07 10:00:00	DIA	ETF	102.26	102.34	102.15	102.18	740900.0
2004-10-07 11:00:00	DIA	ETF	102.17	102.2	101.85	101.99	633900.0
2004-10-07 12:00:00	DIA	ETF	101.99	102.04	101.8	101.93	827300.0
2004-10-07 13:00:00	DIA	ETF	101.92	101.97	101.82	101.9	245600.0
2004-10-07 14:00:00	DIA	ETF	101.9	102.08	101.87	101.9	1048100.0
2004-10-07 15:00:00	DIA	ETF	101.9	101.91	101.44	101.48	2313000.0
2004-10-07 16:00:00	DIA	ETF	101.45	101.51	101.43	101.45	151600.0
2004-10-07 17:00:00	DIA	ETF	101.55	101.55	101.55	101.55	100.0
2004-10-07 08:00:00	TLT	ETF	87.0	87.0	86.94	86.96	7800.0
2004-10-07 09:00:00	TLT	ETF	87.0	87.15	87.0	87.12	135100.0
2004-10-07 10:00:00	TLT	ETF	87.16	87.18	86.82	86.83	326200.0
2004-10-07 11:00:00	TLT	ETF	86.85	86.98	86.85	86.87	93600.0
2004-10-07 12:00:00	TLT	ETF	86.82	86.9	86.78	86.78	137000.0
2004-10-07 13:00:00	TLT	ETF	86.81	86.91	86.74	86.85	309800.0
2004-10-07 14:00:00	TLT	ETF	86.85	87.0	86.85	86.86	429200.0
2004-10-07 15:00:00	TLT	ETF	86.87	86.87	86.79	86.85	449100.0

> showing 50 of 707 rows — these rows as CSV

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