PREVIEW / etf_1hour / 2006-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-26.parquet
  size:    50 KB
  rows:    1,562

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
2006-07-26 04:00:00	SPY	ETF	126.75	126.75	126.66	126.66	1500.0
2006-07-26 06:00:00	SPY	ETF	126.54	126.56	126.5	126.56	155500.0
2006-07-26 07:00:00	SPY	ETF	126.65	126.7	126.6	126.65	61000.0
2006-07-26 08:00:00	SPY	ETF	126.6	126.8	126.52	126.75	879900.0
2006-07-26 09:00:00	SPY	ETF	126.76	126.8	126.38	126.62	7618700.0
2006-07-26 10:00:00	SPY	ETF	126.62	126.65	126.18	126.36	15197500.0
2006-07-26 11:00:00	SPY	ETF	126.3515	126.7	126.29	126.69	7223100.0
2006-07-26 12:00:00	SPY	ETF	126.69	127.09	126.68	126.84	11111900.0
2006-07-26 13:00:00	SPY	ETF	126.83	127.29	126.77	127.13	6613600.0
2006-07-26 14:00:00	SPY	ETF	127.13	127.45	126.78	127.29	22226900.0
2006-07-26 15:00:00	SPY	ETF	127.3015	127.37	126.88	126.89	9865700.0
2006-07-26 16:00:00	SPY	ETF	126.87	126.98	126.8	126.8	1318200.0
2006-07-26 17:00:00	SPY	ETF	126.78	126.82	126.78	126.8	786900.0
2006-07-26 18:00:00	SPY	ETF	126.82	126.83	126.82	126.82	2300.0
2006-07-26 19:00:00	SPY	ETF	126.8	126.81	126.76	126.77	4100.0
2006-07-26 09:00:00	QQQ	ETF	36.5	36.52	36.34	36.48	14494300.0
2006-07-26 10:00:00	QQQ	ETF	36.49	36.49	36.23	36.28	18030200.0
2006-07-26 11:00:00	QQQ	ETF	36.28	36.5	36.23	36.43	9539800.0
2006-07-26 12:00:00	QQQ	ETF	36.43	36.64	36.42	36.51	14577500.0
2006-07-26 13:00:00	QQQ	ETF	36.51	36.71	36.5	36.68	6988700.0
2006-07-26 14:00:00	QQQ	ETF	36.68	36.87	36.54	36.82	18333300.0
2006-07-26 15:00:00	QQQ	ETF	36.81	36.83	36.56	36.57	17016700.0
2006-07-26 08:00:00	IWM	ETF	68.95	69.05	68.82	69.03	720000.0
2006-07-26 09:00:00	IWM	ETF	69.03	69.09	68.52	68.78	7817100.0
2006-07-26 10:00:00	IWM	ETF	68.78	68.78	68.12	68.4	12122900.0
2006-07-26 11:00:00	IWM	ETF	68.4	68.84	68.39	68.8	8252900.0
2006-07-26 12:00:00	IWM	ETF	68.78	69.22	68.78	68.97	6652900.0
2006-07-26 13:00:00	IWM	ETF	68.97	69.41	68.85	69.3	3370300.0
2006-07-26 14:00:00	IWM	ETF	69.31	69.6	69.08	69.42	9036100.0
2006-07-26 15:00:00	IWM	ETF	69.42	69.49	68.95	68.95	6042300.0
2006-07-26 16:00:00	IWM	ETF	68.9	69.24	68.87	68.94	601400.0
2006-07-26 17:00:00	IWM	ETF	68.9	69.05	68.86	69.05	3543600.0
2006-07-26 18:00:00	IWM	ETF	68.95	68.95	68.95	68.95	300.0
2006-07-26 19:00:00	IWM	ETF	68.86	68.87	68.85	68.87	4000.0
2006-07-26 07:00:00	DIA	ETF	110.7	110.85	110.7	110.8	23500.0
2006-07-26 08:00:00	DIA	ETF	110.76	110.9	110.68	110.87	7000.0
2006-07-26 09:00:00	DIA	ETF	110.92	110.92	110.54	110.71	997600.0
2006-07-26 10:00:00	DIA	ETF	110.71	110.74	110.39	110.5	1012000.0
2006-07-26 11:00:00	DIA	ETF	110.52	110.81	110.49	110.74	939600.0
2006-07-26 12:00:00	DIA	ETF	110.75	111.08	110.75	110.96	603200.0
2006-07-26 13:00:00	DIA	ETF	110.96	111.29	110.88	111.17	427100.0
2006-07-26 14:00:00	DIA	ETF	111.17	111.48	110.88	111.33	1219400.0
2006-07-26 15:00:00	DIA	ETF	111.33	111.36	110.92	110.93	840900.0
2006-07-26 16:00:00	DIA	ETF	110.93	110.97	110.9	110.95	75900.0
2006-07-26 17:00:00	DIA	ETF	110.99	111.0	110.97	111.0	21800.0
2006-07-26 19:00:00	DIA	ETF	110.91	110.91	110.91	110.91	1000.0
2006-07-26 08:00:00	GLD	ETF	61.45	61.58	61.24	61.55	107800.0
2006-07-26 09:00:00	GLD	ETF	61.51	61.53	61.07	61.15	467000.0
2006-07-26 10:00:00	GLD	ETF	61.16	61.4401	60.9301	61.29	496700.0
2006-07-26 11:00:00	GLD	ETF	61.29	61.55	61.29	61.47	487500.0

> showing 50 of 1,562 rows — these rows as CSV

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