PREVIEW / etf_1hour / 2001-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-17.parquet
  size:    12 KB
  rows:    226

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-17 09:00:00	SPY	ETF	117.65	117.87	117.4	117.7	1433900.0
2001-08-17 10:00:00	SPY	ETF	117.7	117.81	116.5	116.88	2466100.0
2001-08-17 11:00:00	SPY	ETF	116.86	117.15	116.64	116.81	899400.0
2001-08-17 12:00:00	SPY	ETF	116.82	117.0	116.69	116.78	591800.0
2001-08-17 13:00:00	SPY	ETF	116.77	116.89	116.56	116.7	1507700.0
2001-08-17 14:00:00	SPY	ETF	116.71	116.8	116.42	116.57	816600.0
2001-08-17 15:00:00	SPY	ETF	116.56	116.75	116.01	116.64	2928800.0
2001-08-17 16:00:00	SPY	ETF	116.65	117.65	116.61	117.65	776000.0
2001-08-17 09:00:00	QQQ	ETF	38.44	38.8	38.4	38.59	7031800.0
2001-08-17 10:00:00	QQQ	ETF	38.55	38.63	37.78	38.04	15390700.0
2001-08-17 11:00:00	QQQ	ETF	38.05	38.4	37.95	38.18	6341400.0
2001-08-17 12:00:00	QQQ	ETF	38.18	38.35	38.12	38.16	3557000.0
2001-08-17 13:00:00	QQQ	ETF	38.15	38.24	38.0	38.13	4447500.0
2001-08-17 14:00:00	QQQ	ETF	38.13	38.15	37.9	38.0	4747000.0
2001-08-17 15:00:00	QQQ	ETF	38.0	38.05	37.71	37.8	12054500.0
2001-08-17 16:00:00	QQQ	ETF	37.79	37.95	37.25	37.7	1094100.0
2001-08-17 17:00:00	QQQ	ETF	37.74	37.78	37.7	37.78	25100.0
2001-08-17 18:00:00	QQQ	ETF	37.78	37.94	37.75	37.94	7500.0
2001-08-17 09:00:00	IWM	ETF	47.7	47.815	47.66	47.66	1000.0
2001-08-17 10:00:00	IWM	ETF	47.875	47.875	47.355	47.355	8000.0
2001-08-17 11:00:00	IWM	ETF	47.54	47.715	47.405	47.715	2400.0
2001-08-17 12:00:00	IWM	ETF	47.64	47.71	47.6	47.6	22200.0
2001-08-17 13:00:00	IWM	ETF	47.6	47.65	47.53	47.65	72000.0
2001-08-17 14:00:00	IWM	ETF	47.575	47.7	47.535	47.64	14800.0
2001-08-17 15:00:00	IWM	ETF	47.7	47.7	47.3	47.5	472800.0
2001-08-17 16:00:00	IWM	ETF	47.35	47.35	47.35	47.35	14400.0
2001-08-17 09:00:00	DIA	ETF	103.15	103.62	103.07	103.43	542800.0
2001-08-17 10:00:00	DIA	ETF	103.43	103.55	102.5	102.75	696300.0
2001-08-17 11:00:00	DIA	ETF	102.82	102.89	102.57	102.58	209300.0
2001-08-17 12:00:00	DIA	ETF	102.62	102.76	102.52	102.68	137700.0
2001-08-17 13:00:00	DIA	ETF	102.67	102.74	102.45	102.55	91400.0
2001-08-17 14:00:00	DIA	ETF	102.64	102.66	102.39	102.4	211800.0
2001-08-17 15:00:00	DIA	ETF	102.43	102.54	101.88	102.41	1388400.0
2001-08-17 16:00:00	DIA	ETF	102.54	102.54	102.44	102.47	79800.0
2001-08-17 17:00:00	DIA	ETF	102.47	102.47	102.47	102.47	900.0

> showing 35 of 226 rows — these rows as CSV

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