PREVIEW / etf_1hour / 2002-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-31.parquet
  size:    16 KB
  rows:    380

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-31 08:00:00	SPY	ETF	89.3	89.7	88.91	89.7	8500.0
2002-10-31 09:00:00	SPY	ETF	89.78	90.1	89.2	89.22	3926800.0
2002-10-31 10:00:00	SPY	ETF	89.22	90.3	89.06	89.22	9013900.0
2002-10-31 11:00:00	SPY	ETF	89.2	89.73	88.92	89.7	4332300.0
2002-10-31 12:00:00	SPY	ETF	89.73	89.84	89.01	89.22	2505600.0
2002-10-31 13:00:00	SPY	ETF	89.21	89.65	88.98	89.5	1867900.0
2002-10-31 14:00:00	SPY	ETF	89.5	89.65	89.11	89.14	1804900.0
2002-10-31 15:00:00	SPY	ETF	89.13	89.24	88.19	88.86	9423600.0
2002-10-31 16:00:00	SPY	ETF	88.83	88.93	88.48	88.48	3334000.0
2002-10-31 17:00:00	SPY	ETF	88.5	88.6	88.5	88.6	7400.0
2002-10-31 18:00:00	SPY	ETF	88.55	88.58	88.5	88.5	2100.0
2002-10-31 08:00:00	QQQ	ETF	24.56	24.78	24.37	24.74	52600.0
2002-10-31 09:00:00	QQQ	ETF	24.71	24.84	24.56	24.62	10096900.0
2002-10-31 10:00:00	QQQ	ETF	24.7	25.04	24.42	24.5	23294900.0
2002-10-31 11:00:00	QQQ	ETF	24.49	24.66	24.37	24.65	8857100.0
2002-10-31 12:00:00	QQQ	ETF	24.64	24.69	24.45	24.51	4858100.0
2002-10-31 13:00:00	QQQ	ETF	24.52	24.77	24.46	24.75	4647600.0
2002-10-31 14:00:00	QQQ	ETF	24.75	24.85	24.6	24.72	7325400.0
2002-10-31 15:00:00	QQQ	ETF	24.73	24.77	24.42	24.58	13236700.0
2002-10-31 16:00:00	QQQ	ETF	24.58	24.67	24.48	24.5	2731700.0
2002-10-31 17:00:00	QQQ	ETF	24.5	24.53	24.45	24.53	198100.0
2002-10-31 18:00:00	QQQ	ETF	24.53	24.54	24.46	24.51	25700.0
2002-10-31 19:00:00	QQQ	ETF	24.51	24.53	24.51	24.53	4000.0
2002-10-31 09:00:00	IWM	ETF	37.525	37.65	37.38	37.38	267800.0
2002-10-31 10:00:00	IWM	ETF	37.41	37.685	37.315	37.315	801600.0
2002-10-31 11:00:00	IWM	ETF	37.315	37.45	37.2	37.395	686600.0
2002-10-31 12:00:00	IWM	ETF	37.395	37.45	37.265	37.295	86400.0
2002-10-31 13:00:00	IWM	ETF	37.295	37.395	37.255	37.35	203200.0
2002-10-31 14:00:00	IWM	ETF	37.4	37.475	37.325	37.355	312000.0
2002-10-31 15:00:00	IWM	ETF	37.345	37.57	37.165	37.325	835200.0
2002-10-31 16:00:00	IWM	ETF	37.25	37.325	36.835	37.2	304000.0
2002-10-31 17:00:00	IWM	ETF	37.24	37.24	37.24	37.24	1611000.0
2002-10-31 08:00:00	DIA	ETF	84.49	84.6	84.0	84.6	20400.0
2002-10-31 09:00:00	DIA	ETF	84.7	84.89	84.1	84.26	993600.0
2002-10-31 10:00:00	DIA	ETF	84.26	85.15	83.92	84.02	2675400.0
2002-10-31 11:00:00	DIA	ETF	84.0	84.55	83.8	84.55	1149100.0
2002-10-31 12:00:00	DIA	ETF	84.6	84.61	83.91	84.22	443900.0
2002-10-31 13:00:00	DIA	ETF	84.22	84.6	84.01	84.5	520800.0
2002-10-31 14:00:00	DIA	ETF	84.51	84.74	84.22	84.3	944300.0
2002-10-31 15:00:00	DIA	ETF	84.26	84.4	83.43	84.03	2352600.0
2002-10-31 16:00:00	DIA	ETF	83.98	84.03	83.65	83.65	171100.0
2002-10-31 17:00:00	DIA	ETF	83.65	83.7	83.65	83.66	1100.0
2002-10-31 18:00:00	DIA	ETF	83.66	83.66	83.55	83.65	2600.0
2002-10-31 19:00:00	DIA	ETF	83.55	83.9	83.55	83.79	3400.0
2002-10-31 09:00:00	TLT	ETF	86.05	86.2	86.02	86.2	900.0
2002-10-31 10:00:00	TLT	ETF	86.25	86.33	86.08	86.3	2400.0
2002-10-31 11:00:00	TLT	ETF	86.4	86.4	86.35	86.35	900.0
2002-10-31 12:00:00	TLT	ETF	86.5	86.86	86.48	86.86	203800.0
2002-10-31 13:00:00	TLT	ETF	86.75	86.75	86.63	86.69	5700.0
2002-10-31 14:00:00	TLT	ETF	86.58	86.68	86.58	86.68	1000.0

> showing 50 of 380 rows — these rows as CSV

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