PREVIEW / etf_1hour / 2004-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-04.parquet
  size:    24 KB
  rows:    670

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-03-04 08:00:00	SPY	ETF	115.72	115.82	115.69	115.75	76200.0
2004-03-04 09:00:00	SPY	ETF	115.75	115.85	115.63	115.81	2173400.0
2004-03-04 10:00:00	SPY	ETF	115.78	115.85	115.52	115.63	2574900.0
2004-03-04 11:00:00	SPY	ETF	115.63	115.93	115.62	115.83	2741000.0
2004-03-04 12:00:00	SPY	ETF	115.82	116.06	115.77	116.03	2416400.0
2004-03-04 13:00:00	SPY	ETF	116.05	116.1	115.81	115.88	3122900.0
2004-03-04 14:00:00	SPY	ETF	115.87	116.05	115.86	115.98	1662900.0
2004-03-04 15:00:00	SPY	ETF	115.98	116.08	115.86	116.04	1771000.0
2004-03-04 16:00:00	SPY	ETF	116.05	116.07	115.65	116.05	1011100.0
2004-03-04 17:00:00	SPY	ETF	116.02	116.03	115.9	115.97	9300.0
2004-03-04 18:00:00	SPY	ETF	115.92	115.96	115.92	115.93	7500.0
2004-03-04 19:00:00	SPY	ETF	116.02	116.02	116.01	116.01	1900.0
2004-03-04 08:00:00	QQQ	ETF	36.47	36.5	36.45	36.45	94800.0
2004-03-04 09:00:00	QQQ	ETF	36.46	36.59	36.413	36.54	6986700.0
2004-03-04 10:00:00	QQQ	ETF	36.53	36.574	36.4	36.51	8238300.0
2004-03-04 11:00:00	QQQ	ETF	36.5	36.65	36.5	36.602	6888200.0
2004-03-04 12:00:00	QQQ	ETF	36.601	36.74	36.58	36.73	6742100.0
2004-03-04 13:00:00	QQQ	ETF	36.73	36.82	36.67	36.7	9526300.0
2004-03-04 14:00:00	QQQ	ETF	36.695	36.81	36.69	36.76	6206000.0
2004-03-04 15:00:00	QQQ	ETF	36.76	36.83	36.68	36.809	7593800.0
2004-03-04 16:00:00	QQQ	ETF	36.82	36.83	36.58	36.702	4192700.0
2004-03-04 17:00:00	QQQ	ETF	36.72	36.73	36.66	36.71	227000.0
2004-03-04 18:00:00	QQQ	ETF	36.71	36.73	36.68	36.7	44400.0
2004-03-04 19:00:00	QQQ	ETF	36.73	36.73	36.69	36.69	5800.0
2004-03-04 09:00:00	IWM	ETF	58.94	59.05	58.86	59.015	516800.0
2004-03-04 10:00:00	IWM	ETF	59.015	59.02	58.685	58.955	570200.0
2004-03-04 11:00:00	IWM	ETF	58.98	59.325	58.955	59.17	443200.0
2004-03-04 12:00:00	IWM	ETF	59.175	59.39	59.165	59.375	459800.0
2004-03-04 13:00:00	IWM	ETF	59.385	59.43	59.28	59.33	521400.0
2004-03-04 14:00:00	IWM	ETF	59.33	59.45	59.32	59.435	769200.0
2004-03-04 15:00:00	IWM	ETF	59.41	59.65	59.295	59.605	604400.0
2004-03-04 16:00:00	IWM	ETF	59.595	59.655	59.481	59.55	251800.0
2004-03-04 17:00:00	IWM	ETF	59.504	59.504	59.504	59.504	800.0
2004-03-04 08:00:00	DIA	ETF	106.28	106.28	106.24	106.24	1600.0
2004-03-04 09:00:00	DIA	ETF	106.18	106.22	106.08	106.17	445600.0
2004-03-04 10:00:00	DIA	ETF	106.19	106.19	105.8	105.82	769600.0
2004-03-04 11:00:00	DIA	ETF	105.87	106.1	105.85	106.05	512700.0
2004-03-04 12:00:00	DIA	ETF	106.04	106.21	106.01	106.15	153600.0
2004-03-04 13:00:00	DIA	ETF	106.16	106.19	105.87	105.93	173000.0
2004-03-04 14:00:00	DIA	ETF	105.96	106.09	105.93	106.05	273200.0
2004-03-04 15:00:00	DIA	ETF	106.05	106.06	105.92	106.0	592900.0
2004-03-04 16:00:00	DIA	ETF	106.03	106.08	105.89	105.96	648900.0
2004-03-04 09:00:00	TLT	ETF	87.4	87.45	87.34	87.45	7000.0
2004-03-04 10:00:00	TLT	ETF	87.43	87.63	87.38	87.63	36500.0
2004-03-04 11:00:00	TLT	ETF	87.58	87.75	87.56	87.75	24200.0
2004-03-04 12:00:00	TLT	ETF	87.74	87.94	87.7	87.92	15200.0
2004-03-04 13:00:00	TLT	ETF	87.95	87.95	87.81	87.89	20700.0
2004-03-04 14:00:00	TLT	ETF	87.9	87.92	87.78	87.88	14400.0
2004-03-04 15:00:00	TLT	ETF	87.89	87.94	87.864	87.91	260900.0
2004-03-04 16:00:00	TLT	ETF	87.85	87.94	87.85	87.94	24300.0

> showing 50 of 670 rows — these rows as CSV

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