PREVIEW / etf_1hour / 2001-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-11.parquet
  size:    13 KB
  rows:    266

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-11 09:00:00	SPY	ETF	108.95	110.25	108.95	109.89	6614800.0
2001-10-11 10:00:00	SPY	ETF	109.88	110.3	109.45	109.75	4393800.0
2001-10-11 11:00:00	SPY	ETF	109.75	110.15	109.5	109.66	1840200.0
2001-10-11 12:00:00	SPY	ETF	109.67	109.9	109.51	109.87	1272200.0
2001-10-11 13:00:00	SPY	ETF	109.84	110.16	109.66	109.71	1559900.0
2001-10-11 14:00:00	SPY	ETF	109.71	109.85	109.18	109.38	2382000.0
2001-10-11 15:00:00	SPY	ETF	109.37	110.05	109.15	110.01	3409000.0
2001-10-11 16:00:00	SPY	ETF	110.02	110.46	109.81	110.39	1020000.0
2001-10-11 17:00:00	SPY	ETF	110.27	110.6	109.0	110.6	11800.0
2001-10-11 18:00:00	SPY	ETF	110.6	110.74	110.48	110.48	4400.0
2001-10-11 09:00:00	QQQ	ETF	33.19	34.05	33.14	33.91	24047600.0
2001-10-11 10:00:00	QQQ	ETF	33.88	34.26	33.71	33.81	22310800.0
2001-10-11 11:00:00	QQQ	ETF	33.86	34.14	33.76	33.9	11948700.0
2001-10-11 12:00:00	QQQ	ETF	33.88	34.36	33.86	34.32	7230800.0
2001-10-11 13:00:00	QQQ	ETF	34.34	34.59	34.25	34.29	12689400.0
2001-10-11 14:00:00	QQQ	ETF	34.32	34.34	33.8	33.97	14699800.0
2001-10-11 15:00:00	QQQ	ETF	34.0	34.64	33.83	34.6	17054600.0
2001-10-11 16:00:00	QQQ	ETF	34.61	35.35	34.06	35.25	3607500.0
2001-10-11 17:00:00	QQQ	ETF	35.15	35.32	34.78	35.25	932700.0
2001-10-11 18:00:00	QQQ	ETF	35.25	35.4	35.17	35.2	73000.0
2001-10-11 09:00:00	IWM	ETF	42.5	42.925	42.5	42.715	114400.0
2001-10-11 10:00:00	IWM	ETF	42.7	42.975	42.64	42.82	394400.0
2001-10-11 11:00:00	IWM	ETF	42.825	43.035	42.71	42.835	199400.0
2001-10-11 12:00:00	IWM	ETF	42.92	43.015	42.825	43.015	64000.0
2001-10-11 13:00:00	IWM	ETF	43.005	43.2	42.9	43.09	49200.0
2001-10-11 14:00:00	IWM	ETF	43.07	43.07	42.7	42.785	256400.0
2001-10-11 15:00:00	IWM	ETF	42.755	42.91	42.675	42.875	178800.0
2001-10-11 16:00:00	IWM	ETF	42.675	42.675	42.64	42.675	140000.0
2001-10-11 09:00:00	DIA	ETF	93.1	94.35	92.95	93.98	3386100.0
2001-10-11 10:00:00	DIA	ETF	93.95	94.12	93.62	93.8	1557600.0
2001-10-11 11:00:00	DIA	ETF	93.78	94.55	93.68	93.95	879800.0
2001-10-11 12:00:00	DIA	ETF	93.9	94.18	93.8	94.12	225400.0
2001-10-11 13:00:00	DIA	ETF	94.17	94.35	94.02	94.1	337600.0
2001-10-11 14:00:00	DIA	ETF	94.12	94.2	93.56	93.68	718700.0
2001-10-11 15:00:00	DIA	ETF	93.73	94.27	93.4	94.25	970600.0
2001-10-11 16:00:00	DIA	ETF	94.16	94.39	93.98	94.3	3389900.0
2001-10-11 17:00:00	DIA	ETF	94.4	94.55	94.4	94.55	3000800.0
2001-10-11 18:00:00	DIA	ETF	94.55	94.55	94.5	94.5	200.0

> showing 38 of 266 rows — these rows as CSV

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