PREVIEW / etf_1hour / 2005-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-25.parquet
  size:    23 KB
  rows:    611

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-25 06:00:00	SPY	ETF	126.94	126.94	126.94	126.94	1000.0
2005-11-25 07:00:00	SPY	ETF	126.95	126.95	126.95	126.95	500.0
2005-11-25 08:00:00	SPY	ETF	126.94	126.97	126.9	126.97	59100.0
2005-11-25 09:00:00	SPY	ETF	126.96	127.22	126.71	127.08	3408400.0
2005-11-25 10:00:00	SPY	ETF	127.08	127.17	126.81	126.95	5766600.0
2005-11-25 11:00:00	SPY	ETF	126.94	127.16	126.94	127.06	2113800.0
2005-11-25 12:00:00	SPY	ETF	127.05	127.19	127.0	127.1	2565000.0
2005-11-25 13:00:00	SPY	ETF	127.1	127.22	127.05	127.13	387200.0
2005-11-25 09:00:00	QQQ	ETF	41.84	41.93	41.81	41.84	6222600.0
2005-11-25 10:00:00	QQQ	ETF	41.84	41.88	41.73	41.77	6338300.0
2005-11-25 11:00:00	QQQ	ETF	41.77	41.84	41.75	41.83	2517900.0
2005-11-25 12:00:00	QQQ	ETF	41.82	41.94	41.81	41.9	6309700.0
2005-11-25 13:00:00	QQQ	ETF	41.89	41.95	41.88	41.89	1202800.0
2005-11-25 14:00:00	QQQ	ETF	41.89	41.9	41.88	41.9	23200.0
2005-11-25 15:00:00	QQQ	ETF	41.88	41.9	41.88	41.88	7600.0
2005-11-25 08:00:00	IWM	ETF	67.86	67.91	67.85	67.91	10500.0
2005-11-25 09:00:00	IWM	ETF	67.93	68.0	67.8	67.92	1721300.0
2005-11-25 10:00:00	IWM	ETF	67.91	67.95	67.77	67.8	1741500.0
2005-11-25 11:00:00	IWM	ETF	67.8	68.03	67.8	67.98	1329300.0
2005-11-25 12:00:00	IWM	ETF	67.97	68.13	67.89	68.0	899100.0
2005-11-25 13:00:00	IWM	ETF	68.01	68.05	67.96	67.96	42000.0
2005-11-25 08:00:00	DIA	ETF	109.21	109.21	109.17	109.2	7300.0
2005-11-25 09:00:00	DIA	ETF	109.21	109.5	109.21	109.4	502300.0
2005-11-25 10:00:00	DIA	ETF	109.4	109.49	109.23	109.27	575500.0
2005-11-25 11:00:00	DIA	ETF	109.27	109.38	109.27	109.33	138400.0
2005-11-25 12:00:00	DIA	ETF	109.32	109.38	109.26	109.32	206900.0
2005-11-25 13:00:00	DIA	ETF	109.32	109.36	109.3	109.33	16800.0
2005-11-25 08:00:00	GLD	ETF	49.18	49.18	49.18	49.18	100.0
2005-11-25 09:00:00	GLD	ETF	49.5	49.5	49.4	49.44	165100.0
2005-11-25 10:00:00	GLD	ETF	49.45	49.45	49.36	49.41	173000.0
2005-11-25 11:00:00	GLD	ETF	49.39	49.45	49.3	49.42	216000.0
2005-11-25 12:00:00	GLD	ETF	49.42	49.99	49.4101	49.55	152800.0
2005-11-25 13:00:00	GLD	ETF	49.53	49.53	49.42	49.42	6200.0
2005-11-25 09:00:00	TLT	ETF	90.41	90.46	90.34	90.371	176600.0
2005-11-25 10:00:00	TLT	ETF	90.3801	90.54	90.35	90.51	170800.0
2005-11-25 11:00:00	TLT	ETF	90.48	90.49	90.35	90.399	14600.0
2005-11-25 12:00:00	TLT	ETF	90.37	90.5	90.35	90.43	58300.0
2005-11-25 13:00:00	TLT	ETF	90.44	90.51	90.44	90.51	1200.0

> showing 38 of 611 rows — these rows as CSV

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