PREVIEW / etf_1hour / 2001-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-20.parquet
  size:    11 KB
  rows:    214

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-20 09:00:00	SPY	ETF	121.15	121.65	121.08	121.31	1532200.0
2001-07-20 10:00:00	SPY	ETF	121.3	121.94	120.92	121.71	1127700.0
2001-07-20 11:00:00	SPY	ETF	121.65	121.79	121.23	121.46	448900.0
2001-07-20 12:00:00	SPY	ETF	121.49	121.64	121.21	121.39	603600.0
2001-07-20 13:00:00	SPY	ETF	121.43	121.49	121.04	121.33	395300.0
2001-07-20 14:00:00	SPY	ETF	121.29	121.64	121.18	121.5	1022700.0
2001-07-20 15:00:00	SPY	ETF	121.56	121.58	121.27	121.44	1037500.0
2001-07-20 16:00:00	SPY	ETF	121.41	121.47	121.16	121.27	433100.0
2001-07-20 17:00:00	SPY	ETF	121.34	121.34	121.34	121.34	400.0
2001-07-20 09:00:00	QQQ	ETF	41.49	41.85	41.36	41.57	9167700.0
2001-07-20 10:00:00	QQQ	ETF	41.58	42.14	41.4	42.0	12542700.0
2001-07-20 11:00:00	QQQ	ETF	42.0	42.04	41.63	41.76	5058700.0
2001-07-20 12:00:00	QQQ	ETF	41.78	41.93	41.52	41.66	3224700.0
2001-07-20 13:00:00	QQQ	ETF	41.66	41.78	41.5	41.7	3479000.0
2001-07-20 14:00:00	QQQ	ETF	41.67	42.05	41.65	41.9	4509200.0
2001-07-20 15:00:00	QQQ	ETF	41.9	42.0	41.7	41.81	6476200.0
2001-07-20 16:00:00	QQQ	ETF	41.81	41.85	41.65	41.75	1957300.0
2001-07-20 17:00:00	QQQ	ETF	41.75	41.83	41.73	41.78	14300.0
2001-07-20 18:00:00	QQQ	ETF	41.8	41.84	41.75	41.75	7200.0
2001-07-20 09:00:00	IWM	ETF	48.25	48.575	48.25	48.28	98800.0
2001-07-20 10:00:00	IWM	ETF	48.325	48.8	48.305	48.8	68400.0
2001-07-20 11:00:00	IWM	ETF	48.75	48.77	48.58	48.77	168000.0
2001-07-20 12:00:00	IWM	ETF	48.715	48.75	48.555	48.6	84400.0
2001-07-20 13:00:00	IWM	ETF	48.525	48.62	48.455	48.455	63400.0
2001-07-20 14:00:00	IWM	ETF	48.62	48.73	48.56	48.73	55000.0
2001-07-20 15:00:00	IWM	ETF	48.71	48.745	48.585	48.585	75400.0
2001-07-20 16:00:00	IWM	ETF	48.65	48.65	48.5	48.5	13600.0
2001-07-20 09:00:00	DIA	ETF	105.55	105.89	105.41	105.65	399600.0
2001-07-20 10:00:00	DIA	ETF	105.61	106.07	105.36	105.9	174600.0
2001-07-20 11:00:00	DIA	ETF	105.86	105.92	105.52	105.63	77800.0
2001-07-20 12:00:00	DIA	ETF	105.66	105.69	105.43	105.63	26000.0
2001-07-20 13:00:00	DIA	ETF	105.58	105.63	105.35	105.53	192300.0
2001-07-20 14:00:00	DIA	ETF	105.59	105.89	105.45	105.84	171700.0
2001-07-20 15:00:00	DIA	ETF	105.76	105.88	105.62	105.86	107500.0
2001-07-20 16:00:00	DIA	ETF	105.86	105.87	105.77	105.77	43000.0

> showing 35 of 214 rows — these rows as CSV

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