PREVIEW / etf_1hour / 2005-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-15.parquet
  size:    35 KB
  rows:    1,085

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
2005-11-15 07:00:00	SPY	ETF	123.43	123.47	123.43	123.44	3100.0
2005-11-15 08:00:00	SPY	ETF	123.47	123.74	123.4	123.54	2604300.0
2005-11-15 09:00:00	SPY	ETF	123.58	123.65	123.3	123.36	9788200.0
2005-11-15 10:00:00	SPY	ETF	123.37	123.89	123.32	123.76	10511500.0
2005-11-15 11:00:00	SPY	ETF	123.77	123.91	123.65	123.89	3837000.0
2005-11-15 12:00:00	SPY	ETF	123.88	124.09	123.85	124.02	7023200.0
2005-11-15 13:00:00	SPY	ETF	124.02	124.05	123.44	123.53	9187500.0
2005-11-15 14:00:00	SPY	ETF	123.53	123.6	122.95	122.95	14018400.0
2005-11-15 15:00:00	SPY	ETF	122.95	123.43	122.86	123.15	10241900.0
2005-11-15 16:00:00	SPY	ETF	123.15	123.473	123.14	123.25	1044800.0
2005-11-15 17:00:00	SPY	ETF	123.25	123.3	123.22	123.29	23000.0
2005-11-15 18:00:00	SPY	ETF	123.22	123.22	123.22	123.22	2500.0
2005-11-15 19:00:00	SPY	ETF	123.2	123.2	123.2	123.2	500.0
2005-11-15 09:00:00	QQQ	ETF	40.73	40.79	40.62	40.69	9232100.0
2005-11-15 10:00:00	QQQ	ETF	40.69	40.78	40.63	40.74	10547200.0
2005-11-15 11:00:00	QQQ	ETF	40.73	40.8	40.69	40.8	3641700.0
2005-11-15 12:00:00	QQQ	ETF	40.8	40.9	40.76	40.83	8834300.0
2005-11-15 13:00:00	QQQ	ETF	40.83	40.85	40.6	40.62	10223100.0
2005-11-15 14:00:00	QQQ	ETF	40.63	40.64	40.41	40.41	19518500.0
2005-11-15 15:00:00	QQQ	ETF	40.42	40.55	40.38	40.52	14798700.0
2005-11-15 08:00:00	IWM	ETF	66.09	66.18	66.02	66.07	50400.0
2005-11-15 09:00:00	IWM	ETF	66.04	66.16	65.65	65.67	5041100.0
2005-11-15 10:00:00	IWM	ETF	65.67	65.88	65.47	65.78	6923600.0
2005-11-15 11:00:00	IWM	ETF	65.79	66.08	65.69	66.06	4089500.0
2005-11-15 12:00:00	IWM	ETF	66.07	66.24	65.99	66.16	2440200.0
2005-11-15 13:00:00	IWM	ETF	66.16	66.21	65.48	65.52	4625800.0
2005-11-15 14:00:00	IWM	ETF	65.52	65.53	65.19	65.2	4642700.0
2005-11-15 15:00:00	IWM	ETF	65.18	65.43	65.15	65.29	5955400.0
2005-11-15 16:00:00	IWM	ETF	65.3	65.3	65.19	65.24	176100.0
2005-11-15 17:00:00	IWM	ETF	65.26	65.26	65.26	65.26	2200.0
2005-11-15 18:00:00	IWM	ETF	65.23	65.23	65.23	65.23	100.0
2005-11-15 07:00:00	DIA	ETF	107.0	107.0	107.0	107.0	200.0
2005-11-15 08:00:00	DIA	ETF	107.14	107.41	107.14	107.25	24300.0
2005-11-15 09:00:00	DIA	ETF	107.22	107.26	106.97	106.99	1049800.0
2005-11-15 10:00:00	DIA	ETF	106.982	107.36	106.97	107.29	1155800.0
2005-11-15 11:00:00	DIA	ETF	107.25	107.38	107.2	107.38	231600.0
2005-11-15 12:00:00	DIA	ETF	107.38	107.55	107.35	107.5	867600.0
2005-11-15 13:00:00	DIA	ETF	107.53	107.57	107.13	107.16	989400.0
2005-11-15 14:00:00	DIA	ETF	107.16	107.16	106.84	106.84	1724900.0
2005-11-15 15:00:00	DIA	ETF	106.83	107.02	106.77	107.02	1167600.0
2005-11-15 16:00:00	DIA	ETF	107.03	107.14	106.95	107.14	133700.0
2005-11-15 17:00:00	DIA	ETF	107.12	107.53	107.12	107.15	1300.0
2005-11-15 08:00:00	GLD	ETF	46.78	46.82	46.58	46.58	11300.0
2005-11-15 09:00:00	GLD	ETF	46.8	46.83	46.76	46.78	200500.0
2005-11-15 10:00:00	GLD	ETF	46.78	46.78	46.63	46.63	124600.0
2005-11-15 11:00:00	GLD	ETF	46.64	46.7	46.53	46.65	550600.0
2005-11-15 12:00:00	GLD	ETF	46.67	46.75	46.641	46.66	53700.0
2005-11-15 13:00:00	GLD	ETF	46.67	46.74	46.66	46.67	48300.0
2005-11-15 14:00:00	GLD	ETF	46.68	46.73	46.61	46.62	188200.0
2005-11-15 15:00:00	GLD	ETF	46.62	46.68	46.6	46.66	148200.0

> showing 50 of 1,085 rows — these rows as CSV

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