PREVIEW / etf_1hour / 2002-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-24.parquet
  size:    16 KB
  rows:    382

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-24 08:00:00	SPY	ETF	89.95	90.53	89.9	90.5	49000.0
2002-10-24 09:00:00	SPY	ETF	90.6	90.9	89.94	90.55	6403800.0
2002-10-24 10:00:00	SPY	ETF	90.55	90.69	89.67	90.26	8702000.0
2002-10-24 11:00:00	SPY	ETF	90.25	90.62	89.85	90.15	4442100.0
2002-10-24 12:00:00	SPY	ETF	90.11	90.4	89.88	90.21	3664600.0
2002-10-24 13:00:00	SPY	ETF	90.29	90.29	89.55	89.75	5500800.0
2002-10-24 14:00:00	SPY	ETF	89.77	89.82	88.56	88.77	6319800.0
2002-10-24 15:00:00	SPY	ETF	88.77	88.94	88.1	88.6	10185000.0
2002-10-24 16:00:00	SPY	ETF	88.58	88.72	88.19	88.35	2543800.0
2002-10-24 17:00:00	SPY	ETF	90.49	90.49	88.27	88.29	49400.0
2002-10-24 18:00:00	SPY	ETF	88.32	88.38	88.28	88.28	4100.0
2002-10-24 19:00:00	SPY	ETF	88.28	88.28	88.09	88.09	2000.0
2002-10-24 08:00:00	QQQ	ETF	24.5	24.69	24.47	24.69	40300.0
2002-10-24 09:00:00	QQQ	ETF	24.71	24.8	24.44	24.71	12061300.0
2002-10-24 10:00:00	QQQ	ETF	24.74	24.75	24.33	24.65	15531900.0
2002-10-24 11:00:00	QQQ	ETF	24.65	24.86	24.49	24.62	13336800.0
2002-10-24 12:00:00	QQQ	ETF	24.61	24.7	24.49	24.65	7528800.0
2002-10-24 13:00:00	QQQ	ETF	24.65	24.72	24.33	24.43	8615200.0
2002-10-24 14:00:00	QQQ	ETF	24.43	24.48	24.1	24.16	13779300.0
2002-10-24 15:00:00	QQQ	ETF	24.17	24.27	23.92	24.0	12952900.0
2002-10-24 16:00:00	QQQ	ETF	24.0	24.09	23.94	24.02	2729800.0
2002-10-24 17:00:00	QQQ	ETF	24.03	24.06	23.98	23.99	96900.0
2002-10-24 18:00:00	QQQ	ETF	23.98	24.07	23.98	24.01	39400.0
2002-10-24 19:00:00	QQQ	ETF	24.01	24.01	23.96	23.96	4800.0
2002-10-24 09:00:00	IWM	ETF	36.95	36.95	36.73	36.935	979000.0
2002-10-24 10:00:00	IWM	ETF	36.975	37.05	36.775	36.975	1047800.0
2002-10-24 11:00:00	IWM	ETF	36.975	37.07	36.875	36.95	371400.0
2002-10-24 12:00:00	IWM	ETF	36.95	37.005	36.895	36.985	314000.0
2002-10-24 13:00:00	IWM	ETF	36.97	37.005	36.825	36.875	442000.0
2002-10-24 14:00:00	IWM	ETF	36.88	36.89	36.42	36.505	612000.0
2002-10-24 15:00:00	IWM	ETF	36.46	36.605	36.385	36.465	814600.0
2002-10-24 16:00:00	IWM	ETF	36.49	36.565	36.425	36.49	1002000.0
2002-10-24 08:00:00	DIA	ETF	84.95	85.59	84.95	85.59	6100.0
2002-10-24 09:00:00	DIA	ETF	85.58	85.89	84.86	85.45	2461200.0
2002-10-24 10:00:00	DIA	ETF	85.38	85.49	84.47	85.0	2432900.0
2002-10-24 11:00:00	DIA	ETF	84.97	85.35	84.64	84.9	1208300.0
2002-10-24 12:00:00	DIA	ETF	84.87	85.1	84.65	84.93	594100.0
2002-10-24 13:00:00	DIA	ETF	84.96	85.04	84.2	84.48	978200.0
2002-10-24 14:00:00	DIA	ETF	84.48	84.5	83.3	83.47	1514400.0
2002-10-24 15:00:00	DIA	ETF	83.49	83.7	82.78	83.15	2421100.0
2002-10-24 16:00:00	DIA	ETF	83.12	83.25	82.75	82.95	499700.0
2002-10-24 17:00:00	DIA	ETF	82.91	83.01	82.87	82.9	1600.0
2002-10-24 18:00:00	DIA	ETF	82.9	82.9	82.9	82.9	100.0
2002-10-24 19:00:00	DIA	ETF	82.67	82.67	82.67	82.67	100.0
2002-10-24 09:00:00	TLT	ETF	84.16	84.25	84.08	84.13	7900.0
2002-10-24 10:00:00	TLT	ETF	84.1	84.26	84.1	84.22	15700.0
2002-10-24 11:00:00	TLT	ETF	84.24	84.45	84.24	84.45	85500.0
2002-10-24 12:00:00	TLT	ETF	84.51	84.67	84.45	84.51	9800.0
2002-10-24 13:00:00	TLT	ETF	84.56	84.61	84.41	84.61	8700.0
2002-10-24 14:00:00	TLT	ETF	84.77	85.06	84.73	85.04	9400.0

> showing 50 of 382 rows — these rows as CSV

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