PREVIEW / etf_1hour / 2001-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-26.parquet
  size:    12 KB
  rows:    231

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-26 09:00:00	SPY	ETF	120.9	121.39	120.57	121.34	1347700.0
2001-06-26 10:00:00	SPY	ETF	121.31	121.69	120.78	120.97	1527700.0
2001-06-26 11:00:00	SPY	ETF	120.95	121.29	120.65	120.81	688900.0
2001-06-26 12:00:00	SPY	ETF	120.88	121.26	120.73	121.26	536000.0
2001-06-26 13:00:00	SPY	ETF	121.17	122.14	121.17	122.0	1586800.0
2001-06-26 14:00:00	SPY	ETF	122.0	122.39	121.9	121.98	1053200.0
2001-06-26 15:00:00	SPY	ETF	121.96	122.21	121.73	121.84	655300.0
2001-06-26 16:00:00	SPY	ETF	121.82	121.87	121.16	121.6	308000.0
2001-06-26 17:00:00	SPY	ETF	121.6	121.6	121.6	121.6	200.0
2001-06-26 18:00:00	SPY	ETF	121.11	121.65	121.11	121.65	1000.0
2001-06-26 09:00:00	QQQ	ETF	42.54	43.15	42.48	43.13	8660000.0
2001-06-26 10:00:00	QQQ	ETF	43.09	43.29	42.64	42.76	9816400.0
2001-06-26 11:00:00	QQQ	ETF	42.76	43.03	42.5	42.63	4114200.0
2001-06-26 12:00:00	QQQ	ETF	42.64	42.85	42.6	42.82	2366000.0
2001-06-26 13:00:00	QQQ	ETF	42.83	43.55	42.76	43.55	8882900.0
2001-06-26 14:00:00	QQQ	ETF	43.47	43.85	43.45	43.51	8226600.0
2001-06-26 15:00:00	QQQ	ETF	43.51	43.89	43.45	43.6	7091900.0
2001-06-26 16:00:00	QQQ	ETF	43.65	43.75	43.29	43.38	2762900.0
2001-06-26 17:00:00	QQQ	ETF	43.39	43.6	43.37	43.5	84400.0
2001-06-26 18:00:00	QQQ	ETF	43.5	43.59	43.5	43.59	5500.0
2001-06-26 09:00:00	IWM	ETF	48.0	48.205	47.925	48.2	122400.0
2001-06-26 10:00:00	IWM	ETF	48.25	48.375	48.25	48.3	152000.0
2001-06-26 11:00:00	IWM	ETF	48.345	48.5	48.3	48.425	74600.0
2001-06-26 12:00:00	IWM	ETF	48.415	48.5	48.415	48.5	82200.0
2001-06-26 13:00:00	IWM	ETF	48.55	48.915	48.55	48.905	136200.0
2001-06-26 14:00:00	IWM	ETF	48.935	49.05	48.9	48.975	212800.0
2001-06-26 15:00:00	IWM	ETF	48.86	48.995	48.825	48.995	134000.0
2001-06-26 16:00:00	IWM	ETF	48.935	49.0	48.935	49.0	59000.0
2001-06-26 09:00:00	DIA	ETF	104.6	104.68	104.15	104.48	432600.0
2001-06-26 10:00:00	DIA	ETF	104.64	104.86	104.13	104.24	284900.0
2001-06-26 11:00:00	DIA	ETF	104.28	104.43	104.01	104.21	159300.0
2001-06-26 12:00:00	DIA	ETF	104.13	104.72	104.13	104.6	101900.0
2001-06-26 13:00:00	DIA	ETF	104.54	105.37	104.54	105.25	436000.0
2001-06-26 14:00:00	DIA	ETF	105.26	105.5	105.05	105.16	480200.0
2001-06-26 15:00:00	DIA	ETF	105.16	105.29	104.71	104.75	405100.0
2001-06-26 16:00:00	DIA	ETF	104.7	104.85	104.59	104.84	100900.0

> showing 36 of 231 rows — these rows as CSV

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