PREVIEW / etf_1hour / 2003-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-24.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-04-24 08:00:00	SPY	ETF	91.56	91.73	91.4	91.64	42000.0
2003-04-24 09:00:00	SPY	ETF	91.65	91.69	91.27	91.42	4251600.0
2003-04-24 10:00:00	SPY	ETF	91.42	91.85	91.03	91.2	6390900.0
2003-04-24 11:00:00	SPY	ETF	91.25	91.31	90.96	91.16	5641700.0
2003-04-24 12:00:00	SPY	ETF	91.15	91.42	91.04	91.31	3598400.0
2003-04-24 13:00:00	SPY	ETF	91.33	91.57	91.15	91.57	4000800.0
2003-04-24 14:00:00	SPY	ETF	91.56	92.05	91.45	91.9	5739100.0
2003-04-24 15:00:00	SPY	ETF	91.88	92.08	91.3	91.42	8158700.0
2003-04-24 16:00:00	SPY	ETF	91.43	91.54	91.3	91.54	1685500.0
2003-04-24 17:00:00	SPY	ETF	91.52	91.54	91.47	91.47	323500.0
2003-04-24 18:00:00	SPY	ETF	91.49	91.52	91.4	91.4	16500.0
2003-04-24 19:00:00	SPY	ETF	91.4	91.41	91.38	91.4	14400.0
2003-04-24 08:00:00	QQQ	ETF	27.44	27.47	27.39	27.43	117100.0
2003-04-24 09:00:00	QQQ	ETF	27.43	27.54	27.3	27.44	12895500.0
2003-04-24 10:00:00	QQQ	ETF	27.44	27.65	27.33	27.39	12853900.0
2003-04-24 11:00:00	QQQ	ETF	27.4	27.44	27.27	27.4	9245300.0
2003-04-24 12:00:00	QQQ	ETF	27.38	27.48	27.34	27.43	4005700.0
2003-04-24 13:00:00	QQQ	ETF	27.43	27.52	27.38	27.5	4098300.0
2003-04-24 14:00:00	QQQ	ETF	27.5	27.75	27.45	27.66	9798600.0
2003-04-24 15:00:00	QQQ	ETF	27.66	27.74	27.49	27.56	10588700.0
2003-04-24 16:00:00	QQQ	ETF	27.54	27.62	27.48	27.62	2090900.0
2003-04-24 17:00:00	QQQ	ETF	27.62	27.62	27.55	27.55	91700.0
2003-04-24 18:00:00	QQQ	ETF	27.57	27.59	27.5	27.55	81700.0
2003-04-24 19:00:00	QQQ	ETF	27.5	27.53	27.47	27.52	65500.0
2003-04-24 09:00:00	IWM	ETF	39.155	39.3	39.075	39.235	204200.0
2003-04-24 10:00:00	IWM	ETF	39.245	39.35	39.095	39.095	760400.0
2003-04-24 11:00:00	IWM	ETF	39.105	39.125	39.02	39.115	374400.0
2003-04-24 12:00:00	IWM	ETF	39.12	39.135	39.08	39.115	96000.0
2003-04-24 13:00:00	IWM	ETF	39.145	39.145	39.05	39.135	374800.0
2003-04-24 14:00:00	IWM	ETF	39.155	39.32	39.145	39.315	146800.0
2003-04-24 15:00:00	IWM	ETF	39.3	39.34	39.05	39.15	360200.0
2003-04-24 16:00:00	IWM	ETF	39.095	39.175	39.025	39.175	71000.0
2003-04-24 08:00:00	DIA	ETF	84.69	84.75	84.63	84.65	21900.0
2003-04-24 09:00:00	DIA	ETF	84.67	84.73	84.41	84.54	1637600.0
2003-04-24 10:00:00	DIA	ETF	84.55	84.91	84.15	84.25	1960200.0
2003-04-24 11:00:00	DIA	ETF	84.29	84.4	84.05	84.24	998400.0
2003-04-24 12:00:00	DIA	ETF	84.25	84.49	84.11	84.4	308100.0
2003-04-24 13:00:00	DIA	ETF	84.42	84.64	84.25	84.63	630000.0
2003-04-24 14:00:00	DIA	ETF	84.6	84.99	84.51	84.87	1072300.0
2003-04-24 15:00:00	DIA	ETF	84.87	84.97	84.35	84.42	1219800.0
2003-04-24 16:00:00	DIA	ETF	84.42	84.54	84.4	84.54	59900.0
2003-04-24 17:00:00	DIA	ETF	84.55	84.67	84.55	84.66	5800.0
2003-04-24 18:00:00	DIA	ETF	84.62	84.62	84.55	84.55	5700.0
2003-04-24 19:00:00	DIA	ETF	84.45	84.57	84.45	84.57	2900.0
2003-04-24 09:00:00	TLT	ETF	88.4	88.7	88.4	88.69	28300.0
2003-04-24 10:00:00	TLT	ETF	88.79	88.79	88.62	88.74	23300.0
2003-04-24 11:00:00	TLT	ETF	88.7	88.85	88.7	88.78	29600.0
2003-04-24 12:00:00	TLT	ETF	88.78	88.86	88.72	88.78	12500.0
2003-04-24 13:00:00	TLT	ETF	88.78	88.99	88.78	88.85	20000.0
2003-04-24 14:00:00	TLT	ETF	88.79	88.89	88.75	88.75	6500.0

> showing 50 of 394 rows — these rows as CSV

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