PREVIEW / etf_1hour / 2001-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-20.parquet
  size:    12 KB
  rows:    240

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-06-20 09:00:00	SPY	ETF	121.19	122.17	121.1	122.11	1410800.0
2001-06-20 10:00:00	SPY	ETF	122.1	122.73	122.07	122.47	1514800.0
2001-06-20 11:00:00	SPY	ETF	122.42	122.85	121.84	121.91	1419700.0
2001-06-20 12:00:00	SPY	ETF	121.88	122.17	121.67	121.95	524600.0
2001-06-20 13:00:00	SPY	ETF	121.92	122.03	121.41	121.63	557800.0
2001-06-20 14:00:00	SPY	ETF	121.58	122.38	121.55	122.12	719300.0
2001-06-20 15:00:00	SPY	ETF	122.06	122.86	122.06	122.6	1715900.0
2001-06-20 16:00:00	SPY	ETF	122.6	122.74	122.23	122.47	761200.0
2001-06-20 17:00:00	SPY	ETF	122.16	122.16	122.16	122.16	1000.0
2001-06-20 09:00:00	QQQ	ETF	41.3	42.26	41.28	42.18	13347900.0
2001-06-20 10:00:00	QQQ	ETF	42.22	42.62	42.04	42.45	13273400.0
2001-06-20 11:00:00	QQQ	ETF	42.45	42.82	42.15	42.2	10915700.0
2001-06-20 12:00:00	QQQ	ETF	42.19	42.39	42.01	42.07	4370600.0
2001-06-20 13:00:00	QQQ	ETF	42.07	42.13	41.41	41.56	8919300.0
2001-06-20 14:00:00	QQQ	ETF	41.56	42.37	41.52	41.91	13914300.0
2001-06-20 15:00:00	QQQ	ETF	41.93	42.97	41.9	42.92	14204500.0
2001-06-20 16:00:00	QQQ	ETF	42.9	42.95	42.7	42.85	1641200.0
2001-06-20 17:00:00	QQQ	ETF	42.87	42.9	42.78	42.85	69400.0
2001-06-20 18:00:00	QQQ	ETF	42.89	42.92	42.82	42.9	15600.0
2001-06-20 09:00:00	IWM	ETF	48.5	48.875	48.5	48.795	78000.0
2001-06-20 10:00:00	IWM	ETF	48.8	49.125	48.8	49.025	114800.0
2001-06-20 11:00:00	IWM	ETF	49.035	49.19	48.945	49.015	165600.0
2001-06-20 12:00:00	IWM	ETF	49.015	49.015	48.875	48.945	56600.0
2001-06-20 13:00:00	IWM	ETF	48.95	48.955	48.735	48.745	68200.0
2001-06-20 14:00:00	IWM	ETF	48.74	49.075	48.74	49.075	95000.0
2001-06-20 15:00:00	IWM	ETF	49.07	49.55	49.045	49.55	241800.0
2001-06-20 16:00:00	IWM	ETF	49.495	49.5	49.4	49.425	37600.0
2001-06-20 09:00:00	DIA	ETF	105.95	106.6	105.85	106.55	305200.0
2001-06-20 10:00:00	DIA	ETF	106.55	107.14	106.55	106.85	304300.0
2001-06-20 11:00:00	DIA	ETF	106.9	107.14	106.11	106.11	839300.0
2001-06-20 12:00:00	DIA	ETF	106.12	106.34	105.95	106.05	152400.0
2001-06-20 13:00:00	DIA	ETF	106.12	106.23	105.67	105.8	101800.0
2001-06-20 14:00:00	DIA	ETF	105.8	106.4	105.74	106.17	139200.0
2001-06-20 15:00:00	DIA	ETF	106.2	106.85	106.17	106.51	434200.0
2001-06-20 16:00:00	DIA	ETF	106.58	106.73	106.45	106.7	77000.0

> showing 35 of 240 rows — these rows as CSV

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