PREVIEW / etf_1hour / 2001-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-02-23.parquet
  size:    11 KB
  rows:    212

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-02-23 09:00:00	SPY	ETF	125.08	125.24	124.16	124.21	1786400.0
2001-02-23 10:00:00	SPY	ETF	124.4	124.78	123.35	123.59	2973100.0
2001-02-23 11:00:00	SPY	ETF	123.88	124.29	123.2	123.54	2080900.0
2001-02-23 12:00:00	SPY	ETF	123.51	123.66	122.53	122.96	1421700.0
2001-02-23 13:00:00	SPY	ETF	122.99	123.01	121.8	122.02	1847100.0
2001-02-23 14:00:00	SPY	ETF	122.0	123.7	121.81	123.23	1823200.0
2001-02-23 15:00:00	SPY	ETF	123.2	125.54	123.0	124.89	3026000.0
2001-02-23 16:00:00	SPY	ETF	124.98	125.1	122.46	125.0	2918200.0
2001-02-23 17:00:00	SPY	ETF	124.8	125.0	124.12	124.12	1763700.0
2001-02-23 09:00:00	QQQ	ETF	50.09	50.62	49.48	49.79	10163300.0
2001-02-23 10:00:00	QQQ	ETF	49.66	50.18	48.7	49.15	14020700.0
2001-02-23 11:00:00	QQQ	ETF	49.11	49.8	48.85	49.25	7898300.0
2001-02-23 12:00:00	QQQ	ETF	49.25	49.35	48.4	48.85	12022900.0
2001-02-23 13:00:00	QQQ	ETF	48.85	48.99	48.25	48.52	6803500.0
2001-02-23 14:00:00	QQQ	ETF	48.52	50.08	48.36	49.55	17057000.0
2001-02-23 15:00:00	QQQ	ETF	49.6	51.6	49.42	51.26	18994300.0
2001-02-23 16:00:00	QQQ	ETF	51.3	51.55	49.85	51.45	2193500.0
2001-02-23 17:00:00	QQQ	ETF	51.45	51.68	51.3	51.5	82100.0
2001-02-23 18:00:00	QQQ	ETF	51.55	51.9	51.5	51.65	26100.0
2001-02-23 09:00:00	IWM	ETF	47.4	47.4	47.1	47.29	20000.0
2001-02-23 10:00:00	IWM	ETF	47.1	47.29	46.525	46.705	52400.0
2001-02-23 11:00:00	IWM	ETF	46.705	46.8	46.65	46.775	16200.0
2001-02-23 12:00:00	IWM	ETF	46.7	46.7	46.25	46.545	13000.0
2001-02-23 13:00:00	IWM	ETF	46.545	46.545	46.225	46.225	13600.0
2001-02-23 14:00:00	IWM	ETF	46.425	46.8	46.3	46.795	27000.0
2001-02-23 15:00:00	IWM	ETF	46.8	47.75	46.8	47.725	212800.0
2001-02-23 16:00:00	IWM	ETF	47.625	47.625	47.6	47.6	10800.0
2001-02-23 09:00:00	DIA	ETF	105.1	105.2	104.45	104.45	210600.0
2001-02-23 10:00:00	DIA	ETF	104.4	104.99	104.0	104.4	337000.0
2001-02-23 11:00:00	DIA	ETF	104.45	104.7	103.9	104.0	162300.0
2001-02-23 12:00:00	DIA	ETF	103.95	104.09	103.38	103.85	238300.0
2001-02-23 13:00:00	DIA	ETF	103.61	103.75	103.0	103.4	308100.0
2001-02-23 14:00:00	DIA	ETF	103.35	104.15	103.09	103.8	521400.0
2001-02-23 15:00:00	DIA	ETF	103.64	105.12	103.55	104.59	565300.0
2001-02-23 16:00:00	DIA	ETF	104.59	104.74	103.3	104.55	110200.0

> showing 35 of 212 rows — these rows as CSV

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