PREVIEW / etf_1hour / 2002-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-04.parquet
  size:    16 KB
  rows:    368

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-04 08:00:00	SPY	ETF	82.29	83.16	82.29	82.96	7200.0
2002-10-04 09:00:00	SPY	ETF	82.96	83.0	81.45	81.7	7454800.0
2002-10-04 10:00:00	SPY	ETF	81.75	81.94	80.82	80.9	9125800.0
2002-10-04 11:00:00	SPY	ETF	80.9	81.2	80.35	80.9	6263100.0
2002-10-04 12:00:00	SPY	ETF	80.92	81.19	80.52	80.59	3551200.0
2002-10-04 13:00:00	SPY	ETF	80.52	80.64	79.58	80.15	10800600.0
2002-10-04 14:00:00	SPY	ETF	80.14	81.14	79.72	81.1	10867400.0
2002-10-04 15:00:00	SPY	ETF	81.12	81.55	79.95	80.38	13999600.0
2002-10-04 16:00:00	SPY	ETF	80.35	81.04	80.31	80.81	4020800.0
2002-10-04 17:00:00	SPY	ETF	80.87	80.92	80.7	80.7	10300.0
2002-10-04 18:00:00	SPY	ETF	80.1	81.65	79.67	80.76	235900.0
2002-10-04 19:00:00	SPY	ETF	80.85	80.91	80.75	80.75	800.0
2002-10-04 08:00:00	QQQ	ETF	20.78	21.09	20.78	21.05	72900.0
2002-10-04 09:00:00	QQQ	ETF	21.0	21.04	20.55	20.61	11144800.0
2002-10-04 10:00:00	QQQ	ETF	20.62	20.77	20.4	20.57	14466200.0
2002-10-04 11:00:00	QQQ	ETF	20.58	20.66	20.34	20.5	9995000.0
2002-10-04 12:00:00	QQQ	ETF	20.5	20.6	20.35	20.36	5479400.0
2002-10-04 13:00:00	QQQ	ETF	20.37	20.4	20.11	20.28	9952000.0
2002-10-04 14:00:00	QQQ	ETF	20.27	20.55	20.2	20.52	10072700.0
2002-10-04 15:00:00	QQQ	ETF	20.52	20.72	20.24	20.28	16123100.0
2002-10-04 16:00:00	QQQ	ETF	20.28	20.6	20.2	20.32	3295600.0
2002-10-04 17:00:00	QQQ	ETF	20.31	20.41	20.27	20.31	74700.0
2002-10-04 18:00:00	QQQ	ETF	20.32	20.35	20.3	20.34	42900.0
2002-10-04 09:00:00	IWM	ETF	35.875	35.875	35.175	35.3	499200.0
2002-10-04 10:00:00	IWM	ETF	35.3	35.325	35.02	35.02	202000.0
2002-10-04 11:00:00	IWM	ETF	35.04	35.08	34.795	34.975	979000.0
2002-10-04 12:00:00	IWM	ETF	34.975	35.075	34.81	34.845	182800.0
2002-10-04 13:00:00	IWM	ETF	34.82	34.82	34.425	34.625	472600.0
2002-10-04 14:00:00	IWM	ETF	34.565	34.8	34.47	34.79	461400.0
2002-10-04 15:00:00	IWM	ETF	34.8	34.94	34.585	34.625	734000.0
2002-10-04 16:00:00	IWM	ETF	34.55	34.885	34.55	34.885	31200.0
2002-10-04 17:00:00	IWM	ETF	34.685	34.685	34.685	34.685	432400.0
2002-10-04 08:00:00	DIA	ETF	77.54	78.28	77.54	78.0	8600.0
2002-10-04 09:00:00	DIA	ETF	77.93	78.05	76.75	76.95	1510200.0
2002-10-04 10:00:00	DIA	ETF	76.96	77.19	76.08	76.18	2304500.0
2002-10-04 11:00:00	DIA	ETF	76.16	76.4	75.65	76.13	2127900.0
2002-10-04 12:00:00	DIA	ETF	76.14	76.52	75.8	75.83	1068900.0
2002-10-04 13:00:00	DIA	ETF	75.84	75.92	74.83	75.33	2685400.0
2002-10-04 14:00:00	DIA	ETF	75.35	76.29	74.81	76.28	3579800.0
2002-10-04 15:00:00	DIA	ETF	76.24	76.57	75.05	75.49	2719300.0
2002-10-04 16:00:00	DIA	ETF	75.48	76.66	75.3	75.95	421800.0
2002-10-04 17:00:00	DIA	ETF	75.99	76.0	75.89	75.92	2600.0
2002-10-04 18:00:00	DIA	ETF	75.92	75.92	75.92	75.92	600.0
2002-10-04 19:00:00	DIA	ETF	75.92	75.92	75.92	75.92	200.0
2002-10-04 09:00:00	TLT	ETF	88.4	88.77	88.4	88.75	10000.0
2002-10-04 10:00:00	TLT	ETF	88.72	88.88	88.64	88.87	17800.0
2002-10-04 11:00:00	TLT	ETF	88.9	89.0	88.86	88.87	14600.0
2002-10-04 12:00:00	TLT	ETF	88.93	88.97	88.81	88.84	6300.0
2002-10-04 13:00:00	TLT	ETF	88.94	89.62	88.94	89.62	22900.0
2002-10-04 14:00:00	TLT	ETF	89.48	89.72	89.24	89.44	51600.0

> showing 50 of 368 rows — these rows as CSV

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