PREVIEW / etf_1hour / 2005-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-03.parquet
  size:    32 KB
  rows:    991

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-03 07:00:00	SPY	ETF	123.05	123.08	123.0	123.0	6400.0
2005-10-03 08:00:00	SPY	ETF	123.01	123.1	122.92	123.0	183000.0
2005-10-03 09:00:00	SPY	ETF	123.03	123.34	122.85	123.22	10536600.0
2005-10-03 10:00:00	SPY	ETF	123.22	123.33	122.49	122.53	12700100.0
2005-10-03 11:00:00	SPY	ETF	122.51	122.82	122.51	122.65	4662800.0
2005-10-03 12:00:00	SPY	ETF	122.64	122.74	122.48	122.56	2150100.0
2005-10-03 13:00:00	SPY	ETF	122.55	122.83	122.53	122.73	2891600.0
2005-10-03 14:00:00	SPY	ETF	122.72	122.88	122.45	122.78	4780400.0
2005-10-03 15:00:00	SPY	ETF	122.79	122.92	122.59	122.68	6810900.0
2005-10-03 16:00:00	SPY	ETF	122.66	122.67	122.54	122.56	2838400.0
2005-10-03 17:00:00	SPY	ETF	122.53	122.59	122.52	122.52	18200.0
2005-10-03 18:00:00	SPY	ETF	122.57	122.63	122.57	122.63	21500.0
2005-10-03 19:00:00	SPY	ETF	122.63	122.63	122.63	122.63	1000.0
2005-10-03 09:00:00	QQQ	ETF	39.54	39.75	39.53	39.69	13886000.0
2005-10-03 10:00:00	QQQ	ETF	39.69	39.73	39.51	39.57	12909300.0
2005-10-03 11:00:00	QQQ	ETF	39.56	39.68	39.56	39.63	5980900.0
2005-10-03 12:00:00	QQQ	ETF	39.64	39.66	39.53	39.59	4420500.0
2005-10-03 13:00:00	QQQ	ETF	39.59	39.68	39.58	39.64	7177800.0
2005-10-03 14:00:00	QQQ	ETF	39.64	39.73	39.53	39.67	12399600.0
2005-10-03 15:00:00	QQQ	ETF	39.67	39.71	39.56	39.57	12393700.0
2005-10-03 08:00:00	IWM	ETF	66.39	66.47	66.38	66.39	55300.0
2005-10-03 09:00:00	IWM	ETF	66.39	66.99	66.39	66.99	5868100.0
2005-10-03 10:00:00	IWM	ETF	66.98	67.06	66.48	66.49	9218700.0
2005-10-03 11:00:00	IWM	ETF	66.49	66.8	66.49	66.63	1780700.0
2005-10-03 12:00:00	IWM	ETF	66.61	66.72	66.48	66.5	2235100.0
2005-10-03 13:00:00	IWM	ETF	66.5	66.73	66.49	66.65	729100.0
2005-10-03 14:00:00	IWM	ETF	66.63	66.77	66.46	66.68	1458700.0
2005-10-03 15:00:00	IWM	ETF	66.68	66.79	66.55	66.75	4262800.0
2005-10-03 16:00:00	IWM	ETF	66.76	67.26	66.65	66.77	281300.0
2005-10-03 07:00:00	DIA	ETF	105.78	105.79	105.78	105.79	5800.0
2005-10-03 08:00:00	DIA	ETF	105.79	105.79	105.7	105.72	2200.0
2005-10-03 09:00:00	DIA	ETF	105.74	105.99	105.66	105.91	339600.0
2005-10-03 10:00:00	DIA	ETF	105.9	106.01	105.25	105.25	1478900.0
2005-10-03 11:00:00	DIA	ETF	105.25	105.52	105.25	105.42	538200.0
2005-10-03 12:00:00	DIA	ETF	105.41	105.43	105.2	105.22	568600.0
2005-10-03 13:00:00	DIA	ETF	105.23	105.49	105.23	105.41	481000.0
2005-10-03 14:00:00	DIA	ETF	105.41	105.5	105.16	105.42	752100.0
2005-10-03 15:00:00	DIA	ETF	105.43	105.55	105.25	105.34	1134100.0
2005-10-03 16:00:00	DIA	ETF	105.34	105.34	105.12	105.25	30100.0
2005-10-03 17:00:00	DIA	ETF	105.25	105.25	105.25	105.25	100.0
2005-10-03 08:00:00	GLD	ETF	46.5	46.67	46.44	46.63	36700.0
2005-10-03 09:00:00	GLD	ETF	46.59	46.63	46.56	46.61	177100.0
2005-10-03 10:00:00	GLD	ETF	46.58	46.61	46.38	46.43	315900.0
2005-10-03 11:00:00	GLD	ETF	46.43	46.51	46.4	46.42	1033800.0
2005-10-03 12:00:00	GLD	ETF	46.42	46.49	46.39	46.49	275100.0
2005-10-03 13:00:00	GLD	ETF	46.49	46.52	46.44	46.45	193800.0
2005-10-03 14:00:00	GLD	ETF	46.45	46.48	46.42	46.47	61700.0
2005-10-03 15:00:00	GLD	ETF	46.47	46.48	46.4	46.41	99200.0
2005-10-03 07:00:00	TLT	ETF	92.25	92.25	92.0	92.0	200.0
2005-10-03 08:00:00	TLT	ETF	91.87	91.87	91.85	91.85	900.0

> showing 50 of 991 rows — these rows as CSV

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