PREVIEW / etf_1hour / 2003-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-22.parquet
  size:    16 KB
  rows:    391

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
2003-01-22 08:00:00	SPY	ETF	88.7	88.75	88.53	88.68	37500.0
2003-01-22 09:00:00	SPY	ETF	88.68	89.08	88.61	88.9	5373700.0
2003-01-22 10:00:00	SPY	ETF	88.92	89.32	88.55	89.07	6129800.0
2003-01-22 11:00:00	SPY	ETF	89.08	89.09	88.45	88.56	4515100.0
2003-01-22 12:00:00	SPY	ETF	88.53	89.22	88.52	89.1	4952600.0
2003-01-22 13:00:00	SPY	ETF	89.08	89.3	88.73	88.78	3392500.0
2003-01-22 14:00:00	SPY	ETF	88.78	89.22	88.42	88.55	7629900.0
2003-01-22 15:00:00	SPY	ETF	88.54	88.75	88.01	88.06	7004300.0
2003-01-22 16:00:00	SPY	ETF	88.06	88.4	88.03	88.31	1094300.0
2003-01-22 17:00:00	SPY	ETF	88.33	88.43	88.21	88.43	433200.0
2003-01-22 18:00:00	SPY	ETF	88.42	88.58	88.36	88.5	229000.0
2003-01-22 19:00:00	SPY	ETF	88.51	88.53	88.5	88.5	4400.0
2003-01-22 08:00:00	QQQ	ETF	24.89	24.91	24.84	24.9	133100.0
2003-01-22 09:00:00	QQQ	ETF	24.9	25.22	24.87	25.12	14528700.0
2003-01-22 10:00:00	QQQ	ETF	25.12	25.41	24.99	25.35	14088700.0
2003-01-22 11:00:00	QQQ	ETF	25.37	25.37	25.2	25.24	9096200.0
2003-01-22 12:00:00	QQQ	ETF	25.21	25.52	25.21	25.44	7086500.0
2003-01-22 13:00:00	QQQ	ETF	25.43	25.53	25.33	25.37	5725200.0
2003-01-22 14:00:00	QQQ	ETF	25.37	25.53	25.22	25.25	7733400.0
2003-01-22 15:00:00	QQQ	ETF	25.25	25.33	24.99	25.03	10261700.0
2003-01-22 16:00:00	QQQ	ETF	25.05	25.2	24.93	25.15	4438000.0
2003-01-22 17:00:00	QQQ	ETF	25.16	25.28	25.15	25.25	1335300.0
2003-01-22 18:00:00	QQQ	ETF	25.24	25.38	25.23	25.37	634400.0
2003-01-22 19:00:00	QQQ	ETF	25.37	25.4	25.3	25.32	35300.0
2003-01-22 09:00:00	IWM	ETF	37.885	38.0	37.875	37.955	471800.0
2003-01-22 10:00:00	IWM	ETF	37.95	38.05	37.79	38.0	828000.0
2003-01-22 11:00:00	IWM	ETF	37.955	38.005	37.895	37.94	252000.0
2003-01-22 12:00:00	IWM	ETF	37.93	38.15	37.925	38.15	234200.0
2003-01-22 13:00:00	IWM	ETF	38.125	38.175	37.98	37.98	359000.0
2003-01-22 14:00:00	IWM	ETF	37.975	38.1	37.925	38.02	296000.0
2003-01-22 15:00:00	IWM	ETF	37.93	38.015	37.73	37.73	656400.0
2003-01-22 16:00:00	IWM	ETF	37.7	37.775	37.7	37.735	22000.0
2003-01-22 17:00:00	IWM	ETF	37.875	37.875	37.875	37.875	79000.0
2003-01-22 08:00:00	DIA	ETF	84.18	84.18	84.0	84.11	4400.0
2003-01-22 09:00:00	DIA	ETF	84.0	84.43	84.0	84.25	1275000.0
2003-01-22 10:00:00	DIA	ETF	84.21	84.54	83.87	84.32	1888600.0
2003-01-22 11:00:00	DIA	ETF	84.32	84.35	83.7	83.81	831100.0
2003-01-22 12:00:00	DIA	ETF	83.81	84.35	83.76	84.26	603400.0
2003-01-22 13:00:00	DIA	ETF	84.26	84.42	83.88	83.94	614800.0
2003-01-22 14:00:00	DIA	ETF	83.91	84.25	83.51	83.57	1063000.0
2003-01-22 15:00:00	DIA	ETF	83.61	83.77	83.15	83.22	1390800.0
2003-01-22 16:00:00	DIA	ETF	83.21	83.45	83.19	83.45	139900.0
2003-01-22 17:00:00	DIA	ETF	83.45	83.5	83.39	83.47	15500.0
2003-01-22 18:00:00	DIA	ETF	83.47	83.66	83.47	83.66	7600.0
2003-01-22 19:00:00	DIA	ETF	83.66	83.76	83.66	83.7	3900.0
2003-01-22 09:00:00	TLT	ETF	87.68	87.74	87.56	87.6	24400.0
2003-01-22 10:00:00	TLT	ETF	87.55	87.67	87.52	87.65	42400.0
2003-01-22 11:00:00	TLT	ETF	87.67	87.8	87.65	87.74	3700.0
2003-01-22 12:00:00	TLT	ETF	87.7	87.75	87.65	87.65	2900.0
2003-01-22 13:00:00	TLT	ETF	87.61	87.75	87.61	87.75	3300.0

> showing 50 of 391 rows — these rows as CSV

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