PREVIEW / etf_1hour / 2004-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-22.parquet
  size:    28 KB
  rows:    772

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-22 08:00:00	SPY	ETF	117.12	117.15	117.06	117.13	24700.0
2004-11-22 09:00:00	SPY	ETF	117.14	117.25	117.09	117.09	3722700.0
2004-11-22 10:00:00	SPY	ETF	117.12	117.38	117.03	117.16	6653300.0
2004-11-22 11:00:00	SPY	ETF	117.14	117.32	117.05	117.15	3230900.0
2004-11-22 12:00:00	SPY	ETF	117.15	117.43	117.11	117.35	1912700.0
2004-11-22 13:00:00	SPY	ETF	117.35	117.83	117.34	117.83	5650200.0
2004-11-22 14:00:00	SPY	ETF	117.83	118.12	117.8	117.82	5613700.0
2004-11-22 15:00:00	SPY	ETF	117.81	118.05	117.75	117.95	6317500.0
2004-11-22 16:00:00	SPY	ETF	117.97	118.04	117.94	117.95	2101600.0
2004-11-22 17:00:00	SPY	ETF	117.96	117.99	117.1	117.96	6500.0
2004-11-22 18:00:00	SPY	ETF	118.0	118.0	117.97	117.98	400.0
2004-11-22 19:00:00	SPY	ETF	117.98	118.03	117.98	118.0	7900.0
2004-11-22 08:00:00	QQQ	ETF	38.51	38.57	38.5	38.55	83500.0
2004-11-22 09:00:00	QQQ	ETF	38.55	38.64	38.54	38.571	10002700.0
2004-11-22 10:00:00	QQQ	ETF	38.57	38.65	38.48	38.55	14291200.0
2004-11-22 11:00:00	QQQ	ETF	38.55	38.61	38.5	38.535	7110900.0
2004-11-22 12:00:00	QQQ	ETF	38.55	38.71	38.515	38.69	5952900.0
2004-11-22 13:00:00	QQQ	ETF	38.69	38.95	38.68	38.9	13734700.0
2004-11-22 14:00:00	QQQ	ETF	38.9	39.04	38.89	38.907	12287700.0
2004-11-22 15:00:00	QQQ	ETF	38.909	39.03	38.87	39.02	11844400.0
2004-11-22 16:00:00	QQQ	ETF	39.02	39.07	38.88	39.05	2682000.0
2004-11-22 17:00:00	QQQ	ETF	39.05	39.07	39.03	39.042	86300.0
2004-11-22 18:00:00	QQQ	ETF	39.051	39.06	39.05	39.06	15400.0
2004-11-22 19:00:00	QQQ	ETF	39.05	39.06	39.04	39.05	14200.0
2004-11-22 08:00:00	IWM	ETF	61.005	61.025	60.975	60.975	3200.0
2004-11-22 09:00:00	IWM	ETF	61.065	61.255	61.065	61.155	2386600.0
2004-11-22 10:00:00	IWM	ETF	61.15	61.31	61.125	61.18	2602000.0
2004-11-22 11:00:00	IWM	ETF	61.185	61.29	61.145	61.24	1186800.0
2004-11-22 12:00:00	IWM	ETF	61.24	61.445	61.23	61.415	759800.0
2004-11-22 13:00:00	IWM	ETF	61.415	61.825	61.41	61.78	2301000.0
2004-11-22 14:00:00	IWM	ETF	61.785	61.935	61.78	61.795	1465600.0
2004-11-22 15:00:00	IWM	ETF	61.795	62.02	61.725	62.01	1522200.0
2004-11-22 16:00:00	IWM	ETF	62.01	62.025	61.825	61.95	1024000.0
2004-11-22 17:00:00	IWM	ETF	61.95	62.01	61.95	62.01	6600.0
2004-11-22 08:00:00	DIA	ETF	104.32	104.33	104.27	104.27	27600.0
2004-11-22 09:00:00	DIA	ETF	104.33	104.45	104.25	104.26	1236800.0
2004-11-22 10:00:00	DIA	ETF	104.26	104.53	104.23	104.33	1639700.0
2004-11-22 11:00:00	DIA	ETF	104.34	104.44	104.26	104.3	990400.0
2004-11-22 12:00:00	DIA	ETF	104.3	104.47	104.26	104.4	775100.0
2004-11-22 13:00:00	DIA	ETF	104.4	104.76	104.39	104.73	873700.0
2004-11-22 14:00:00	DIA	ETF	104.74	105.0	104.73	104.75	1037200.0
2004-11-22 15:00:00	DIA	ETF	104.75	104.9	104.68	104.79	1203900.0
2004-11-22 16:00:00	DIA	ETF	104.8	104.85	104.77	104.82	224200.0
2004-11-22 18:00:00	DIA	ETF	104.73	104.73	104.73	104.73	300.0
2004-11-22 19:00:00	DIA	ETF	104.78	104.78	104.78	104.78	100.0
2004-11-22 09:00:00	GLD	ETF	44.75	44.89	44.74	44.86	1318100.0
2004-11-22 10:00:00	GLD	ETF	44.86	44.89	44.82	44.83	2819000.0
2004-11-22 11:00:00	GLD	ETF	44.84	44.88	44.8	44.85	3209100.0
2004-11-22 12:00:00	GLD	ETF	44.85	44.9	44.83	44.86	3115200.0
2004-11-22 13:00:00	GLD	ETF	44.86	44.95	44.84	44.94	331600.0

> showing 50 of 772 rows — these rows as CSV

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