PREVIEW / etf_1hour / 2002-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-09.parquet
  size:    16 KB
  rows:    371

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-09 08:00:00	SPY	ETF	79.61	79.61	79.16	79.16	5800.0
2002-10-09 09:00:00	SPY	ETF	79.25	79.36	78.55	78.7	6690000.0
2002-10-09 10:00:00	SPY	ETF	78.71	79.7	78.22	78.78	13399700.0
2002-10-09 11:00:00	SPY	ETF	78.75	79.24	78.45	79.08	4638900.0
2002-10-09 12:00:00	SPY	ETF	79.11	79.15	78.05	78.71	9433800.0
2002-10-09 13:00:00	SPY	ETF	78.73	79.44	78.07	79.2	9219100.0
2002-10-09 14:00:00	SPY	ETF	79.25	79.26	78.04	78.1	12687800.0
2002-10-09 15:00:00	SPY	ETF	78.14	78.75	77.78	77.96	13273200.0
2002-10-09 16:00:00	SPY	ETF	78.0	79.0	77.9	78.3	6298700.0
2002-10-09 17:00:00	SPY	ETF	78.3	78.4	77.83	78.23	331100.0
2002-10-09 18:00:00	SPY	ETF	78.23	78.3	78.15	78.15	40100.0
2002-10-09 08:00:00	QQQ	ETF	20.0	20.0	19.87	19.87	23700.0
2002-10-09 09:00:00	QQQ	ETF	19.91	20.08	19.84	20.03	11396600.0
2002-10-09 10:00:00	QQQ	ETF	19.97	20.52	19.87	20.28	22765800.0
2002-10-09 11:00:00	QQQ	ETF	20.28	20.48	20.12	20.45	15529200.0
2002-10-09 12:00:00	QQQ	ETF	20.43	20.46	20.1	20.26	10371500.0
2002-10-09 13:00:00	QQQ	ETF	20.24	20.53	20.1	20.43	12345400.0
2002-10-09 14:00:00	QQQ	ETF	20.43	20.48	20.08	20.1	9846800.0
2002-10-09 15:00:00	QQQ	ETF	20.09	20.26	19.97	20.09	16678300.0
2002-10-09 16:00:00	QQQ	ETF	20.1	20.18	19.94	20.15	1804400.0
2002-10-09 17:00:00	QQQ	ETF	20.16	20.24	20.13	20.15	149700.0
2002-10-09 18:00:00	QQQ	ETF	20.15	20.2	20.12	20.14	47400.0
2002-10-09 19:00:00	QQQ	ETF	20.13	20.13	20.09	20.09	1700.0
2002-10-09 09:00:00	IWM	ETF	33.575	33.745	33.42	33.42	593800.0
2002-10-09 10:00:00	IWM	ETF	33.41	33.625	33.28	33.365	604600.0
2002-10-09 11:00:00	IWM	ETF	33.28	33.39	33.15	33.34	323000.0
2002-10-09 12:00:00	IWM	ETF	33.365	33.365	33.0	33.075	548000.0
2002-10-09 13:00:00	IWM	ETF	33.04	33.275	32.875	33.25	592600.0
2002-10-09 14:00:00	IWM	ETF	33.275	33.285	32.89	32.905	243800.0
2002-10-09 15:00:00	IWM	ETF	32.905	33.005	32.49	32.51	1447800.0
2002-10-09 16:00:00	IWM	ETF	32.555	32.635	32.55	32.55	21000.0
2002-10-09 17:00:00	IWM	ETF	32.55	32.6	32.395	32.6	3114000.0
2002-10-09 08:00:00	DIA	ETF	74.5	74.5	74.3	74.3	900.0
2002-10-09 09:00:00	DIA	ETF	74.2	74.38	73.58	73.79	1906500.0
2002-10-09 10:00:00	DIA	ETF	73.77	74.74	73.45	73.7	4254200.0
2002-10-09 11:00:00	DIA	ETF	73.74	74.12	73.46	74.04	2110200.0
2002-10-09 12:00:00	DIA	ETF	74.02	74.1	73.05	73.52	2955500.0
2002-10-09 13:00:00	DIA	ETF	73.52	74.25	73.01	74.0	2723600.0
2002-10-09 14:00:00	DIA	ETF	74.0	74.05	73.02	73.14	2868800.0
2002-10-09 15:00:00	DIA	ETF	73.11	73.75	72.9	73.05	3105200.0
2002-10-09 16:00:00	DIA	ETF	73.05	73.3	73.0	73.3	212100.0
2002-10-09 17:00:00	DIA	ETF	73.3	73.3	73.07	73.2	6100.0
2002-10-09 18:00:00	DIA	ETF	73.25	73.25	73.2	73.2	1700.0
2002-10-09 19:00:00	DIA	ETF	73.16	73.16	73.15	73.15	900.0
2002-10-09 09:00:00	TLT	ETF	90.3	90.3	89.98	90.12	189500.0
2002-10-09 10:00:00	TLT	ETF	90.15	90.28	89.95	90.15	80200.0
2002-10-09 11:00:00	TLT	ETF	90.1	90.16	90.08	90.12	41500.0
2002-10-09 12:00:00	TLT	ETF	90.18	90.38	90.15	90.27	21700.0
2002-10-09 13:00:00	TLT	ETF	90.1	90.2	90.0	90.0	9300.0
2002-10-09 14:00:00	TLT	ETF	90.22	90.22	90.03	90.08	14000.0

> showing 50 of 371 rows — these rows as CSV

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