PREVIEW / etf_1hour / 2005-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-15.parquet
  size:    31 KB
  rows:    957

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-09-15 06:00:00	SPY	ETF	123.42	123.42	123.42	123.42	5800.0
2005-09-15 07:00:00	SPY	ETF	123.45	123.46	123.4	123.44	45300.0
2005-09-15 08:00:00	SPY	ETF	123.45	123.6	123.2	123.48	2422200.0
2005-09-15 09:00:00	SPY	ETF	123.47	123.65	123.43	123.54	6070700.0
2005-09-15 10:00:00	SPY	ETF	123.53	123.54	123.09	123.32	10858400.0
2005-09-15 11:00:00	SPY	ETF	123.32	123.5	123.17	123.22	6879200.0
2005-09-15 12:00:00	SPY	ETF	123.21	123.23	122.9	123.04	10937000.0
2005-09-15 13:00:00	SPY	ETF	123.04	123.35	123.03	123.09	6110100.0
2005-09-15 14:00:00	SPY	ETF	123.11	123.29	123.0	123.18	4814300.0
2005-09-15 15:00:00	SPY	ETF	123.18	123.28	122.94	123.22	15047600.0
2005-09-15 16:00:00	SPY	ETF	123.2	123.24	123.11	123.17	1851500.0
2005-09-15 17:00:00	SPY	ETF	123.17	123.22	123.03	123.15	116800.0
2005-09-15 18:00:00	SPY	ETF	123.17	123.2	123.13	123.2	477000.0
2005-09-15 19:00:00	SPY	ETF	123.21	123.23	123.21	123.23	700.0
2005-09-15 09:00:00	QQQ	ETF	39.26	39.34	39.19	39.25	13010700.0
2005-09-15 10:00:00	QQQ	ETF	39.25	39.26	39.05	39.15	16520700.0
2005-09-15 11:00:00	QQQ	ETF	39.15	39.28	39.11	39.17	9504800.0
2005-09-15 12:00:00	QQQ	ETF	39.17	39.18	39.06	39.14	10880400.0
2005-09-15 13:00:00	QQQ	ETF	39.14	39.27	39.12	39.13	6549700.0
2005-09-15 14:00:00	QQQ	ETF	39.13	39.22	39.11	39.14	6066600.0
2005-09-15 15:00:00	QQQ	ETF	39.13	39.2	39.1	39.17	9700700.0
2005-09-15 08:00:00	IWM	ETF	66.47	66.55	66.44	66.46	616700.0
2005-09-15 09:00:00	IWM	ETF	66.45	66.64	66.36	66.46	2639100.0
2005-09-15 10:00:00	IWM	ETF	66.45	66.46	66.14	66.23	3481400.0
2005-09-15 11:00:00	IWM	ETF	66.23	66.41	66.16	66.25	2621200.0
2005-09-15 12:00:00	IWM	ETF	66.26	66.4	66.06	66.22	2328100.0
2005-09-15 13:00:00	IWM	ETF	66.22	66.43	66.21	66.29	1772400.0
2005-09-15 14:00:00	IWM	ETF	66.29	66.43	66.22	66.32	3149700.0
2005-09-15 15:00:00	IWM	ETF	66.32	66.35	66.07	66.24	6154100.0
2005-09-15 16:00:00	IWM	ETF	66.25	66.25	66.17	66.19	13400.0
2005-09-15 17:00:00	IWM	ETF	66.29	66.29	66.29	66.29	200.0
2005-09-15 08:00:00	DIA	ETF	105.77	105.89	105.67	105.79	42500.0
2005-09-15 09:00:00	DIA	ETF	105.8	105.9	105.71	105.79	640300.0
2005-09-15 10:00:00	DIA	ETF	105.79	105.81	105.47	105.64	1153100.0
2005-09-15 11:00:00	DIA	ETF	105.67	105.81	105.51	105.57	927800.0
2005-09-15 12:00:00	DIA	ETF	105.57	105.66	105.26	105.41	1109000.0
2005-09-15 13:00:00	DIA	ETF	105.42	105.7	105.3	105.54	916700.0
2005-09-15 14:00:00	DIA	ETF	105.54	105.69	105.3	105.66	534800.0
2005-09-15 15:00:00	DIA	ETF	105.63	105.68	105.37	105.62	1582600.0
2005-09-15 16:00:00	DIA	ETF	105.63	105.63	105.62	105.62	3000.0
2005-09-15 17:00:00	DIA	ETF	105.75	105.75	105.66	105.66	500.0
2005-09-15 19:00:00	DIA	ETF	105.74	105.74	105.74	105.74	300.0
2005-09-15 08:00:00	GLD	ETF	45.08	45.33	45.08	45.3	63200.0
2005-09-15 09:00:00	GLD	ETF	45.29	45.4	45.21	45.3596	453900.0
2005-09-15 10:00:00	GLD	ETF	45.35	45.38	45.2	45.28	329800.0
2005-09-15 11:00:00	GLD	ETF	45.27	45.32	45.14	45.17	164700.0
2005-09-15 12:00:00	GLD	ETF	45.18	45.43	45.13	45.4	394100.0
2005-09-15 13:00:00	GLD	ETF	45.4	45.47	45.38	45.42	324100.0
2005-09-15 14:00:00	GLD	ETF	45.42	45.43	45.37	45.42	162100.0
2005-09-15 15:00:00	GLD	ETF	45.42	45.45	45.4	45.42	248600.0

> showing 50 of 957 rows — these rows as CSV

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