PREVIEW / etf_1hour / 2007-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-02.parquet
  size:    62 KB
  rows:    1,995

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-02-02 06:00:00	SPY	ETF	144.65	144.65	144.65	144.65	7500.0
2007-02-02 07:00:00	SPY	ETF	144.62	144.67	144.61	144.61	23800.0
2007-02-02 08:00:00	SPY	ETF	144.62	144.98	144.46	144.94	2564300.0
2007-02-02 09:00:00	SPY	ETF	144.95	144.96	144.38	144.41	8083300.0
2007-02-02 10:00:00	SPY	ETF	144.42	144.9	144.39	144.78	10412600.0
2007-02-02 11:00:00	SPY	ETF	144.79	144.79	144.45	144.71	6455600.0
2007-02-02 12:00:00	SPY	ETF	144.71	144.85	144.64	144.81	2813000.0
2007-02-02 13:00:00	SPY	ETF	144.82	144.89	144.77	144.84	3158600.0
2007-02-02 14:00:00	SPY	ETF	144.83	144.95	144.62	144.77	5473600.0
2007-02-02 15:00:00	SPY	ETF	144.78	144.87	144.69	144.79	5858200.0
2007-02-02 16:00:00	SPY	ETF	144.79	144.85	144.51	144.77	2489200.0
2007-02-02 17:00:00	SPY	ETF	144.77	144.94	144.77	144.8	38200.0
2007-02-02 18:00:00	SPY	ETF	144.8	144.8	144.78	144.78	600.0
2007-02-02 07:00:00	QQQ	ETF	44.07	44.07	44.07	44.07	200.0
2007-02-02 08:00:00	QQQ	ETF	44.07	44.22	43.99	44.19	5170558.0
2007-02-02 09:00:00	QQQ	ETF	44.19	44.2	43.94	43.96	15512916.0
2007-02-02 10:00:00	QQQ	ETF	43.96	44.25	43.94	44.17	21750500.0
2007-02-02 11:00:00	QQQ	ETF	44.16	44.2	43.99	44.14	16361800.0
2007-02-02 12:00:00	QQQ	ETF	44.14	44.23	44.09	44.2	7050300.0
2007-02-02 13:00:00	QQQ	ETF	44.21	44.24	44.15	44.18	3750300.0
2007-02-02 14:00:00	QQQ	ETF	44.18	44.21	44.01	44.1	14527000.0
2007-02-02 15:00:00	QQQ	ETF	44.1	44.17	44.06	44.17	9181100.0
2007-02-02 16:00:00	QQQ	ETF	44.16	44.19	44.14	44.17	3485273.0
2007-02-02 17:00:00	QQQ	ETF	44.17	44.2	44.17	44.18	40306.0
2007-02-02 18:00:00	QQQ	ETF	44.2	44.21	44.18	44.21	12600.0
2007-02-02 19:00:00	QQQ	ETF	44.22	44.22	44.2	44.21	12659.0
2007-02-02 07:00:00	IWM	ETF	80.12	80.12	80.11	80.11	3000.0
2007-02-02 08:00:00	IWM	ETF	80.12	80.5	80.08	80.5	850900.0
2007-02-02 09:00:00	IWM	ETF	80.5	80.51	80.02	80.07	3969300.0
2007-02-02 10:00:00	IWM	ETF	80.05	80.38	80.04	80.22	6065400.0
2007-02-02 11:00:00	IWM	ETF	80.21	80.3	80.04	80.29	4519700.0
2007-02-02 12:00:00	IWM	ETF	80.29	80.36	80.22	80.34	1209600.0
2007-02-02 13:00:00	IWM	ETF	80.34	80.44	80.32	80.41	1691500.0
2007-02-02 14:00:00	IWM	ETF	80.4	80.45	80.13	80.28	2827500.0
2007-02-02 15:00:00	IWM	ETF	80.28	80.3999	80.23	80.28	4315800.0
2007-02-02 16:00:00	IWM	ETF	80.27	80.33	80.23	80.24	476300.0
2007-02-02 17:00:00	IWM	ETF	80.3	80.3	80.3	80.3	100.0
2007-02-02 07:00:00	DIA	ETF	126.83	126.83	126.8	126.8	1400.0
2007-02-02 08:00:00	DIA	ETF	126.81	126.99	126.66	126.89	35500.0
2007-02-02 09:00:00	DIA	ETF	126.95	126.96	126.41	126.43	812900.0
2007-02-02 10:00:00	DIA	ETF	126.45	126.77	126.42	126.64	1072900.0
2007-02-02 11:00:00	DIA	ETF	126.64	126.64	126.36	126.56	869500.0
2007-02-02 12:00:00	DIA	ETF	126.55	126.67	126.49	126.58	365900.0
2007-02-02 13:00:00	DIA	ETF	126.58	126.64	126.51	126.54	459400.0
2007-02-02 14:00:00	DIA	ETF	126.54	126.59	126.32	126.43	997800.0
2007-02-02 15:00:00	DIA	ETF	126.45	126.52	126.37	126.51	880400.0
2007-02-02 16:00:00	DIA	ETF	126.51	126.56	126.5	126.56	340700.0
2007-02-02 04:00:00	GLD	ETF	65.1	65.1	65.1	65.1	1000.0
2007-02-02 07:00:00	GLD	ETF	65.1	65.1	65.1	65.1	3000.0
2007-02-02 08:00:00	GLD	ETF	65.05	65.43	64.73	64.9	819800.0

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

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