PREVIEW / etf_1hour / 2003-01-21

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-21.parquet
  size:    16 KB
  rows:    394

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-21 08:00:00	SPY	ETF	90.48	90.8	90.45	90.8	57700.0
2003-01-21 09:00:00	SPY	ETF	90.79	90.92	90.4	90.48	4994900.0
2003-01-21 10:00:00	SPY	ETF	90.48	90.52	89.75	89.85	8017600.0
2003-01-21 11:00:00	SPY	ETF	89.85	89.99	89.65	89.94	3990200.0
2003-01-21 12:00:00	SPY	ETF	89.92	90.08	89.63	90.05	3752200.0
2003-01-21 13:00:00	SPY	ETF	90.05	90.18	89.8	89.89	2389000.0
2003-01-21 14:00:00	SPY	ETF	89.91	89.91	89.42	89.47	3633600.0
2003-01-21 15:00:00	SPY	ETF	89.43	89.46	89.03	89.07	6676900.0
2003-01-21 16:00:00	SPY	ETF	89.02	89.25	88.73	89.13	1202500.0
2003-01-21 17:00:00	SPY	ETF	89.13	90.46	89.08	89.12	5546600.0
2003-01-21 18:00:00	SPY	ETF	89.11	89.18	89.06	89.18	8800.0
2003-01-21 19:00:00	SPY	ETF	89.21	89.21	89.12	89.18	1900.0
2003-01-21 08:00:00	QQQ	ETF	25.3	25.45	25.25	25.43	122100.0
2003-01-21 09:00:00	QQQ	ETF	25.44	25.55	25.34	25.41	9015500.0
2003-01-21 10:00:00	QQQ	ETF	25.42	25.46	25.17	25.25	15203100.0
2003-01-21 11:00:00	QQQ	ETF	25.27	25.34	25.13	25.34	6351000.0
2003-01-21 12:00:00	QQQ	ETF	25.34	25.48	25.27	25.48	5992100.0
2003-01-21 13:00:00	QQQ	ETF	25.47	25.55	25.37	25.41	4071700.0
2003-01-21 14:00:00	QQQ	ETF	25.41	25.42	25.22	25.25	6602200.0
2003-01-21 15:00:00	QQQ	ETF	25.25	25.27	25.1	25.13	13153000.0
2003-01-21 16:00:00	QQQ	ETF	25.11	25.15	24.97	25.02	2849000.0
2003-01-21 17:00:00	QQQ	ETF	25.02	25.1	25.0	25.09	1176500.0
2003-01-21 18:00:00	QQQ	ETF	25.09	25.12	25.06	25.11	54800.0
2003-01-21 19:00:00	QQQ	ETF	25.14	25.14	25.08	25.1	11100.0
2003-01-21 09:00:00	IWM	ETF	38.7	38.77	38.445	38.49	233400.0
2003-01-21 10:00:00	IWM	ETF	38.48	38.48	38.225	38.305	221200.0
2003-01-21 11:00:00	IWM	ETF	38.3	38.345	38.21	38.32	264200.0
2003-01-21 12:00:00	IWM	ETF	38.325	38.365	38.255	38.365	86400.0
2003-01-21 13:00:00	IWM	ETF	38.375	38.395	38.325	38.34	188400.0
2003-01-21 14:00:00	IWM	ETF	38.34	38.34	38.165	38.165	227000.0
2003-01-21 15:00:00	IWM	ETF	38.155	38.165	38.05	38.1	523000.0
2003-01-21 16:00:00	IWM	ETF	38.14	38.16	38.06	38.06	122200.0
2003-01-21 08:00:00	DIA	ETF	85.92	86.25	85.92	86.25	1400.0
2003-01-21 09:00:00	DIA	ETF	86.28	86.4	85.85	85.99	554500.0
2003-01-21 10:00:00	DIA	ETF	85.98	86.0	85.25	85.35	789800.0
2003-01-21 11:00:00	DIA	ETF	85.39	85.49	85.15	85.35	769900.0
2003-01-21 12:00:00	DIA	ETF	85.35	85.55	85.12	85.52	585800.0
2003-01-21 13:00:00	DIA	ETF	85.5	85.6	85.24	85.34	293500.0
2003-01-21 14:00:00	DIA	ETF	85.3	85.3	84.84	84.86	809900.0
2003-01-21 15:00:00	DIA	ETF	84.85	84.88	84.45	84.49	1598400.0
2003-01-21 16:00:00	DIA	ETF	84.45	84.7	84.45	84.67	158100.0
2003-01-21 17:00:00	DIA	ETF	84.6	84.6	84.56	84.56	3600.0
2003-01-21 18:00:00	DIA	ETF	84.55	84.6	84.55	84.55	2700.0
2003-01-21 09:00:00	TLT	ETF	86.88	86.96	86.8	86.96	15300.0
2003-01-21 10:00:00	TLT	ETF	86.95	87.23	86.9	87.23	45300.0
2003-01-21 11:00:00	TLT	ETF	87.15	87.18	87.05	87.05	5200.0
2003-01-21 12:00:00	TLT	ETF	87.08	87.22	87.08	87.18	4000.0
2003-01-21 13:00:00	TLT	ETF	87.17	87.22	87.09	87.14	7800.0
2003-01-21 14:00:00	TLT	ETF	87.26	87.33	87.25	87.27	5100.0
2003-01-21 15:00:00	TLT	ETF	87.36	87.4	87.28	87.4	16800.0

> showing 50 of 394 rows — these rows as CSV

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