PREVIEW / etf_1hour / 2026-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-16.parquet
  size:    712 KB
  rows:    28,673

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
2026-04-16 04:00:00	SPY	ETF	700.95	701.99	700.15	700.7	103128.0
2026-04-16 05:00:00	SPY	ETF	700.63	700.93	700.5	700.72	42741.0
2026-04-16 06:00:00	SPY	ETF	700.802	700.96	699.82	700.42	52266.0
2026-04-16 07:00:00	SPY	ETF	700.39	700.88	700.17	700.78	144956.0
2026-04-16 08:00:00	SPY	ETF	700.79	701.2	700.49	700.83	218653.0
2026-04-16 09:00:00	SPY	ETF	700.88	701.3	698.53	699.48	5057829.0
2026-04-16 10:00:00	SPY	ETF	699.47	700.21	698.652	699.93	5293541.0
2026-04-16 11:00:00	SPY	ETF	699.93	702.36	699.93	702.22	5255851.0
2026-04-16 12:00:00	SPY	ETF	702.22	702.78	700.175	700.81	4290282.0
2026-04-16 13:00:00	SPY	ETF	700.83	701.53	699.83	700.6	3166906.0
2026-04-16 14:00:00	SPY	ETF	700.61	701.18	699.474	700.705	3808859.0
2026-04-16 15:00:00	SPY	ETF	700.71	701.94	700.6	701.55	7408613.0
2026-04-16 16:00:00	SPY	ETF	701.55	701.9	700.2	701.76	1930306.0
2026-04-16 17:00:00	SPY	ETF	701.76	701.76	701.5	701.681	64611.0
2026-04-16 18:00:00	SPY	ETF	701.69	702.21	701.5	702.07	78947.0
2026-04-16 19:00:00	SPY	ETF	702.05	702.396	702.05	702.22	29133.0
2026-04-16 04:00:00	QQQ	ETF	639.32	640.36	638.58	639.3	300236.0
2026-04-16 05:00:00	QQQ	ETF	639.26	639.66	639.16	639.52	74424.0
2026-04-16 06:00:00	QQQ	ETF	639.652	639.83	637.45	638.427	254262.0
2026-04-16 07:00:00	QQQ	ETF	638.43	638.88	637.9	638.75	216016.0
2026-04-16 08:00:00	QQQ	ETF	638.76	639.04	636.922	638.34	288421.0
2026-04-16 09:00:00	QQQ	ETF	638.38	639.58	635.255	636.35	4576468.0
2026-04-16 10:00:00	QQQ	ETF	636.33	638.8	635.6	638.36	4343124.0
2026-04-16 11:00:00	QQQ	ETF	638.36	641.67	638.36	641.53	4489109.0
2026-04-16 12:00:00	QQQ	ETF	641.51	642.18	639.019	640.04	3375659.0
2026-04-16 13:00:00	QQQ	ETF	640.07	640.92	639.05	639.755	2766307.0
2026-04-16 14:00:00	QQQ	ETF	639.75	640.31	637.2	639.14	3805795.0
2026-04-16 15:00:00	QQQ	ETF	639.15	640.89	639.09	640.41	5468371.0
2026-04-16 16:00:00	QQQ	ETF	640.38	640.5	639.27	639.92	1693497.0
2026-04-16 17:00:00	QQQ	ETF	639.91	639.96	639.31	639.57	82261.0
2026-04-16 18:00:00	QQQ	ETF	639.58	640.4	639.48	640.14	157761.0
2026-04-16 19:00:00	QQQ	ETF	640.11	640.41	640.01	640.24	38430.0
2026-04-16 04:00:00	IWM	ETF	269.65	269.98	269.2	269.38	80278.0
2026-04-16 05:00:00	IWM	ETF	269.41	269.58	269.35	269.58	9635.0
2026-04-16 06:00:00	IWM	ETF	269.61	269.76	269.39	269.56	45700.0
2026-04-16 07:00:00	IWM	ETF	269.66	269.95	269.48	269.55	189406.0
2026-04-16 08:00:00	IWM	ETF	269.57	269.78	269.04	269.12	157989.0
2026-04-16 09:00:00	IWM	ETF	269.14	270.35	268.3	269.17	3142054.0
2026-04-16 10:00:00	IWM	ETF	269.18	269.23	268.05	268.925	2320677.0
2026-04-16 11:00:00	IWM	ETF	268.92	270.2	268.92	269.92	2074754.0
2026-04-16 12:00:00	IWM	ETF	269.91	270.2	268.81	269.34	2306782.0
2026-04-16 13:00:00	IWM	ETF	269.35	269.4	268.5	269.01	1882434.0
2026-04-16 14:00:00	IWM	ETF	269.02	269.5	268.91	269.32	1560659.0
2026-04-16 15:00:00	IWM	ETF	269.335	270.09	269.33	269.96	3713024.0
2026-04-16 16:00:00	IWM	ETF	269.98	270.31	269.87	270.26	886296.0
2026-04-16 17:00:00	IWM	ETF	270.26	270.26	270.055	270.14	9951.0
2026-04-16 18:00:00	IWM	ETF	270.18	270.46	270.18	270.41	30409.0
2026-04-16 19:00:00	IWM	ETF	270.42	270.67	270.37	270.511	18699.0
2026-04-16 04:00:00	DIA	ETF	485.35	485.35	484.82	484.978	6337.0
2026-04-16 05:00:00	DIA	ETF	485.01	485.01	484.8	484.91	1835.0

> showing 50 of 28,673 rows — these rows as CSV

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