PREVIEW / etf_1hour / 2002-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-12-16.parquet
  size:    16 KB
  rows:    393

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-12-16 08:00:00	SPY	ETF	89.91	89.98	89.82	89.88	5200.0
2002-12-16 09:00:00	SPY	ETF	89.85	90.2	89.66	90.18	2472500.0
2002-12-16 10:00:00	SPY	ETF	90.15	90.77	90.13	90.65	5437300.0
2002-12-16 11:00:00	SPY	ETF	90.65	91.23	90.65	91.22	4375400.0
2002-12-16 12:00:00	SPY	ETF	91.21	91.34	91.02	91.06	2931200.0
2002-12-16 13:00:00	SPY	ETF	91.1	91.24	90.9	91.17	2356100.0
2002-12-16 14:00:00	SPY	ETF	91.19	91.35	90.95	91.05	3860700.0
2002-12-16 15:00:00	SPY	ETF	91.04	91.68	91.0	91.63	7680000.0
2002-12-16 16:00:00	SPY	ETF	91.68	91.8	91.44	91.67	1463200.0
2002-12-16 17:00:00	SPY	ETF	91.66	91.75	91.6	91.69	257200.0
2002-12-16 18:00:00	SPY	ETF	91.65	91.76	91.5	91.5	15700.0
2002-12-16 19:00:00	SPY	ETF	91.64	91.7	91.64	91.68	1200.0
2002-12-16 08:00:00	QQQ	ETF	25.18	25.25	25.17	25.19	45500.0
2002-12-16 09:00:00	QQQ	ETF	25.2	25.3	25.07	25.23	4704900.0
2002-12-16 10:00:00	QQQ	ETF	25.24	25.59	25.17	25.51	11294500.0
2002-12-16 11:00:00	QQQ	ETF	25.52	25.75	25.52	25.72	5645000.0
2002-12-16 12:00:00	QQQ	ETF	25.73	25.79	25.61	25.66	6182100.0
2002-12-16 13:00:00	QQQ	ETF	25.66	25.76	25.6	25.7	4548700.0
2002-12-16 14:00:00	QQQ	ETF	25.71	25.82	25.66	25.72	4229600.0
2002-12-16 15:00:00	QQQ	ETF	25.7	25.96	25.7	25.87	9792800.0
2002-12-16 16:00:00	QQQ	ETF	25.88	25.9	25.8	25.89	1474500.0
2002-12-16 17:00:00	QQQ	ETF	25.87	25.94	25.87	25.92	141900.0
2002-12-16 18:00:00	QQQ	ETF	25.9	25.99	25.89	25.99	66400.0
2002-12-16 19:00:00	QQQ	ETF	25.99	25.99	25.92	25.98	22800.0
2002-12-16 09:00:00	IWM	ETF	38.65	38.77	38.65	38.76	37800.0
2002-12-16 10:00:00	IWM	ETF	38.77	38.98	38.75	38.965	327000.0
2002-12-16 11:00:00	IWM	ETF	38.965	39.065	38.95	39.065	158800.0
2002-12-16 12:00:00	IWM	ETF	39.0	39.08	38.87	38.91	607200.0
2002-12-16 13:00:00	IWM	ETF	38.925	38.955	38.855	38.905	204000.0
2002-12-16 14:00:00	IWM	ETF	38.94	39.025	38.905	38.94	527200.0
2002-12-16 15:00:00	IWM	ETF	38.95	39.265	38.915	39.2	727400.0
2002-12-16 16:00:00	IWM	ETF	39.215	39.275	39.135	39.225	22600.0
2002-12-16 08:00:00	DIA	ETF	85.0	85.0	84.9	84.9	1300.0
2002-12-16 09:00:00	DIA	ETF	84.85	85.21	84.78	85.2	376600.0
2002-12-16 10:00:00	DIA	ETF	85.21	85.67	85.16	85.6	888800.0
2002-12-16 11:00:00	DIA	ETF	85.62	86.0	85.61	85.99	870800.0
2002-12-16 12:00:00	DIA	ETF	85.99	86.17	85.83	85.94	781200.0
2002-12-16 13:00:00	DIA	ETF	85.96	86.12	85.77	86.08	506900.0
2002-12-16 14:00:00	DIA	ETF	86.06	86.28	85.86	86.0	440200.0
2002-12-16 15:00:00	DIA	ETF	85.95	86.49	85.95	86.45	709100.0
2002-12-16 16:00:00	DIA	ETF	86.46	86.7	86.38	86.65	214200.0
2002-12-16 17:00:00	DIA	ETF	86.54	86.67	86.53	86.67	5100.0
2002-12-16 18:00:00	DIA	ETF	86.6	87.15	86.6	86.7	3500.0
2002-12-16 09:00:00	TLT	ETF	86.8	86.8	86.64	86.64	8800.0
2002-12-16 10:00:00	TLT	ETF	86.65	86.65	86.4	86.5	6000.0
2002-12-16 11:00:00	TLT	ETF	86.48	86.48	86.44	86.44	2100.0
2002-12-16 12:00:00	TLT	ETF	86.15	86.26	86.0	86.0	1400.0
2002-12-16 13:00:00	TLT	ETF	85.94	86.06	85.86	86.06	47200.0
2002-12-16 14:00:00	TLT	ETF	85.95	86.0	85.84	86.0	4400.0
2002-12-16 15:00:00	TLT	ETF	85.96	85.96	85.91	85.94	34200.0

> showing 50 of 393 rows — these rows as CSV

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