PREVIEW / etf_1hour / 2003-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-25.parquet
  size:    15 KB
  rows:    374

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-04-25 08:00:00	SPY	ETF	91.55	91.55	91.05	91.45	52800.0
2003-04-25 09:00:00	SPY	ETF	91.44	91.48	90.86	90.96	6159300.0
2003-04-25 10:00:00	SPY	ETF	90.94	91.16	90.43	90.52	8148000.0
2003-04-25 11:00:00	SPY	ETF	90.51	90.53	90.12	90.28	3912000.0
2003-04-25 12:00:00	SPY	ETF	90.28	90.48	90.02	90.3	2793500.0
2003-04-25 13:00:00	SPY	ETF	90.31	90.6	90.22	90.31	3051000.0
2003-04-25 14:00:00	SPY	ETF	90.29	90.48	90.05	90.19	2910300.0
2003-04-25 15:00:00	SPY	ETF	90.2	90.38	90.05	90.15	10197100.0
2003-04-25 16:00:00	SPY	ETF	90.16	90.27	90.05	90.1	1402100.0
2003-04-25 17:00:00	SPY	ETF	90.1	90.19	90.05	90.19	10800.0
2003-04-25 18:00:00	SPY	ETF	90.1	90.2	90.05	90.2	7100.0
2003-04-25 19:00:00	SPY	ETF	90.1	90.18	90.1	90.18	600.0
2003-04-25 08:00:00	QQQ	ETF	27.42	27.43	27.21	27.39	163600.0
2003-04-25 09:00:00	QQQ	ETF	27.39	27.45	27.15	27.21	9634100.0
2003-04-25 10:00:00	QQQ	ETF	27.21	27.35	26.97	27.04	13820400.0
2003-04-25 11:00:00	QQQ	ETF	27.04	27.05	26.86	26.96	7828900.0
2003-04-25 12:00:00	QQQ	ETF	26.96	27.08	26.92	27.0	4155900.0
2003-04-25 13:00:00	QQQ	ETF	27.0	27.09	26.95	26.98	3730000.0
2003-04-25 14:00:00	QQQ	ETF	26.99	27.02	26.91	26.95	4432400.0
2003-04-25 15:00:00	QQQ	ETF	26.95	27.0	26.87	26.94	9198500.0
2003-04-25 16:00:00	QQQ	ETF	26.94	27.06	26.9	26.93	1983700.0
2003-04-25 17:00:00	QQQ	ETF	26.93	26.99	26.92	26.96	102100.0
2003-04-25 18:00:00	QQQ	ETF	26.97	26.97	26.94	26.94	24200.0
2003-04-25 19:00:00	QQQ	ETF	26.94	27.03	26.94	27.03	3300.0
2003-04-25 09:00:00	IWM	ETF	39.125	39.125	38.89	38.93	137200.0
2003-04-25 10:00:00	IWM	ETF	38.93	38.96	38.78	38.835	250800.0
2003-04-25 11:00:00	IWM	ETF	38.8	38.8	38.695	38.78	168200.0
2003-04-25 12:00:00	IWM	ETF	38.785	38.825	38.725	38.805	57000.0
2003-04-25 13:00:00	IWM	ETF	38.79	38.845	38.765	38.79	90000.0
2003-04-25 14:00:00	IWM	ETF	38.76	38.82	38.74	38.75	36200.0
2003-04-25 15:00:00	IWM	ETF	38.765	38.82	38.615	38.625	255200.0
2003-04-25 16:00:00	IWM	ETF	38.635	38.745	38.635	38.745	61400.0
2003-04-25 08:00:00	DIA	ETF	84.45	84.45	84.1	84.4	18200.0
2003-04-25 09:00:00	DIA	ETF	84.38	84.38	83.85	83.89	770300.0
2003-04-25 10:00:00	DIA	ETF	83.9	84.1	83.45	83.49	1362700.0
2003-04-25 11:00:00	DIA	ETF	83.47	83.5	83.1	83.27	949400.0
2003-04-25 12:00:00	DIA	ETF	83.26	83.49	83.06	83.24	693000.0
2003-04-25 13:00:00	DIA	ETF	83.24	83.5	83.2	83.27	477700.0
2003-04-25 14:00:00	DIA	ETF	83.27	83.4	83.06	83.19	825400.0
2003-04-25 15:00:00	DIA	ETF	83.16	83.27	82.85	83.08	1929400.0
2003-04-25 16:00:00	DIA	ETF	83.1	83.22	83.05	83.22	158300.0
2003-04-25 17:00:00	DIA	ETF	83.17	83.17	83.08	83.08	1100.0
2003-04-25 18:00:00	DIA	ETF	83.15	83.15	83.08	83.08	2500.0
2003-04-25 19:00:00	DIA	ETF	83.08	83.15	83.08	83.15	1100.0
2003-04-25 09:00:00	TLT	ETF	88.75	88.76	88.68	88.75	105700.0
2003-04-25 10:00:00	TLT	ETF	88.8	89.06	88.8	88.95	12300.0
2003-04-25 11:00:00	TLT	ETF	89.06	89.06	88.94	88.94	2800.0
2003-04-25 12:00:00	TLT	ETF	88.87	89.07	88.87	89.04	17800.0
2003-04-25 13:00:00	TLT	ETF	89.04	89.1	88.85	88.95	48800.0
2003-04-25 14:00:00	TLT	ETF	88.99	89.0	88.92	88.92	15300.0

> showing 50 of 374 rows — these rows as CSV

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