PREVIEW / etf_1hour / 2001-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-02.parquet
  size:    12 KB
  rows:    260

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
2001-10-02 09:00:00	SPY	ETF	104.0	104.53	103.85	104.29	2014600.0
2001-10-02 10:00:00	SPY	ETF	104.25	104.55	103.97	104.4	1818200.0
2001-10-02 11:00:00	SPY	ETF	104.35	104.88	104.28	104.77	1852500.0
2001-10-02 12:00:00	SPY	ETF	104.75	104.83	104.58	104.62	947900.0
2001-10-02 13:00:00	SPY	ETF	104.68	104.7	104.26	104.44	2180900.0
2001-10-02 14:00:00	SPY	ETF	104.44	104.75	103.65	103.73	4716500.0
2001-10-02 15:00:00	SPY	ETF	103.67	105.38	103.65	105.38	4324900.0
2001-10-02 16:00:00	SPY	ETF	105.35	105.7	104.45	105.45	1410200.0
2001-10-02 17:00:00	SPY	ETF	105.45	105.55	105.45	105.55	3400.0
2001-10-02 18:00:00	SPY	ETF	105.55	105.55	105.55	105.55	500.0
2001-10-02 09:00:00	QQQ	ETF	28.65	29.11	28.55	29.1	10200900.0
2001-10-02 10:00:00	QQQ	ETF	29.08	29.29	28.92	29.12	9281300.0
2001-10-02 11:00:00	QQQ	ETF	29.1	29.41	29.05	29.2	8411900.0
2001-10-02 12:00:00	QQQ	ETF	29.22	29.28	29.1	29.12	4385900.0
2001-10-02 13:00:00	QQQ	ETF	29.11	29.15	28.94	29.06	4413900.0
2001-10-02 14:00:00	QQQ	ETF	29.06	29.21	28.4	28.44	20823200.0
2001-10-02 15:00:00	QQQ	ETF	28.45	28.98	28.41	28.85	12994200.0
2001-10-02 16:00:00	QQQ	ETF	28.85	28.89	28.74	28.75	1633200.0
2001-10-02 17:00:00	QQQ	ETF	28.75	28.82	28.7	28.8	79200.0
2001-10-02 18:00:00	QQQ	ETF	28.8	28.86	28.8	28.8	15600.0
2001-10-02 09:00:00	IWM	ETF	39.55	39.925	39.55	39.925	15000.0
2001-10-02 10:00:00	IWM	ETF	39.825	39.925	39.725	39.77	45600.0
2001-10-02 11:00:00	IWM	ETF	39.85	40.04	39.84	39.93	17200.0
2001-10-02 12:00:00	IWM	ETF	39.855	39.93	39.78	39.85	95200.0
2001-10-02 13:00:00	IWM	ETF	39.86	39.87	39.705	39.765	56800.0
2001-10-02 14:00:00	IWM	ETF	39.83	40.0	39.5	40.0	343000.0
2001-10-02 15:00:00	IWM	ETF	39.575	40.115	39.575	40.0	264200.0
2001-10-02 16:00:00	IWM	ETF	40.125	40.185	40.0	40.125	240800.0
2001-10-02 09:00:00	DIA	ETF	88.32	88.93	88.27	88.69	516200.0
2001-10-02 10:00:00	DIA	ETF	88.69	88.78	88.37	88.58	468700.0
2001-10-02 11:00:00	DIA	ETF	88.58	89.0	88.5	88.87	760500.0
2001-10-02 12:00:00	DIA	ETF	88.87	89.0	88.76	88.86	334700.0
2001-10-02 13:00:00	DIA	ETF	88.78	88.88	88.5	88.71	405000.0
2001-10-02 14:00:00	DIA	ETF	88.64	89.0	88.04	88.21	1222100.0
2001-10-02 15:00:00	DIA	ETF	88.08	89.58	88.06	89.58	802500.0
2001-10-02 16:00:00	DIA	ETF	89.55	89.71	89.31	89.55	285100.0
2001-10-02 17:00:00	DIA	ETF	89.6	89.7	89.6	89.6	6400.0
2001-10-02 18:00:00	DIA	ETF	89.6	89.6	89.6	89.6	1500.0

> showing 38 of 260 rows — these rows as CSV

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