PREVIEW / etf_1hour / 2003-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-15.parquet
  size:    16 KB
  rows:    379

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-15 08:00:00	SPY	ETF	93.3	93.45	93.19	93.45	37700.0
2003-01-15 09:00:00	SPY	ETF	93.43	93.57	92.61	92.67	3815600.0
2003-01-15 10:00:00	SPY	ETF	92.66	92.7	92.14	92.19	5693300.0
2003-01-15 11:00:00	SPY	ETF	92.17	92.33	92.01	92.18	2781000.0
2003-01-15 12:00:00	SPY	ETF	92.18	92.2	91.91	92.08	3442300.0
2003-01-15 13:00:00	SPY	ETF	92.07	92.24	91.96	92.11	2790800.0
2003-01-15 14:00:00	SPY	ETF	92.08	92.4	91.95	92.3	4863800.0
2003-01-15 15:00:00	SPY	ETF	92.29	92.52	92.05	92.13	3156800.0
2003-01-15 16:00:00	SPY	ETF	92.13	92.48	92.11	92.26	890300.0
2003-01-15 17:00:00	SPY	ETF	92.32	92.35	92.26	92.31	40900.0
2003-01-15 18:00:00	SPY	ETF	92.27	92.31	92.23	92.3	1100.0
2003-01-15 19:00:00	SPY	ETF	92.25	92.28	92.24	92.24	900.0
2003-01-15 08:00:00	QQQ	ETF	27.11	27.27	27.11	27.21	79500.0
2003-01-15 09:00:00	QQQ	ETF	27.21	27.35	26.86	26.89	10833300.0
2003-01-15 10:00:00	QQQ	ETF	26.93	26.98	26.76	26.78	9620300.0
2003-01-15 11:00:00	QQQ	ETF	26.78	26.82	26.67	26.71	5961400.0
2003-01-15 12:00:00	QQQ	ETF	26.71	26.74	26.58	26.64	5615600.0
2003-01-15 13:00:00	QQQ	ETF	26.64	26.72	26.58	26.66	3767700.0
2003-01-15 14:00:00	QQQ	ETF	26.67	26.79	26.61	26.76	4868700.0
2003-01-15 15:00:00	QQQ	ETF	26.77	26.88	26.67	26.73	8916000.0
2003-01-15 16:00:00	QQQ	ETF	26.7	26.85	26.52	26.68	2374000.0
2003-01-15 17:00:00	QQQ	ETF	26.67	26.72	26.62	26.65	497100.0
2003-01-15 18:00:00	QQQ	ETF	26.65	26.66	26.62	26.62	57000.0
2003-01-15 19:00:00	QQQ	ETF	26.63	26.63	26.61	26.63	7300.0
2003-01-15 08:00:00	IWM	ETF	39.615	39.615	39.615	39.615	2000.0
2003-01-15 09:00:00	IWM	ETF	39.585	39.7	39.245	39.315	212800.0
2003-01-15 10:00:00	IWM	ETF	39.26	39.325	39.1	39.19	461600.0
2003-01-15 11:00:00	IWM	ETF	39.2	39.26	39.145	39.185	257000.0
2003-01-15 12:00:00	IWM	ETF	39.175	39.2	39.075	39.2	165400.0
2003-01-15 13:00:00	IWM	ETF	39.2	39.3	39.18	39.2	227800.0
2003-01-15 14:00:00	IWM	ETF	39.245	39.375	39.16	39.335	345000.0
2003-01-15 15:00:00	IWM	ETF	39.37	39.435	39.225	39.32	619600.0
2003-01-15 16:00:00	IWM	ETF	39.35	39.73	39.3	39.425	40200.0
2003-01-15 08:00:00	DIA	ETF	88.47	88.55	88.47	88.5	4200.0
2003-01-15 09:00:00	DIA	ETF	88.52	88.7	87.81	87.86	774600.0
2003-01-15 10:00:00	DIA	ETF	87.9	87.9	87.25	87.31	1438400.0
2003-01-15 11:00:00	DIA	ETF	87.31	87.53	87.22	87.37	418200.0
2003-01-15 12:00:00	DIA	ETF	87.38	87.41	87.15	87.24	453500.0
2003-01-15 13:00:00	DIA	ETF	87.24	87.45	87.17	87.39	360700.0
2003-01-15 14:00:00	DIA	ETF	87.39	87.54	87.23	87.47	761900.0
2003-01-15 15:00:00	DIA	ETF	87.44	87.65	87.27	87.35	734300.0
2003-01-15 16:00:00	DIA	ETF	87.32	87.68	87.32	87.59	110200.0
2003-01-15 17:00:00	DIA	ETF	87.58	87.58	87.53	87.53	4000.0
2003-01-15 18:00:00	DIA	ETF	87.48	87.51	87.45	87.48	2100.0
2003-01-15 09:00:00	TLT	ETF	86.28	86.28	86.28	86.28	100.0
2003-01-15 10:00:00	TLT	ETF	86.2	86.43	86.2	86.4	40000.0
2003-01-15 11:00:00	TLT	ETF	86.32	86.4	86.3	86.38	27200.0
2003-01-15 12:00:00	TLT	ETF	86.32	86.7	86.32	86.68	15900.0
2003-01-15 13:00:00	TLT	ETF	86.63	86.7	86.53	86.53	2400.0
2003-01-15 14:00:00	TLT	ETF	86.62	86.65	86.47	86.54	27200.0

> showing 50 of 379 rows — these rows as CSV

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