PREVIEW / etf_1hour / 2006-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-26.parquet
  size:    45 KB
  rows:    1,429

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-06-26 05:00:00	SPY	ETF	124.78	124.78	124.64	124.64	300.0
2006-06-26 07:00:00	SPY	ETF	124.69	124.69	124.51	124.61	82600.0
2006-06-26 08:00:00	SPY	ETF	124.71	124.71	124.51	124.6	184900.0
2006-06-26 09:00:00	SPY	ETF	124.57	124.68	124.25	124.51	5327100.0
2006-06-26 10:00:00	SPY	ETF	124.52	124.75	124.35	124.52	6111100.0
2006-06-26 11:00:00	SPY	ETF	124.5205	124.63	124.3	124.41	3231000.0
2006-06-26 12:00:00	SPY	ETF	124.41	124.69	124.26	124.66	4271400.0
2006-06-26 13:00:00	SPY	ETF	124.66	124.83	124.55	124.65	2917900.0
2006-06-26 14:00:00	SPY	ETF	124.65	124.88	124.5	124.74	6949300.0
2006-06-26 15:00:00	SPY	ETF	124.75	125.05	124.65	125.04	6058200.0
2006-06-26 16:00:00	SPY	ETF	125.03	125.06	124.629	125.04	1130200.0
2006-06-26 17:00:00	SPY	ETF	125.05	125.06	124.91	124.95	83200.0
2006-06-26 18:00:00	SPY	ETF	124.92	124.95	124.87	124.91	40400.0
2006-06-26 19:00:00	SPY	ETF	124.94	124.94	124.94	124.94	800.0
2006-06-26 09:00:00	QQQ	ETF	38.17	38.29	38.13	38.22	10190300.0
2006-06-26 10:00:00	QQQ	ETF	38.22	38.39	38.14	38.26	14943800.0
2006-06-26 11:00:00	QQQ	ETF	38.26	38.31	38.14	38.18	6637400.0
2006-06-26 12:00:00	QQQ	ETF	38.19	38.21	38.07	38.2	7386100.0
2006-06-26 13:00:00	QQQ	ETF	38.2	38.25	38.13	38.17	5561900.0
2006-06-26 14:00:00	QQQ	ETF	38.17	38.26	38.11	38.19	7678300.0
2006-06-26 15:00:00	QQQ	ETF	38.19	38.29	38.17	38.23	8132200.0
2006-06-26 08:00:00	IWM	ETF	69.2	69.2	69.01	69.03	87700.0
2006-06-26 09:00:00	IWM	ETF	69.04	69.21	68.96	69.11	6302000.0
2006-06-26 10:00:00	IWM	ETF	69.11	69.38	68.98	69.04	5949000.0
2006-06-26 11:00:00	IWM	ETF	69.05	69.17	68.95	69.02	4080100.0
2006-06-26 12:00:00	IWM	ETF	69.03	69.2	69.0	69.13	2819700.0
2006-06-26 13:00:00	IWM	ETF	69.14	69.28	69.0	69.08	2049200.0
2006-06-26 14:00:00	IWM	ETF	69.08	69.2	69.0	69.1	2364600.0
2006-06-26 15:00:00	IWM	ETF	69.1	69.47	69.08	69.47	7396100.0
2006-06-26 16:00:00	IWM	ETF	69.46	69.56	69.2567	69.56	8156400.0
2006-06-26 17:00:00	IWM	ETF	69.5	69.55	69.5	69.55	60600.0
2006-06-26 18:00:00	IWM	ETF	69.5	69.5	69.45	69.45	23200.0
2006-06-26 08:00:00	DIA	ETF	110.0	110.05	109.96	109.96	2700.0
2006-06-26 09:00:00	DIA	ETF	109.93	110.16	109.85	109.99	394200.0
2006-06-26 10:00:00	DIA	ETF	110.0	110.17	109.87	109.95	834500.0
2006-06-26 11:00:00	DIA	ETF	109.94	110.09	109.72	109.8	829300.0
2006-06-26 12:00:00	DIA	ETF	109.8	110.01	109.65	109.96	654800.0
2006-06-26 13:00:00	DIA	ETF	109.96	110.09	109.86	109.91	713100.0
2006-06-26 14:00:00	DIA	ETF	109.91	110.13	109.8	110.03	380200.0
2006-06-26 15:00:00	DIA	ETF	110.04	110.43	109.98	110.4	453400.0
2006-06-26 16:00:00	DIA	ETF	110.41	110.46	110.4	110.46	12300.0
2006-06-26 17:00:00	DIA	ETF	110.35	110.35	110.35	110.35	200.0
2006-06-26 18:00:00	DIA	ETF	110.42	110.45	110.41	110.45	800.0
2006-06-26 07:00:00	GLD	ETF	58.17	58.17	58.11	58.11	5500.0
2006-06-26 08:00:00	GLD	ETF	58.06	58.26	57.94	58.2	49300.0
2006-06-26 09:00:00	GLD	ETF	58.24	58.34	58.06	58.06	595100.0
2006-06-26 10:00:00	GLD	ETF	58.06	58.07	57.47	57.54	682800.0
2006-06-26 11:00:00	GLD	ETF	57.5201	57.85	57.42	57.84	453500.0
2006-06-26 12:00:00	GLD	ETF	57.84	58.14	57.81	58.06	621300.0
2006-06-26 13:00:00	GLD	ETF	58.06	58.25	58.05	58.21	419400.0

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

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