PREVIEW / etf_1hour / 2003-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-10.parquet
  size:    18 KB
  rows:    464

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-10-10 08:00:00	SPY	ETF	104.46	104.7	104.31	104.31	233800.0
2003-10-10 09:00:00	SPY	ETF	104.31	104.42	104.14	104.2	3943800.0
2003-10-10 10:00:00	SPY	ETF	104.2	104.48	103.97	104.06	3874100.0
2003-10-10 11:00:00	SPY	ETF	104.04	104.23	103.91	104.18	2638500.0
2003-10-10 12:00:00	SPY	ETF	104.18	104.29	104.01	104.15	1781200.0
2003-10-10 13:00:00	SPY	ETF	104.15	104.38	104.13	104.23	1638700.0
2003-10-10 14:00:00	SPY	ETF	104.16	104.29	103.96	104.0	2214300.0
2003-10-10 15:00:00	SPY	ETF	103.98	104.22	103.93	104.2	2948000.0
2003-10-10 16:00:00	SPY	ETF	104.22	104.6	104.18	104.5	1369900.0
2003-10-10 17:00:00	SPY	ETF	104.54	104.58	104.52	104.54	8000.0
2003-10-10 18:00:00	SPY	ETF	104.5	104.54	104.5	104.54	1700.0
2003-10-10 19:00:00	SPY	ETF	104.51	104.51	104.51	104.51	200.0
2003-10-10 08:00:00	QQQ	ETF	34.81	34.93	34.77	34.79	381900.0
2003-10-10 09:00:00	QQQ	ETF	34.78	34.95	34.72	34.81	15432700.0
2003-10-10 10:00:00	QQQ	ETF	34.809	34.97	34.68	34.7	11626400.0
2003-10-10 11:00:00	QQQ	ETF	34.71	34.825	34.64	34.794	8522000.0
2003-10-10 12:00:00	QQQ	ETF	34.79	34.87	34.73	34.81	4002200.0
2003-10-10 13:00:00	QQQ	ETF	34.81	34.97	34.809	34.844	5925800.0
2003-10-10 14:00:00	QQQ	ETF	34.85	34.92	34.7	34.755	4255300.0
2003-10-10 15:00:00	QQQ	ETF	34.759	34.93	34.71	34.93	8818100.0
2003-10-10 16:00:00	QQQ	ETF	34.92	35.03	34.67	35.01	4337900.0
2003-10-10 17:00:00	QQQ	ETF	35.01	35.02	34.98	35.0	72600.0
2003-10-10 18:00:00	QQQ	ETF	35.01	35.03	34.99	35.02	6700.0
2003-10-10 19:00:00	QQQ	ETF	35.02	35.04	35.02	35.04	9300.0
2003-10-10 09:00:00	IWM	ETF	51.925	52.08	51.8	51.905	1620400.0
2003-10-10 10:00:00	IWM	ETF	51.905	52.0	51.415	51.415	1112000.0
2003-10-10 11:00:00	IWM	ETF	51.445	51.605	51.3	51.55	903600.0
2003-10-10 12:00:00	IWM	ETF	51.55	51.685	51.525	51.535	422400.0
2003-10-10 13:00:00	IWM	ETF	51.56	51.635	51.54	51.57	921400.0
2003-10-10 14:00:00	IWM	ETF	51.555	51.575	51.375	51.425	386400.0
2003-10-10 15:00:00	IWM	ETF	51.415	51.8	51.38	51.745	575200.0
2003-10-10 16:00:00	IWM	ETF	51.745	51.929	51.725	51.9	46000.0
2003-10-10 08:00:00	DIA	ETF	97.34	97.48	97.11	97.15	28900.0
2003-10-10 09:00:00	DIA	ETF	97.1	97.26	97.03	97.15	523600.0
2003-10-10 10:00:00	DIA	ETF	97.15	97.34	96.95	97.01	450600.0
2003-10-10 11:00:00	DIA	ETF	97.02	97.15	96.88	97.08	250000.0
2003-10-10 12:00:00	DIA	ETF	97.1	97.17	96.85	96.93	224600.0
2003-10-10 13:00:00	DIA	ETF	96.94	97.15	96.94	97.04	148800.0
2003-10-10 14:00:00	DIA	ETF	97.03	97.09	96.78	96.81	178900.0
2003-10-10 15:00:00	DIA	ETF	96.82	97.05	96.79	97.0	447700.0
2003-10-10 16:00:00	DIA	ETF	97.003	97.3	96.98	97.28	124200.0
2003-10-10 17:00:00	DIA	ETF	97.3	97.3	97.28	97.28	300.0
2003-10-10 09:00:00	TLT	ETF	84.5	84.6	84.3	84.36	99900.0
2003-10-10 10:00:00	TLT	ETF	84.33	84.64	84.33	84.63	24700.0
2003-10-10 11:00:00	TLT	ETF	84.55	84.73	84.5	84.59	62300.0
2003-10-10 12:00:00	TLT	ETF	84.53	84.55	84.52	84.52	6500.0
2003-10-10 13:00:00	TLT	ETF	84.52	84.52	84.39	84.47	3000.0
2003-10-10 14:00:00	TLT	ETF	84.49	84.49	84.43	84.47	8600.0
2003-10-10 15:00:00	TLT	ETF	84.44	84.59	84.43	84.57	38700.0
2003-10-10 16:00:00	TLT	ETF	84.55	84.59	84.55	84.57	6200.0

> showing 50 of 464 rows — these rows as CSV

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