PREVIEW / etf_1hour / 2005-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-01.parquet
  size:    33 KB
  rows:    1,010

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-01 04:00:00	SPY	ETF	120.55	120.55	120.55	120.55	800.0
2005-11-01 06:00:00	SPY	ETF	120.62	120.62	120.6	120.6	12000.0
2005-11-01 07:00:00	SPY	ETF	120.68	120.7	120.6	120.6	105900.0
2005-11-01 08:00:00	SPY	ETF	120.65	120.72	120.13	120.61	1824400.0
2005-11-01 09:00:00	SPY	ETF	120.62	120.69	120.13	120.39	9422600.0
2005-11-01 10:00:00	SPY	ETF	120.39	120.64	120.25	120.57	9384000.0
2005-11-01 11:00:00	SPY	ETF	120.55	120.6	120.37	120.46	3573600.0
2005-11-01 12:00:00	SPY	ETF	120.46	120.55	120.38	120.44	3677700.0
2005-11-01 13:00:00	SPY	ETF	120.44	120.64	120.35	120.43	3332400.0
2005-11-01 14:00:00	SPY	ETF	120.42	120.9	120.27	120.34	21352600.0
2005-11-01 15:00:00	SPY	ETF	120.34	120.57	120.22	120.3	10275600.0
2005-11-01 16:00:00	SPY	ETF	120.31	120.53	120.3	120.4023	540300.0
2005-11-01 17:00:00	SPY	ETF	120.43	120.49	120.37	120.47	603400.0
2005-11-01 18:00:00	SPY	ETF	120.47	120.49	120.42	120.47	3100.0
2005-11-01 19:00:00	SPY	ETF	120.47	120.47	120.47	120.47	100.0
2005-11-01 09:00:00	QQQ	ETF	38.76	39.82	38.75	38.79	13362600.0
2005-11-01 10:00:00	QQQ	ETF	38.8	38.87	38.71	38.85	11549900.0
2005-11-01 11:00:00	QQQ	ETF	38.84	38.85	38.75	38.82	5318700.0
2005-11-01 12:00:00	QQQ	ETF	38.82	38.88	38.78	38.82	5320400.0
2005-11-01 13:00:00	QQQ	ETF	38.83	38.85	38.78	38.83	3327300.0
2005-11-01 14:00:00	QQQ	ETF	38.83	39.01	38.78	38.83	21197600.0
2005-11-01 15:00:00	QQQ	ETF	38.83	38.9	38.76	38.84	11412900.0
2005-11-01 07:00:00	IWM	ETF	63.92	63.92	63.92	63.92	1000.0
2005-11-01 08:00:00	IWM	ETF	63.96	64.02	63.78	64.01	916600.0
2005-11-01 09:00:00	IWM	ETF	64.01	64.1	63.65	63.68	3600300.0
2005-11-01 10:00:00	IWM	ETF	63.68	63.96	63.6	63.93	8768300.0
2005-11-01 11:00:00	IWM	ETF	63.94	63.95	63.78	63.95	2218100.0
2005-11-01 12:00:00	IWM	ETF	63.95	64.08	63.88	63.93	2771800.0
2005-11-01 13:00:00	IWM	ETF	63.92	64.08	63.91	64.01	797800.0
2005-11-01 14:00:00	IWM	ETF	64.02	64.37	63.86	63.9	6312500.0
2005-11-01 15:00:00	IWM	ETF	63.89	64.01	63.7	63.99	4654700.0
2005-11-01 16:00:00	IWM	ETF	64.03	64.19	63.98	64.14	98900.0
2005-11-01 08:00:00	DIA	ETF	104.25	104.3	103.89	104.29	524500.0
2005-11-01 09:00:00	DIA	ETF	104.31	104.48	103.97	104.289	769100.0
2005-11-01 10:00:00	DIA	ETF	104.29	104.36	104.18	104.36	583500.0
2005-11-01 11:00:00	DIA	ETF	104.36	104.36	104.16	104.26	412900.0
2005-11-01 12:00:00	DIA	ETF	104.262	104.28	104.17	104.21	102400.0
2005-11-01 13:00:00	DIA	ETF	104.22	104.22	104.08	104.09	319500.0
2005-11-01 14:00:00	DIA	ETF	104.09	104.47	103.98	104.06	1449300.0
2005-11-01 15:00:00	DIA	ETF	104.06	104.24	103.98	103.99	1069000.0
2005-11-01 16:00:00	DIA	ETF	104.01	104.15	104.0	104.15	21900.0
2005-11-01 08:00:00	GLD	ETF	46.44	46.44	46.08	46.1	4300.0
2005-11-01 09:00:00	GLD	ETF	46.05	46.07	45.97	46.02	523800.0
2005-11-01 10:00:00	GLD	ETF	46.01	46.02	45.65	45.84	1092600.0
2005-11-01 11:00:00	GLD	ETF	45.84	45.97	45.8	45.9	355100.0
2005-11-01 12:00:00	GLD	ETF	45.9	45.92	45.81	45.86	140100.0
2005-11-01 13:00:00	GLD	ETF	45.86	45.86	45.71	45.8	390100.0
2005-11-01 14:00:00	GLD	ETF	45.8	45.81	45.75	45.76	541300.0
2005-11-01 15:00:00	GLD	ETF	45.76	45.79	45.72	45.7499	403800.0
2005-11-01 16:00:00	GLD	ETF	45.72	45.72	45.71	45.71	28500.0

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

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