PREVIEW / etf_1hour / 2005-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-21.parquet
  size:    33 KB
  rows:    984

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-10-21 05:00:00	SPY	ETF	118.32	118.32	118.32	118.32	56600.0
2005-10-21 07:00:00	SPY	ETF	118.12	118.15	118.07	118.13	140500.0
2005-10-21 08:00:00	SPY	ETF	118.11	118.35	118.07	118.14	2893700.0
2005-10-21 09:00:00	SPY	ETF	118.13	118.66	117.51	118.28	15829800.0
2005-10-21 10:00:00	SPY	ETF	118.29	118.5	117.8	117.96	15440300.0
2005-10-21 11:00:00	SPY	ETF	117.98	118.25	117.64	117.76	9027900.0
2005-10-21 12:00:00	SPY	ETF	117.75	118.54	117.51	118.54	18995500.0
2005-10-21 13:00:00	SPY	ETF	118.5	118.78	118.24	118.58	9086400.0
2005-10-21 14:00:00	SPY	ETF	118.58	118.74	118.15	118.34	7856300.0
2005-10-21 15:00:00	SPY	ETF	118.34	118.35	117.95	118.02	10401900.0
2005-10-21 16:00:00	SPY	ETF	118.0	118.22	117.68	118.17	1941700.0
2005-10-21 17:00:00	SPY	ETF	118.2	118.21	118.15	118.15	269400.0
2005-10-21 18:00:00	SPY	ETF	118.2	118.2	118.15	118.15	300.0
2005-10-21 09:00:00	QQQ	ETF	38.7	38.86	38.54	38.6	17541800.0
2005-10-21 10:00:00	QQQ	ETF	38.6	38.75	38.49	38.54	19571400.0
2005-10-21 11:00:00	QQQ	ETF	38.54	38.66	38.44	38.5	12485300.0
2005-10-21 12:00:00	QQQ	ETF	38.5	38.72	38.38	38.71	20011700.0
2005-10-21 13:00:00	QQQ	ETF	38.72	38.75	38.6	38.67	9331700.0
2005-10-21 14:00:00	QQQ	ETF	38.68	38.73	38.56	38.63	8609800.0
2005-10-21 15:00:00	QQQ	ETF	38.63	38.65	38.53	38.55	11365100.0
2005-10-21 08:00:00	IWM	ETF	62.63	62.72	62.55	62.68	402900.0
2005-10-21 09:00:00	IWM	ETF	62.64	62.97	62.47	62.9	8848600.0
2005-10-21 10:00:00	IWM	ETF	62.9	63.31	62.7	62.9	10416200.0
2005-10-21 11:00:00	IWM	ETF	62.9	63.11	62.71	62.8	3491300.0
2005-10-21 12:00:00	IWM	ETF	62.8	63.22	62.62	63.22	4059200.0
2005-10-21 13:00:00	IWM	ETF	63.2	63.38	63.06	63.26	2852100.0
2005-10-21 14:00:00	IWM	ETF	63.26	63.39	62.96	63.05	3524700.0
2005-10-21 15:00:00	IWM	ETF	63.06	63.12	62.86	62.91	5048200.0
2005-10-21 16:00:00	IWM	ETF	62.94	63.05	62.87	63.0	1355900.0
2005-10-21 17:00:00	IWM	ETF	63.0	63.0	62.98	62.98	1200.0
2005-10-21 18:00:00	IWM	ETF	63.02	63.02	63.02	63.02	3198700.0
2005-10-21 19:00:00	IWM	ETF	63.02	63.02	63.02	63.02	200.0
2005-10-21 07:00:00	DIA	ETF	103.0	103.0	102.81	102.82	92600.0
2005-10-21 08:00:00	DIA	ETF	102.815	103.02	102.76	102.8	141400.0
2005-10-21 09:00:00	DIA	ETF	102.71	103.05	102.54	102.68	1305500.0
2005-10-21 10:00:00	DIA	ETF	102.68	102.84	102.12	102.2	2396500.0
2005-10-21 11:00:00	DIA	ETF	102.22	102.35	101.95	102.02	1160000.0
2005-10-21 12:00:00	DIA	ETF	102.02	102.64	101.87	102.62	1619100.0
2005-10-21 13:00:00	DIA	ETF	102.64	102.9	102.4	102.5501	1077100.0
2005-10-21 14:00:00	DIA	ETF	102.55	102.67	102.17	102.34	1058800.0
2005-10-21 15:00:00	DIA	ETF	102.35	102.35	102.01	102.1	1501000.0
2005-10-21 16:00:00	DIA	ETF	102.1	102.18	102.08	102.18	173000.0
2005-10-21 17:00:00	DIA	ETF	102.16	102.16	102.16	102.16	200.0
2005-10-21 18:00:00	DIA	ETF	102.17	102.17	102.17	102.17	100.0
2005-10-21 19:00:00	DIA	ETF	102.25	102.25	102.25	102.25	400.0
2005-10-21 08:00:00	GLD	ETF	46.04	46.04	46.0	46.0	200200.0
2005-10-21 09:00:00	GLD	ETF	45.96	46.17	45.96	46.13	220700.0
2005-10-21 10:00:00	GLD	ETF	46.12	46.15	45.92	45.98	200400.0
2005-10-21 11:00:00	GLD	ETF	45.98	46.08	45.91	46.08	117500.0
2005-10-21 12:00:00	GLD	ETF	46.08	46.56	46.06	46.51	150500.0

> showing 50 of 984 rows — these rows as CSV

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