PREVIEW / etf_1hour / 2001-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-08.parquet
  size:    12 KB
  rows:    244

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-08 09:00:00	SPY	ETF	106.27	106.7	105.93	106.67	2172700.0
2001-10-08 10:00:00	SPY	ETF	106.65	107.21	105.87	106.84	3018600.0
2001-10-08 11:00:00	SPY	ETF	106.85	107.3	106.57	106.79	1424400.0
2001-10-08 12:00:00	SPY	ETF	106.9	106.9	106.46	106.6	674500.0
2001-10-08 13:00:00	SPY	ETF	106.52	106.88	106.41	106.63	614000.0
2001-10-08 14:00:00	SPY	ETF	106.7	106.8	106.07	106.12	1559500.0
2001-10-08 15:00:00	SPY	ETF	106.05	106.68	105.93	106.53	1834200.0
2001-10-08 16:00:00	SPY	ETF	106.51	106.7	106.47	106.54	1223700.0
2001-10-08 17:00:00	SPY	ETF	106.55	106.55	106.53	106.53	1400.0
2001-10-08 18:00:00	SPY	ETF	106.45	106.45	106.45	106.45	100.0
2001-10-08 09:00:00	QQQ	ETF	31.13	31.97	30.96	31.94	13235600.0
2001-10-08 10:00:00	QQQ	ETF	31.93	32.31	31.4	31.99	15692600.0
2001-10-08 11:00:00	QQQ	ETF	31.98	32.35	31.87	32.01	8528900.0
2001-10-08 12:00:00	QQQ	ETF	31.95	32.09	31.72	31.88	5714500.0
2001-10-08 13:00:00	QQQ	ETF	31.88	32.25	31.78	32.07	6372100.0
2001-10-08 14:00:00	QQQ	ETF	32.06	32.13	31.5	31.5	7328800.0
2001-10-08 15:00:00	QQQ	ETF	31.51	31.95	31.44	31.85	6767900.0
2001-10-08 16:00:00	QQQ	ETF	31.87	31.98	31.81	31.9	1428400.0
2001-10-08 17:00:00	QQQ	ETF	31.91	32.0	31.85	31.93	63700.0
2001-10-08 18:00:00	QQQ	ETF	31.92	32.0	31.87	31.95	15600.0
2001-10-08 09:00:00	IWM	ETF	40.75	41.105	40.75	41.105	57800.0
2001-10-08 10:00:00	IWM	ETF	41.025	41.395	41.025	41.25	34000.0
2001-10-08 11:00:00	IWM	ETF	41.24	41.335	41.24	41.265	5800.0
2001-10-08 12:00:00	IWM	ETF	41.215	41.215	41.155	41.155	1400.0
2001-10-08 13:00:00	IWM	ETF	41.16	41.2	41.105	41.2	25400.0
2001-10-08 14:00:00	IWM	ETF	41.1	41.1	40.875	40.875	52800.0
2001-10-08 15:00:00	IWM	ETF	40.8	41.04	40.75	40.925	149000.0
2001-10-08 16:00:00	IWM	ETF	41.005	41.005	40.925	40.925	3600.0
2001-10-08 09:00:00	DIA	ETF	90.2	90.84	90.05	90.74	661400.0
2001-10-08 10:00:00	DIA	ETF	90.8	91.55	90.21	91.2	1369400.0
2001-10-08 11:00:00	DIA	ETF	91.21	91.62	91.0	91.28	1242700.0
2001-10-08 12:00:00	DIA	ETF	91.25	91.25	90.85	90.92	290500.0
2001-10-08 13:00:00	DIA	ETF	90.92	91.1	90.75	90.92	144100.0
2001-10-08 14:00:00	DIA	ETF	90.91	91.03	90.44	90.48	306000.0
2001-10-08 15:00:00	DIA	ETF	90.41	90.88	90.35	90.75	504500.0
2001-10-08 16:00:00	DIA	ETF	90.77	90.85	90.5	90.5	53400.0

> showing 36 of 244 rows — these rows as CSV

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