PREVIEW / etf_1hour / 2002-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-06-20.parquet
  size:    13 KB
  rows:    292

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-06-20 09:00:00	SPY	ETF	102.26	102.87	102.25	102.79	2558600.0
2002-06-20 10:00:00	SPY	ETF	102.76	103.05	101.71	101.96	4062300.0
2002-06-20 11:00:00	SPY	ETF	101.97	102.24	101.66	101.8	1755100.0
2002-06-20 12:00:00	SPY	ETF	101.81	102.58	101.52	102.0	4661700.0
2002-06-20 13:00:00	SPY	ETF	102.03	102.25	101.77	101.95	1328300.0
2002-06-20 14:00:00	SPY	ETF	101.93	102.37	101.76	102.04	2727700.0
2002-06-20 15:00:00	SPY	ETF	102.01	102.08	100.96	101.2	5437300.0
2002-06-20 16:00:00	SPY	ETF	101.19	101.31	101.12	101.29	2083600.0
2002-06-20 17:00:00	SPY	ETF	101.24	101.3	101.24	101.27	22600.0
2002-06-20 18:00:00	SPY	ETF	101.35	101.35	101.1	101.1	70400.0
2002-06-20 09:00:00	QQQ	ETF	27.27	27.45	27.16	27.25	11644800.0
2002-06-20 10:00:00	QQQ	ETF	27.23	27.39	26.67	26.87	19489800.0
2002-06-20 11:00:00	QQQ	ETF	26.87	26.98	26.75	26.81	10216100.0
2002-06-20 12:00:00	QQQ	ETF	26.81	27.06	26.68	26.82	16462800.0
2002-06-20 13:00:00	QQQ	ETF	26.8	26.95	26.67	26.72	6965800.0
2002-06-20 14:00:00	QQQ	ETF	26.72	26.9	26.6	26.8	9276700.0
2002-06-20 15:00:00	QQQ	ETF	26.8	26.84	26.3	26.46	18435000.0
2002-06-20 16:00:00	QQQ	ETF	26.46	26.54	26.39	26.42	2280600.0
2002-06-20 17:00:00	QQQ	ETF	26.4	26.55	26.4	26.5	135200.0
2002-06-20 18:00:00	QQQ	ETF	26.51	26.52	26.5	26.5	9900.0
2002-06-20 09:00:00	IWM	ETF	46.12	46.3	46.035	46.205	89200.0
2002-06-20 10:00:00	IWM	ETF	46.165	46.3	45.785	45.86	149400.0
2002-06-20 11:00:00	IWM	ETF	45.895	46.095	45.895	45.97	122400.0
2002-06-20 12:00:00	IWM	ETF	46.035	46.51	46.0	46.225	274000.0
2002-06-20 13:00:00	IWM	ETF	46.225	46.41	46.225	46.38	264800.0
2002-06-20 14:00:00	IWM	ETF	46.37	46.4	46.305	46.315	69400.0
2002-06-20 15:00:00	IWM	ETF	46.265	46.265	45.66	45.805	944600.0
2002-06-20 16:00:00	IWM	ETF	45.85	45.9	45.565	45.9	59400.0
2002-06-20 17:00:00	IWM	ETF	45.95	45.95	45.95	45.95	1000.0
2002-06-20 09:00:00	DIA	ETF	95.64	95.95	95.45	95.8	352100.0
2002-06-20 10:00:00	DIA	ETF	95.95	96.12	94.96	95.2	1218900.0
2002-06-20 11:00:00	DIA	ETF	95.21	95.58	95.1	95.22	448500.0
2002-06-20 12:00:00	DIA	ETF	95.28	96.0	95.01	95.45	1024600.0
2002-06-20 13:00:00	DIA	ETF	95.44	95.68	95.25	95.44	231000.0
2002-06-20 14:00:00	DIA	ETF	95.43	95.76	95.27	95.5	494500.0
2002-06-20 15:00:00	DIA	ETF	95.48	95.54	94.42	94.53	1346200.0
2002-06-20 16:00:00	DIA	ETF	94.55	94.69	94.45	94.56	281900.0

> showing 37 of 292 rows — these rows as CSV

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