PREVIEW / etf_1hour / 2001-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-16.parquet
  size:    12 KB
  rows:    232

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-16 09:00:00	SPY	ETF	121.77	122.28	121.77	121.83	1205400.0
2001-07-16 10:00:00	SPY	ETF	121.76	121.95	121.43	121.85	804600.0
2001-07-16 11:00:00	SPY	ETF	121.79	122.06	121.35	121.41	353000.0
2001-07-16 12:00:00	SPY	ETF	121.41	121.46	121.03	121.06	426800.0
2001-07-16 13:00:00	SPY	ETF	121.11	121.12	120.43	120.53	668400.0
2001-07-16 14:00:00	SPY	ETF	120.6	120.85	120.32	120.73	1039700.0
2001-07-16 15:00:00	SPY	ETF	120.74	120.89	120.29	120.6	1521300.0
2001-07-16 16:00:00	SPY	ETF	120.51	121.1	120.44	120.85	625500.0
2001-07-16 17:00:00	SPY	ETF	120.64	120.64	120.31	120.35	2200.0
2001-07-16 09:00:00	QQQ	ETF	43.37	43.86	43.23	43.25	6039500.0
2001-07-16 10:00:00	QQQ	ETF	43.24	43.53	43.11	43.4	8385700.0
2001-07-16 11:00:00	QQQ	ETF	43.4	43.64	42.95	42.95	5712700.0
2001-07-16 12:00:00	QQQ	ETF	42.95	43.03	42.31	42.35	6701200.0
2001-07-16 13:00:00	QQQ	ETF	42.35	42.39	42.01	42.26	5844100.0
2001-07-16 14:00:00	QQQ	ETF	42.27	42.55	42.1	42.27	6772600.0
2001-07-16 15:00:00	QQQ	ETF	42.26	42.44	41.9	42.0	9822600.0
2001-07-16 16:00:00	QQQ	ETF	42.0	42.59	41.92	42.18	2125300.0
2001-07-16 17:00:00	QQQ	ETF	42.17	42.17	41.92	41.93	193500.0
2001-07-16 18:00:00	QQQ	ETF	41.97	42.0	41.75	41.9	25900.0
2001-07-16 09:00:00	IWM	ETF	48.85	48.995	48.845	48.845	26000.0
2001-07-16 10:00:00	IWM	ETF	48.775	48.775	48.55	48.75	20000.0
2001-07-16 11:00:00	IWM	ETF	48.845	48.885	48.695	48.745	42800.0
2001-07-16 12:00:00	IWM	ETF	48.695	48.7	48.5	48.52	41000.0
2001-07-16 13:00:00	IWM	ETF	48.6	48.6	48.395	48.415	110600.0
2001-07-16 14:00:00	IWM	ETF	48.45	48.48	48.33	48.45	135200.0
2001-07-16 15:00:00	IWM	ETF	48.455	48.48	48.15	48.255	82000.0
2001-07-16 16:00:00	IWM	ETF	48.075	48.25	48.075	48.075	33600.0
2001-07-16 09:00:00	DIA	ETF	105.46	105.75	105.45	105.52	97600.0
2001-07-16 10:00:00	DIA	ETF	105.5	105.74	105.31	105.7	141500.0
2001-07-16 11:00:00	DIA	ETF	105.65	105.84	105.41	105.57	113200.0
2001-07-16 12:00:00	DIA	ETF	105.49	105.61	105.28	105.33	111800.0
2001-07-16 13:00:00	DIA	ETF	105.36	105.36	104.72	104.75	136100.0
2001-07-16 14:00:00	DIA	ETF	104.77	105.0	104.57	104.88	107100.0
2001-07-16 15:00:00	DIA	ETF	104.89	104.99	104.6	104.82	92200.0
2001-07-16 16:00:00	DIA	ETF	104.87	105.05	104.86	105.05	79000.0

> showing 35 of 232 rows — these rows as CSV

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