PREVIEW / etf_1hour / 2003-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-02.parquet
  size:    18 KB
  rows:    445

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-09-02 08:00:00	SPY	ETF	101.76	101.76	101.65	101.71	26300.0
2003-09-02 09:00:00	SPY	ETF	101.72	101.93	101.58	101.73	4870200.0
2003-09-02 10:00:00	SPY	ETF	101.75	101.85	101.06	101.4	7272300.0
2003-09-02 11:00:00	SPY	ETF	101.36	101.78	101.36	101.5	3575700.0
2003-09-02 12:00:00	SPY	ETF	101.5	102.14	101.48	101.92	4417300.0
2003-09-02 13:00:00	SPY	ETF	101.95	102.04	101.63	101.69	2776900.0
2003-09-02 14:00:00	SPY	ETF	101.7	102.52	101.65	102.5	7097700.0
2003-09-02 15:00:00	SPY	ETF	102.493	102.88	102.46	102.77	8284700.0
2003-09-02 16:00:00	SPY	ETF	102.8	102.99	102.7	102.88	2366400.0
2003-09-02 17:00:00	SPY	ETF	102.88	102.89	102.82	102.87	1421200.0
2003-09-02 18:00:00	SPY	ETF	102.87	102.96	102.87	102.92	23100.0
2003-09-02 19:00:00	SPY	ETF	102.86	102.9	102.85	102.9	2500.0
2003-09-02 08:00:00	QQQ	ETF	33.61	33.61	33.52	33.53	145900.0
2003-09-02 09:00:00	QQQ	ETF	33.54	33.625	33.41	33.488	9698200.0
2003-09-02 10:00:00	QQQ	ETF	33.499	33.55	33.13	33.32	15384600.0
2003-09-02 11:00:00	QQQ	ETF	33.31	33.45	33.28	33.3	6590800.0
2003-09-02 12:00:00	QQQ	ETF	33.301	33.54	33.3	33.41	5698600.0
2003-09-02 13:00:00	QQQ	ETF	33.43	33.497	33.36	33.38	5104900.0
2003-09-02 14:00:00	QQQ	ETF	33.38	33.68	33.37	33.67	12359500.0
2003-09-02 15:00:00	QQQ	ETF	33.67	33.86	33.65	33.829	16732600.0
2003-09-02 16:00:00	QQQ	ETF	33.83	33.929	33.79	33.91	2158500.0
2003-09-02 17:00:00	QQQ	ETF	33.91	33.93	33.875	33.888	371500.0
2003-09-02 18:00:00	QQQ	ETF	33.88	33.92	33.87	33.87	29700.0
2003-09-02 19:00:00	QQQ	ETF	33.87	33.93	33.87	33.92	12400.0
2003-09-02 08:00:00	IWM	ETF	49.695	49.695	49.695	49.695	400.0
2003-09-02 09:00:00	IWM	ETF	49.875	49.965	49.725	49.8	1058600.0
2003-09-02 10:00:00	IWM	ETF	49.8	49.9	49.55	49.84	1124800.0
2003-09-02 11:00:00	IWM	ETF	49.825	50.01	49.8	49.91	242200.0
2003-09-02 12:00:00	IWM	ETF	49.915	50.225	49.915	50.18	489000.0
2003-09-02 13:00:00	IWM	ETF	50.195	50.325	50.175	50.28	334600.0
2003-09-02 14:00:00	IWM	ETF	50.255	50.525	50.255	50.48	1176800.0
2003-09-02 15:00:00	IWM	ETF	50.495	50.7	50.475	50.65	869200.0
2003-09-02 16:00:00	IWM	ETF	50.725	50.8	50.65	50.8	660200.0
2003-09-02 08:00:00	DIA	ETF	94.7	94.7	94.45	94.45	1800.0
2003-09-02 09:00:00	DIA	ETF	94.48	94.89	94.19	94.63	1015700.0
2003-09-02 10:00:00	DIA	ETF	94.64	94.72	94.07	94.35	830600.0
2003-09-02 11:00:00	DIA	ETF	94.32	94.78	94.32	94.37	400300.0
2003-09-02 12:00:00	DIA	ETF	94.39	94.93	94.37	94.72	432900.0
2003-09-02 13:00:00	DIA	ETF	94.71	94.82	94.45	94.48	294800.0
2003-09-02 14:00:00	DIA	ETF	94.48	95.22	94.48	95.21	834600.0
2003-09-02 15:00:00	DIA	ETF	95.2	95.6	95.16	95.5	1407100.0
2003-09-02 16:00:00	DIA	ETF	95.48	95.55	95.43	95.55	188800.0
2003-09-02 17:00:00	DIA	ETF	95.55	95.57	94.3583	95.56	39400.0
2003-09-02 18:00:00	DIA	ETF	95.57	95.57	95.57	95.57	100.0
2003-09-02 19:00:00	DIA	ETF	95.55	95.58	95.55	95.58	600.0
2003-09-02 09:00:00	TLT	ETF	83.63	83.65	82.55	82.75	68200.0
2003-09-02 10:00:00	TLT	ETF	82.84	83.27	82.7	83.2	188900.0
2003-09-02 11:00:00	TLT	ETF	83.19	83.19	82.71	82.78	78700.0
2003-09-02 12:00:00	TLT	ETF	82.85	82.85	82.5	82.58	73100.0
2003-09-02 13:00:00	TLT	ETF	82.62	82.63	82.33	82.6	51300.0

> showing 50 of 445 rows — these rows as CSV

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