PREVIEW / etf_1hour / 2007-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-10.parquet
  size:    84 KB
  rows:    2,758

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
2007-09-10 05:00:00	SPY	ETF	146.42	146.42	146.42	146.42	300.0
2007-09-10 06:00:00	SPY	ETF	146.04	146.22	146.03	146.22	86000.0
2007-09-10 07:00:00	SPY	ETF	146.33	146.44	145.87	145.9	832100.0
2007-09-10 08:00:00	SPY	ETF	145.93	146.43	145.9	146.4	3191800.0
2007-09-10 09:00:00	SPY	ETF	146.4	146.8	145.96	145.97	24949672.0
2007-09-10 10:00:00	SPY	ETF	145.97	146.11	144.76	145.07	36775800.0
2007-09-10 11:00:00	SPY	ETF	145.07	145.17	144.33	144.85	31113400.0
2007-09-10 12:00:00	SPY	ETF	144.85	145.15	144.71	144.96	16280700.0
2007-09-10 13:00:00	SPY	ETF	144.96	145.54	144.81	145.08	19208100.0
2007-09-10 14:00:00	SPY	ETF	145.08	145.88	144.88	145.78	16904600.0
2007-09-10 15:00:00	SPY	ETF	145.78	146.65	145.5	145.51	33108900.0
2007-09-10 16:00:00	SPY	ETF	145.5	146.34	145.5	145.69	4118800.0
2007-09-10 17:00:00	SPY	ETF	145.69	145.69	145.56	145.6	279200.0
2007-09-10 18:00:00	SPY	ETF	145.6	145.68	145.6	145.6	36900.0
2007-09-10 19:00:00	SPY	ETF	145.65	145.68	145.63	145.68	13800.0
2007-09-10 07:00:00	QQQ	ETF	48.41	48.44	48.29	48.29	369552.0
2007-09-10 08:00:00	QQQ	ETF	48.32	48.52	48.1	48.51	4476734.0
2007-09-10 09:00:00	QQQ	ETF	48.52	48.77	48.34	48.35	18009470.0
2007-09-10 10:00:00	QQQ	ETF	48.35	48.37	47.96	48.06	16483969.0
2007-09-10 11:00:00	QQQ	ETF	48.06	48.12	47.81	48.08	15985998.0
2007-09-10 12:00:00	QQQ	ETF	48.08	48.18	47.98	48.07	7108461.0
2007-09-10 13:00:00	QQQ	ETF	48.06	48.3	48.01	48.14	10042839.0
2007-09-10 14:00:00	QQQ	ETF	48.147	48.39	48.06	48.3492	10780553.0
2007-09-10 15:00:00	QQQ	ETF	48.34	48.63	48.18	48.21	22015223.0
2007-09-10 16:00:00	QQQ	ETF	48.2	48.6	48.2	48.31	2769143.0
2007-09-10 17:00:00	QQQ	ETF	48.31	48.33	48.26	48.29	13314.0
2007-09-10 18:00:00	QQQ	ETF	48.3	48.31	48.28	48.28	7750.0
2007-09-10 19:00:00	QQQ	ETF	48.3	48.32	48.29	48.29	19161.0
2007-09-10 07:00:00	IWM	ETF	77.73	77.73	77.44	77.44	57000.0
2007-09-10 08:00:00	IWM	ETF	77.45	77.7	77.38	77.7	1342200.0
2007-09-10 09:00:00	IWM	ETF	77.79	77.96	77.22	77.22	9229400.0
2007-09-10 10:00:00	IWM	ETF	77.22	77.35	76.24	76.51	16514200.0
2007-09-10 11:00:00	IWM	ETF	76.5	76.56	75.62	76.15	14441900.0
2007-09-10 12:00:00	IWM	ETF	76.15	76.51	76.03	76.23	8983000.0
2007-09-10 13:00:00	IWM	ETF	76.22	76.69	76.14	76.48	5339400.0
2007-09-10 14:00:00	IWM	ETF	76.48	77.03	76.28	76.92	7745100.0
2007-09-10 15:00:00	IWM	ETF	76.92	77.45	76.59	76.59	10658900.0
2007-09-10 16:00:00	IWM	ETF	76.6	76.89	76.55	76.65	7381600.0
2007-09-10 07:00:00	DIA	ETF	131.39	131.55	131.39	131.4	1100.0
2007-09-10 08:00:00	DIA	ETF	131.34	131.72	131.34	131.72	65700.0
2007-09-10 09:00:00	DIA	ETF	131.74	132.08	131.5	131.5	1578900.0
2007-09-10 10:00:00	DIA	ETF	131.5	131.62	130.73	130.93	2212400.0
2007-09-10 11:00:00	DIA	ETF	130.93	131.03	130.24	130.59	2927100.0
2007-09-10 12:00:00	DIA	ETF	130.6	130.88	130.54	130.71	1258400.0
2007-09-10 13:00:00	DIA	ETF	130.69	131.28	130.61	130.97	2558200.0
2007-09-10 14:00:00	DIA	ETF	130.95	131.47	130.77	131.41	910500.0
2007-09-10 15:00:00	DIA	ETF	131.41	132.07	131.22	131.22	1866400.0
2007-09-10 16:00:00	DIA	ETF	131.24	131.44	131.23	131.44	488300.0
2007-09-10 17:00:00	DIA	ETF	131.4	131.45	131.4	131.45	1300.0
2007-09-10 07:00:00	GLD	ETF	69.68	69.8	69.68	69.78	19500.0

> showing 50 of 2,758 rows — these rows as CSV

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