PREVIEW / etf_1hour / 2005-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-26.parquet
  size:    34 KB
  rows:    1,018

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-26 07:00:00	SPY	ETF	120.03	120.05	119.85	119.85	235100.0
2005-10-26 08:00:00	SPY	ETF	119.84	120.11	119.4	119.58	3735200.0
2005-10-26 09:00:00	SPY	ETF	119.58	120.0	119.35	119.96	10007100.0
2005-10-26 10:00:00	SPY	ETF	119.94	120.33	119.41	120.25	17492100.0
2005-10-26 11:00:00	SPY	ETF	120.25	120.54	120.02	120.08	10223800.0
2005-10-26 12:00:00	SPY	ETF	120.07	120.15	119.8	119.97	7068300.0
2005-10-26 13:00:00	SPY	ETF	119.98	120.01	119.41	119.67	11623200.0
2005-10-26 14:00:00	SPY	ETF	119.68	120.01	119.45	119.69	8387800.0
2005-10-26 15:00:00	SPY	ETF	119.68	119.93	119.19	119.26	10272500.0
2005-10-26 16:00:00	SPY	ETF	119.27	119.85	119.23	119.35	828700.0
2005-10-26 17:00:00	SPY	ETF	119.34	119.5324	119.33	119.42	1623100.0
2005-10-26 18:00:00	SPY	ETF	119.4	119.4	119.29	119.29	1300.0
2005-10-26 19:00:00	SPY	ETF	119.29	119.36	119.27	119.36	5000.0
2005-10-26 09:00:00	QQQ	ETF	38.96	39.1	38.9	39.08	9688600.0
2005-10-26 10:00:00	QQQ	ETF	39.06	39.25	39.01	39.22	18531500.0
2005-10-26 11:00:00	QQQ	ETF	39.22	39.27	39.08	39.09	10234300.0
2005-10-26 12:00:00	QQQ	ETF	39.09	39.11	38.96	39.04	10724500.0
2005-10-26 13:00:00	QQQ	ETF	39.05	39.07	38.83	38.9	10261100.0
2005-10-26 14:00:00	QQQ	ETF	38.9	39.02	38.88	38.96	10124700.0
2005-10-26 15:00:00	QQQ	ETF	38.96	39.01	38.76	38.8	12115600.0
2005-10-26 07:00:00	IWM	ETF	64.04	64.04	63.94	63.94	38700.0
2005-10-26 08:00:00	IWM	ETF	63.91	64.04	63.58	63.72	392100.0
2005-10-26 09:00:00	IWM	ETF	63.73	64.09	63.61	64.08	5049000.0
2005-10-26 10:00:00	IWM	ETF	64.05	64.4	63.91	64.19	6229400.0
2005-10-26 11:00:00	IWM	ETF	64.18	64.59	64.06	64.27	3939100.0
2005-10-26 12:00:00	IWM	ETF	64.27	64.34	64.11	64.24	1287200.0
2005-10-26 13:00:00	IWM	ETF	64.24	64.27	63.43	63.55	7474900.0
2005-10-26 14:00:00	IWM	ETF	63.55	63.91	63.52	63.6	3575100.0
2005-10-26 15:00:00	IWM	ETF	63.57	63.84	63.31	63.43	4664100.0
2005-10-26 16:00:00	IWM	ETF	63.44	63.54	63.4	63.49	826000.0
2005-10-26 17:00:00	IWM	ETF	63.47	63.49	63.45	63.49	1926500.0
2005-10-26 19:00:00	IWM	ETF	63.46	63.46	63.46	63.46	300.0
2005-10-26 07:00:00	DIA	ETF	103.9	103.93	103.9	103.93	2700.0
2005-10-26 08:00:00	DIA	ETF	103.93	103.93	103.4	103.5	121200.0
2005-10-26 09:00:00	DIA	ETF	103.5	103.83	103.31	103.82	777800.0
2005-10-26 10:00:00	DIA	ETF	103.8	104.14	103.63	104.1	1511500.0
2005-10-26 11:00:00	DIA	ETF	104.1	104.26	103.89	103.96	1118500.0
2005-10-26 12:00:00	DIA	ETF	103.93	104.02	103.77	103.93	591800.0
2005-10-26 13:00:00	DIA	ETF	103.91	103.92	103.54	103.73	860800.0
2005-10-26 14:00:00	DIA	ETF	103.74	104.0	103.59	103.73	1468000.0
2005-10-26 15:00:00	DIA	ETF	103.73	103.9	103.38	103.4	1020100.0
2005-10-26 16:00:00	DIA	ETF	103.42	103.56	103.42	103.56	7000.0
2005-10-26 17:00:00	DIA	ETF	103.58	103.58	103.54	103.54	163400.0
2005-10-26 18:00:00	DIA	ETF	103.52	103.52	103.52	103.52	500.0
2005-10-26 19:00:00	DIA	ETF	103.52	103.52	103.52	103.52	500.0
2005-10-26 08:00:00	GLD	ETF	47.03	47.1	47.01	47.1	3100.0
2005-10-26 09:00:00	GLD	ETF	47.07	47.18	47.03	47.18	521600.0
2005-10-26 10:00:00	GLD	ETF	47.17	47.21	47.08	47.16	179000.0
2005-10-26 11:00:00	GLD	ETF	47.17	47.18	47.03	47.05	135800.0
2005-10-26 12:00:00	GLD	ETF	47.03	47.07	46.929	47.01	682500.0

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

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