PREVIEW / etf_1hour / 2002-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-10-22.parquet
  size:    16 KB
  rows:    366

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-22 08:00:00	SPY	ETF	89.3	89.3	89.06	89.27	13600.0
2002-10-22 09:00:00	SPY	ETF	89.19	89.35	88.82	89.04	5650500.0
2002-10-22 10:00:00	SPY	ETF	89.06	90.01	88.97	89.79	7584700.0
2002-10-22 11:00:00	SPY	ETF	89.79	89.99	89.12	89.45	4866700.0
2002-10-22 12:00:00	SPY	ETF	89.43	89.58	88.96	89.3	3551200.0
2002-10-22 13:00:00	SPY	ETF	89.27	89.45	88.62	88.79	3375700.0
2002-10-22 14:00:00	SPY	ETF	88.79	89.04	88.52	88.93	5489400.0
2002-10-22 15:00:00	SPY	ETF	88.9	89.48	88.6	89.37	6219900.0
2002-10-22 16:00:00	SPY	ETF	89.32	89.62	89.22	89.42	3000200.0
2002-10-22 17:00:00	SPY	ETF	89.51	89.51	88.65	89.31	102800.0
2002-10-22 18:00:00	SPY	ETF	89.39	89.49	89.39	89.44	4900.0
2002-10-22 19:00:00	SPY	ETF	89.5	89.5	89.47	89.47	400.0
2002-10-22 08:00:00	QQQ	ETF	23.78	23.8	23.75	23.79	10500.0
2002-10-22 09:00:00	QQQ	ETF	23.76	23.89	23.65	23.73	9191800.0
2002-10-22 10:00:00	QQQ	ETF	23.73	24.34	23.71	24.21	23920400.0
2002-10-22 11:00:00	QQQ	ETF	24.2	24.32	23.9	24.02	15861400.0
2002-10-22 12:00:00	QQQ	ETF	24.03	24.09	23.94	24.04	4270900.0
2002-10-22 13:00:00	QQQ	ETF	24.04	24.13	23.76	23.81	7633300.0
2002-10-22 14:00:00	QQQ	ETF	23.81	23.9	23.66	23.85	9825600.0
2002-10-22 15:00:00	QQQ	ETF	23.89	24.01	23.78	23.95	12733000.0
2002-10-22 16:00:00	QQQ	ETF	23.92	24.24	23.92	24.09	2541200.0
2002-10-22 17:00:00	QQQ	ETF	24.09	24.1	23.88	23.93	1467700.0
2002-10-22 18:00:00	QQQ	ETF	23.94	24.0	23.91	24.0	127900.0
2002-10-22 19:00:00	QQQ	ETF	23.98	24.02	23.98	24.02	3600.0
2002-10-22 09:00:00	IWM	ETF	36.35	36.43	36.16	36.225	273400.0
2002-10-22 10:00:00	IWM	ETF	36.205	36.615	36.205	36.43	1031200.0
2002-10-22 11:00:00	IWM	ETF	36.43	36.48	36.27	36.375	711000.0
2002-10-22 12:00:00	IWM	ETF	36.375	36.415	36.25	36.33	117200.0
2002-10-22 13:00:00	IWM	ETF	36.305	36.385	36.145	36.17	188000.0
2002-10-22 14:00:00	IWM	ETF	36.17	36.21	36.05	36.19	187000.0
2002-10-22 15:00:00	IWM	ETF	36.2	36.335	36.095	36.15	594200.0
2002-10-22 16:00:00	IWM	ETF	36.15	36.275	36.15	36.15	29600.0
2002-10-22 17:00:00	IWM	ETF	36.155	36.295	36.155	36.295	590800.0
2002-10-22 09:00:00	DIA	ETF	84.5	84.7	84.2	84.37	1895700.0
2002-10-22 10:00:00	DIA	ETF	84.37	84.98	84.15	84.8	3107900.0
2002-10-22 11:00:00	DIA	ETF	84.83	85.01	84.22	84.57	1162100.0
2002-10-22 12:00:00	DIA	ETF	84.52	84.74	84.2	84.49	685300.0
2002-10-22 13:00:00	DIA	ETF	84.46	84.65	83.88	84.04	1119700.0
2002-10-22 14:00:00	DIA	ETF	84.01	84.22	83.8	84.09	1154800.0
2002-10-22 15:00:00	DIA	ETF	84.08	84.64	83.82	84.53	1279300.0
2002-10-22 16:00:00	DIA	ETF	84.51	85.31	84.44	84.52	147300.0
2002-10-22 17:00:00	DIA	ETF	84.51	84.51	84.25	84.46	6500.0
2002-10-22 18:00:00	DIA	ETF	84.4	84.54	84.4	84.4	4600.0
2002-10-22 19:00:00	DIA	ETF	84.64	84.64	84.64	84.64	300.0
2002-10-22 09:00:00	TLT	ETF	84.85	84.85	84.64	84.76	16300.0
2002-10-22 10:00:00	TLT	ETF	84.77	84.83	84.51	84.51	27800.0
2002-10-22 11:00:00	TLT	ETF	84.63	84.74	84.54	84.66	12800.0
2002-10-22 12:00:00	TLT	ETF	84.55	84.7	84.34	84.34	5000.0
2002-10-22 13:00:00	TLT	ETF	84.44	84.6	84.35	84.5	106100.0
2002-10-22 14:00:00	TLT	ETF	84.49	84.59	84.41	84.47	19700.0

> showing 50 of 366 rows — these rows as CSV

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