PREVIEW / etf_1hour / 2002-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-11-19.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-11-19 08:00:00	SPY	ETF	90.3	90.43	90.07	90.2	10500.0
2002-11-19 09:00:00	SPY	ETF	90.15	90.3	89.8	89.85	3385000.0
2002-11-19 10:00:00	SPY	ETF	89.85	90.45	89.76	90.08	5877900.0
2002-11-19 11:00:00	SPY	ETF	90.08	90.26	89.87	90.0	1863200.0
2002-11-19 12:00:00	SPY	ETF	90.0	90.85	90.0	90.75	3837300.0
2002-11-19 13:00:00	SPY	ETF	90.75	91.1	90.6	90.92	3247100.0
2002-11-19 14:00:00	SPY	ETF	90.92	90.97	90.17	90.17	4627800.0
2002-11-19 15:00:00	SPY	ETF	90.16	90.42	89.77	90.23	6073200.0
2002-11-19 16:00:00	SPY	ETF	90.25	90.45	90.15	90.3	2049400.0
2002-11-19 17:00:00	SPY	ETF	90.31	90.33	90.28	90.28	13300.0
2002-11-19 18:00:00	SPY	ETF	90.3	90.3	90.18	90.25	8200.0
2002-11-19 08:00:00	QQQ	ETF	25.97	25.97	25.85	25.85	19700.0
2002-11-19 09:00:00	QQQ	ETF	25.86	25.89	25.51	25.51	13761700.0
2002-11-19 10:00:00	QQQ	ETF	25.52	25.78	25.42	25.61	15749900.0
2002-11-19 11:00:00	QQQ	ETF	25.61	25.69	25.48	25.57	7916800.0
2002-11-19 12:00:00	QQQ	ETF	25.51	25.9	25.5	25.83	7424500.0
2002-11-19 13:00:00	QQQ	ETF	25.83	26.05	25.75	25.87	11045400.0
2002-11-19 14:00:00	QQQ	ETF	25.87	25.89	25.51	25.54	9475900.0
2002-11-19 15:00:00	QQQ	ETF	25.54	25.6	25.3	25.5	14181300.0
2002-11-19 16:00:00	QQQ	ETF	25.51	25.68	25.49	25.61	2467600.0
2002-11-19 17:00:00	QQQ	ETF	25.62	25.63	25.58	25.59	95800.0
2002-11-19 18:00:00	QQQ	ETF	25.61	25.61	25.55	25.59	60500.0
2002-11-19 19:00:00	QQQ	ETF	25.58	25.58	25.57	25.57	3900.0
2002-11-19 09:00:00	IWM	ETF	38.015	38.295	38.0	38.03	176000.0
2002-11-19 10:00:00	IWM	ETF	38.025	38.22	38.0	38.06	201200.0
2002-11-19 11:00:00	IWM	ETF	38.05	38.05	37.9	37.915	105000.0
2002-11-19 12:00:00	IWM	ETF	37.955	38.25	37.95	38.245	395800.0
2002-11-19 13:00:00	IWM	ETF	38.25	38.3	38.11	38.2	585000.0
2002-11-19 14:00:00	IWM	ETF	38.235	38.235	37.975	37.99	292400.0
2002-11-19 15:00:00	IWM	ETF	37.955	38.005	37.775	37.87	312400.0
2002-11-19 16:00:00	IWM	ETF	37.85	37.97	37.82	37.97	63000.0
2002-11-19 17:00:00	IWM	ETF	37.875	37.875	37.875	37.875	52600.0
2002-11-19 08:00:00	DIA	ETF	84.8	85.5	84.71	84.84	2800.0
2002-11-19 09:00:00	DIA	ETF	84.72	84.72	84.16	84.2	547400.0
2002-11-19 10:00:00	DIA	ETF	84.2	84.88	84.15	84.5	1246600.0
2002-11-19 11:00:00	DIA	ETF	84.54	84.77	84.32	84.57	312600.0
2002-11-19 12:00:00	DIA	ETF	84.55	85.41	84.55	85.33	614700.0
2002-11-19 13:00:00	DIA	ETF	85.35	85.59	85.21	85.46	658000.0
2002-11-19 14:00:00	DIA	ETF	85.46	85.54	84.84	84.85	950300.0
2002-11-19 15:00:00	DIA	ETF	84.92	85.08	84.53	84.93	1282100.0
2002-11-19 16:00:00	DIA	ETF	84.93	85.07	84.86	85.0	77000.0
2002-11-19 17:00:00	DIA	ETF	84.9	85.14	84.9	85.06	1400.0
2002-11-19 18:00:00	DIA	ETF	85.1	85.1	85.06	85.06	400.0
2002-11-19 09:00:00	TLT	ETF	87.95	88.15	87.95	88.15	5600.0
2002-11-19 10:00:00	TLT	ETF	88.23	88.23	88.03	88.15	6200.0
2002-11-19 11:00:00	TLT	ETF	88.05	88.05	87.79	87.83	2000.0
2002-11-19 12:00:00	TLT	ETF	87.81	87.86	87.71	87.71	10000.0
2002-11-19 13:00:00	TLT	ETF	87.57	87.86	87.51	87.6	7700.0
2002-11-19 14:00:00	TLT	ETF	87.61	87.85	87.6	87.85	8300.0
2002-11-19 15:00:00	TLT	ETF	87.85	87.86	87.79	87.82	8200.0

> showing 50 of 382 rows — these rows as CSV

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