PREVIEW / etf_1hour / 2002-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-05-09.parquet
  size:    14 KB
  rows:    304

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-05-09 09:00:00	SPY	ETF	108.65	109.02	108.41	108.98	2602500.0
2002-05-09 10:00:00	SPY	ETF	108.93	109.0	108.02	108.26	2815300.0
2002-05-09 11:00:00	SPY	ETF	108.29	108.48	108.07	108.44	768800.0
2002-05-09 12:00:00	SPY	ETF	108.43	108.55	107.62	108.5	5143700.0
2002-05-09 13:00:00	SPY	ETF	108.48	108.73	108.23	108.44	1309900.0
2002-05-09 14:00:00	SPY	ETF	108.46	108.51	108.01	108.04	750900.0
2002-05-09 15:00:00	SPY	ETF	108.03	108.19	107.58	107.65	2322900.0
2002-05-09 16:00:00	SPY	ETF	107.68	108.58	107.58	107.73	2317200.0
2002-05-09 17:00:00	SPY	ETF	107.73	107.85	107.65	107.85	2500.0
2002-05-09 18:00:00	SPY	ETF	107.75	107.85	107.75	107.85	300.0
2002-05-09 09:00:00	QQQ	ETF	31.57	31.89	31.51	31.84	16219100.0
2002-05-09 10:00:00	QQQ	ETF	31.84	31.88	31.09	31.24	20921400.0
2002-05-09 11:00:00	QQQ	ETF	31.24	31.32	31.05	31.16	9998400.0
2002-05-09 12:00:00	QQQ	ETF	31.15	31.35	30.8	31.28	17287300.0
2002-05-09 13:00:00	QQQ	ETF	31.28	31.5	31.15	31.28	9099000.0
2002-05-09 14:00:00	QQQ	ETF	31.3	31.36	31.05	31.08	10744200.0
2002-05-09 15:00:00	QQQ	ETF	31.08	31.26	30.87	30.89	14039600.0
2002-05-09 16:00:00	QQQ	ETF	30.9	30.99	30.77	30.94	4102800.0
2002-05-09 17:00:00	QQQ	ETF	30.95	30.97	30.9	30.95	42100.0
2002-05-09 18:00:00	QQQ	ETF	30.95	30.97	30.95	30.96	11200.0
2002-05-09 09:00:00	IWM	ETF	50.8	50.8	50.44	50.64	66200.0
2002-05-09 10:00:00	IWM	ETF	50.675	50.735	50.39	50.54	252000.0
2002-05-09 11:00:00	IWM	ETF	50.545	50.65	50.5	50.57	78000.0
2002-05-09 12:00:00	IWM	ETF	50.555	50.555	50.39	50.48	79200.0
2002-05-09 13:00:00	IWM	ETF	50.545	50.65	50.5	50.62	216400.0
2002-05-09 14:00:00	IWM	ETF	50.565	50.735	50.52	50.54	278600.0
2002-05-09 15:00:00	IWM	ETF	50.55	50.55	49.875	50.025	387200.0
2002-05-09 16:00:00	IWM	ETF	49.85	50.0	49.85	49.875	354800.0
2002-05-09 09:00:00	DIA	ETF	101.06	101.58	100.86	101.54	867800.0
2002-05-09 10:00:00	DIA	ETF	101.5	101.5	100.58	100.92	339900.0
2002-05-09 11:00:00	DIA	ETF	100.87	101.1	100.75	100.94	134900.0
2002-05-09 12:00:00	DIA	ETF	100.97	100.99	100.25	100.95	605600.0
2002-05-09 13:00:00	DIA	ETF	100.94	101.2	100.78	100.94	202500.0
2002-05-09 14:00:00	DIA	ETF	100.94	101.08	100.68	100.78	164100.0
2002-05-09 15:00:00	DIA	ETF	100.74	100.86	100.32	100.37	1036300.0
2002-05-09 16:00:00	DIA	ETF	100.4	100.55	100.37	100.55	139100.0

> showing 36 of 304 rows — these rows as CSV

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