PREVIEW / etf_1hour / 2002-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-11.parquet
  size:    16 KB
  rows:    360

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-11 08:00:00	SPY	ETF	81.42	81.98	81.35	81.84	12100.0
2002-10-11 09:00:00	SPY	ETF	81.94	83.19	81.77	83.14	14109400.0
2002-10-11 10:00:00	SPY	ETF	83.1	83.7	82.8	83.5	12454600.0
2002-10-11 11:00:00	SPY	ETF	83.54	83.6	83.05	83.32	5342000.0
2002-10-11 12:00:00	SPY	ETF	83.3	84.03	83.21	83.85	8616000.0
2002-10-11 13:00:00	SPY	ETF	83.86	84.73	83.8	84.55	7425300.0
2002-10-11 14:00:00	SPY	ETF	84.52	84.68	83.68	83.98	9447400.0
2002-10-11 15:00:00	SPY	ETF	83.98	84.0	82.94	83.9	12771100.0
2002-10-11 16:00:00	SPY	ETF	83.9	84.35	83.64	84.15	5774400.0
2002-10-11 17:00:00	SPY	ETF	84.15	84.49	81.95	84.22	130900.0
2002-10-11 18:00:00	SPY	ETF	84.22	84.29	84.19	84.19	1300.0
2002-10-11 08:00:00	QQQ	ETF	21.21	21.5	21.21	21.48	67600.0
2002-10-11 09:00:00	QQQ	ETF	21.45	21.89	21.42	21.88	20699100.0
2002-10-11 10:00:00	QQQ	ETF	21.88	21.99	21.72	21.95	20674900.0
2002-10-11 11:00:00	QQQ	ETF	21.95	22.0	21.8	21.9	11164800.0
2002-10-11 12:00:00	QQQ	ETF	21.9	22.17	21.88	22.1	12510900.0
2002-10-11 13:00:00	QQQ	ETF	22.11	22.38	22.05	22.3	11870100.0
2002-10-11 14:00:00	QQQ	ETF	22.26	22.35	22.01	22.12	16235300.0
2002-10-11 15:00:00	QQQ	ETF	22.13	22.15	21.73	22.1	23172000.0
2002-10-11 16:00:00	QQQ	ETF	22.1	22.25	21.99	22.2	4840100.0
2002-10-11 17:00:00	QQQ	ETF	22.21	22.25	22.16	22.24	221100.0
2002-10-11 18:00:00	QQQ	ETF	22.24	22.29	22.22	22.25	26800.0
2002-10-11 19:00:00	QQQ	ETF	22.27	22.27	22.25	22.25	2100.0
2002-10-11 09:00:00	IWM	ETF	33.885	34.325	33.885	34.325	578800.0
2002-10-11 10:00:00	IWM	ETF	34.345	34.475	34.2	34.45	628600.0
2002-10-11 11:00:00	IWM	ETF	34.45	34.45	34.255	34.355	705400.0
2002-10-11 12:00:00	IWM	ETF	34.355	34.6	34.355	34.575	382600.0
2002-10-11 13:00:00	IWM	ETF	34.585	34.745	34.55	34.68	285200.0
2002-10-11 14:00:00	IWM	ETF	34.735	34.745	34.4	34.5	553600.0
2002-10-11 15:00:00	IWM	ETF	34.515	34.525	34.19	34.415	814600.0
2002-10-11 16:00:00	IWM	ETF	34.415	34.49	34.35	34.385	1951800.0
2002-10-11 08:00:00	DIA	ETF	76.23	76.65	76.23	76.65	200.0
2002-10-11 09:00:00	DIA	ETF	76.55	77.65	76.54	77.52	4653300.0
2002-10-11 10:00:00	DIA	ETF	77.53	78.2	77.2	78.05	3613400.0
2002-10-11 11:00:00	DIA	ETF	78.07	78.15	77.65	77.92	2037200.0
2002-10-11 12:00:00	DIA	ETF	77.9	78.58	77.83	78.37	2000400.0
2002-10-11 13:00:00	DIA	ETF	78.37	79.2	78.3	79.03	2465500.0
2002-10-11 14:00:00	DIA	ETF	78.98	79.21	78.21	78.61	2493400.0
2002-10-11 15:00:00	DIA	ETF	78.61	78.62	77.7	78.56	4152000.0
2002-10-11 16:00:00	DIA	ETF	78.55	79.09	78.4	79.03	619000.0
2002-10-11 17:00:00	DIA	ETF	79.0	79.4	79.0	79.25	33100.0
2002-10-11 18:00:00	DIA	ETF	79.2	79.39	79.15	79.25	5100.0
2002-10-11 19:00:00	DIA	ETF	79.14	79.14	79.14	79.14	100.0
2002-10-11 09:00:00	TLT	ETF	89.1	89.22	88.65	88.65	91800.0
2002-10-11 10:00:00	TLT	ETF	88.75	88.99	88.67	88.86	24200.0
2002-10-11 11:00:00	TLT	ETF	88.86	88.95	88.79	88.79	23400.0
2002-10-11 12:00:00	TLT	ETF	88.82	88.82	88.07	88.07	216500.0
2002-10-11 13:00:00	TLT	ETF	88.22	88.37	88.06	88.13	25200.0
2002-10-11 14:00:00	TLT	ETF	88.09	88.26	88.06	88.24	16700.0
2002-10-11 15:00:00	TLT	ETF	88.3	88.38	88.21	88.38	3900.0

> showing 50 of 360 rows — these rows as CSV

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