PREVIEW / etf_1hour / 2001-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-13.parquet
  size:    11 KB
  rows:    219

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-13 09:00:00	SPY	ETF	120.84	121.17	120.7	120.77	1440800.0
2001-07-13 10:00:00	SPY	ETF	120.71	121.68	120.62	121.42	1774800.0
2001-07-13 11:00:00	SPY	ETF	121.42	121.78	121.11	121.59	759300.0
2001-07-13 12:00:00	SPY	ETF	121.65	122.1	121.51	121.91	1019000.0
2001-07-13 13:00:00	SPY	ETF	121.94	122.17	121.81	121.93	548300.0
2001-07-13 14:00:00	SPY	ETF	121.92	122.18	121.76	122.01	563600.0
2001-07-13 15:00:00	SPY	ETF	122.03	122.32	121.48	121.9	3094000.0
2001-07-13 16:00:00	SPY	ETF	121.91	122.24	121.8	122.12	528200.0
2001-07-13 18:00:00	SPY	ETF	122.05	122.05	122.0	122.0	200.0
2001-07-13 09:00:00	QQQ	ETF	43.38	43.54	43.02	43.02	8042100.0
2001-07-13 10:00:00	QQQ	ETF	43.15	43.59	42.9	43.48	11506500.0
2001-07-13 11:00:00	QQQ	ETF	43.48	43.95	43.2	43.86	8835500.0
2001-07-13 12:00:00	QQQ	ETF	43.86	44.1	43.71	44.05	5860300.0
2001-07-13 13:00:00	QQQ	ETF	44.05	44.43	43.91	43.95	7830500.0
2001-07-13 14:00:00	QQQ	ETF	43.96	44.11	43.8	43.88	5538200.0
2001-07-13 15:00:00	QQQ	ETF	43.88	44.05	43.2	43.65	9212300.0
2001-07-13 16:00:00	QQQ	ETF	43.64	43.76	43.15	43.6	1268100.0
2001-07-13 17:00:00	QQQ	ETF	43.6	43.65	43.6	43.65	7700.0
2001-07-13 18:00:00	QQQ	ETF	43.6	43.65	43.5	43.57	5000.0
2001-07-13 09:00:00	IWM	ETF	48.55	48.575	48.35	48.5	15400.0
2001-07-13 10:00:00	IWM	ETF	48.495	48.85	48.435	48.85	11000.0
2001-07-13 11:00:00	IWM	ETF	48.815	48.925	48.675	48.925	11000.0
2001-07-13 12:00:00	IWM	ETF	48.875	48.925	48.875	48.91	34200.0
2001-07-13 13:00:00	IWM	ETF	48.91	48.975	48.865	48.865	29200.0
2001-07-13 14:00:00	IWM	ETF	48.97	48.97	48.845	48.865	31400.0
2001-07-13 15:00:00	IWM	ETF	48.925	49.075	48.725	48.9	62200.0
2001-07-13 09:00:00	DIA	ETF	104.75	105.04	104.55	104.55	370500.0
2001-07-13 10:00:00	DIA	ETF	104.5	105.2	104.4	105.02	236600.0
2001-07-13 11:00:00	DIA	ETF	104.92	105.3	104.71	105.2	115100.0
2001-07-13 12:00:00	DIA	ETF	105.23	105.64	105.1	105.46	179100.0
2001-07-13 13:00:00	DIA	ETF	105.43	105.7	105.29	105.29	84000.0
2001-07-13 14:00:00	DIA	ETF	105.4	105.65	105.31	105.55	43100.0
2001-07-13 15:00:00	DIA	ETF	105.53	105.62	105.1	105.58	95100.0
2001-07-13 16:00:00	DIA	ETF	105.45	105.69	105.45	105.68	61800.0

> showing 34 of 219 rows — these rows as CSV

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