PREVIEW / etf_1hour / 2005-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-03-11.parquet
  size:    30 KB
  rows:    854

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-11 08:00:00	SPY	ETF	121.5	121.54	121.15	121.15	194700.0
2005-03-11 09:00:00	SPY	ETF	121.21	121.72	121.08	121.56	8344100.0
2005-03-11 10:00:00	SPY	ETF	121.57	121.62	120.71	120.85	10152700.0
2005-03-11 11:00:00	SPY	ETF	120.84	121.03	120.74	120.88	6093200.0
2005-03-11 12:00:00	SPY	ETF	120.87	121.05	120.74	120.86	2374200.0
2005-03-11 13:00:00	SPY	ETF	120.86	121.0	120.39	120.46	5850700.0
2005-03-11 14:00:00	SPY	ETF	120.47	120.73	120.26	120.4	7479400.0
2005-03-11 15:00:00	SPY	ETF	120.4	120.57	120.16	120.41	10750400.0
2005-03-11 16:00:00	SPY	ETF	120.44	120.45	120.33	120.34	4098000.0
2005-03-11 17:00:00	SPY	ETF	120.37	121.35	120.24	120.25	571700.0
2005-03-11 18:00:00	SPY	ETF	120.34	120.34	120.25	120.25	2100.0
2005-03-11 19:00:00	SPY	ETF	120.34	120.34	120.32	120.32	400.0
2005-03-11 09:00:00	QQQ	ETF	37.69	37.82	37.48	37.75	16394300.0
2005-03-11 10:00:00	QQQ	ETF	37.75	37.79	37.34	37.37	19172200.0
2005-03-11 11:00:00	QQQ	ETF	37.37	37.4	37.26	37.3	12986300.0
2005-03-11 12:00:00	QQQ	ETF	37.3	37.37	37.24	37.31	5616700.0
2005-03-11 13:00:00	QQQ	ETF	37.31	37.35	37.11	37.14	10523100.0
2005-03-11 14:00:00	QQQ	ETF	37.15	37.27	37.1	37.16	8387500.0
2005-03-11 15:00:00	QQQ	ETF	37.16	37.21	37.02	37.16	19693000.0
2005-03-11 08:00:00	IWM	ETF	62.695	62.695	62.695	62.695	2000.0
2005-03-11 09:00:00	IWM	ETF	62.645	63.05	62.55	62.965	2052200.0
2005-03-11 10:00:00	IWM	ETF	62.955	63.025	62.385	62.455	2681000.0
2005-03-11 11:00:00	IWM	ETF	62.45	62.635	62.375	62.545	2094600.0
2005-03-11 12:00:00	IWM	ETF	62.535	62.75	62.43	62.605	974800.0
2005-03-11 13:00:00	IWM	ETF	62.615	62.7	62.28	62.345	1644400.0
2005-03-11 14:00:00	IWM	ETF	62.35	62.48	62.32	62.34	2297600.0
2005-03-11 15:00:00	IWM	ETF	62.335	62.6	62.205	62.47	3183200.0
2005-03-11 16:00:00	IWM	ETF	62.52	62.585	62.47	62.475	420000.0
2005-03-11 17:00:00	IWM	ETF	62.3423	62.3423	62.3423	62.3423	800.0
2005-03-11 08:00:00	DIA	ETF	108.59	108.59	108.56	108.56	2100.0
2005-03-11 09:00:00	DIA	ETF	108.5	108.81	108.33	108.75	934800.0
2005-03-11 10:00:00	DIA	ETF	108.74	108.76	108.11	108.24	504000.0
2005-03-11 11:00:00	DIA	ETF	108.23	108.37	108.17	108.31	207700.0
2005-03-11 12:00:00	DIA	ETF	108.3	108.43	108.2	108.29	155500.0
2005-03-11 13:00:00	DIA	ETF	108.29	108.34	107.93	107.93	316500.0
2005-03-11 14:00:00	DIA	ETF	107.96	108.18	107.79	107.853	528300.0
2005-03-11 15:00:00	DIA	ETF	107.84	107.99	107.65	107.86	781300.0
2005-03-11 16:00:00	DIA	ETF	107.89	107.89	107.83	107.86	5900.0
2005-03-11 17:00:00	DIA	ETF	107.9	107.9	107.8	107.9	1000.0
2005-03-11 08:00:00	GLD	ETF	44.4	44.44	44.22	44.22	15700.0
2005-03-11 09:00:00	GLD	ETF	44.2	44.44	44.18	44.36	658700.0
2005-03-11 10:00:00	GLD	ETF	44.36	44.45	44.33	44.45	248700.0
2005-03-11 11:00:00	GLD	ETF	44.43	44.67	44.42	44.55	210500.0
2005-03-11 12:00:00	GLD	ETF	44.56	44.64	44.53	44.57	802000.0
2005-03-11 13:00:00	GLD	ETF	44.58	44.6	44.52	44.57	272100.0
2005-03-11 14:00:00	GLD	ETF	44.57	44.57	44.45	44.5	168900.0
2005-03-11 15:00:00	GLD	ETF	44.5	44.53	44.43	44.43	278700.0
2005-03-11 16:00:00	GLD	ETF	44.42	44.42	44.42	44.42	200.0
2005-03-11 17:00:00	GLD	ETF	44.46	44.46	44.46	44.46	100.0
2005-03-11 08:00:00	TLT	ETF	88.73	88.73	88.49	88.6	12800.0

> showing 50 of 854 rows — these rows as CSV

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