PREVIEW / etf_1hour / 2005-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-30.parquet
  size:    32 KB
  rows:    994

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-30 07:00:00	SPY	ETF	122.61	122.64	122.61	122.64	32500.0
2005-09-30 08:00:00	SPY	ETF	122.58	123.58	122.55	122.66	770800.0
2005-09-30 09:00:00	SPY	ETF	122.57	122.76	122.45	122.73	5865200.0
2005-09-30 10:00:00	SPY	ETF	122.76	122.97	122.52	122.85	9875200.0
2005-09-30 11:00:00	SPY	ETF	122.85	122.89	122.52	122.6	6522600.0
2005-09-30 12:00:00	SPY	ETF	122.59	122.77	122.53	122.66	2296200.0
2005-09-30 13:00:00	SPY	ETF	122.66	122.73	122.5	122.622	2553800.0
2005-09-30 14:00:00	SPY	ETF	122.63	122.95	122.5	122.8	3397900.0
2005-09-30 15:00:00	SPY	ETF	122.79	122.87	121.74	122.85	10520900.0
2005-09-30 16:00:00	SPY	ETF	122.86	123.07	122.8	123.04	1392900.0
2005-09-30 17:00:00	SPY	ETF	123.0	123.08	123.0	123.01	1600.0
2005-09-30 18:00:00	SPY	ETF	123.04	123.1	123.04	123.05	3100.0
2005-09-30 19:00:00	SPY	ETF	123.05	123.08	123.05	123.08	200.0
2005-09-30 09:00:00	QQQ	ETF	39.15	39.27	39.13	39.26	10250600.0
2005-09-30 10:00:00	QQQ	ETF	39.26	39.45	39.23	39.39	20994800.0
2005-09-30 11:00:00	QQQ	ETF	39.38	39.4	39.23	39.26	7759800.0
2005-09-30 12:00:00	QQQ	ETF	39.25	39.36	39.24	39.34	4100900.0
2005-09-30 13:00:00	QQQ	ETF	39.33	39.35	39.24	39.31	5632000.0
2005-09-30 14:00:00	QQQ	ETF	39.31	39.44	39.29	39.37	6607000.0
2005-09-30 15:00:00	QQQ	ETF	39.38	39.46	39.27	39.45	15806300.0
2005-09-30 08:00:00	IWM	ETF	66.11	66.12	66.01	66.08	24700.0
2005-09-30 09:00:00	IWM	ETF	66.06	66.14	65.79	66.05	4991400.0
2005-09-30 10:00:00	IWM	ETF	66.05	66.39	65.91	66.33	8535900.0
2005-09-30 11:00:00	IWM	ETF	66.31	66.32	65.94	65.99	4790700.0
2005-09-30 12:00:00	IWM	ETF	65.99	66.18	65.92	66.12	1702200.0
2005-09-30 13:00:00	IWM	ETF	66.11	66.21	66.05	66.18	801900.0
2005-09-30 14:00:00	IWM	ETF	66.18	66.44	66.15	66.33	1867000.0
2005-09-30 15:00:00	IWM	ETF	66.33	66.4	66.22	66.28	3947100.0
2005-09-30 16:00:00	IWM	ETF	66.28	66.39	66.27	66.39	1681100.0
2005-09-30 17:00:00	IWM	ETF	66.35	66.35	66.27	66.27	1900.0
2005-09-30 08:00:00	DIA	ETF	105.41	105.41	105.3	105.3	900.0
2005-09-30 09:00:00	DIA	ETF	105.39	105.45	105.2	105.42	747600.0
2005-09-30 10:00:00	DIA	ETF	105.42	105.56	105.23	105.5	739400.0
2005-09-30 11:00:00	DIA	ETF	105.48	105.48	105.21	105.25	312400.0
2005-09-30 12:00:00	DIA	ETF	105.24	105.36	105.23	105.31	207500.0
2005-09-30 13:00:00	DIA	ETF	105.32	105.42	105.24	105.4	307900.0
2005-09-30 14:00:00	DIA	ETF	105.36	105.65	105.34	105.53	400600.0
2005-09-30 15:00:00	DIA	ETF	105.53	105.63	105.36	105.61	988900.0
2005-09-30 16:00:00	DIA	ETF	105.67	105.9	105.55	105.55	417700.0
2005-09-30 17:00:00	DIA	ETF	105.9	105.9	105.9	105.9	100.0
2005-09-30 18:00:00	DIA	ETF	105.83	105.83	105.79	105.79	300.0
2005-09-30 19:00:00	DIA	ETF	105.85	105.85	105.85	105.85	600.0
2005-09-30 08:00:00	GLD	ETF	47.2	47.26	47.2	47.26	1500.0
2005-09-30 09:00:00	GLD	ETF	47.15	47.15	46.98	47.04	261700.0
2005-09-30 10:00:00	GLD	ETF	47.0496	47.2	47.03	47.06	108500.0
2005-09-30 11:00:00	GLD	ETF	47.07	47.07	46.77	46.916	247100.0
2005-09-30 12:00:00	GLD	ETF	46.93	46.94	46.74	46.78	80800.0
2005-09-30 13:00:00	GLD	ETF	46.79	46.82	46.65	46.73	129000.0
2005-09-30 14:00:00	GLD	ETF	46.75	46.75	46.68	46.71	105700.0
2005-09-30 15:00:00	GLD	ETF	46.71	46.78	46.69	46.71	226600.0

> showing 50 of 994 rows — these rows as CSV

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