PREVIEW / etf_1hour / 2001-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-22.parquet
  size:    12 KB
  rows:    243

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-08-22 09:00:00	SPY	ETF	116.75	116.79	116.32	116.74	1425900.0
2001-08-22 10:00:00	SPY	ETF	116.79	116.84	115.98	116.03	2214400.0
2001-08-22 11:00:00	SPY	ETF	116.0	116.54	115.78	116.52	1408700.0
2001-08-22 12:00:00	SPY	ETF	116.52	116.8	116.39	116.47	866300.0
2001-08-22 13:00:00	SPY	ETF	116.47	116.62	116.12	116.15	607600.0
2001-08-22 14:00:00	SPY	ETF	116.14	117.31	116.05	117.15	2117500.0
2001-08-22 15:00:00	SPY	ETF	117.19	117.43	116.56	117.05	1820900.0
2001-08-22 16:00:00	SPY	ETF	117.04	117.4	116.81	117.0	672800.0
2001-08-22 17:00:00	SPY	ETF	117.2	117.2	117.2	117.2	500.0
2001-08-22 09:00:00	QQQ	ETF	37.45	37.49	37.06	37.33	9127100.0
2001-08-22 10:00:00	QQQ	ETF	37.33	37.4	36.74	36.74	11310200.0
2001-08-22 11:00:00	QQQ	ETF	36.8	37.08	36.54	37.08	9365800.0
2001-08-22 12:00:00	QQQ	ETF	37.04	37.22	36.91	36.97	4845100.0
2001-08-22 13:00:00	QQQ	ETF	36.96	37.08	36.67	36.67	4379900.0
2001-08-22 14:00:00	QQQ	ETF	36.66	37.61	36.56	37.55	8751700.0
2001-08-22 15:00:00	QQQ	ETF	37.56	37.84	37.31	37.69	11471400.0
2001-08-22 16:00:00	QQQ	ETF	37.7	37.78	37.06	37.77	2946100.0
2001-08-22 17:00:00	QQQ	ETF	37.72	37.85	37.7	37.78	76600.0
2001-08-22 18:00:00	QQQ	ETF	37.74	37.9	37.74	37.9	45600.0
2001-08-22 09:00:00	IWM	ETF	47.45	47.525	47.35	47.445	29800.0
2001-08-22 10:00:00	IWM	ETF	47.375	47.425	47.125	47.125	83000.0
2001-08-22 11:00:00	IWM	ETF	47.055	47.55	46.89	47.15	238000.0
2001-08-22 12:00:00	IWM	ETF	47.095	47.245	47.095	47.195	50800.0
2001-08-22 13:00:00	IWM	ETF	47.125	47.165	47.04	47.04	244600.0
2001-08-22 14:00:00	IWM	ETF	47.025	47.42	47.025	47.385	148000.0
2001-08-22 15:00:00	IWM	ETF	47.37	47.65	47.37	47.55	467600.0
2001-08-22 16:00:00	IWM	ETF	47.675	47.675	47.65	47.65	5800.0
2001-08-22 09:00:00	DIA	ETF	102.2	102.3	101.92	102.25	817100.0
2001-08-22 10:00:00	DIA	ETF	102.26	102.32	101.58	101.7	1083100.0
2001-08-22 11:00:00	DIA	ETF	101.67	102.39	101.45	102.36	514000.0
2001-08-22 12:00:00	DIA	ETF	102.35	102.65	102.23	102.28	468200.0
2001-08-22 13:00:00	DIA	ETF	102.28	102.42	101.93	102.02	353000.0
2001-08-22 14:00:00	DIA	ETF	101.97	103.15	101.93	103.01	1222400.0
2001-08-22 15:00:00	DIA	ETF	103.03	103.23	102.5	102.92	764000.0
2001-08-22 16:00:00	DIA	ETF	102.92	102.99	102.8	102.8	170400.0
2001-08-22 17:00:00	DIA	ETF	102.85	102.85	102.85	102.85	100.0
2001-08-22 18:00:00	DIA	ETF	102.85	102.85	102.85	102.85	300.0

> showing 37 of 243 rows — these rows as CSV

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