PREVIEW / etf_1hour / 2005-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-11.parquet
  size:    28 KB
  rows:    837

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-04-11 07:00:00	SPY	ETF	118.22	118.25	118.18	118.19	15500.0
2005-04-11 08:00:00	SPY	ETF	118.19	118.36	118.18	118.33	258300.0
2005-04-11 09:00:00	SPY	ETF	118.32	118.42	118.11	118.13	6253600.0
2005-04-11 10:00:00	SPY	ETF	118.13	118.25	117.83	118.07	10800400.0
2005-04-11 11:00:00	SPY	ETF	118.07	118.19	117.86	117.95	4120200.0
2005-04-11 12:00:00	SPY	ETF	117.95	118.36	117.93	118.243	5051400.0
2005-04-11 13:00:00	SPY	ETF	118.22	118.32	118.02	118.07	3181100.0
2005-04-11 14:00:00	SPY	ETF	118.07	118.34	118.0	118.25	4136300.0
2005-04-11 15:00:00	SPY	ETF	118.27	118.29	118.05	118.19	6184100.0
2005-04-11 16:00:00	SPY	ETF	118.2	118.25	118.07	118.11	3711100.0
2005-04-11 17:00:00	SPY	ETF	118.09	118.12	118.09	118.12	860400.0
2005-04-11 18:00:00	SPY	ETF	118.09	118.09	118.08	118.09	800.0
2005-04-11 09:00:00	QQQ	ETF	36.75	36.78	36.64	36.65	7237300.0
2005-04-11 10:00:00	QQQ	ETF	36.65	36.66	36.41	36.51	17261800.0
2005-04-11 11:00:00	QQQ	ETF	36.51	36.56	36.46	36.49	7624200.0
2005-04-11 12:00:00	QQQ	ETF	36.5	36.64	36.49	36.6	8043700.0
2005-04-11 13:00:00	QQQ	ETF	36.6	36.64	36.47	36.48	6997400.0
2005-04-11 14:00:00	QQQ	ETF	36.48	36.56	36.46	36.5	4913400.0
2005-04-11 15:00:00	QQQ	ETF	36.5	36.52	36.4	36.48	12383900.0
2005-04-11 08:00:00	IWM	ETF	60.685	60.685	60.685	60.685	1800.0
2005-04-11 09:00:00	IWM	ETF	60.73	60.74	60.43	60.445	2383000.0
2005-04-11 10:00:00	IWM	ETF	60.44	60.45	60.195	60.27	5297200.0
2005-04-11 11:00:00	IWM	ETF	60.27	60.39	60.25	60.33	1383000.0
2005-04-11 12:00:00	IWM	ETF	60.335	60.58	60.335	60.485	1857200.0
2005-04-11 13:00:00	IWM	ETF	60.49	60.57	60.4	60.415	840800.0
2005-04-11 14:00:00	IWM	ETF	60.415	60.665	60.385	60.58	1626200.0
2005-04-11 15:00:00	IWM	ETF	60.585	60.585	60.25	60.335	4625600.0
2005-04-11 16:00:00	IWM	ETF	60.35	60.395	60.3	60.3	177400.0
2005-04-11 17:00:00	IWM	ETF	60.275	60.275	59.71	60.235	9400.0
2005-04-11 08:00:00	DIA	ETF	104.65	104.75	104.65	104.75	44900.0
2005-04-11 09:00:00	DIA	ETF	104.74	104.81	104.59	104.61	387900.0
2005-04-11 10:00:00	DIA	ETF	104.61	104.72	104.38	104.55	532200.0
2005-04-11 11:00:00	DIA	ETF	104.55	104.62	104.41	104.43	300000.0
2005-04-11 12:00:00	DIA	ETF	104.42	104.72	104.42	104.64	284900.0
2005-04-11 13:00:00	DIA	ETF	104.65	104.72	104.47	104.55	688700.0
2005-04-11 14:00:00	DIA	ETF	104.57	104.72	104.47	104.65	287200.0
2005-04-11 15:00:00	DIA	ETF	104.65	104.67	104.44	104.5	577200.0
2005-04-11 16:00:00	DIA	ETF	104.53	104.53	104.45	104.45	63200.0
2005-04-11 18:00:00	DIA	ETF	104.5	104.5	104.5	104.5	800.0
2005-04-11 09:00:00	GLD	ETF	42.84	42.96	42.79	42.92	100500.0
2005-04-11 10:00:00	GLD	ETF	42.9	42.92	42.81	42.85	120500.0
2005-04-11 11:00:00	GLD	ETF	42.86	42.9	42.82	42.88	80300.0
2005-04-11 12:00:00	GLD	ETF	42.88	42.9	42.83	42.86	44500.0
2005-04-11 13:00:00	GLD	ETF	42.85	42.86	42.8	42.82	56600.0
2005-04-11 14:00:00	GLD	ETF	42.83	42.84	42.77	42.8	63400.0
2005-04-11 15:00:00	GLD	ETF	42.81	42.82	42.74	42.78	47300.0
2005-04-11 16:00:00	GLD	ETF	42.76	42.76	42.76	42.76	1000.0
2005-04-11 08:00:00	TLT	ETF	88.95	88.95	88.95	88.95	400.0
2005-04-11 09:00:00	TLT	ETF	89.02	89.11	88.94	89.11	168500.0
2005-04-11 10:00:00	TLT	ETF	89.08	89.29	89.08	89.26	126700.0

> showing 50 of 837 rows — these rows as CSV

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