PREVIEW / etf_1hour / 2004-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-12.parquet
  size:    24 KB
  rows:    700

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
2004-04-12 08:00:00	SPY	ETF	114.7	114.76	114.65	114.69	26900.0
2004-04-12 09:00:00	SPY	ETF	114.69	114.83	114.48	114.8	2325000.0
2004-04-12 10:00:00	SPY	ETF	114.8	115.08	114.78	115.06	4332600.0
2004-04-12 11:00:00	SPY	ETF	115.06	115.08	114.76	114.9	2270400.0
2004-04-12 12:00:00	SPY	ETF	114.9	114.97	114.79	114.82	1097100.0
2004-04-12 13:00:00	SPY	ETF	114.82	114.89	114.64	114.77	1547100.0
2004-04-12 14:00:00	SPY	ETF	114.79	114.92	114.73	114.77	1582800.0
2004-04-12 15:00:00	SPY	ETF	114.78	114.95	114.69	114.85	2616500.0
2004-04-12 16:00:00	SPY	ETF	114.86	114.99	114.77	114.89	639900.0
2004-04-12 17:00:00	SPY	ETF	114.94	114.95	114.85	114.85	16100.0
2004-04-12 18:00:00	SPY	ETF	114.9	114.9	114.9	114.9	600.0
2004-04-12 19:00:00	SPY	ETF	114.87	115.02	114.87	114.98	11200.0
2004-04-12 08:00:00	QQQ	ETF	37.1	37.17	37.1	37.13	123200.0
2004-04-12 09:00:00	QQQ	ETF	37.13	37.13	36.96	37.06	5865700.0
2004-04-12 10:00:00	QQQ	ETF	37.061	37.22	37.06	37.2	8872500.0
2004-04-12 11:00:00	QQQ	ETF	37.2	37.22	37.07	37.17	5753800.0
2004-04-12 12:00:00	QQQ	ETF	37.17	37.19	37.11	37.13	3562200.0
2004-04-12 13:00:00	QQQ	ETF	37.13	37.16	37.07	37.13	3767900.0
2004-04-12 14:00:00	QQQ	ETF	37.13	37.19	37.09	37.09	4687400.0
2004-04-12 15:00:00	QQQ	ETF	37.103	37.24	37.07	37.16	9238300.0
2004-04-12 16:00:00	QQQ	ETF	37.13	37.203	37.04	37.19	3339000.0
2004-04-12 17:00:00	QQQ	ETF	37.19	37.19	37.16	37.17	39500.0
2004-04-12 18:00:00	QQQ	ETF	37.16	37.19	37.15	37.19	17700.0
2004-04-12 19:00:00	QQQ	ETF	37.19	37.26	37.18	37.2	111800.0
2004-04-12 09:00:00	IWM	ETF	59.65	60.0	59.65	60.0	549000.0
2004-04-12 10:00:00	IWM	ETF	60.0	60.145	59.945	59.99	763600.0
2004-04-12 11:00:00	IWM	ETF	59.965	59.975	59.75	59.8	1770400.0
2004-04-12 12:00:00	IWM	ETF	59.815	59.825	59.71	59.765	363600.0
2004-04-12 13:00:00	IWM	ETF	59.77	59.77	59.665	59.73	272800.0
2004-04-12 14:00:00	IWM	ETF	59.765	59.82	59.64	59.65	485600.0
2004-04-12 15:00:00	IWM	ETF	59.65	59.73	59.56	59.63	2269200.0
2004-04-12 16:00:00	IWM	ETF	59.65	59.795	59.65	59.725	311600.0
2004-04-12 17:00:00	IWM	ETF	59.745	59.745	59.745	59.745	100400.0
2004-04-12 08:00:00	DIA	ETF	104.99	105.1	104.98	105.0	4300.0
2004-04-12 09:00:00	DIA	ETF	104.96	105.15	104.84	105.1	348800.0
2004-04-12 10:00:00	DIA	ETF	105.1	105.45	105.1	105.4	422400.0
2004-04-12 11:00:00	DIA	ETF	105.44	105.47	105.18	105.35	389900.0
2004-04-12 12:00:00	DIA	ETF	105.38	105.42	105.27	105.32	225400.0
2004-04-12 13:00:00	DIA	ETF	105.31	105.36	105.12	105.26	341700.0
2004-04-12 14:00:00	DIA	ETF	105.31	105.39	105.2	105.24	191400.0
2004-04-12 15:00:00	DIA	ETF	105.24	105.41	105.15	105.33	538100.0
2004-04-12 16:00:00	DIA	ETF	105.3	105.4	105.28	105.35	27500.0
2004-04-12 18:00:00	DIA	ETF	105.38	105.38	105.38	105.38	200.0
2004-04-12 09:00:00	TLT	ETF	85.81	85.85	85.77	85.78	16700.0
2004-04-12 10:00:00	TLT	ETF	85.76	85.82	85.63	85.76	79600.0
2004-04-12 11:00:00	TLT	ETF	85.76	85.85	85.71	85.71	31500.0
2004-04-12 12:00:00	TLT	ETF	85.67	85.76	85.63	85.63	18800.0
2004-04-12 13:00:00	TLT	ETF	85.63	85.78	85.6	85.65	38700.0
2004-04-12 14:00:00	TLT	ETF	85.69	85.8	85.67	85.77	39200.0
2004-04-12 15:00:00	TLT	ETF	85.77	85.79	85.71	85.75	42300.0

> showing 50 of 700 rows — these rows as CSV

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