PREVIEW / etf_1hour / 2025-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-16.parquet
  size:    613 KB
  rows:    23,224

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
2025-01-16 04:00:00	SPY	ETF	594.75	594.75	593.71	594.32	24253.0
2025-01-16 05:00:00	SPY	ETF	593.8	594.89	593.62	594.7	27354.0
2025-01-16 06:00:00	SPY	ETF	594.6	594.8	594.19	594.68	25194.0
2025-01-16 07:00:00	SPY	ETF	594.65	594.66	592.87	593.01	364365.0
2025-01-16 08:00:00	SPY	ETF	594.33	595.56	592.55	593.59	405430.0
2025-01-16 09:00:00	SPY	ETF	593.59	594.34	592.065	592.185	3279074.0
2025-01-16 10:00:00	SPY	ETF	592.18	593.46	591.32	593.46	3020470.0
2025-01-16 11:00:00	SPY	ETF	593.44	594.35	591.82	593.5055	3207571.0
2025-01-16 12:00:00	SPY	ETF	593.495	593.81	592.785	592.9799	1497322.0
2025-01-16 13:00:00	SPY	ETF	592.97	593.54	590.93	591.4	2607685.0
2025-01-16 14:00:00	SPY	ETF	591.38	593.08	591.075	592.93	2191212.0
2025-01-16 15:00:00	SPY	ETF	592.93	593.33	591.48	591.7	5131261.0
2025-01-16 16:00:00	SPY	ETF	591.71	591.9	590.35	591.0	2710994.0
2025-01-16 17:00:00	SPY	ETF	591.03	591.04	590.94	591.0	37890.0
2025-01-16 18:00:00	SPY	ETF	591.0	591.44	590.86	591.44	60312.0
2025-01-16 19:00:00	SPY	ETF	591.48	591.6	591.31	591.51	16149.0
2025-01-16 04:00:00	QQQ	ETF	519.52	520.25	518.06	518.53	83898.0
2025-01-16 05:00:00	QQQ	ETF	518.31	519.32	517.81	519.03	34239.0
2025-01-16 06:00:00	QQQ	ETF	519.1	519.51	518.73	519.37	35017.0
2025-01-16 07:00:00	QQQ	ETF	519.23	519.29	517.46	517.55	133329.0
2025-01-16 08:00:00	QQQ	ETF	518.72	520.31	515.62	518.5	358290.0
2025-01-16 09:00:00	QQQ	ETF	518.47	519.09	515.99	516.1538	2652744.0
2025-01-16 10:00:00	QQQ	ETF	516.1101	517.38	515.2	517.32	3065105.0
2025-01-16 11:00:00	QQQ	ETF	517.31	518.52	514.76	516.76	2747352.0
2025-01-16 12:00:00	QQQ	ETF	516.76	517.37	516.03	516.45	1333234.0
2025-01-16 13:00:00	QQQ	ETF	516.35	517.05	513.4678	514.16	2094883.0
2025-01-16 14:00:00	QQQ	ETF	514.1325	516.28	513.83	516.13	1682378.0
2025-01-16 15:00:00	QQQ	ETF	516.08	516.63	512.95	513.07	3767519.0
2025-01-16 16:00:00	QQQ	ETF	513.1	513.11	511.32	512.27	1668208.0
2025-01-16 17:00:00	QQQ	ETF	512.25	512.26	512.0	512.25	46977.0
2025-01-16 18:00:00	QQQ	ETF	512.3	512.8601	512.18	512.76	71472.0
2025-01-16 19:00:00	QQQ	ETF	512.74	512.92	512.581	512.89	55523.0
2025-01-16 04:00:00	IWM	ETF	224.2	224.2	223.4	223.62	42135.0
2025-01-16 05:00:00	IWM	ETF	223.62	223.94	223.38	223.66	9486.0
2025-01-16 06:00:00	IWM	ETF	223.6	223.98	223.54	223.93	19463.0
2025-01-16 07:00:00	IWM	ETF	223.94	223.94	223.33	223.49	74321.0
2025-01-16 08:00:00	IWM	ETF	223.83	224.61	223.31	223.9	249300.0
2025-01-16 09:00:00	IWM	ETF	223.94	224.95	223.13	223.25	2286402.0
2025-01-16 10:00:00	IWM	ETF	223.25	224.316	222.71	224.23	1976561.0
2025-01-16 11:00:00	IWM	ETF	224.21	224.88	223.83	224.65	1735715.0
2025-01-16 12:00:00	IWM	ETF	224.61	224.8	224.11	224.21	770309.0
2025-01-16 13:00:00	IWM	ETF	224.2	224.47	223.69	223.79	1312386.0
2025-01-16 14:00:00	IWM	ETF	223.79	224.58	223.68	224.46	1166733.0
2025-01-16 15:00:00	IWM	ETF	224.45	225.23	224.25	224.47	3126682.0
2025-01-16 16:00:00	IWM	ETF	224.49	224.54	223.87	224.14	1049704.0
2025-01-16 17:00:00	IWM	ETF	224.11	224.11	223.9912	224.06	4123.0
2025-01-16 18:00:00	IWM	ETF	224.09	224.18	224.04	224.18	22714.0
2025-01-16 19:00:00	IWM	ETF	224.24	224.33	224.09	224.33	34467.0
2025-01-16 04:00:00	DIA	ETF	432.24	432.39	432.17	432.39	2800.0
2025-01-16 05:00:00	DIA	ETF	432.1	432.62	432.1	432.62	700.0

> showing 50 of 23,224 rows — these rows as CSV

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