PREVIEW / etf_1hour / 2005-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-14.parquet
  size:    33 KB
  rows:    988

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-10-14 07:00:00	SPY	ETF	117.7	117.83	117.7	117.72	502900.0
2005-10-14 08:00:00	SPY	ETF	117.75	118.38	117.67	118.29	6992100.0
2005-10-14 09:00:00	SPY	ETF	118.29	118.34	117.81	117.86	14425700.0
2005-10-14 10:00:00	SPY	ETF	117.88	118.09	117.56	117.86	17403800.0
2005-10-14 11:00:00	SPY	ETF	117.86	118.39	117.81	118.27	8078700.0
2005-10-14 12:00:00	SPY	ETF	118.29	118.61	118.07	118.11	13338500.0
2005-10-14 13:00:00	SPY	ETF	118.1	118.42	117.95	118.38	7331000.0
2005-10-14 14:00:00	SPY	ETF	118.39	118.64	118.11	118.53	6636100.0
2005-10-14 15:00:00	SPY	ETF	118.53	118.81	118.43	118.75	11051700.0
2005-10-14 16:00:00	SPY	ETF	118.77	118.77	118.59	118.59	850300.0
2005-10-14 17:00:00	SPY	ETF	118.65	118.69	118.58	118.6	21600.0
2005-10-14 18:00:00	SPY	ETF	118.65	118.67	118.65	118.67	5300.0
2005-10-14 19:00:00	SPY	ETF	118.67	118.67	118.6	118.61	2700.0
2005-10-14 09:00:00	QQQ	ETF	37.86	37.96	37.72	37.73	18266200.0
2005-10-14 10:00:00	QQQ	ETF	37.73	37.94	37.64	37.85	26224000.0
2005-10-14 11:00:00	QQQ	ETF	37.85	37.95	37.8	37.9	13122900.0
2005-10-14 12:00:00	QQQ	ETF	37.91	38.02	37.76	37.78	16952100.0
2005-10-14 13:00:00	QQQ	ETF	37.78	37.89	37.7	37.88	9270700.0
2005-10-14 14:00:00	QQQ	ETF	37.88	38.04	37.77	37.97	12747300.0
2005-10-14 15:00:00	QQQ	ETF	37.98	38.07	37.96	38.06	14309600.0
2005-10-14 07:00:00	IWM	ETF	62.0	62.0	62.0	62.0	8500.0
2005-10-14 08:00:00	IWM	ETF	61.96	62.59	61.96	62.48	1490800.0
2005-10-14 09:00:00	IWM	ETF	62.46	62.55	61.32	62.06	11310800.0
2005-10-14 10:00:00	IWM	ETF	62.05	62.45	61.68	62.32	11150800.0
2005-10-14 11:00:00	IWM	ETF	62.32	62.65	62.2	62.62	5893000.0
2005-10-14 12:00:00	IWM	ETF	62.63	62.89	62.48	62.53	7590300.0
2005-10-14 13:00:00	IWM	ETF	62.52	62.66	62.35	62.65	3778400.0
2005-10-14 14:00:00	IWM	ETF	62.66	62.85	62.54	62.79	2003200.0
2005-10-14 15:00:00	IWM	ETF	62.79	63.02	62.78	62.95	6833200.0
2005-10-14 16:00:00	IWM	ETF	62.94	63.0	62.79	62.81	300300.0
2005-10-14 07:00:00	DIA	ETF	102.22	102.22	102.22	102.22	100.0
2005-10-14 08:00:00	DIA	ETF	102.17	102.61	102.15	102.56	305400.0
2005-10-14 09:00:00	DIA	ETF	102.56	102.64	102.26	102.3	2170600.0
2005-10-14 10:00:00	DIA	ETF	102.3	102.52	102.03	102.23	1712100.0
2005-10-14 11:00:00	DIA	ETF	102.24	102.66	102.2	102.5	1272700.0
2005-10-14 12:00:00	DIA	ETF	102.5	102.75	102.36	102.38	639500.0
2005-10-14 13:00:00	DIA	ETF	102.38	102.62	102.29	102.6	600700.0
2005-10-14 14:00:00	DIA	ETF	102.58	102.69	102.38	102.65	467500.0
2005-10-14 15:00:00	DIA	ETF	102.643	102.97	102.59	102.95	1405300.0
2005-10-14 16:00:00	DIA	ETF	102.88	102.91	102.8	102.83	105100.0
2005-10-14 17:00:00	DIA	ETF	102.89	102.89	102.89	102.89	600.0
2005-10-14 18:00:00	DIA	ETF	102.95	102.95	102.95	102.95	100.0
2005-10-14 08:00:00	GLD	ETF	47.03	47.03	46.65	46.65	7700.0
2005-10-14 09:00:00	GLD	ETF	46.65	46.65	46.4	46.49	377500.0
2005-10-14 10:00:00	GLD	ETF	46.48	46.59	46.41	46.52	618200.0
2005-10-14 11:00:00	GLD	ETF	46.51	46.57	46.45	46.54	288300.0
2005-10-14 12:00:00	GLD	ETF	46.54	46.71	46.53	46.67	223600.0
2005-10-14 13:00:00	GLD	ETF	46.66	46.79	46.6	46.77	453100.0
2005-10-14 14:00:00	GLD	ETF	46.76	46.83	46.7101	46.79	198300.0
2005-10-14 15:00:00	GLD	ETF	46.8	46.82	46.73	46.78	171900.0

> showing 50 of 988 rows — these rows as CSV

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