PREVIEW / etf_1hour / 2003-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-02-05.parquet
  size:    16 KB
  rows:    369

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-02-05 08:00:00	SPY	ETF	85.2	85.7	85.2	85.52	49200.0
2003-02-05 09:00:00	SPY	ETF	85.55	85.9	85.33	85.58	5312400.0
2003-02-05 10:00:00	SPY	ETF	85.58	85.9	84.89	85.77	8088900.0
2003-02-05 11:00:00	SPY	ETF	85.77	85.97	85.35	85.76	4244000.0
2003-02-05 12:00:00	SPY	ETF	85.72	86.54	85.64	86.33	6664300.0
2003-02-05 13:00:00	SPY	ETF	86.29	86.4	85.82	85.95	3361400.0
2003-02-05 14:00:00	SPY	ETF	85.94	85.99	84.7	84.8	8725600.0
2003-02-05 15:00:00	SPY	ETF	84.75	84.98	84.48	84.64	8255800.0
2003-02-05 16:00:00	SPY	ETF	84.64	84.92	84.62	84.76	3368500.0
2003-02-05 17:00:00	SPY	ETF	84.77	85.4	84.77	84.85	130800.0
2003-02-05 18:00:00	SPY	ETF	84.8	84.84	84.72	84.76	6500.0
2003-02-05 19:00:00	SPY	ETF	84.8	84.82	84.74	84.78	5700.0
2003-02-05 08:00:00	QQQ	ETF	24.2	24.36	24.2	24.31	82200.0
2003-02-05 09:00:00	QQQ	ETF	24.31	24.43	24.21	24.32	9765400.0
2003-02-05 10:00:00	QQQ	ETF	24.31	24.75	24.12	24.57	13896400.0
2003-02-05 11:00:00	QQQ	ETF	24.6	24.67	24.42	24.57	6667000.0
2003-02-05 12:00:00	QQQ	ETF	24.58	24.86	24.47	24.74	9120000.0
2003-02-05 13:00:00	QQQ	ETF	24.74	24.78	24.57	24.6	4129800.0
2003-02-05 14:00:00	QQQ	ETF	24.62	24.64	24.04	24.14	17349300.0
2003-02-05 15:00:00	QQQ	ETF	24.14	24.23	24.01	24.09	10648000.0
2003-02-05 16:00:00	QQQ	ETF	24.09	24.7	24.05	24.11	1548600.0
2003-02-05 17:00:00	QQQ	ETF	24.11	24.12	24.06	24.11	308000.0
2003-02-05 18:00:00	QQQ	ETF	24.09	24.09	24.06	24.07	36400.0
2003-02-05 19:00:00	QQQ	ETF	24.08	24.11	24.04	24.05	24600.0
2003-02-05 08:00:00	IWM	ETF	36.755	36.755	36.755	36.755	1000.0
2003-02-05 09:00:00	IWM	ETF	36.96	36.96	36.725	36.745	571400.0
2003-02-05 10:00:00	IWM	ETF	36.8	36.93	36.565	36.885	800200.0
2003-02-05 11:00:00	IWM	ETF	36.915	36.95	36.745	36.81	201600.0
2003-02-05 12:00:00	IWM	ETF	36.86	37.0	36.785	36.94	228800.0
2003-02-05 13:00:00	IWM	ETF	36.925	36.965	36.75	36.78	303400.0
2003-02-05 14:00:00	IWM	ETF	36.78	36.78	36.405	36.42	399200.0
2003-02-05 15:00:00	IWM	ETF	36.365	36.505	36.345	36.455	700800.0
2003-02-05 16:00:00	IWM	ETF	36.445	36.6	36.445	36.595	13000.0
2003-02-05 17:00:00	IWM	ETF	36.57	36.57	36.57	36.57	600.0
2003-02-05 08:00:00	DIA	ETF	80.29	80.67	80.29	80.6	13600.0
2003-02-05 09:00:00	DIA	ETF	80.6	81.0	80.54	80.79	907400.0
2003-02-05 10:00:00	DIA	ETF	80.78	81.09	80.15	80.97	1872900.0
2003-02-05 11:00:00	DIA	ETF	80.9	81.1	80.55	80.96	877900.0
2003-02-05 12:00:00	DIA	ETF	80.97	81.69	80.77	81.47	1093700.0
2003-02-05 13:00:00	DIA	ETF	81.45	81.6	81.05	81.16	699300.0
2003-02-05 14:00:00	DIA	ETF	81.16	81.2	80.02	80.11	1591400.0
2003-02-05 15:00:00	DIA	ETF	80.1	80.26	79.6	79.97	1484900.0
2003-02-05 16:00:00	DIA	ETF	79.98	80.17	79.98	80.08	106800.0
2003-02-05 17:00:00	DIA	ETF	80.07	80.14	80.01	80.14	2500.0
2003-02-05 18:00:00	DIA	ETF	80.03	80.06	79.9	79.9	1000.0
2003-02-05 19:00:00	DIA	ETF	79.99	79.99	79.99	79.99	200.0
2003-02-05 09:00:00	TLT	ETF	88.23	88.25	88.08	88.25	1500.0
2003-02-05 10:00:00	TLT	ETF	88.23	88.47	88.05	88.11	55900.0
2003-02-05 11:00:00	TLT	ETF	88.15	88.45	88.1	88.27	23000.0
2003-02-05 12:00:00	TLT	ETF	88.05	88.65	87.47	87.55	48600.0

> showing 50 of 369 rows — these rows as CSV

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