PREVIEW / etf_1hour / 2024-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-01-26.parquet
  size:    526 KB
  rows:    19,348

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
2024-01-26 04:00:00	SPY	ETF	486.21	487.06	485.91	487.06	35322.0
2024-01-26 05:00:00	SPY	ETF	487.08	487.35	486.91	487.23	20671.0
2024-01-26 06:00:00	SPY	ETF	487.25	487.55	487.04	487.39	23430.0
2024-01-26 07:00:00	SPY	ETF	487.37	488.01	487.37	487.57	182733.0
2024-01-26 08:00:00	SPY	ETF	487.62	488.63	485.71	488.4	485135.0
2024-01-26 09:00:00	SPY	ETF	488.4	488.4	487.15	487.7001	4480056.0
2024-01-26 10:00:00	SPY	ETF	487.7	489.0365	487.0399	489.015	7564313.0
2024-01-26 11:00:00	SPY	ETF	489.02	489.12	488.1	488.74	6121956.0
2024-01-26 12:00:00	SPY	ETF	488.74	488.88	486.71	487.015	7633268.0
2024-01-26 13:00:00	SPY	ETF	487.02	487.53	486.54	486.98	5279489.0
2024-01-26 14:00:00	SPY	ETF	486.9941	488.15	486.945	487.97	5329509.0
2024-01-26 15:00:00	SPY	ETF	487.98	488.0599	487.025	487.47	10212411.0
2024-01-26 16:00:00	SPY	ETF	487.465	487.7	487.09	487.11	4838735.0
2024-01-26 17:00:00	SPY	ETF	487.11	487.26	487.09	487.24	49263.0
2024-01-26 18:00:00	SPY	ETF	487.15	487.25	486.5	486.97	33144.0
2024-01-26 19:00:00	SPY	ETF	486.93	487.07	486.75	486.75	9085.0
2024-01-26 04:00:00	QQQ	ETF	423.28	423.85	422.3	423.85	103508.0
2024-01-26 05:00:00	QQQ	ETF	423.82	424.19	423.53	423.85	94559.0
2024-01-26 06:00:00	QQQ	ETF	423.99	424.39	423.62	424.36	76586.0
2024-01-26 07:00:00	QQQ	ETF	424.32	425.24	424.27	424.64	314345.0
2024-01-26 08:00:00	QQQ	ETF	424.252	426.669	422.28	425.4	709932.0
2024-01-26 09:00:00	QQQ	ETF	425.37	425.39	423.48	424.25	3867305.0
2024-01-26 10:00:00	QQQ	ETF	424.25	426.11	423.18	426.11	5430208.0
2024-01-26 11:00:00	QQQ	ETF	426.1	426.17	424.92	425.695	3634016.0
2024-01-26 12:00:00	QQQ	ETF	425.7	426.21	423.4399	423.74	4100559.0
2024-01-26 13:00:00	QQQ	ETF	423.74	424.25	423.15	423.52	2926665.0
2024-01-26 14:00:00	QQQ	ETF	423.53	424.84	423.42	424.58	3283485.0
2024-01-26 15:00:00	QQQ	ETF	424.57	424.685	423.45	423.77	4898954.0
2024-01-26 16:00:00	QQQ	ETF	423.78	423.83	423.0	423.21	1147234.0
2024-01-26 17:00:00	QQQ	ETF	423.21	423.42	423.1455	423.4	40522.0
2024-01-26 18:00:00	QQQ	ETF	423.42	423.46	423.2	423.29	15532.0
2024-01-26 19:00:00	QQQ	ETF	423.3	423.5	423.03	423.3	31203.0
2024-01-26 04:00:00	IWM	ETF	196.09	196.81	195.86	196.69	41996.0
2024-01-26 05:00:00	IWM	ETF	196.72	196.98	196.68	196.79	22452.0
2024-01-26 06:00:00	IWM	ETF	196.86	197.01	196.65	196.67	49302.0
2024-01-26 07:00:00	IWM	ETF	196.7	196.96	196.55	196.81	54794.0
2024-01-26 08:00:00	IWM	ETF	196.86	197.4	195.56	197.26	714476.0
2024-01-26 09:00:00	IWM	ETF	197.28	197.89	196.33	196.96	4801076.0
2024-01-26 10:00:00	IWM	ETF	196.94	197.33	195.93	196.94	5208941.0
2024-01-26 11:00:00	IWM	ETF	196.925	196.97	196.16	196.7401	3155522.0
2024-01-26 12:00:00	IWM	ETF	196.74	196.779	195.38	195.755	3388612.0
2024-01-26 13:00:00	IWM	ETF	195.75	196.18	195.62	195.93	1671308.0
2024-01-26 14:00:00	IWM	ETF	195.93	196.39	195.92	196.275	1871821.0
2024-01-26 15:00:00	IWM	ETF	196.28	196.2928	195.76	195.97	3510394.0
2024-01-26 16:00:00	IWM	ETF	195.98	195.98	195.77	195.84	2089406.0
2024-01-26 17:00:00	IWM	ETF	195.77	195.83	195.56	195.8	61788.0
2024-01-26 18:00:00	IWM	ETF	195.79	195.89	195.64	195.74	21490.0
2024-01-26 19:00:00	IWM	ETF	195.69	195.76	195.64	195.64	4759.0
2024-01-26 04:00:00	DIA	ETF	379.32	379.53	379.32	379.53	1000.0
2024-01-26 05:00:00	DIA	ETF	379.84	379.88	379.84	379.88	600.0

> showing 50 of 19,348 rows — these rows as CSV

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