PREVIEW / etf_1hour / 2003-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-29.parquet
  size:    18 KB
  rows:    478

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-10-29 08:00:00	SPY	ETF	104.79	104.83	104.72	104.72	55000.0
2003-10-29 09:00:00	SPY	ETF	104.72	104.98	104.69	104.78	3316400.0
2003-10-29 10:00:00	SPY	ETF	104.82	105.04	104.71	104.89	4278500.0
2003-10-29 11:00:00	SPY	ETF	104.89	104.97	104.75	104.89	2047500.0
2003-10-29 12:00:00	SPY	ETF	104.89	105.13	104.85	105.04	3786900.0
2003-10-29 13:00:00	SPY	ETF	105.04	105.43	104.97	105.14	2755600.0
2003-10-29 14:00:00	SPY	ETF	105.14	105.32	104.75	105.19	5934900.0
2003-10-29 15:00:00	SPY	ETF	105.19	105.32	105.09	105.25	2979200.0
2003-10-29 16:00:00	SPY	ETF	105.25	105.3	104.94	104.96	1404600.0
2003-10-29 17:00:00	SPY	ETF	105.01	105.08	105.007	105.04	30800.0
2003-10-29 18:00:00	SPY	ETF	105.03	105.08	105.02	105.07	6900.0
2003-10-29 19:00:00	SPY	ETF	105.07	105.07	105.06	105.06	5100.0
2003-10-29 08:00:00	QQQ	ETF	35.27	35.27	35.2	35.2	73800.0
2003-10-29 09:00:00	QQQ	ETF	35.2	35.29	35.13	35.182	7850900.0
2003-10-29 10:00:00	QQQ	ETF	35.18	35.35	35.07	35.21	13241500.0
2003-10-29 11:00:00	QQQ	ETF	35.21	35.23	35.087	35.147	4806800.0
2003-10-29 12:00:00	QQQ	ETF	35.14	35.26	35.1	35.16	6135400.0
2003-10-29 13:00:00	QQQ	ETF	35.15	35.4	35.14	35.31	7867600.0
2003-10-29 14:00:00	QQQ	ETF	35.288	35.41	35.16	35.3	9371700.0
2003-10-29 15:00:00	QQQ	ETF	35.32	35.39	35.25	35.3	9121800.0
2003-10-29 16:00:00	QQQ	ETF	35.3	35.33	35.25	35.25	1772200.0
2003-10-29 17:00:00	QQQ	ETF	35.27	35.3	35.24	35.3	200600.0
2003-10-29 18:00:00	QQQ	ETF	35.27	35.28	35.26	35.27	47100.0
2003-10-29 19:00:00	QQQ	ETF	35.27	35.3	35.27	35.3	12400.0
2003-10-29 08:00:00	IWM	ETF	52.46	52.46	52.46	52.46	2000.0
2003-10-29 09:00:00	IWM	ETF	52.385	52.49	52.29	52.465	1291000.0
2003-10-29 10:00:00	IWM	ETF	52.468	52.735	52.45	52.635	2416800.0
2003-10-29 11:00:00	IWM	ETF	52.655	52.68	52.55	52.61	399800.0
2003-10-29 12:00:00	IWM	ETF	52.615	52.8	52.6	52.72	1165200.0
2003-10-29 13:00:00	IWM	ETF	52.715	52.95	52.71	52.875	1199800.0
2003-10-29 14:00:00	IWM	ETF	52.85	52.925	52.635	52.85	700200.0
2003-10-29 15:00:00	IWM	ETF	52.845	53.125	52.835	53.095	1167800.0
2003-10-29 16:00:00	IWM	ETF	53.039	53.078	52.915	53.04	619800.0
2003-10-29 08:00:00	DIA	ETF	97.43	97.43	97.28	97.28	3800.0
2003-10-29 09:00:00	DIA	ETF	97.34	97.58	97.29	97.45	459400.0
2003-10-29 10:00:00	DIA	ETF	97.43	97.74	97.42	97.53	739400.0
2003-10-29 11:00:00	DIA	ETF	97.5	97.69	97.42	97.58	262400.0
2003-10-29 12:00:00	DIA	ETF	97.6	97.77	97.52	97.71	190400.0
2003-10-29 13:00:00	DIA	ETF	97.7	98.02	97.67	97.85	492700.0
2003-10-29 14:00:00	DIA	ETF	97.85	97.99	97.53	97.88	828800.0
2003-10-29 15:00:00	DIA	ETF	97.89	97.97	97.777	97.95	955100.0
2003-10-29 16:00:00	DIA	ETF	97.9	97.97	97.68	97.68	66500.0
2003-10-29 17:00:00	DIA	ETF	97.66	97.67	97.65	97.67	3200.0
2003-10-29 09:00:00	TLT	ETF	85.28	85.35	85.09	85.09	311300.0
2003-10-29 10:00:00	TLT	ETF	85.17	85.25	85.01	85.2	181800.0
2003-10-29 11:00:00	TLT	ETF	85.23	85.3	85.16	85.24	84900.0
2003-10-29 12:00:00	TLT	ETF	85.23	85.31	85.15	85.31	120400.0
2003-10-29 13:00:00	TLT	ETF	85.34	85.34	84.88	85.03	45100.0
2003-10-29 14:00:00	TLT	ETF	85.07	85.2	84.86	84.9	61100.0
2003-10-29 15:00:00	TLT	ETF	84.94	84.96	84.61	84.65	54500.0

> showing 50 of 478 rows — these rows as CSV

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