PREVIEW / etf_1hour / 2004-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-25.parquet
  size:    24 KB
  rows:    663

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-25 08:00:00	SPY	ETF	114.53	114.64	114.53	114.55	19600.0
2004-02-25 09:00:00	SPY	ETF	114.54	114.84	114.38	114.8	6553600.0
2004-02-25 10:00:00	SPY	ETF	114.78	114.91	114.63	114.77	3965400.0
2004-02-25 11:00:00	SPY	ETF	114.75	115.03	114.32	114.54	5198000.0
2004-02-25 12:00:00	SPY	ETF	114.55	114.87	114.48	114.87	3135700.0
2004-02-25 13:00:00	SPY	ETF	114.88	114.95	114.66	114.84	1301000.0
2004-02-25 14:00:00	SPY	ETF	114.84	114.94	114.71	114.82	2106400.0
2004-02-25 15:00:00	SPY	ETF	114.81	115.06	114.79	114.91	5003300.0
2004-02-25 16:00:00	SPY	ETF	114.91	114.96	114.81	114.93	2535800.0
2004-02-25 17:00:00	SPY	ETF	114.96	114.99	114.87	114.98	91600.0
2004-02-25 18:00:00	SPY	ETF	114.99	114.99	114.97	114.99	17300.0
2004-02-25 19:00:00	SPY	ETF	114.97	114.97	114.95	114.95	600.0
2004-02-25 08:00:00	QQQ	ETF	36.39	36.45	36.39	36.42	133200.0
2004-02-25 09:00:00	QQQ	ETF	36.41	36.67	36.4	36.64	13936900.0
2004-02-25 10:00:00	QQQ	ETF	36.63	36.654	36.45	36.51	13737600.0
2004-02-25 11:00:00	QQQ	ETF	36.512	36.63	36.33	36.42	12404000.0
2004-02-25 12:00:00	QQQ	ETF	36.42	36.58	36.38	36.57	5120000.0
2004-02-25 13:00:00	QQQ	ETF	36.57	36.601	36.5	36.56	4815400.0
2004-02-25 14:00:00	QQQ	ETF	36.56	36.606	36.46	36.52	4866100.0
2004-02-25 15:00:00	QQQ	ETF	36.51	36.64	36.49	36.58	10992600.0
2004-02-25 16:00:00	QQQ	ETF	36.58	36.622	36.5	36.62	4194500.0
2004-02-25 17:00:00	QQQ	ETF	36.62	36.64	36.59	36.63	178200.0
2004-02-25 18:00:00	QQQ	ETF	36.63	36.631	36.58	36.62	46300.0
2004-02-25 19:00:00	QQQ	ETF	36.61	36.63	36.6	36.6	9300.0
2004-02-25 09:00:00	IWM	ETF	57.075	57.345	56.84	57.325	2955000.0
2004-02-25 10:00:00	IWM	ETF	57.32	57.405	57.175	57.2	1241600.0
2004-02-25 11:00:00	IWM	ETF	57.18	57.37	56.985	57.075	710600.0
2004-02-25 12:00:00	IWM	ETF	57.045	57.29	57.03	57.29	831400.0
2004-02-25 13:00:00	IWM	ETF	57.265	57.345	57.205	57.27	774000.0
2004-02-25 14:00:00	IWM	ETF	57.28	57.47	57.265	57.315	871400.0
2004-02-25 15:00:00	IWM	ETF	57.325	57.73	57.29	57.68	1831600.0
2004-02-25 16:00:00	IWM	ETF	57.6755	57.7025	57.625	57.7025	520200.0
2004-02-25 08:00:00	DIA	ETF	105.95	106.0	105.95	105.98	3400.0
2004-02-25 09:00:00	DIA	ETF	105.91	106.18	105.71	106.13	719100.0
2004-02-25 10:00:00	DIA	ETF	106.15	106.2	105.95	106.05	659800.0
2004-02-25 11:00:00	DIA	ETF	106.05	106.33	105.8	105.96	738700.0
2004-02-25 12:00:00	DIA	ETF	105.96	106.17	105.9	106.15	210400.0
2004-02-25 13:00:00	DIA	ETF	106.18	106.18	105.97	106.12	253500.0
2004-02-25 14:00:00	DIA	ETF	106.1	106.18	106.0	106.09	184600.0
2004-02-25 15:00:00	DIA	ETF	106.09	106.29	106.06	106.19	992100.0
2004-02-25 16:00:00	DIA	ETF	106.167	106.2	106.15	106.18	297500.0
2004-02-25 17:00:00	DIA	ETF	106.2	106.25	106.19	106.19	2600.0
2004-02-25 18:00:00	DIA	ETF	106.2	106.2	106.17	106.17	600.0
2004-02-25 09:00:00	TLT	ETF	88.22	88.26	88.2	88.22	215400.0
2004-02-25 10:00:00	TLT	ETF	88.17	88.25	88.08	88.16	80800.0
2004-02-25 11:00:00	TLT	ETF	88.16	88.36	88.12	88.12	93900.0
2004-02-25 12:00:00	TLT	ETF	88.16	88.23	88.1	88.11	21000.0
2004-02-25 13:00:00	TLT	ETF	88.12	88.25	88.03	88.1	37900.0
2004-02-25 14:00:00	TLT	ETF	88.07	88.12	88.04	88.08	75500.0
2004-02-25 15:00:00	TLT	ETF	88.08	88.14	88.06	88.12	47100.0

> showing 50 of 663 rows — these rows as CSV

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