PREVIEW / etf_1hour / 2005-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-25.parquet
  size:    33 KB
  rows:    978

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-25 07:00:00	SPY	ETF	119.57	119.67	119.56	119.67	59600.0
2005-10-25 08:00:00	SPY	ETF	119.73	119.75	119.55	119.64	726500.0
2005-10-25 09:00:00	SPY	ETF	119.64	120.03	119.6	119.95	7355400.0
2005-10-25 10:00:00	SPY	ETF	119.95	120.24	119.66	120.0	13552100.0
2005-10-25 11:00:00	SPY	ETF	119.99	120.08	119.44	119.48	12867200.0
2005-10-25 12:00:00	SPY	ETF	119.48	119.82	119.38	119.5	6418200.0
2005-10-25 13:00:00	SPY	ETF	119.52	119.52	118.97	119.1	9879700.0
2005-10-25 14:00:00	SPY	ETF	119.09	119.47	118.94	119.36	10369500.0
2005-10-25 15:00:00	SPY	ETF	119.36	119.87	119.06	119.74	13035200.0
2005-10-25 16:00:00	SPY	ETF	119.77	119.78	119.61	119.67	808600.0
2005-10-25 17:00:00	SPY	ETF	119.68	119.97	119.65	119.67	6700.0
2005-10-25 18:00:00	SPY	ETF	119.67	119.7	119.67	119.7	1600.0
2005-10-25 19:00:00	SPY	ETF	119.71	119.71	119.71	119.71	2700.0
2005-10-25 09:00:00	QQQ	ETF	39.07	39.16	39.03	39.13	9348700.0
2005-10-25 10:00:00	QQQ	ETF	39.12	39.19	39.01	39.07	15782500.0
2005-10-25 11:00:00	QQQ	ETF	39.07	39.09	38.94	38.94	11801000.0
2005-10-25 12:00:00	QQQ	ETF	38.95	39.03	38.92	38.95	8141800.0
2005-10-25 13:00:00	QQQ	ETF	38.94	38.97	38.82	38.85	11518800.0
2005-10-25 14:00:00	QQQ	ETF	38.85	38.92	38.77	38.87	11329900.0
2005-10-25 15:00:00	QQQ	ETF	38.87	39.09	38.79	39.08	15403300.0
2005-10-25 07:00:00	IWM	ETF	64.08	64.18	64.08	64.18	7900.0
2005-10-25 08:00:00	IWM	ETF	64.17	64.21	64.12	64.12	29800.0
2005-10-25 09:00:00	IWM	ETF	64.12	64.28	63.92	64.16	2892100.0
2005-10-25 10:00:00	IWM	ETF	64.16	64.4	63.91	64.08	5564100.0
2005-10-25 11:00:00	IWM	ETF	64.1	64.13	63.6	63.64	5881000.0
2005-10-25 12:00:00	IWM	ETF	63.64	63.85	63.44	63.5	3189000.0
2005-10-25 13:00:00	IWM	ETF	63.49	63.6	63.27	63.34	3447900.0
2005-10-25 14:00:00	IWM	ETF	63.35	63.74	63.29	63.69	5081100.0
2005-10-25 15:00:00	IWM	ETF	63.69	64.0	63.41	64.0	4741400.0
2005-10-25 16:00:00	IWM	ETF	64.0	64.01	63.9	63.91	84300.0
2005-10-25 17:00:00	IWM	ETF	63.85	63.91	63.85	63.91	791200.0
2005-10-25 19:00:00	IWM	ETF	63.91	63.91	63.91	63.91	1000.0
2005-10-25 07:00:00	DIA	ETF	103.37	103.37	103.37	103.37	100.0
2005-10-25 08:00:00	DIA	ETF	103.39	103.5	103.39	103.47	2000.0
2005-10-25 09:00:00	DIA	ETF	103.54	103.82	103.51	103.77	936800.0
2005-10-25 10:00:00	DIA	ETF	103.73	104.06	103.53	103.91	1225200.0
2005-10-25 11:00:00	DIA	ETF	103.91	103.95	103.52	103.57	1264000.0
2005-10-25 12:00:00	DIA	ETF	103.57	103.85	103.52	103.58	400600.0
2005-10-25 13:00:00	DIA	ETF	103.58	103.58	103.2	103.26	605100.0
2005-10-25 14:00:00	DIA	ETF	103.24	103.44	103.07	103.41	1131300.0
2005-10-25 15:00:00	DIA	ETF	103.41	103.82	103.11	103.73	1072300.0
2005-10-25 16:00:00	DIA	ETF	103.73	103.75	103.67	103.67	10000.0
2005-10-25 17:00:00	DIA	ETF	103.6	103.6	103.6	103.6	200.0
2005-10-25 08:00:00	GLD	ETF	46.59	46.93	46.59	46.93	13800.0
2005-10-25 09:00:00	GLD	ETF	46.87	47.09	46.87	47.02	296900.0
2005-10-25 10:00:00	GLD	ETF	47.01	47.16	47.0	47.1	700900.0
2005-10-25 11:00:00	GLD	ETF	47.09	47.14	47.02	47.1	522700.0
2005-10-25 12:00:00	GLD	ETF	47.1	47.19	47.07	47.14	604100.0
2005-10-25 13:00:00	GLD	ETF	47.16	47.19	47.06	47.14	315500.0
2005-10-25 14:00:00	GLD	ETF	47.14	47.15	47.06	47.14	428100.0

> showing 50 of 978 rows — these rows as CSV

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