PREVIEW / etf_1hour / 2005-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-10.parquet
  size:    29 KB
  rows:    864

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-06-10 05:00:00	SPY	ETF	120.55	120.57	120.55	120.57	4200.0
2005-06-10 07:00:00	SPY	ETF	120.65	120.65	120.58	120.64	1200.0
2005-06-10 08:00:00	SPY	ETF	120.63	120.7	120.58	120.66	153600.0
2005-06-10 09:00:00	SPY	ETF	120.67	120.67	120.38	120.41	3441200.0
2005-06-10 10:00:00	SPY	ETF	120.42	120.61	120.05	120.19	9007300.0
2005-06-10 11:00:00	SPY	ETF	120.2	120.26	119.91	119.94	3674400.0
2005-06-10 12:00:00	SPY	ETF	119.94	120.02	119.67	119.77	6126500.0
2005-06-10 13:00:00	SPY	ETF	119.77	120.01	119.72	119.87	2676400.0
2005-06-10 14:00:00	SPY	ETF	119.86	119.93	119.6	119.75	4184000.0
2005-06-10 15:00:00	SPY	ETF	119.75	120.25	119.71	120.21	5993300.0
2005-06-10 16:00:00	SPY	ETF	120.22	120.26	120.15	120.15	477100.0
2005-06-10 17:00:00	SPY	ETF	120.15	120.15	120.13	120.13	2200.0
2005-06-10 19:00:00	SPY	ETF	120.15	120.15	120.15	120.15	300.0
2005-06-10 09:00:00	QQQ	ETF	37.9	37.9	37.66	37.68	13989500.0
2005-06-10 10:00:00	QQQ	ETF	37.68	37.68	37.53	37.58	18505200.0
2005-06-10 11:00:00	QQQ	ETF	37.58	37.61	37.45	37.46	10361600.0
2005-06-10 12:00:00	QQQ	ETF	37.45	37.48	37.38	37.43	10701500.0
2005-06-10 13:00:00	QQQ	ETF	37.43	37.51	37.41	37.46	4978500.0
2005-06-10 14:00:00	QQQ	ETF	37.45	37.5	37.39	37.45	6816100.0
2005-06-10 15:00:00	QQQ	ETF	37.45	37.58	37.45	37.55	15781000.0
2005-06-10 07:00:00	IWM	ETF	62.33	62.33	62.33	62.33	100.0
2005-06-10 08:00:00	IWM	ETF	62.5	62.57	62.49	62.49	5800.0
2005-06-10 09:00:00	IWM	ETF	62.44	62.55	62.24	62.34	2026400.0
2005-06-10 10:00:00	IWM	ETF	62.35	62.39	62.15	62.33	3619400.0
2005-06-10 11:00:00	IWM	ETF	62.33	62.46	62.25	62.26	1378900.0
2005-06-10 12:00:00	IWM	ETF	62.26	62.28	62.08	62.17	2733700.0
2005-06-10 13:00:00	IWM	ETF	62.16	62.34	62.15	62.22	1538800.0
2005-06-10 14:00:00	IWM	ETF	62.22	62.29	62.12	62.16	2281900.0
2005-06-10 15:00:00	IWM	ETF	62.16	62.42	62.15	62.34	4607000.0
2005-06-10 16:00:00	IWM	ETF	62.37	62.5	62.315	62.5	1391600.0
2005-06-10 09:00:00	DIA	ETF	105.17	105.38	105.07	105.17	680500.0
2005-06-10 10:00:00	DIA	ETF	105.16	105.17	104.85	105.03	1271400.0
2005-06-10 11:00:00	DIA	ETF	105.03	105.07	104.8	104.81	341700.0
2005-06-10 12:00:00	DIA	ETF	104.81	104.87	104.55	104.6	587400.0
2005-06-10 13:00:00	DIA	ETF	104.6	104.82	104.58	104.72	667400.0
2005-06-10 14:00:00	DIA	ETF	104.71	104.78	104.48	104.62	364600.0
2005-06-10 15:00:00	DIA	ETF	104.62	105.11	104.61	105.09	857600.0
2005-06-10 16:00:00	DIA	ETF	105.09	105.19	105.07	105.19	108900.0
2005-06-10 17:00:00	DIA	ETF	105.07	105.07	105.05	105.05	300.0
2005-06-10 09:00:00	GLD	ETF	42.25	42.26	42.18	42.19	62100.0
2005-06-10 10:00:00	GLD	ETF	42.22	42.4	42.12	42.28	220500.0
2005-06-10 11:00:00	GLD	ETF	42.25	42.37	42.23	42.37	179000.0
2005-06-10 12:00:00	GLD	ETF	42.32	42.72	42.3	42.62	274900.0
2005-06-10 13:00:00	GLD	ETF	42.62	42.68	42.6	42.63	597900.0
2005-06-10 14:00:00	GLD	ETF	42.64	42.65	42.62	42.65	135400.0
2005-06-10 15:00:00	GLD	ETF	42.65	42.65	42.6	42.63	178000.0
2005-06-10 08:00:00	TLT	ETF	95.71	95.74	95.71	95.74	200.0
2005-06-10 09:00:00	TLT	ETF	95.56	95.56	95.34	95.37	84700.0
2005-06-10 10:00:00	TLT	ETF	95.34	95.34	95.05	95.26	492800.0
2005-06-10 11:00:00	TLT	ETF	95.22	95.34	95.15	95.28	75100.0

> showing 50 of 864 rows — these rows as CSV

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