PREVIEW / etf_1hour / 2003-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-25.parquet
  size:    17 KB
  rows:    416

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-06-25 08:00:00	SPY	ETF	98.61	98.71	98.55	98.6	58100.0
2003-06-25 09:00:00	SPY	ETF	98.57	99.07	98.46	99.07	2995300.0
2003-06-25 10:00:00	SPY	ETF	99.07	99.333	98.98	99.25	4847600.0
2003-06-25 11:00:00	SPY	ETF	99.25	99.44	99.1	99.18	2151600.0
2003-06-25 12:00:00	SPY	ETF	99.17	99.297	99.14	99.29	1045500.0
2003-06-25 13:00:00	SPY	ETF	99.289	99.34	98.88	98.9	3620900.0
2003-06-25 14:00:00	SPY	ETF	98.92	99.24	98.28	98.843	15353200.0
2003-06-25 15:00:00	SPY	ETF	98.84	98.98	97.67	97.86	8614700.0
2003-06-25 16:00:00	SPY	ETF	97.84	97.86	97.52	97.63	3857400.0
2003-06-25 17:00:00	SPY	ETF	97.65	97.69	97.59	97.61	190800.0
2003-06-25 18:00:00	SPY	ETF	97.6	97.62	97.56	97.61	4600.0
2003-06-25 19:00:00	SPY	ETF	97.61	97.63	97.56	97.56	6700.0
2003-06-25 08:00:00	QQQ	ETF	29.7	29.75	29.61	29.65	126800.0
2003-06-25 09:00:00	QQQ	ETF	29.65	29.95	29.61	29.93	7765600.0
2003-06-25 10:00:00	QQQ	ETF	29.91	30.1	29.88	30.07	11952900.0
2003-06-25 11:00:00	QQQ	ETF	30.07	30.18	29.98	30.04	8272400.0
2003-06-25 12:00:00	QQQ	ETF	30.03	30.14	30.01	30.13	2640200.0
2003-06-25 13:00:00	QQQ	ETF	30.12	30.15	29.95	29.974	6026700.0
2003-06-25 14:00:00	QQQ	ETF	29.974	30.14	29.79	29.928	21595600.0
2003-06-25 15:00:00	QQQ	ETF	29.9	29.98	29.49	29.62	21154800.0
2003-06-25 16:00:00	QQQ	ETF	29.623	29.63	29.48	29.51	2148800.0
2003-06-25 17:00:00	QQQ	ETF	29.503	29.54	29.497	29.52	74600.0
2003-06-25 18:00:00	QQQ	ETF	29.51	29.54	29.5	29.53	25500.0
2003-06-25 19:00:00	QQQ	ETF	29.53	29.57	29.52	29.55	14900.0
2003-06-25 20:00:00	QQQ	ETF	29.53	29.53	29.53	29.53	200.0
2003-06-25 09:00:00	IWM	ETF	43.835	44.11	43.835	44.085	481200.0
2003-06-25 10:00:00	IWM	ETF	44.055	44.305	44.055	44.275	305000.0
2003-06-25 11:00:00	IWM	ETF	44.295	44.39	44.28	44.35	598800.0
2003-06-25 12:00:00	IWM	ETF	44.35	44.435	44.33	44.43	190800.0
2003-06-25 13:00:00	IWM	ETF	44.47	44.52	44.34	44.34	380600.0
2003-06-25 14:00:00	IWM	ETF	44.34	44.515	44.095	44.29	1063800.0
2003-06-25 15:00:00	IWM	ETF	44.33	44.425	44.05	44.165	660600.0
2003-06-25 16:00:00	IWM	ETF	44.15	44.15	44.07	44.07	6000.0
2003-06-25 08:00:00	DIA	ETF	91.34	91.34	91.25	91.25	22300.0
2003-06-25 09:00:00	DIA	ETF	91.11	91.52	91.11	91.49	706200.0
2003-06-25 10:00:00	DIA	ETF	91.5	91.73	91.41	91.59	817000.0
2003-06-25 11:00:00	DIA	ETF	91.58	91.71	91.45	91.5	588300.0
2003-06-25 12:00:00	DIA	ETF	91.5	91.59	91.43	91.559	246800.0
2003-06-25 13:00:00	DIA	ETF	91.56	91.6	91.23	91.25	527000.0
2003-06-25 14:00:00	DIA	ETF	91.29	91.54	90.6	91.09	3111900.0
2003-06-25 15:00:00	DIA	ETF	91.124	91.24	90.08	90.26	2325400.0
2003-06-25 16:00:00	DIA	ETF	90.26	90.29	90.06	90.09	127400.0
2003-06-25 17:00:00	DIA	ETF	90.14	90.14	90.12	90.12	1900.0
2003-06-25 19:00:00	DIA	ETF	90.11	90.11	90.11	90.11	200.0
2003-06-25 09:00:00	TLT	ETF	95.42	95.49	95.28	95.28	194600.0
2003-06-25 10:00:00	TLT	ETF	95.28	95.29	94.65	94.7	78300.0
2003-06-25 11:00:00	TLT	ETF	94.74	94.74	94.47	94.6	138800.0
2003-06-25 12:00:00	TLT	ETF	94.57	94.6	94.55	94.58	7000.0
2003-06-25 13:00:00	TLT	ETF	94.59	94.59	94.48	94.54	11100.0
2003-06-25 14:00:00	TLT	ETF	94.55	94.7	93.45	93.78	348300.0

> showing 50 of 416 rows — these rows as CSV

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