PREVIEW / etf_1hour / 2001-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-29.parquet
  size:    12 KB
  rows:    240

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-29 09:00:00	SPY	ETF	122.8	123.09	122.26	122.96	1151300.0
2001-06-29 10:00:00	SPY	ETF	122.86	123.69	122.84	123.22	2093100.0
2001-06-29 11:00:00	SPY	ETF	123.26	123.52	122.95	123.48	881200.0
2001-06-29 12:00:00	SPY	ETF	123.45	123.78	123.3	123.59	764700.0
2001-06-29 13:00:00	SPY	ETF	123.61	124.0	123.53	123.74	1106800.0
2001-06-29 14:00:00	SPY	ETF	123.7	124.01	123.5	123.65	1103700.0
2001-06-29 15:00:00	SPY	ETF	123.7	123.97	123.0	123.2	1395400.0
2001-06-29 16:00:00	SPY	ETF	123.05	123.48	122.65	122.75	626900.0
2001-06-29 17:00:00	SPY	ETF	122.65	122.78	122.6	122.78	46500.0
2001-06-29 09:00:00	QQQ	ETF	45.09	45.64	44.7	45.47	9791900.0
2001-06-29 10:00:00	QQQ	ETF	45.46	46.05	45.44	45.63	11799700.0
2001-06-29 11:00:00	QQQ	ETF	45.64	45.88	45.42	45.82	5093500.0
2001-06-29 12:00:00	QQQ	ETF	45.84	45.96	45.65	45.93	3870000.0
2001-06-29 13:00:00	QQQ	ETF	45.92	46.52	45.9	46.29	9513900.0
2001-06-29 14:00:00	QQQ	ETF	46.27	46.35	45.82	46.0	7465000.0
2001-06-29 15:00:00	QQQ	ETF	46.0	46.33	45.75	46.0	7182500.0
2001-06-29 16:00:00	QQQ	ETF	45.99	46.39	45.54	45.65	2133500.0
2001-06-29 17:00:00	QQQ	ETF	45.7	45.85	45.7	45.7	242100.0
2001-06-29 09:00:00	IWM	ETF	50.45	50.675	50.225	50.675	140400.0
2001-06-29 10:00:00	IWM	ETF	50.675	50.9	50.625	50.75	296200.0
2001-06-29 11:00:00	IWM	ETF	50.8	50.88	50.605	50.88	44000.0
2001-06-29 12:00:00	IWM	ETF	50.88	51.05	50.755	50.96	39000.0
2001-06-29 13:00:00	IWM	ETF	51.025	51.2	50.975	51.025	62600.0
2001-06-29 14:00:00	IWM	ETF	51.05	51.05	50.75	50.9	228200.0
2001-06-29 15:00:00	IWM	ETF	50.9	51.075	50.46	50.85	381400.0
2001-06-29 16:00:00	IWM	ETF	51.0	51.1	50.625	50.7	114200.0
2001-06-29 17:00:00	IWM	ETF	50.85	50.95	50.75	50.95	953200.0
2001-06-29 09:00:00	DIA	ETF	105.85	105.85	105.38	105.73	238500.0
2001-06-29 10:00:00	DIA	ETF	105.73	106.2	105.69	105.75	546600.0
2001-06-29 11:00:00	DIA	ETF	105.74	105.98	105.48	105.94	63200.0
2001-06-29 12:00:00	DIA	ETF	105.83	106.1	105.52	105.75	61100.0
2001-06-29 13:00:00	DIA	ETF	105.8	106.09	105.74	105.88	93800.0
2001-06-29 14:00:00	DIA	ETF	105.92	106.15	105.7	105.9	69600.0
2001-06-29 15:00:00	DIA	ETF	105.93	106.13	105.16	105.3	354800.0
2001-06-29 16:00:00	DIA	ETF	105.3	105.35	105.2	105.24	55600.0

> showing 35 of 240 rows — these rows as CSV

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