PREVIEW / etf_1hour / 2001-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-09.parquet
  size:    12 KB
  rows:    244

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-10-09 09:00:00	SPY	ETF	106.61	106.75	105.87	106.07	2391100.0
2001-10-09 10:00:00	SPY	ETF	106.06	106.68	105.6	106.5	2918900.0
2001-10-09 11:00:00	SPY	ETF	106.46	106.52	105.9	106.05	1662500.0
2001-10-09 12:00:00	SPY	ETF	106.09	106.16	105.66	105.95	1684500.0
2001-10-09 13:00:00	SPY	ETF	105.95	106.33	105.85	106.0	1160300.0
2001-10-09 14:00:00	SPY	ETF	105.97	106.28	105.7	106.05	1181300.0
2001-10-09 15:00:00	SPY	ETF	106.03	106.4	105.62	105.92	2610200.0
2001-10-09 16:00:00	SPY	ETF	105.92	106.25	105.86	106.05	1059800.0
2001-10-09 09:00:00	QQQ	ETF	31.86	32.02	31.25	31.4	9635200.0
2001-10-09 10:00:00	QQQ	ETF	31.43	31.79	31.08	31.66	11538800.0
2001-10-09 11:00:00	QQQ	ETF	31.7	31.71	31.01	31.16	8274100.0
2001-10-09 12:00:00	QQQ	ETF	31.16	31.3	31.05	31.19	5076900.0
2001-10-09 13:00:00	QQQ	ETF	31.18	31.47	31.1	31.27	4839700.0
2001-10-09 14:00:00	QQQ	ETF	31.28	31.38	31.08	31.2	4597100.0
2001-10-09 15:00:00	QQQ	ETF	31.2	31.43	30.87	30.97	9847800.0
2001-10-09 16:00:00	QQQ	ETF	31.0	31.2	30.96	31.15	1527400.0
2001-10-09 17:00:00	QQQ	ETF	31.15	31.25	31.0	31.15	204600.0
2001-10-09 18:00:00	QQQ	ETF	31.15	31.15	31.07	31.1	20100.0
2001-10-09 09:00:00	IWM	ETF	40.825	40.95	40.53	40.6	17400.0
2001-10-09 10:00:00	IWM	ETF	40.53	40.975	40.5	40.895	120800.0
2001-10-09 11:00:00	IWM	ETF	40.805	40.84	40.755	40.755	70000.0
2001-10-09 12:00:00	IWM	ETF	40.725	40.8	40.62	40.785	22800.0
2001-10-09 13:00:00	IWM	ETF	40.795	40.81	40.79	40.81	11400.0
2001-10-09 14:00:00	IWM	ETF	40.7	40.825	40.7	40.8	230400.0
2001-10-09 15:00:00	IWM	ETF	40.8	40.9	40.595	40.715	498600.0
2001-10-09 16:00:00	IWM	ETF	40.725	40.725	40.585	40.585	16200.0
2001-10-09 09:00:00	DIA	ETF	90.99	90.99	90.4	90.54	379300.0
2001-10-09 10:00:00	DIA	ETF	90.5	91.1	90.2	90.8	638900.0
2001-10-09 11:00:00	DIA	ETF	90.8	90.94	90.45	90.6	202800.0
2001-10-09 12:00:00	DIA	ETF	90.56	90.69	90.32	90.62	114800.0
2001-10-09 13:00:00	DIA	ETF	90.65	90.9	90.4	90.55	255900.0
2001-10-09 14:00:00	DIA	ETF	90.5	90.66	90.3	90.4	309900.0
2001-10-09 15:00:00	DIA	ETF	90.46	90.78	90.15	90.57	549200.0
2001-10-09 16:00:00	DIA	ETF	90.53	90.63	90.42	90.54	76400.0
2001-10-09 18:00:00	DIA	ETF	90.54	90.55	90.54	90.55	600.0

> showing 35 of 244 rows — these rows as CSV

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