PREVIEW / etf_1hour / 2025-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-13.parquet
  size:    632 KB
  rows:    24,056

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-13 04:00:00	SPY	ETF	578.23	578.23	575.04	575.25	48861.0
2025-01-13 05:00:00	SPY	ETF	575.33	576.16	575.2	575.7	11605.0
2025-01-13 06:00:00	SPY	ETF	575.5	576.23	575.5	575.97	25645.0
2025-01-13 07:00:00	SPY	ETF	576.02	577.48	575.3	576.94	300774.0
2025-01-13 08:00:00	SPY	ETF	575.8	578.77	575.3196	576.7809	284260.0
2025-01-13 09:00:00	SPY	ETF	576.78	578.32	575.35	577.87	4944033.0
2025-01-13 10:00:00	SPY	ETF	577.88	579.18	575.94	577.9	4506111.0
2025-01-13 11:00:00	SPY	ETF	577.9	578.21	575.88	576.0	3395169.0
2025-01-13 12:00:00	SPY	ETF	576.02	579.55	575.68	579.46	2872693.0
2025-01-13 13:00:00	SPY	ETF	579.46	580.285	578.88	580.01	2774565.0
2025-01-13 14:00:00	SPY	ETF	580.01	581.0	578.97	580.4816	3243105.0
2025-01-13 15:00:00	SPY	ETF	580.47	581.75	579.87	581.54	6558199.0
2025-01-13 16:00:00	SPY	ETF	581.53	582.25	581.17	582.15	4544295.0
2025-01-13 17:00:00	SPY	ETF	582.14	582.5	582.07	582.3798	96551.0
2025-01-13 18:00:00	SPY	ETF	582.59	583.93	582.59	583.21	198033.0
2025-01-13 19:00:00	SPY	ETF	583.2	583.2	582.76	583.2	44307.0
2025-01-13 04:00:00	QQQ	ETF	504.28	504.28	499.61	500.29	193585.0
2025-01-13 05:00:00	QQQ	ETF	500.22	501.45	499.92	500.75	86982.0
2025-01-13 06:00:00	QQQ	ETF	500.87	501.47	500.53	501.2	99589.0
2025-01-13 07:00:00	QQQ	ETF	501.24	503.17	500.3	502.6	334346.0
2025-01-13 08:00:00	QQQ	ETF	501.75	504.95	499.881	502.23	406527.0
2025-01-13 09:00:00	QQQ	ETF	502.44	503.07	499.7	502.145	4271882.0
2025-01-13 10:00:00	QQQ	ETF	502.14	503.988	500.02	502.05	3492480.0
2025-01-13 11:00:00	QQQ	ETF	502.06	502.69	500.31	500.53	2228146.0
2025-01-13 12:00:00	QQQ	ETF	500.52	504.3	500.06	504.18	2833452.0
2025-01-13 13:00:00	QQQ	ETF	504.18	504.729	503.4	504.24	2092767.0
2025-01-13 14:00:00	QQQ	ETF	504.23	505.07	502.91	504.56	1776684.0
2025-01-13 15:00:00	QQQ	ETF	504.57	506.02	503.8126	505.6	2745467.0
2025-01-13 16:00:00	QQQ	ETF	505.61	506.73	505.39	506.68	1640910.0
2025-01-13 17:00:00	QQQ	ETF	506.65	507.3	506.54	507.3	47676.0
2025-01-13 18:00:00	QQQ	ETF	507.32	508.97	507.16	508.04	221509.0
2025-01-13 19:00:00	QQQ	ETF	508.1	508.2496	507.65	508.18	107126.0
2025-01-13 04:00:00	IWM	ETF	214.31	215.0	213.93	214.05	65459.0
2025-01-13 05:00:00	IWM	ETF	214.1	214.49	214.04	214.19	36296.0
2025-01-13 06:00:00	IWM	ETF	214.15	214.42	214.06	214.2	22990.0
2025-01-13 07:00:00	IWM	ETF	214.27	214.74	214.05	214.55	86092.0
2025-01-13 08:00:00	IWM	ETF	214.245	215.08	214.03	214.54	148311.0
2025-01-13 09:00:00	IWM	ETF	214.54	215.565	213.97	215.56	2998923.0
2025-01-13 10:00:00	IWM	ETF	215.56	215.82	214.38	215.25	2793767.0
2025-01-13 11:00:00	IWM	ETF	215.27	215.41	214.125	214.22	2393219.0
2025-01-13 12:00:00	IWM	ETF	214.23	215.6	214.05	215.5388	1390718.0
2025-01-13 13:00:00	IWM	ETF	215.54	216.3	215.37	216.13	2128225.0
2025-01-13 14:00:00	IWM	ETF	216.12	216.69	215.8	216.36	1955217.0
2025-01-13 15:00:00	IWM	ETF	216.33	217.515	215.99	217.29	3146571.0
2025-01-13 16:00:00	IWM	ETF	217.25	217.63	217.13	217.47	1097574.0
2025-01-13 17:00:00	IWM	ETF	217.5	217.65	217.5	217.6192	14643.0
2025-01-13 18:00:00	IWM	ETF	217.64	218.66	217.64	218.1	78762.0
2025-01-13 19:00:00	IWM	ETF	218.11	218.119	217.87	218.09	18363.0
2025-01-13 04:00:00	DIA	ETF	418.0	418.11	417.68	417.84	2000.0
2025-01-13 05:00:00	DIA	ETF	417.82	418.01	417.68	417.96	4706.0

> showing 50 of 24,056 rows — these rows as CSV

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