PREVIEW / etf_1hour / 2003-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-17.parquet
  size:    16 KB
  rows:    375

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
2003-01-17 08:00:00	SPY	ETF	91.24	91.3	91.1	91.12	41500.0
2003-01-17 09:00:00	SPY	ETF	91.17	91.29	90.77	91.07	8060000.0
2003-01-17 10:00:00	SPY	ETF	91.07	91.34	90.72	90.76	5140300.0
2003-01-17 11:00:00	SPY	ETF	90.78	90.81	90.35	90.47	6011200.0
2003-01-17 12:00:00	SPY	ETF	90.49	90.68	90.46	90.58	1781300.0
2003-01-17 13:00:00	SPY	ETF	90.61	90.62	90.21	90.29	3283700.0
2003-01-17 14:00:00	SPY	ETF	90.29	90.57	90.15	90.52	3688400.0
2003-01-17 15:00:00	SPY	ETF	90.52	90.64	90.22	90.49	4227600.0
2003-01-17 16:00:00	SPY	ETF	90.48	90.73	90.42	90.69	1503800.0
2003-01-17 17:00:00	SPY	ETF	90.58	90.65	90.58	90.63	5000.0
2003-01-17 18:00:00	SPY	ETF	90.64	90.65	90.6	90.6	2100.0
2003-01-17 19:00:00	SPY	ETF	90.66	90.66	90.66	90.66	100.0
2003-01-17 08:00:00	QQQ	ETF	26.03	26.03	25.86	25.9	194300.0
2003-01-17 09:00:00	QQQ	ETF	25.91	25.94	25.58	25.69	18956200.0
2003-01-17 10:00:00	QQQ	ETF	25.69	25.82	25.6	25.62	13569300.0
2003-01-17 11:00:00	QQQ	ETF	25.64	25.65	25.45	25.49	10202400.0
2003-01-17 12:00:00	QQQ	ETF	25.5	25.61	25.49	25.58	3383900.0
2003-01-17 13:00:00	QQQ	ETF	25.57	25.59	25.38	25.42	5101600.0
2003-01-17 14:00:00	QQQ	ETF	25.41	25.54	25.32	25.51	6532900.0
2003-01-17 15:00:00	QQQ	ETF	25.52	25.53	25.29	25.32	10238600.0
2003-01-17 16:00:00	QQQ	ETF	25.35	25.45	25.27	25.31	3017600.0
2003-01-17 17:00:00	QQQ	ETF	25.3	25.35	25.28	25.28	156100.0
2003-01-17 18:00:00	QQQ	ETF	25.28	25.35	25.26	25.35	32800.0
2003-01-17 19:00:00	QQQ	ETF	25.36	25.39	25.34	25.39	5300.0
2003-01-17 09:00:00	IWM	ETF	39.03	39.12	38.82	38.89	263000.0
2003-01-17 10:00:00	IWM	ETF	38.895	39.0	38.655	38.66	383000.0
2003-01-17 11:00:00	IWM	ETF	38.66	38.7	38.45	38.57	385600.0
2003-01-17 12:00:00	IWM	ETF	38.55	38.66	38.55	38.63	113400.0
2003-01-17 13:00:00	IWM	ETF	38.625	38.675	38.52	38.58	81200.0
2003-01-17 14:00:00	IWM	ETF	38.575	38.69	38.54	38.675	295600.0
2003-01-17 15:00:00	IWM	ETF	38.685	38.72	38.575	38.575	374200.0
2003-01-17 16:00:00	IWM	ETF	38.525	38.98	38.495	38.63	18600.0
2003-01-17 08:00:00	DIA	ETF	86.52	86.52	86.37	86.37	5100.0
2003-01-17 09:00:00	DIA	ETF	86.43	86.56	86.13	86.43	1705200.0
2003-01-17 10:00:00	DIA	ETF	86.4	86.75	86.15	86.21	1111500.0
2003-01-17 11:00:00	DIA	ETF	86.21	86.25	85.81	85.92	826100.0
2003-01-17 12:00:00	DIA	ETF	85.93	86.11	85.93	86.02	483100.0
2003-01-17 13:00:00	DIA	ETF	86.01	86.03	85.7	85.77	285600.0
2003-01-17 14:00:00	DIA	ETF	85.77	86.0	85.67	86.0	596200.0
2003-01-17 15:00:00	DIA	ETF	86.0	86.09	85.71	85.96	775800.0
2003-01-17 16:00:00	DIA	ETF	85.96	86.15	85.92	86.1	248200.0
2003-01-17 17:00:00	DIA	ETF	86.1	86.11	86.1	86.11	1900.0
2003-01-17 19:00:00	DIA	ETF	86.1	86.1	86.1	86.1	200.0
2003-01-17 09:00:00	TLT	ETF	87.1	87.24	87.02	87.02	41200.0
2003-01-17 10:00:00	TLT	ETF	87.01	87.1	86.93	87.0	11700.0
2003-01-17 11:00:00	TLT	ETF	87.0	87.12	86.97	87.12	11600.0
2003-01-17 12:00:00	TLT	ETF	87.1	87.12	87.03	87.04	2700.0
2003-01-17 13:00:00	TLT	ETF	87.04	87.17	87.0	87.17	18900.0
2003-01-17 14:00:00	TLT	ETF	87.1	87.2	87.0	87.19	1700.0
2003-01-17 15:00:00	TLT	ETF	87.19	87.2	87.04	87.04	3600.0

> showing 50 of 375 rows — these rows as CSV

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