PREVIEW / etf_1hour / 2004-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-09.parquet
  size:    23 KB
  rows:    602

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-02-09 08:00:00	SPY	ETF	114.72	114.72	114.6	114.62	8800.0
2004-02-09 09:00:00	SPY	ETF	114.61	114.7	114.43	114.58	3155700.0
2004-02-09 10:00:00	SPY	ETF	114.57	114.71	114.42	114.55	2217500.0
2004-02-09 11:00:00	SPY	ETF	114.56	114.69	114.45	114.65	2367900.0
2004-02-09 12:00:00	SPY	ETF	114.65	114.76	114.5	114.6	2610100.0
2004-02-09 13:00:00	SPY	ETF	114.6	114.87	114.59	114.75	1975100.0
2004-02-09 14:00:00	SPY	ETF	114.75	114.78	114.37	114.41	2288300.0
2004-02-09 15:00:00	SPY	ETF	114.41	114.49	114.29	114.34	7251700.0
2004-02-09 16:00:00	SPY	ETF	114.34	114.53	114.32	114.49	1852200.0
2004-02-09 17:00:00	SPY	ETF	114.49	114.49	114.47	114.49	6400.0
2004-02-09 18:00:00	SPY	ETF	114.49	114.49	114.44	114.45	4400.0
2004-02-09 19:00:00	SPY	ETF	114.5	114.5	114.45	114.45	300.0
2004-02-09 20:00:00	SPY	ETF	114.48	114.48	114.48	114.48	100.0
2004-02-09 08:00:00	QQQ	ETF	37.35	37.39	37.32	37.36	166200.0
2004-02-09 09:00:00	QQQ	ETF	37.36	37.38	37.14	37.24	8215400.0
2004-02-09 10:00:00	QQQ	ETF	37.23	37.32	37.124	37.25	9321300.0
2004-02-09 11:00:00	QQQ	ETF	37.25	37.35	37.2	37.29	4583600.0
2004-02-09 12:00:00	QQQ	ETF	37.29	37.34	37.23	37.25	4955100.0
2004-02-09 13:00:00	QQQ	ETF	37.26	37.38	37.25	37.31	4973500.0
2004-02-09 14:00:00	QQQ	ETF	37.3	37.34	37.13	37.16	7640800.0
2004-02-09 15:00:00	QQQ	ETF	37.16	37.19	37.05	37.1	14014500.0
2004-02-09 16:00:00	QQQ	ETF	37.09	37.15	37.05	37.13	2478400.0
2004-02-09 17:00:00	QQQ	ETF	37.13	37.2	37.13	37.2	483700.0
2004-02-09 18:00:00	QQQ	ETF	37.18	37.2	37.17	37.18	40000.0
2004-02-09 19:00:00	QQQ	ETF	37.15	37.2	37.15	37.19	33000.0
2004-02-09 09:00:00	IWM	ETF	58.3955	58.415	58.095	58.31	1286200.0
2004-02-09 10:00:00	IWM	ETF	58.2905	58.4	58.17	58.335	825000.0
2004-02-09 11:00:00	IWM	ETF	58.35	58.525	58.335	58.485	847800.0
2004-02-09 12:00:00	IWM	ETF	58.475	58.52	58.395	58.495	1015600.0
2004-02-09 13:00:00	IWM	ETF	58.49	58.65	58.48	58.555	1067600.0
2004-02-09 14:00:00	IWM	ETF	58.55	58.595	58.395	58.45	722200.0
2004-02-09 15:00:00	IWM	ETF	58.39	58.485	58.215	58.25	2063400.0
2004-02-09 16:00:00	IWM	ETF	58.25	58.345	58.235	58.315	712400.0
2004-02-09 18:00:00	IWM	ETF	58.315	58.315	58.295	58.295	2000.0
2004-02-09 08:00:00	DIA	ETF	106.16	106.22	106.09	106.1	8600.0
2004-02-09 09:00:00	DIA	ETF	106.12	106.17	105.83	106.037	679000.0
2004-02-09 10:00:00	DIA	ETF	106.035	106.11	105.85	106.03	387700.0
2004-02-09 11:00:00	DIA	ETF	106.01	106.19	105.95	106.11	423500.0
2004-02-09 12:00:00	DIA	ETF	106.1	106.24	106.01	106.13	329000.0
2004-02-09 13:00:00	DIA	ETF	106.14	106.42	106.13	106.24	301500.0
2004-02-09 14:00:00	DIA	ETF	106.29	106.29	105.99	106.0	302000.0
2004-02-09 15:00:00	DIA	ETF	106.0	106.08	105.9	105.97	603400.0
2004-02-09 16:00:00	DIA	ETF	105.99	106.15	105.97	106.12	612500.0
2004-02-09 09:00:00	TLT	ETF	87.56	87.56	87.5	87.5	600.0
2004-02-09 10:00:00	TLT	ETF	87.5	87.5	87.39	87.4	31200.0
2004-02-09 11:00:00	TLT	ETF	87.45	87.45	87.45	87.45	6000.0
2004-02-09 12:00:00	TLT	ETF	87.5	87.56	87.4	87.45	20700.0
2004-02-09 13:00:00	TLT	ETF	87.5	87.54	87.47	87.51	8100.0
2004-02-09 14:00:00	TLT	ETF	87.49	87.61	87.49	87.53	22800.0
2004-02-09 15:00:00	TLT	ETF	87.49	87.59	87.49	87.55	121900.0

> showing 50 of 602 rows — these rows as CSV

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