PREVIEW / etf_1hour / 2001-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-06.parquet
  size:    11 KB
  rows:    217

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-06 09:00:00	SPY	ETF	121.35	121.51	121.23	121.25	710900.0
2001-08-06 10:00:00	SPY	ETF	121.24	121.51	120.68	120.84	1521300.0
2001-08-06 11:00:00	SPY	ETF	120.83	121.03	120.71	120.8	1098400.0
2001-08-06 12:00:00	SPY	ETF	120.77	120.84	120.37	120.53	1031200.0
2001-08-06 13:00:00	SPY	ETF	120.53	120.68	120.36	120.56	701600.0
2001-08-06 14:00:00	SPY	ETF	120.57	120.59	120.1	120.36	828300.0
2001-08-06 15:00:00	SPY	ETF	120.36	120.53	120.15	120.45	1465400.0
2001-08-06 16:00:00	SPY	ETF	120.42	121.35	120.0	120.1	811800.0
2001-08-06 17:00:00	SPY	ETF	119.91	120.39	119.91	120.39	600.0
2001-08-06 09:00:00	QQQ	ETF	42.53	42.83	42.48	42.62	4792600.0
2001-08-06 10:00:00	QQQ	ETF	42.62	42.9	42.37	42.55	5405000.0
2001-08-06 11:00:00	QQQ	ETF	42.56	42.77	42.5	42.64	3947200.0
2001-08-06 12:00:00	QQQ	ETF	42.64	42.71	42.39	42.46	2898600.0
2001-08-06 13:00:00	QQQ	ETF	42.43	42.62	42.42	42.6	2316500.0
2001-08-06 14:00:00	QQQ	ETF	42.59	42.62	42.35	42.55	3433200.0
2001-08-06 15:00:00	QQQ	ETF	42.53	42.55	42.36	42.48	5568700.0
2001-08-06 16:00:00	QQQ	ETF	42.47	42.65	42.43	42.5	1205300.0
2001-08-06 17:00:00	QQQ	ETF	42.5	42.52	42.45	42.5	70100.0
2001-08-06 18:00:00	QQQ	ETF	42.5	42.52	42.5	42.5	8200.0
2001-08-06 09:00:00	IWM	ETF	48.5	48.5	48.3	48.3	4000.0
2001-08-06 10:00:00	IWM	ETF	48.45	48.45	48.255	48.255	1600.0
2001-08-06 11:00:00	IWM	ETF	48.2	48.42	48.2	48.325	5800.0
2001-08-06 12:00:00	IWM	ETF	48.3	48.34	48.11	48.11	5400.0
2001-08-06 13:00:00	IWM	ETF	48.275	48.285	48.1	48.15	4000.0
2001-08-06 14:00:00	IWM	ETF	48.165	48.165	47.85	48.045	72000.0
2001-08-06 15:00:00	IWM	ETF	48.035	48.045	47.8	47.995	123200.0
2001-08-06 16:00:00	IWM	ETF	47.88	47.9	47.8	47.9	7200.0
2001-08-06 09:00:00	DIA	ETF	105.0	105.02	104.82	104.86	200400.0
2001-08-06 10:00:00	DIA	ETF	104.93	105.08	104.44	104.54	193200.0
2001-08-06 11:00:00	DIA	ETF	104.54	104.67	104.43	104.5	141200.0
2001-08-06 12:00:00	DIA	ETF	104.52	104.55	104.11	104.25	183200.0
2001-08-06 13:00:00	DIA	ETF	104.24	104.35	104.06	104.19	119100.0
2001-08-06 14:00:00	DIA	ETF	104.21	104.23	103.86	104.13	290500.0
2001-08-06 15:00:00	DIA	ETF	104.08	104.15	103.85	104.1	186400.0
2001-08-06 16:00:00	DIA	ETF	104.12	104.12	103.93	103.94	156000.0

> showing 35 of 217 rows — these rows as CSV

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