PREVIEW / etf_1hour / 2004-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-18.parquet
  size:    26 KB
  rows:    766

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-18 08:00:00	SPY	ETF	118.48	118.64	118.44	118.56	65200.0
2004-11-18 09:00:00	SPY	ETF	118.56	118.68	118.38	118.43	3550700.0
2004-11-18 10:00:00	SPY	ETF	118.43	118.72	118.23	118.62	7080200.0
2004-11-18 11:00:00	SPY	ETF	118.63	118.68	118.52	118.57	3301700.0
2004-11-18 12:00:00	SPY	ETF	118.57	118.67	118.44	118.44	3869000.0
2004-11-18 13:00:00	SPY	ETF	118.45	118.6	118.35	118.6	2792700.0
2004-11-18 14:00:00	SPY	ETF	118.6	118.77	118.36	118.72	3481800.0
2004-11-18 15:00:00	SPY	ETF	118.71	118.8	118.54	118.68	5401100.0
2004-11-18 16:00:00	SPY	ETF	118.68	118.75	118.62	118.73	1201600.0
2004-11-18 17:00:00	SPY	ETF	118.73	118.77	118.69	118.69	58700.0
2004-11-18 18:00:00	SPY	ETF	118.7	118.7	118.62	118.62	15800.0
2004-11-18 08:00:00	QQQ	ETF	38.99	38.99	38.89	38.97	323300.0
2004-11-18 09:00:00	QQQ	ETF	38.97	39.12	38.94	38.98	13219300.0
2004-11-18 10:00:00	QQQ	ETF	38.98	39.22	38.887	39.19	17093500.0
2004-11-18 11:00:00	QQQ	ETF	39.19	39.23	39.127	39.16	13529400.0
2004-11-18 12:00:00	QQQ	ETF	39.16	39.22	39.11	39.125	11126600.0
2004-11-18 13:00:00	QQQ	ETF	39.126	39.19	39.069	39.18	8699600.0
2004-11-18 14:00:00	QQQ	ETF	39.185	39.34	39.1	39.31	11061300.0
2004-11-18 15:00:00	QQQ	ETF	39.31	39.36	39.23	39.29	16860400.0
2004-11-18 16:00:00	QQQ	ETF	39.3	39.33	39.27	39.294	1996700.0
2004-11-18 17:00:00	QQQ	ETF	39.29	39.32	39.28	39.31	125800.0
2004-11-18 18:00:00	QQQ	ETF	39.31	39.31	39.27	39.27	40100.0
2004-11-18 19:00:00	QQQ	ETF	39.27	39.29	39.26	39.27	14800.0
2004-11-18 08:00:00	IWM	ETF	62.05	62.07	62.045	62.07	8600.0
2004-11-18 09:00:00	IWM	ETF	62.01	62.18	61.93	61.94	1407000.0
2004-11-18 10:00:00	IWM	ETF	61.915	61.97	61.63	61.955	1898200.0
2004-11-18 11:00:00	IWM	ETF	61.95	61.97	61.865	61.925	892000.0
2004-11-18 12:00:00	IWM	ETF	61.925	61.945	61.68	61.69	1768000.0
2004-11-18 13:00:00	IWM	ETF	61.69	61.895	61.675	61.895	1154000.0
2004-11-18 14:00:00	IWM	ETF	61.905	62.095	61.755	62.09	1398200.0
2004-11-18 15:00:00	IWM	ETF	62.065	62.1	61.955	62.015	1931200.0
2004-11-18 16:00:00	IWM	ETF	62.01	62.06	61.96	62.05	352600.0
2004-11-18 17:00:00	IWM	ETF	62.1	62.1	62.095	62.1	20400.0
2004-11-18 08:00:00	DIA	ETF	105.96	106.0	105.95	105.99	3700.0
2004-11-18 09:00:00	DIA	ETF	105.91	106.05	105.89	105.93	548500.0
2004-11-18 10:00:00	DIA	ETF	105.92	106.05	105.73	105.99	866600.0
2004-11-18 11:00:00	DIA	ETF	106.0	106.1	105.8	105.95	528800.0
2004-11-18 12:00:00	DIA	ETF	105.95	106.03	105.87	105.88	857900.0
2004-11-18 13:00:00	DIA	ETF	105.88	105.99	105.78	105.96	298600.0
2004-11-18 14:00:00	DIA	ETF	105.96	106.09	105.79	106.05	840500.0
2004-11-18 15:00:00	DIA	ETF	106.04	106.1	105.94	105.98	697600.0
2004-11-18 16:00:00	DIA	ETF	105.98	106.06	105.96	106.04	42700.0
2004-11-18 17:00:00	DIA	ETF	106.09	106.09	106.09	106.09	400.0
2004-11-18 18:00:00	DIA	ETF	106.05	106.05	106.02	106.02	500.0
2004-11-18 19:00:00	DIA	ETF	106.02	106.1	106.02	106.1	1300.0
2004-11-18 09:00:00	GLD	ETF	44.43	44.49	44.2	44.2	1082700.0
2004-11-18 10:00:00	GLD	ETF	44.22	44.36	44.07	44.22	1802100.0
2004-11-18 11:00:00	GLD	ETF	44.23	44.32	44.18	44.24	787700.0
2004-11-18 12:00:00	GLD	ETF	44.24	44.25	44.09	44.24	895100.0
2004-11-18 13:00:00	GLD	ETF	44.24	44.34	44.22	44.32	417200.0

> showing 50 of 766 rows — these rows as CSV

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