PREVIEW / etf_1hour / 2003-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-26.parquet
  size:    19 KB
  rows:    480

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-11-26 08:00:00	SPY	ETF	106.39	106.5	106.34	106.38	123100.0
2003-11-26 09:00:00	SPY	ETF	106.4	106.46	106.06	106.16	3718900.0
2003-11-26 10:00:00	SPY	ETF	106.14	106.33	105.6	105.68	6159700.0
2003-11-26 11:00:00	SPY	ETF	105.65	105.77	105.39	105.72	5830300.0
2003-11-26 12:00:00	SPY	ETF	105.7	106.15	105.7	106.14	3379600.0
2003-11-26 13:00:00	SPY	ETF	106.14	106.2	106.01	106.18	2383900.0
2003-11-26 14:00:00	SPY	ETF	106.2	106.43	106.17	106.29	3191600.0
2003-11-26 15:00:00	SPY	ETF	106.28	106.45	106.17	106.38	2419000.0
2003-11-26 16:00:00	SPY	ETF	106.4	106.44	106.3	106.33	1343800.0
2003-11-26 17:00:00	SPY	ETF	106.32	106.35	106.27	106.35	47700.0
2003-11-26 18:00:00	SPY	ETF	106.32	106.3203	106.3	106.3	6700.0
2003-11-26 19:00:00	SPY	ETF	106.27	106.32	106.27	106.32	1700.0
2003-11-26 08:00:00	QQQ	ETF	35.4	35.48	35.38	35.44	229600.0
2003-11-26 09:00:00	QQQ	ETF	35.44	35.52	35.34	35.381	9917900.0
2003-11-26 10:00:00	QQQ	ETF	35.36	35.44	34.83	34.87	17397300.0
2003-11-26 11:00:00	QQQ	ETF	34.87	35.01	34.81	34.97	8964100.0
2003-11-26 12:00:00	QQQ	ETF	34.97	35.2	34.95	35.179	5648000.0
2003-11-26 13:00:00	QQQ	ETF	35.18	35.22	35.05	35.162	4425000.0
2003-11-26 14:00:00	QQQ	ETF	35.167	35.3	35.15	35.18	5857800.0
2003-11-26 15:00:00	QQQ	ETF	35.18	35.32	35.08	35.278	8758200.0
2003-11-26 16:00:00	QQQ	ETF	35.28	35.356	35.1987	35.32	1531400.0
2003-11-26 17:00:00	QQQ	ETF	35.33	35.35	35.29	35.34	43800.0
2003-11-26 18:00:00	QQQ	ETF	35.32	35.34	35.31	35.32	20200.0
2003-11-26 19:00:00	QQQ	ETF	35.33	35.35	35.3	35.34	7700.0
2003-11-26 20:00:00	QQQ	ETF	35.35	35.36	35.35	35.36	2600.0
2003-11-26 09:00:00	IWM	ETF	54.55	54.745	54.457	54.59	442000.0
2003-11-26 10:00:00	IWM	ETF	54.6	54.67	53.895	53.9	1178800.0
2003-11-26 11:00:00	IWM	ETF	53.895	54.025	53.775	54.02	971000.0
2003-11-26 12:00:00	IWM	ETF	54.02	54.305	54.02	54.3	689800.0
2003-11-26 13:00:00	IWM	ETF	54.305	54.325	54.195	54.295	227000.0
2003-11-26 14:00:00	IWM	ETF	54.3	54.5	54.285	54.405	275400.0
2003-11-26 15:00:00	IWM	ETF	54.405	54.4955	54.315	54.465	752600.0
2003-11-26 16:00:00	IWM	ETF	54.455	54.54	54.435	54.465	254000.0
2003-11-26 18:00:00	IWM	ETF	54.465	54.465	54.465	54.465	200.0
2003-11-26 08:00:00	DIA	ETF	98.08	98.15	98.08	98.15	2900.0
2003-11-26 09:00:00	DIA	ETF	98.08	98.15	97.74	97.81	420000.0
2003-11-26 10:00:00	DIA	ETF	97.81	97.94	97.33	97.4	927200.0
2003-11-26 11:00:00	DIA	ETF	97.39	97.5	97.15	97.42	430800.0
2003-11-26 12:00:00	DIA	ETF	97.42	97.68	97.4	97.68	193800.0
2003-11-26 13:00:00	DIA	ETF	97.7	97.8	97.61	97.79	236600.0
2003-11-26 14:00:00	DIA	ETF	97.8	97.99	97.74	97.85	672100.0
2003-11-26 15:00:00	DIA	ETF	97.83	98.05	97.74	97.9	589800.0
2003-11-26 16:00:00	DIA	ETF	97.9	97.99	97.82	97.88	125500.0
2003-11-26 17:00:00	DIA	ETF	97.88	97.88	97.88	97.88	100.0
2003-11-26 18:00:00	DIA	ETF	97.88	97.88	97.77	97.77	1300.0
2003-11-26 19:00:00	DIA	ETF	97.77	97.8	97.77	97.8	1300.0
2003-11-26 09:00:00	TLT	ETF	86.1	86.1	86.0	86.0	37100.0
2003-11-26 10:00:00	TLT	ETF	85.99	86.4	85.99	86.35	447400.0
2003-11-26 11:00:00	TLT	ETF	86.35	86.35	86.02	86.04	29700.0
2003-11-26 12:00:00	TLT	ETF	86.05	86.05	85.85	85.88	13900.0

> showing 50 of 480 rows — these rows as CSV

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