PREVIEW / etf_1hour / 2026-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-03-27.parquet
  size:    643 KB
  rows:    25,427

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-03-27 04:00:00	SPY	ETF	647.69	648.12	645.23	645.41	120370.0
2026-03-27 05:00:00	SPY	ETF	645.38	646.16	643.9	644.52	226885.0
2026-03-27 06:00:00	SPY	ETF	644.35	645.22	642.46	642.74	390712.0
2026-03-27 07:00:00	SPY	ETF	642.82	643.88	642.0	643.22	378279.0
2026-03-27 08:00:00	SPY	ETF	642.83	649.76	641.78	642.13	705341.0
2026-03-27 09:00:00	SPY	ETF	642.15	642.732	638.594	639.05	9159301.0
2026-03-27 10:00:00	SPY	ETF	639.03	640.8	638.3	640.19	9949360.0
2026-03-27 11:00:00	SPY	ETF	640.19	642.14	638.9401	640.28	10133932.0
2026-03-27 12:00:00	SPY	ETF	640.3	640.43	638.08	638.7	7847549.0
2026-03-27 13:00:00	SPY	ETF	638.7	639.93	635.94	636.13	9535275.0
2026-03-27 14:00:00	SPY	ETF	636.1398	636.73	635.13	635.38	9071106.0
2026-03-27 15:00:00	SPY	ETF	635.38	635.68	633.105	634.08	20675986.0
2026-03-27 16:00:00	SPY	ETF	634.08	634.54	632.27	633.11	3706602.0
2026-03-27 17:00:00	SPY	ETF	633.11	633.8386	633.04	633.24	331609.0
2026-03-27 18:00:00	SPY	ETF	633.22	633.46	632.8	632.9499	66946.0
2026-03-27 19:00:00	SPY	ETF	632.8525	633.19	632.61	632.98	101295.0
2026-03-27 04:00:00	QQQ	ETF	575.19	576.56	573.6	573.91	302544.0
2026-03-27 05:00:00	QQQ	ETF	573.91	574.6	572.16	572.76	214231.0
2026-03-27 06:00:00	QQQ	ETF	572.84	573.47	570.27	570.65	271225.0
2026-03-27 07:00:00	QQQ	ETF	570.65	571.599	569.72	571.01	299731.0
2026-03-27 08:00:00	QQQ	ETF	570.44	578.4	569.44	569.83	978110.0
2026-03-27 09:00:00	QQQ	ETF	569.82	571.02	566.4	566.71	10055571.0
2026-03-27 10:00:00	QQQ	ETF	566.71	568.47	565.66	567.36	10674854.0
2026-03-27 11:00:00	QQQ	ETF	567.35	569.71	566.09	568.2934	10182919.0
2026-03-27 12:00:00	QQQ	ETF	568.3	568.46	565.74	566.45	6629851.0
2026-03-27 13:00:00	QQQ	ETF	566.45	567.76	563.36	563.69	7762848.0
2026-03-27 14:00:00	QQQ	ETF	563.69	564.56	562.91	563.2299	7216223.0
2026-03-27 15:00:00	QQQ	ETF	563.22	563.725	561.57	562.5	12340957.0
2026-03-27 16:00:00	QQQ	ETF	562.51	563.03	560.74	561.2	1904742.0
2026-03-27 17:00:00	QQQ	ETF	561.25	562.15	561.1432	561.7	120582.0
2026-03-27 18:00:00	QQQ	ETF	561.71	561.71	560.35	560.5	87462.0
2026-03-27 19:00:00	QQQ	ETF	560.5594	560.56	560.0	560.13	117673.0
2026-03-27 04:00:00	IWM	ETF	248.6	248.65	247.05	247.14	68142.0
2026-03-27 05:00:00	IWM	ETF	247.12	247.46	246.34	246.54	95632.0
2026-03-27 06:00:00	IWM	ETF	246.42	246.9	245.62	245.64	111287.0
2026-03-27 07:00:00	IWM	ETF	245.71	246.68	245.36	246.28	181085.0
2026-03-27 08:00:00	IWM	ETF	245.7095	249.82	245.53	245.89	231871.0
2026-03-27 09:00:00	IWM	ETF	245.81	246.48	244.21	244.52	3908524.0
2026-03-27 10:00:00	IWM	ETF	244.53	245.67	244.135	245.45	4064351.0
2026-03-27 11:00:00	IWM	ETF	245.46	246.74	244.59	245.4999	4258613.0
2026-03-27 12:00:00	IWM	ETF	245.5	245.59	244.23	244.59	2650711.0
2026-03-27 13:00:00	IWM	ETF	244.58	245.35	243.31	243.36	3125503.0
2026-03-27 14:00:00	IWM	ETF	243.35	244.1	243.02	243.76	3821822.0
2026-03-27 15:00:00	IWM	ETF	243.75	243.86	242.41	243.08	8703744.0
2026-03-27 16:00:00	IWM	ETF	243.1	243.27	242.08	242.48	2209592.0
2026-03-27 17:00:00	IWM	ETF	242.48	242.89	242.45	242.72	12914.0
2026-03-27 18:00:00	IWM	ETF	242.79	242.79	242.13	242.13	10765.0
2026-03-27 19:00:00	IWM	ETF	242.1	242.6197	242.08	242.56	30611.0
2026-03-27 04:00:00	DIA	ETF	459.69	460.04	459.35	459.35	1284.0
2026-03-27 05:00:00	DIA	ETF	459.38	459.59	458.56	459.59	2393.0

> showing 50 of 25,427 rows — these rows as CSV

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