PREVIEW / etf_1hour / 2002-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-25.parquet
  size:    15 KB
  rows:    358

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
2002-10-25 08:00:00	SPY	ETF	88.56	88.82	87.96	88.33	34600.0
2002-10-25 09:00:00	SPY	ETF	88.18	88.8	87.94	88.7	5712400.0
2002-10-25 10:00:00	SPY	ETF	88.72	89.2	88.2	88.43	7280700.0
2002-10-25 11:00:00	SPY	ETF	88.38	89.1	88.23	89.1	4577000.0
2002-10-25 12:00:00	SPY	ETF	89.1	89.38	88.9	89.07	4761100.0
2002-10-25 13:00:00	SPY	ETF	89.1	89.27	88.66	88.86	3791300.0
2002-10-25 14:00:00	SPY	ETF	88.88	90.1	88.78	89.92	5187500.0
2002-10-25 15:00:00	SPY	ETF	89.91	90.16	89.6	90.03	5830600.0
2002-10-25 16:00:00	SPY	ETF	90.0	90.39	90.0	90.16	4759000.0
2002-10-25 17:00:00	SPY	ETF	90.25	90.34	90.2	90.33	16000.0
2002-10-25 18:00:00	SPY	ETF	90.3	90.34	90.3	90.3	1100.0
2002-10-25 08:00:00	QQQ	ETF	24.05	24.14	23.9	23.99	118100.0
2002-10-25 09:00:00	QQQ	ETF	23.97	24.35	23.95	24.29	11374900.0
2002-10-25 10:00:00	QQQ	ETF	24.29	24.49	24.04	24.14	12017200.0
2002-10-25 11:00:00	QQQ	ETF	24.14	24.45	24.12	24.4	6534700.0
2002-10-25 12:00:00	QQQ	ETF	24.4	24.52	24.37	24.45	7347000.0
2002-10-25 13:00:00	QQQ	ETF	24.44	24.48	24.22	24.28	7099000.0
2002-10-25 14:00:00	QQQ	ETF	24.29	24.7	24.27	24.62	10545900.0
2002-10-25 15:00:00	QQQ	ETF	24.61	24.75	24.47	24.74	11339800.0
2002-10-25 16:00:00	QQQ	ETF	24.71	24.75	24.6	24.66	3474400.0
2002-10-25 17:00:00	QQQ	ETF	24.64	24.69	24.62	24.65	60700.0
2002-10-25 18:00:00	QQQ	ETF	24.65	24.68	24.65	24.66	41400.0
2002-10-25 19:00:00	QQQ	ETF	24.64	24.64	24.63	24.63	2300.0
2002-10-25 09:00:00	IWM	ETF	36.325	36.685	36.325	36.65	368800.0
2002-10-25 10:00:00	IWM	ETF	36.67	36.82	36.585	36.625	317800.0
2002-10-25 11:00:00	IWM	ETF	36.65	36.77	36.565	36.77	223200.0
2002-10-25 12:00:00	IWM	ETF	36.775	36.815	36.7	36.765	176400.0
2002-10-25 13:00:00	IWM	ETF	36.775	36.785	36.58	36.635	71000.0
2002-10-25 14:00:00	IWM	ETF	36.725	36.99	36.7	36.955	352200.0
2002-10-25 15:00:00	IWM	ETF	36.985	37.2	36.88	37.2	455400.0
2002-10-25 16:00:00	IWM	ETF	37.13	37.225	36.6	37.13	2385200.0
2002-10-25 08:00:00	DIA	ETF	83.27	83.4	82.6	82.9	5800.0
2002-10-25 09:00:00	DIA	ETF	82.93	83.43	82.6	83.31	2049500.0
2002-10-25 10:00:00	DIA	ETF	83.32	83.8	82.8	82.96	3743300.0
2002-10-25 11:00:00	DIA	ETF	82.97	83.59	82.84	83.59	1191300.0
2002-10-25 12:00:00	DIA	ETF	83.6	83.82	83.38	83.58	1060500.0
2002-10-25 13:00:00	DIA	ETF	83.52	83.64	83.09	83.28	687100.0
2002-10-25 14:00:00	DIA	ETF	83.31	84.5	83.26	84.3	1316400.0
2002-10-25 15:00:00	DIA	ETF	84.3	84.57	84.01	84.5	1589500.0
2002-10-25 16:00:00	DIA	ETF	84.49	84.69	84.45	84.53	119400.0
2002-10-25 17:00:00	DIA	ETF	84.58	84.65	84.58	84.63	10600.0
2002-10-25 18:00:00	DIA	ETF	84.65	84.65	84.63	84.63	600.0
2002-10-25 19:00:00	DIA	ETF	84.55	84.55	84.55	84.55	200.0
2002-10-25 09:00:00	TLT	ETF	85.35	85.56	85.2	85.2	7600.0
2002-10-25 10:00:00	TLT	ETF	85.15	85.42	85.15	85.39	105500.0
2002-10-25 11:00:00	TLT	ETF	85.38	85.38	85.3	85.3	2000.0
2002-10-25 12:00:00	TLT	ETF	85.24	85.38	85.24	85.27	3300.0
2002-10-25 13:00:00	TLT	ETF	85.27	85.43	85.27	85.4	2900.0
2002-10-25 14:00:00	TLT	ETF	85.2	85.38	85.15	85.38	4700.0
2002-10-25 15:00:00	TLT	ETF	85.36	85.54	85.33	85.5	10100.0

> showing 50 of 358 rows — these rows as CSV

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