PREVIEW / etf_1hour / 2003-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-28.parquet
  size:    16 KB
  rows:    406

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-28 08:00:00	SPY	ETF	85.17	85.52	85.0	85.52	99700.0
2003-01-28 09:00:00	SPY	ETF	85.54	85.87	85.38	85.5	4789200.0
2003-01-28 10:00:00	SPY	ETF	85.48	86.1	85.13	85.2	11741300.0
2003-01-28 11:00:00	SPY	ETF	85.2	85.72	85.13	85.53	9756400.0
2003-01-28 12:00:00	SPY	ETF	85.54	85.67	85.24	85.54	1773600.0
2003-01-28 13:00:00	SPY	ETF	85.57	85.92	85.53	85.9	2596900.0
2003-01-28 14:00:00	SPY	ETF	85.89	86.26	85.86	85.97	6251800.0
2003-01-28 15:00:00	SPY	ETF	85.97	86.4	85.76	86.11	5325500.0
2003-01-28 16:00:00	SPY	ETF	86.1	86.12	85.77	85.94	1542600.0
2003-01-28 17:00:00	SPY	ETF	85.92	85.99	85.91	85.92	107700.0
2003-01-28 18:00:00	SPY	ETF	85.95	86.0	85.92	85.92	15100.0
2003-01-28 19:00:00	SPY	ETF	85.95	85.95	85.9	85.91	4200.0
2003-01-28 08:00:00	QQQ	ETF	24.6	24.76	24.56	24.76	120000.0
2003-01-28 09:00:00	QQQ	ETF	24.77	24.87	24.63	24.69	9464800.0
2003-01-28 10:00:00	QQQ	ETF	24.73	24.91	24.42	24.46	15284900.0
2003-01-28 11:00:00	QQQ	ETF	24.45	24.73	24.44	24.65	6434300.0
2003-01-28 12:00:00	QQQ	ETF	24.63	24.69	24.51	24.61	3394000.0
2003-01-28 13:00:00	QQQ	ETF	24.63	24.78	24.62	24.77	3917700.0
2003-01-28 14:00:00	QQQ	ETF	24.75	24.98	24.75	24.86	8724800.0
2003-01-28 15:00:00	QQQ	ETF	24.85	25.05	24.78	24.88	10176900.0
2003-01-28 16:00:00	QQQ	ETF	24.87	24.89	24.75	24.83	2390200.0
2003-01-28 17:00:00	QQQ	ETF	24.82	24.85	24.8	24.84	83000.0
2003-01-28 18:00:00	QQQ	ETF	24.84	24.89	24.83	24.86	72100.0
2003-01-28 19:00:00	QQQ	ETF	24.86	24.87	24.8	24.81	15000.0
2003-01-28 09:00:00	IWM	ETF	36.9	36.98	36.72	36.785	250200.0
2003-01-28 10:00:00	IWM	ETF	36.9	36.995	36.405	36.415	618600.0
2003-01-28 11:00:00	IWM	ETF	36.385	36.675	36.345	36.665	416800.0
2003-01-28 12:00:00	IWM	ETF	36.635	36.73	36.605	36.72	203000.0
2003-01-28 13:00:00	IWM	ETF	36.72	36.815	36.72	36.815	121800.0
2003-01-28 14:00:00	IWM	ETF	36.85	37.09	36.81	37.09	374200.0
2003-01-28 15:00:00	IWM	ETF	37.05	37.195	37.01	37.125	520200.0
2003-01-28 16:00:00	IWM	ETF	36.955	36.955	36.6	36.6	4600.0
2003-01-28 08:00:00	DIA	ETF	80.15	80.48	80.04	80.4	47100.0
2003-01-28 09:00:00	DIA	ETF	80.45	80.75	80.37	80.44	982900.0
2003-01-28 10:00:00	DIA	ETF	80.47	80.9	80.11	80.19	1902100.0
2003-01-28 11:00:00	DIA	ETF	80.19	80.64	80.1	80.5	789000.0
2003-01-28 12:00:00	DIA	ETF	80.51	80.64	80.23	80.47	364900.0
2003-01-28 13:00:00	DIA	ETF	80.57	80.83	80.49	80.8	742700.0
2003-01-28 14:00:00	DIA	ETF	80.81	81.15	80.75	80.89	1015900.0
2003-01-28 15:00:00	DIA	ETF	80.86	81.28	80.66	81.05	963600.0
2003-01-28 16:00:00	DIA	ETF	81.06	81.1	80.69	80.85	119000.0
2003-01-28 17:00:00	DIA	ETF	80.87	80.91	80.85	80.86	2200.0
2003-01-28 18:00:00	DIA	ETF	80.94	80.97	80.91	80.97	2900.0
2003-01-28 19:00:00	DIA	ETF	80.93	80.94	80.89	80.94	1900.0
2003-01-28 09:00:00	TLT	ETF	87.65	87.78	87.59	87.68	3600.0
2003-01-28 10:00:00	TLT	ETF	87.55	87.55	87.1	87.23	23800.0
2003-01-28 11:00:00	TLT	ETF	87.48	87.48	87.23	87.26	9900.0
2003-01-28 12:00:00	TLT	ETF	87.47	87.47	87.42	87.44	5100.0
2003-01-28 13:00:00	TLT	ETF	87.42	87.55	87.42	87.55	200900.0
2003-01-28 14:00:00	TLT	ETF	87.45	87.6	87.43	87.6	205700.0

> showing 50 of 406 rows — these rows as CSV

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