PREVIEW / etf_1hour / 2001-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-02.parquet
  size:    11 KB
  rows:    228

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-07-02 09:00:00	SPY	ETF	122.8	123.04	122.62	122.8	1341000.0
2001-07-02 10:00:00	SPY	ETF	122.86	123.59	122.78	123.47	1251400.0
2001-07-02 11:00:00	SPY	ETF	123.46	124.32	123.4	124.26	1563100.0
2001-07-02 12:00:00	SPY	ETF	124.23	124.25	123.75	123.8	674400.0
2001-07-02 13:00:00	SPY	ETF	123.88	124.25	123.84	123.86	509900.0
2001-07-02 14:00:00	SPY	ETF	123.94	124.17	123.83	124.03	375900.0
2001-07-02 15:00:00	SPY	ETF	124.01	124.22	123.53	123.9	1848300.0
2001-07-02 16:00:00	SPY	ETF	123.89	124.19	123.53	124.05	529400.0
2001-07-02 17:00:00	SPY	ETF	123.97	124.13	123.97	124.13	1300.0
2001-07-02 18:00:00	SPY	ETF	124.0	124.0	124.0	124.0	100.0
2001-07-02 09:00:00	QQQ	ETF	45.65	45.76	45.26	45.56	5888600.0
2001-07-02 10:00:00	QQQ	ETF	45.58	46.2	45.45	46.0	11082200.0
2001-07-02 11:00:00	QQQ	ETF	46.01	46.48	45.96	46.35	9705600.0
2001-07-02 12:00:00	QQQ	ETF	46.36	46.36	45.84	45.94	3978100.0
2001-07-02 13:00:00	QQQ	ETF	45.93	46.1	45.7	45.76	3683900.0
2001-07-02 14:00:00	QQQ	ETF	45.78	46.01	45.65	45.89	3640100.0
2001-07-02 15:00:00	QQQ	ETF	45.9	46.11	45.19	45.48	8884300.0
2001-07-02 16:00:00	QQQ	ETF	45.45	45.69	45.35	45.4	2002300.0
2001-07-02 17:00:00	QQQ	ETF	45.39	45.61	45.3	45.45	71100.0
2001-07-02 18:00:00	QQQ	ETF	45.43	45.53	45.42	45.44	11300.0
2001-07-02 09:00:00	IWM	ETF	50.8	50.8	50.07	50.075	263800.0
2001-07-02 10:00:00	IWM	ETF	50.15	50.4	50.15	50.2	442600.0
2001-07-02 11:00:00	IWM	ETF	50.2	50.425	50.2	50.32	318200.0
2001-07-02 12:00:00	IWM	ETF	50.3	50.3	49.8	49.8	361400.0
2001-07-02 13:00:00	IWM	ETF	49.85	50.05	49.825	49.88	99200.0
2001-07-02 14:00:00	IWM	ETF	49.875	49.985	49.75	49.875	240000.0
2001-07-02 15:00:00	IWM	ETF	49.95	50.045	49.685	49.685	306000.0
2001-07-02 16:00:00	IWM	ETF	49.655	49.8	49.655	49.8	18600.0
2001-07-02 09:00:00	DIA	ETF	104.78	105.0	104.55	104.92	389900.0
2001-07-02 10:00:00	DIA	ETF	104.95	105.81	104.85	105.68	326700.0
2001-07-02 11:00:00	DIA	ETF	105.7	106.58	105.63	106.43	364200.0
2001-07-02 12:00:00	DIA	ETF	106.42	106.43	106.06	106.21	99000.0
2001-07-02 13:00:00	DIA	ETF	106.23	106.47	106.2	106.2	61800.0
2001-07-02 14:00:00	DIA	ETF	106.2	106.31	106.05	106.11	35800.0
2001-07-02 15:00:00	DIA	ETF	106.14	106.36	105.77	105.9	177500.0
2001-07-02 16:00:00	DIA	ETF	105.96	106.21	105.9	106.21	134000.0

> showing 36 of 228 rows — these rows as CSV

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