PREVIEW / etf_1hour / 2002-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-04-25.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-04-25 09:00:00	SPY	ETF	109.21	109.31	108.76	108.95	2935500.0
2002-04-25 10:00:00	SPY	ETF	108.95	109.74	108.72	109.53	4301400.0
2002-04-25 11:00:00	SPY	ETF	109.55	109.66	109.0	109.42	6469600.0
2002-04-25 12:00:00	SPY	ETF	109.44	109.5	109.05	109.17	2415400.0
2002-04-25 13:00:00	SPY	ETF	109.17	109.68	109.17	109.45	1706100.0
2002-04-25 14:00:00	SPY	ETF	109.49	109.62	109.15	109.3	1671800.0
2002-04-25 15:00:00	SPY	ETF	109.3	109.64	108.85	109.44	3507700.0
2002-04-25 16:00:00	SPY	ETF	109.43	109.66	109.38	109.5	1784900.0
2002-04-25 17:00:00	SPY	ETF	109.67	109.67	109.59	109.62	3000.0
2002-04-25 18:00:00	SPY	ETF	109.62	109.78	109.62	109.78	2400.0
2002-04-25 09:00:00	QQQ	ETF	32.3	32.48	32.06	32.2	16290000.0
2002-04-25 10:00:00	QQQ	ETF	32.18	32.73	32.03	32.43	22842700.0
2002-04-25 11:00:00	QQQ	ETF	32.42	32.47	32.0	32.37	13403900.0
2002-04-25 12:00:00	QQQ	ETF	32.37	32.45	32.15	32.28	4698000.0
2002-04-25 13:00:00	QQQ	ETF	32.28	32.67	32.25	32.5	9039300.0
2002-04-25 14:00:00	QQQ	ETF	32.5	32.62	32.15	32.28	8738900.0
2002-04-25 15:00:00	QQQ	ETF	32.27	32.65	32.04	32.44	19243800.0
2002-04-25 16:00:00	QQQ	ETF	32.44	32.65	32.17	32.44	4021900.0
2002-04-25 17:00:00	QQQ	ETF	32.44	32.51	32.42	32.51	131800.0
2002-04-25 18:00:00	QQQ	ETF	32.46	32.54	32.44	32.54	28300.0
2002-04-25 09:00:00	IWM	ETF	50.3	50.44	50.105	50.115	168800.0
2002-04-25 10:00:00	IWM	ETF	50.12	50.645	50.105	50.6	372600.0
2002-04-25 11:00:00	IWM	ETF	50.54	50.55	50.38	50.445	167000.0
2002-04-25 12:00:00	IWM	ETF	50.38	50.5	50.35	50.455	38800.0
2002-04-25 13:00:00	IWM	ETF	50.455	50.69	50.455	50.65	276000.0
2002-04-25 14:00:00	IWM	ETF	50.65	50.685	50.48	50.54	169000.0
2002-04-25 15:00:00	IWM	ETF	50.5	50.72	50.425	50.72	124600.0
2002-04-25 16:00:00	IWM	ETF	50.725	50.77	50.655	50.655	15600.0
2002-04-25 09:00:00	DIA	ETF	100.0	100.1	99.3	99.5	876500.0
2002-04-25 10:00:00	DIA	ETF	99.45	100.09	99.3	99.98	1065200.0
2002-04-25 11:00:00	DIA	ETF	100.0	100.25	99.58	100.0	738400.0
2002-04-25 12:00:00	DIA	ETF	100.03	100.08	99.71	99.81	408600.0
2002-04-25 13:00:00	DIA	ETF	99.85	100.28	99.85	100.11	453200.0
2002-04-25 14:00:00	DIA	ETF	100.11	100.34	99.86	100.03	264700.0
2002-04-25 15:00:00	DIA	ETF	100.03	100.54	99.72	100.5	603400.0
2002-04-25 16:00:00	DIA	ETF	100.43	100.91	100.07	100.07	297200.0
2002-04-25 18:00:00	DIA	ETF	100.55	100.55	100.55	100.55	500.0

> showing 37 of 304 rows — these rows as CSV

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