PREVIEW / etf_1hour / 2005-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-01-11.parquet
  size:    29 KB
  rows:    839

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-01-11 08:00:00	SPY	ETF	118.72	118.75	118.56	118.65	155400.0
2005-01-11 09:00:00	SPY	ETF	118.66	118.7	118.23	118.41	9715200.0
2005-01-11 10:00:00	SPY	ETF	118.41	118.55	118.13	118.38	9335000.0
2005-01-11 11:00:00	SPY	ETF	118.38	118.55	118.3	118.46	5248800.0
2005-01-11 12:00:00	SPY	ETF	118.49	118.49	118.12	118.14	9327900.0
2005-01-11 13:00:00	SPY	ETF	118.13	118.52	117.99	118.44	9547100.0
2005-01-11 14:00:00	SPY	ETF	118.44	118.74	118.34	118.41	7464800.0
2005-01-11 15:00:00	SPY	ETF	118.41	118.57	118.21	118.28	7732600.0
2005-01-11 16:00:00	SPY	ETF	118.31	118.53	118.14	118.51	3089200.0
2005-01-11 17:00:00	SPY	ETF	118.5	118.55	118.4	118.45	194400.0
2005-01-11 18:00:00	SPY	ETF	118.41	118.6	118.38	118.6	66200.0
2005-01-11 19:00:00	SPY	ETF	118.6	118.6	118.58	118.58	1700.0
2005-01-11 09:00:00	QQQ	ETF	38.38	38.45	38.31	38.45	10838800.0
2005-01-11 10:00:00	QQQ	ETF	38.45	38.5	38.31	38.45	19956300.0
2005-01-11 11:00:00	QQQ	ETF	38.45	38.49	38.36	38.41	7661900.0
2005-01-11 12:00:00	QQQ	ETF	38.41	38.42	38.12	38.13	15334600.0
2005-01-11 13:00:00	QQQ	ETF	38.13	38.36	38.07	38.29	14480900.0
2005-01-11 14:00:00	QQQ	ETF	38.29	38.46	38.23	38.28	10540100.0
2005-01-11 15:00:00	QQQ	ETF	38.28	38.39	38.17	38.25	15925900.0
2005-01-11 08:00:00	IWM	ETF	61.4	61.4	61.3	61.3	3800.0
2005-01-11 09:00:00	IWM	ETF	61.365	61.365	60.88	60.99	3405600.0
2005-01-11 10:00:00	IWM	ETF	60.95	61.03	60.6455	60.89	4612800.0
2005-01-11 11:00:00	IWM	ETF	60.885	61.03	60.87	60.99	1770800.0
2005-01-11 12:00:00	IWM	ETF	61.01	61.01	60.765	60.8	2457800.0
2005-01-11 13:00:00	IWM	ETF	60.795	60.965	60.625	60.945	3620800.0
2005-01-11 14:00:00	IWM	ETF	60.945	61.25	60.91	61.045	3251200.0
2005-01-11 15:00:00	IWM	ETF	61.05	61.17	60.9	60.93	2904400.0
2005-01-11 16:00:00	IWM	ETF	60.93	61.125	60.8	60.995	570600.0
2005-01-11 17:00:00	IWM	ETF	60.995	61.01	60.905	60.925	133400.0
2005-01-11 18:00:00	IWM	ETF	60.925	61.055	60.925	61.055	600.0
2005-01-11 19:00:00	IWM	ETF	61.06	61.06	61.06	61.06	1000.0
2005-01-11 08:00:00	DIA	ETF	105.96	105.96	105.85	105.85	2200.0
2005-01-11 09:00:00	DIA	ETF	105.9	105.97	105.49	105.68	1295600.0
2005-01-11 10:00:00	DIA	ETF	105.68	105.81	105.47	105.7	1606800.0
2005-01-11 11:00:00	DIA	ETF	105.71	105.81	105.65	105.74	764800.0
2005-01-11 12:00:00	DIA	ETF	105.72	105.73	105.37	105.38	758500.0
2005-01-11 13:00:00	DIA	ETF	105.36	105.71	105.27	105.65	501300.0
2005-01-11 14:00:00	DIA	ETF	105.65	105.91	105.64	105.7	747700.0
2005-01-11 15:00:00	DIA	ETF	105.69	105.85	105.58	105.61	745900.0
2005-01-11 16:00:00	DIA	ETF	105.62	105.8	105.5	105.73	571900.0
2005-01-11 17:00:00	DIA	ETF	105.8	105.8	105.65	105.65	1100.0
2005-01-11 18:00:00	DIA	ETF	105.8	105.8	105.8	105.8	500.0
2005-01-11 19:00:00	DIA	ETF	105.8	105.8	105.8	105.8	100.0
2005-01-11 09:00:00	GLD	ETF	42.21	42.25	42.17	42.2	268500.0
2005-01-11 10:00:00	GLD	ETF	42.2	42.24	42.12	42.2	141900.0
2005-01-11 11:00:00	GLD	ETF	42.2	42.28	42.158	42.26	145700.0
2005-01-11 12:00:00	GLD	ETF	42.26	42.26	42.12	42.19	335800.0
2005-01-11 13:00:00	GLD	ETF	42.2	42.25	42.18	42.22	222900.0
2005-01-11 14:00:00	GLD	ETF	42.22	42.27	42.21	42.24	213600.0
2005-01-11 15:00:00	GLD	ETF	42.24	42.25	42.17	42.21	178200.0

> showing 50 of 839 rows — these rows as CSV

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