PREVIEW / etf_1hour / 2005-03-03

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-03.parquet
  size:    29 KB
  rows:    834

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-03-03 08:00:00	SPY	ETF	121.51	121.7	121.48	121.66	338900.0
2005-03-03 09:00:00	SPY	ETF	121.65	121.78	121.58	121.69	5362500.0
2005-03-03 10:00:00	SPY	ETF	121.7	121.9	121.34	121.56	10455700.0
2005-03-03 11:00:00	SPY	ETF	121.57	121.57	120.79	120.88	10561400.0
2005-03-03 12:00:00	SPY	ETF	120.86	121.1	120.7	120.98	10496900.0
2005-03-03 13:00:00	SPY	ETF	120.99	121.39	120.8	121.26	6011200.0
2005-03-03 14:00:00	SPY	ETF	121.25	121.58	121.25	121.44	6688700.0
2005-03-03 15:00:00	SPY	ETF	121.45	121.54	121.32	121.34	8751000.0
2005-03-03 16:00:00	SPY	ETF	121.32	121.36	120.89	121.22	1037900.0
2005-03-03 17:00:00	SPY	ETF	121.22	121.25	121.2	121.23	525200.0
2005-03-03 18:00:00	SPY	ETF	121.25	121.29	121.25	121.28	4100.0
2005-03-03 19:00:00	SPY	ETF	121.28	121.28	121.27	121.27	2800.0
2005-03-03 09:00:00	QQQ	ETF	37.7	37.73	37.58	37.6	9656200.0
2005-03-03 10:00:00	QQQ	ETF	37.6	37.69	37.36	37.49	16831300.0
2005-03-03 11:00:00	QQQ	ETF	37.49	37.49	37.09	37.12	17985500.0
2005-03-03 12:00:00	QQQ	ETF	37.12	37.2	37.02	37.16	11736500.0
2005-03-03 13:00:00	QQQ	ETF	37.17	38.2	37.16	37.26	7956600.0
2005-03-03 14:00:00	QQQ	ETF	37.26	37.41	37.24	37.33	10900700.0
2005-03-03 15:00:00	QQQ	ETF	37.34	37.37	37.27	37.29	8655900.0
2005-03-03 08:00:00	IWM	ETF	63.785	63.82	63.785	63.81	4400.0
2005-03-03 09:00:00	IWM	ETF	63.81	63.93	63.71	63.79	1252600.0
2005-03-03 10:00:00	IWM	ETF	63.795	63.97	63.53	63.71	2822200.0
2005-03-03 11:00:00	IWM	ETF	63.7	63.705	63.175	63.215	3426800.0
2005-03-03 12:00:00	IWM	ETF	63.2	63.355	63.14	63.355	1773600.0
2005-03-03 13:00:00	IWM	ETF	63.36	63.57	63.34	63.49	2153200.0
2005-03-03 14:00:00	IWM	ETF	63.49	63.89	63.48	63.785	3641600.0
2005-03-03 15:00:00	IWM	ETF	63.785	63.83	63.575	63.605	1949000.0
2005-03-03 16:00:00	IWM	ETF	63.605	63.635	63.54	63.57	305800.0
2005-03-03 08:00:00	DIA	ETF	108.3	108.39	108.28	108.39	7300.0
2005-03-03 09:00:00	DIA	ETF	108.38	108.51	108.33	108.49	951100.0
2005-03-03 10:00:00	DIA	ETF	108.49	108.67	108.17	108.4	1956500.0
2005-03-03 11:00:00	DIA	ETF	108.39	108.4	107.74	107.8	1117900.0
2005-03-03 12:00:00	DIA	ETF	107.8	108.0	107.64	107.94	1633300.0
2005-03-03 13:00:00	DIA	ETF	107.94	108.28	107.94	108.18	831200.0
2005-03-03 14:00:00	DIA	ETF	108.17	108.5	108.17	108.37	607500.0
2005-03-03 15:00:00	DIA	ETF	108.39	108.46	108.28	108.3	583200.0
2005-03-03 16:00:00	DIA	ETF	108.32	108.32	108.24	108.25	509900.0
2005-03-03 18:00:00	DIA	ETF	108.25	108.25	108.25	108.25	100.0
2005-03-03 09:00:00	GLD	ETF	43.06	43.12	43.04	43.07	136000.0
2005-03-03 10:00:00	GLD	ETF	43.07	43.13	42.963	43.1	228100.0
2005-03-03 11:00:00	GLD	ETF	43.08	43.08	42.9	43.01	346200.0
2005-03-03 12:00:00	GLD	ETF	43.0	43.1	43.0	43.06	170500.0
2005-03-03 13:00:00	GLD	ETF	43.07	43.08	42.95	42.97	799500.0
2005-03-03 14:00:00	GLD	ETF	42.97	43.02	42.96	43.01	115700.0
2005-03-03 15:00:00	GLD	ETF	43.01	43.03	42.96	42.99	102900.0
2005-03-03 16:00:00	GLD	ETF	42.97	42.97	42.97	42.97	10500.0
2005-03-03 08:00:00	TLT	ETF	89.57	89.7	89.57	89.7	10500.0
2005-03-03 09:00:00	TLT	ETF	89.62	89.79	89.62	89.79	333300.0
2005-03-03 10:00:00	TLT	ETF	89.77	89.8	89.62	89.77	388300.0
2005-03-03 11:00:00	TLT	ETF	89.78	89.79	89.65	89.67	76500.0

> showing 50 of 834 rows — these rows as CSV

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