PREVIEW / etf_1hour / 2001-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-04.parquet
  size:    12 KB
  rows:    219

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-04-04 09:00:00	SPY	ETF	110.57	111.16	110.16	110.45	1823100.0
2001-04-04 10:00:00	SPY	ETF	110.56	111.14	109.3	110.8	3534400.0
2001-04-04 11:00:00	SPY	ETF	110.72	112.05	110.69	111.89	2138100.0
2001-04-04 12:00:00	SPY	ETF	111.88	112.1	111.3	111.31	1432700.0
2001-04-04 13:00:00	SPY	ETF	111.45	111.45	110.0	110.0	1538600.0
2001-04-04 14:00:00	SPY	ETF	110.0	111.68	109.85	110.35	1393900.0
2001-04-04 15:00:00	SPY	ETF	110.35	110.99	109.58	110.31	2421400.0
2001-04-04 16:00:00	SPY	ETF	110.4	111.75	110.25	110.9	477900.0
2001-04-04 17:00:00	SPY	ETF	110.77	111.28	110.77	111.25	21000.0
2001-04-04 18:00:00	SPY	ETF	111.5	111.75	111.5	111.62	3000.0
2001-04-04 09:00:00	QQQ	ETF	34.71	35.38	34.5	34.55	9381100.0
2001-04-04 10:00:00	QQQ	ETF	34.56	35.13	34.08	34.89	14746000.0
2001-04-04 11:00:00	QQQ	ETF	34.89	35.81	34.76	35.55	11983800.0
2001-04-04 12:00:00	QQQ	ETF	35.61	35.8	35.21	35.3	7103700.0
2001-04-04 13:00:00	QQQ	ETF	35.25	35.32	34.28	34.3	8491000.0
2001-04-04 14:00:00	QQQ	ETF	34.31	34.8	34.15	34.25	9778300.0
2001-04-04 15:00:00	QQQ	ETF	34.3	34.33	33.6	34.1	11784400.0
2001-04-04 16:00:00	QQQ	ETF	34.1	35.5	34.0	34.07	1539100.0
2001-04-04 17:00:00	QQQ	ETF	34.12	35.6	34.12	34.9	501300.0
2001-04-04 18:00:00	QQQ	ETF	34.9	35.04	34.85	35.0	62300.0
2001-04-04 09:00:00	IWM	ETF	42.325	42.9	42.25	42.825	21400.0
2001-04-04 10:00:00	IWM	ETF	42.425	42.675	42.25	42.55	64200.0
2001-04-04 11:00:00	IWM	ETF	42.525	42.8	42.5	42.65	51800.0
2001-04-04 12:00:00	IWM	ETF	42.9	42.925	42.755	42.885	8200.0
2001-04-04 13:00:00	IWM	ETF	42.7	42.91	42.65	42.65	30600.0
2001-04-04 14:00:00	IWM	ETF	42.635	42.775	42.45	42.575	145200.0
2001-04-04 15:00:00	IWM	ETF	42.35	42.55	42.2	42.325	33400.0
2001-04-04 16:00:00	IWM	ETF	42.4	42.4	42.4	42.4	1600.0
2001-04-04 09:00:00	DIA	ETF	94.5	95.19	94.31	94.67	603100.0
2001-04-04 10:00:00	DIA	ETF	94.6	95.6	93.76	94.9	1367600.0
2001-04-04 11:00:00	DIA	ETF	95.0	96.46	94.9	95.8	1062600.0
2001-04-04 12:00:00	DIA	ETF	95.89	96.16	95.5	95.5	341500.0
2001-04-04 13:00:00	DIA	ETF	95.5	95.8	94.43	94.43	461700.0
2001-04-04 14:00:00	DIA	ETF	94.51	95.47	94.3	95.09	558800.0
2001-04-04 15:00:00	DIA	ETF	94.9	95.7	94.49	95.1	822000.0
2001-04-04 16:00:00	DIA	ETF	95.05	95.5	94.75	95.31	123100.0
2001-04-04 17:00:00	DIA	ETF	95.69	96.31	95.69	96.31	400.0

> showing 37 of 219 rows — these rows as CSV

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