PREVIEW / etf_1hour / 2005-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-04.parquet
  size:    31 KB
  rows:    870

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-05-04 06:00:00	SPY	ETF	116.47	116.47	116.47	116.47	3500.0
2005-05-04 07:00:00	SPY	ETF	116.46	116.5	116.41	116.45	111900.0
2005-05-04 08:00:00	SPY	ETF	116.47	116.93	116.45	116.85	975800.0
2005-05-04 09:00:00	SPY	ETF	116.85	116.85	116.28	116.48	13499000.0
2005-05-04 10:00:00	SPY	ETF	116.46	117.19	116.37	116.98	18916600.0
2005-05-04 11:00:00	SPY	ETF	116.97	117.72	116.88	116.97	7481100.0
2005-05-04 12:00:00	SPY	ETF	116.98	117.08	116.75	117.05	7205800.0
2005-05-04 13:00:00	SPY	ETF	117.04	117.49	116.95	117.39	7282100.0
2005-05-04 14:00:00	SPY	ETF	117.39	117.54	117.31	117.51	8667800.0
2005-05-04 15:00:00	SPY	ETF	117.51	117.75	117.36	117.615	11844900.0
2005-05-04 16:00:00	SPY	ETF	117.62	117.71	117.47	117.59	781800.0
2005-05-04 17:00:00	SPY	ETF	117.58	117.59	117.52	117.54	159000.0
2005-05-04 18:00:00	SPY	ETF	117.52	117.55	117.43	117.43	16600.0
2005-05-04 19:00:00	SPY	ETF	117.46	117.48	117.46	117.48	8400.0
2005-05-04 09:00:00	QQQ	ETF	35.29	35.39	35.24	35.32	7768800.0
2005-05-04 10:00:00	QQQ	ETF	35.31	35.55	35.27	35.49	19087300.0
2005-05-04 11:00:00	QQQ	ETF	35.48	35.58	35.46	35.49	10777100.0
2005-05-04 12:00:00	QQQ	ETF	35.49	35.51	35.39	35.48	8175600.0
2005-05-04 13:00:00	QQQ	ETF	35.49	35.71	35.47	35.67	11906600.0
2005-05-04 14:00:00	QQQ	ETF	35.67	35.74	35.62	35.73	10646500.0
2005-05-04 15:00:00	QQQ	ETF	35.73	35.83	35.67	35.72	17428900.0
2005-05-04 08:00:00	IWM	ETF	58.435	58.525	58.0	58.515	182600.0
2005-05-04 09:00:00	IWM	ETF	58.525	58.6	58.215	58.41	2124000.0
2005-05-04 10:00:00	IWM	ETF	58.405	58.805	58.32	58.715	5075600.0
2005-05-04 11:00:00	IWM	ETF	58.716	58.87	58.575	58.745	2531200.0
2005-05-04 12:00:00	IWM	ETF	58.745	58.815	58.625	58.75	1617400.0
2005-05-04 13:00:00	IWM	ETF	58.755	59.055	58.75	59.02	2607600.0
2005-05-04 14:00:00	IWM	ETF	59.02	59.125	58.96	59.125	2427400.0
2005-05-04 15:00:00	IWM	ETF	59.125	59.275	59.01	59.15	4912400.0
2005-05-04 16:00:00	IWM	ETF	59.145	59.205	58.1388	59.17	1038800.0
2005-05-04 17:00:00	IWM	ETF	59.16	59.2	59.16	59.2	10000.0
2005-05-04 18:00:00	IWM	ETF	59.11	59.11	59.105	59.105	1200.0
2005-05-04 08:00:00	DIA	ETF	102.9	103.2	102.9	103.18	58600.0
2005-05-04 09:00:00	DIA	ETF	103.18	103.18	102.67	102.88	630500.0
2005-05-04 10:00:00	DIA	ETF	102.83	103.56	102.75	103.35	1530200.0
2005-05-04 11:00:00	DIA	ETF	103.33	103.51	103.27	103.31	639300.0
2005-05-04 12:00:00	DIA	ETF	103.3	103.38	103.14	103.35	509800.0
2005-05-04 13:00:00	DIA	ETF	103.36	103.71	103.28	103.62	794100.0
2005-05-04 14:00:00	DIA	ETF	103.64	103.74	103.52	103.69	1011100.0
2005-05-04 15:00:00	DIA	ETF	103.69	103.93	103.56	103.79	2538300.0
2005-05-04 16:00:00	DIA	ETF	103.79	103.82	103.71	103.77	12600.0
2005-05-04 17:00:00	DIA	ETF	103.8	103.85	103.77	103.77	300.0
2005-05-04 18:00:00	DIA	ETF	103.79	103.79	103.79	103.79	400.0
2005-05-04 19:00:00	DIA	ETF	103.75	103.75	103.75	103.75	1000.0
2005-05-04 08:00:00	GLD	ETF	42.8	42.93	42.8	42.93	3000.0
2005-05-04 09:00:00	GLD	ETF	42.9	42.9	42.83	42.88	200900.0
2005-05-04 10:00:00	GLD	ETF	42.88	42.88	42.75	42.8	112500.0
2005-05-04 11:00:00	GLD	ETF	42.81	42.82	42.73	42.82	50400.0
2005-05-04 12:00:00	GLD	ETF	42.82	42.89	42.76	42.87	39500.0
2005-05-04 13:00:00	GLD	ETF	42.87	42.9	42.83	42.86	22100.0

> showing 50 of 870 rows — these rows as CSV

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