PREVIEW / etf_1hour / 2004-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-13.parquet
  size:    24 KB
  rows:    647

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-01-13 08:00:00	SPY	ETF	113.25	113.29	113.12	113.12	15500.0
2004-01-13 09:00:00	SPY	ETF	113.12	113.23	113.02	113.1	1975300.0
2004-01-13 10:00:00	SPY	ETF	113.09	113.21	112.65	112.68	4151200.0
2004-01-13 11:00:00	SPY	ETF	112.68	112.83	112.0	112.02	4130900.0
2004-01-13 12:00:00	SPY	ETF	112.1	112.35	111.82	112.2	7827500.0
2004-01-13 13:00:00	SPY	ETF	112.2	112.34	112.08	112.17	2328600.0
2004-01-13 14:00:00	SPY	ETF	112.16	112.39	111.76	112.13	6035400.0
2004-01-13 15:00:00	SPY	ETF	112.11	112.48	112.0	112.47	5286500.0
2004-01-13 16:00:00	SPY	ETF	112.44	112.56	112.26	112.52	9681300.0
2004-01-13 17:00:00	SPY	ETF	112.54	112.54	112.48	112.48	2900.0
2004-01-13 18:00:00	SPY	ETF	112.48	112.55	112.48	112.55	44800.0
2004-01-13 19:00:00	SPY	ETF	112.46	112.46	112.39	112.39	6800.0
2004-01-13 08:00:00	QQQ	ETF	38.34	38.36	38.26	38.28	65200.0
2004-01-13 09:00:00	QQQ	ETF	38.29	38.344	38.2	38.26	10320800.0
2004-01-13 10:00:00	QQQ	ETF	38.25	38.33	37.937	37.961	21352700.0
2004-01-13 11:00:00	QQQ	ETF	37.95	38.06	37.68	37.71	12554900.0
2004-01-13 12:00:00	QQQ	ETF	37.69	37.88	37.61	37.786	13524500.0
2004-01-13 13:00:00	QQQ	ETF	37.77	37.88	37.729	37.79	6249400.0
2004-01-13 14:00:00	QQQ	ETF	37.78	37.88	37.62	37.76	9098600.0
2004-01-13 15:00:00	QQQ	ETF	37.75	37.93	37.71	37.9	10598200.0
2004-01-13 16:00:00	QQQ	ETF	37.916	37.99	37.88	37.955	2359900.0
2004-01-13 17:00:00	QQQ	ETF	37.94	37.99	37.92	37.92	112500.0
2004-01-13 18:00:00	QQQ	ETF	37.94	38.008	37.94	37.97	33300.0
2004-01-13 19:00:00	QQQ	ETF	37.96	37.97	37.93	37.96	6200.0
2004-01-13 08:00:00	IWM	ETF	58.255	58.255	58.255	58.255	4000.0
2004-01-13 09:00:00	IWM	ETF	58.1535	58.16	57.98	58.02	637600.0
2004-01-13 10:00:00	IWM	ETF	58.0705	58.125	57.68	57.71	899200.0
2004-01-13 11:00:00	IWM	ETF	57.6425	57.81	57.285	57.3	1146000.0
2004-01-13 12:00:00	IWM	ETF	57.255	57.57	57.2105	57.54	1546800.0
2004-01-13 13:00:00	IWM	ETF	57.545	57.64	57.44	57.545	739200.0
2004-01-13 14:00:00	IWM	ETF	57.54	57.63	57.345	57.4685	1133600.0
2004-01-13 15:00:00	IWM	ETF	57.465	57.85	57.415	57.845	886200.0
2004-01-13 16:00:00	IWM	ETF	57.85	57.9785	57.84	57.9185	374000.0
2004-01-13 17:00:00	IWM	ETF	57.905	57.905	57.905	57.905	1000.0
2004-01-13 08:00:00	DIA	ETF	105.27	105.27	105.16	105.16	4900.0
2004-01-13 09:00:00	DIA	ETF	105.19	105.26	105.09	105.15	613100.0
2004-01-13 10:00:00	DIA	ETF	105.15	105.28	104.76	104.77	1554300.0
2004-01-13 11:00:00	DIA	ETF	104.759	104.9	104.056	104.14	1328200.0
2004-01-13 12:00:00	DIA	ETF	104.03	104.4	103.801	104.31	1276600.0
2004-01-13 13:00:00	DIA	ETF	104.29	104.39	104.16	104.28	659000.0
2004-01-13 14:00:00	DIA	ETF	104.27	104.48	103.92	104.239	1377700.0
2004-01-13 15:00:00	DIA	ETF	104.24	104.5	104.06	104.42	1446800.0
2004-01-13 16:00:00	DIA	ETF	104.47	104.57	104.41	104.57	55100.0
2004-01-13 19:00:00	DIA	ETF	104.46	104.46	104.46	104.46	100.0
2004-01-13 09:00:00	TLT	ETF	86.68	86.76	86.66	86.71	19600.0
2004-01-13 10:00:00	TLT	ETF	86.7	86.86	86.56	86.85	89000.0
2004-01-13 11:00:00	TLT	ETF	86.81	86.97	86.67	86.96	30800.0
2004-01-13 12:00:00	TLT	ETF	87.0	87.02	86.87	86.91	53500.0
2004-01-13 13:00:00	TLT	ETF	86.92	87.08	86.92	87.08	53700.0
2004-01-13 14:00:00	TLT	ETF	87.08	87.34	86.98	87.3	47200.0

> showing 50 of 647 rows — these rows as CSV

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