PREVIEW / etf_1hour / 2005-10-06

all etf 1-hour files

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

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-06 07:00:00	SPY	ETF	119.53	119.59	119.5	119.57	92500.0
2005-10-06 08:00:00	SPY	ETF	119.57	120.08	119.4	119.94	4530100.0
2005-10-06 09:00:00	SPY	ETF	119.94	120.02	119.5	119.95	14695300.0
2005-10-06 10:00:00	SPY	ETF	119.96	120.04	119.52	119.93	20907900.0
2005-10-06 11:00:00	SPY	ETF	119.92	120.26	119.57	120.04	12390900.0
2005-10-06 12:00:00	SPY	ETF	120.05	120.21	119.43	119.78	13526200.0
2005-10-06 13:00:00	SPY	ETF	119.78	119.96	119.15	119.21	12240800.0
2005-10-06 14:00:00	SPY	ETF	119.18	119.6	118.82	119.01	20106300.0
2005-10-06 15:00:00	SPY	ETF	119.02	119.45	118.17	119.15	32964000.0
2005-10-06 16:00:00	SPY	ETF	119.16	119.43	119.12	119.43	959700.0
2005-10-06 17:00:00	SPY	ETF	119.43	119.46	119.01	119.2	1515400.0
2005-10-06 18:00:00	SPY	ETF	119.19	119.41	119.18	119.31	112200.0
2005-10-06 19:00:00	SPY	ETF	119.29	119.37	119.29	119.35	91200.0
2005-10-06 09:00:00	QQQ	ETF	38.73	38.8	38.54	38.7	19589900.0
2005-10-06 10:00:00	QQQ	ETF	38.7	38.77	38.56	38.68	21594900.0
2005-10-06 11:00:00	QQQ	ETF	38.68	38.86	38.63	38.68	18498200.0
2005-10-06 12:00:00	QQQ	ETF	38.68	38.75	38.52	38.6	14791200.0
2005-10-06 13:00:00	QQQ	ETF	38.6	38.69	38.36	38.37	17548100.0
2005-10-06 14:00:00	QQQ	ETF	38.38	38.42	38.23	38.29	23535000.0
2005-10-06 15:00:00	QQQ	ETF	38.29	38.37	37.92	38.25	38445800.0
2005-10-06 07:00:00	IWM	ETF	64.07	64.07	64.07	64.07	200.0
2005-10-06 08:00:00	IWM	ETF	64.0	64.25	64.0	64.25	1589100.0
2005-10-06 09:00:00	IWM	ETF	64.21	64.43	63.78	64.18	8097000.0
2005-10-06 10:00:00	IWM	ETF	64.17	64.29	63.64	64.0	12706000.0
2005-10-06 11:00:00	IWM	ETF	64.0	64.53	63.94	64.24	6816600.0
2005-10-06 12:00:00	IWM	ETF	64.23	64.4	63.9	64.17	3508700.0
2005-10-06 13:00:00	IWM	ETF	64.17	64.29	63.56	63.6	4766200.0
2005-10-06 14:00:00	IWM	ETF	63.61	63.8	63.39	63.48	5997100.0
2005-10-06 15:00:00	IWM	ETF	63.49	63.85	62.86	63.67	13783800.0
2005-10-06 16:00:00	IWM	ETF	63.68	63.6985	63.16	63.66	249000.0
2005-10-06 17:00:00	IWM	ETF	63.63	63.7	63.63	63.7	12700.0
2005-10-06 08:00:00	DIA	ETF	103.16	103.55	103.16	103.53	119900.0
2005-10-06 09:00:00	DIA	ETF	103.47	103.66	103.23	103.6	1398600.0
2005-10-06 10:00:00	DIA	ETF	103.61	103.65	103.23	103.49	1451100.0
2005-10-06 11:00:00	DIA	ETF	103.52	103.71	103.42	103.54	768800.0
2005-10-06 12:00:00	DIA	ETF	103.53	103.6	103.05	103.21	1004100.0
2005-10-06 13:00:00	DIA	ETF	103.2	103.35	102.77	102.83	998200.0
2005-10-06 14:00:00	DIA	ETF	102.83	102.95	102.65	102.82	1226100.0
2005-10-06 15:00:00	DIA	ETF	102.85	103.09	102.19	102.86	3810900.0
2005-10-06 16:00:00	DIA	ETF	102.9	103.1	102.89	103.1	235800.0
2005-10-06 17:00:00	DIA	ETF	102.96	102.96	102.85	102.85	2900.0
2005-10-06 18:00:00	DIA	ETF	103.05	103.05	103.05	103.05	200.0
2005-10-06 08:00:00	GLD	ETF	46.5	46.63	46.5	46.63	3800.0
2005-10-06 09:00:00	GLD	ETF	46.55	47.15	46.55	47.04	301400.0
2005-10-06 10:00:00	GLD	ETF	47.05	47.07	46.92	47.01	357300.0
2005-10-06 11:00:00	GLD	ETF	47.0	47.07	46.96	47.05	135200.0
2005-10-06 12:00:00	GLD	ETF	47.05	47.1	46.95	46.99	102600.0
2005-10-06 13:00:00	GLD	ETF	46.99	47.15	46.98	47.07	392700.0
2005-10-06 14:00:00	GLD	ETF	47.09	47.22	47.04	47.21	261300.0
2005-10-06 15:00:00	GLD	ETF	47.21	47.26	47.18	47.18	444900.0

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

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