PREVIEW / etf_1hour / 2023-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-13.parquet
  size:    480 KB
  rows:    17,573

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
2023-10-13 04:00:00	SPY	ETF	434.48	434.84	433.8	433.87	23817.0
2023-10-13 05:00:00	SPY	ETF	433.87	433.87	432.51	432.6	31270.0
2023-10-13 06:00:00	SPY	ETF	432.55	433.21	432.29	432.87	77297.0
2023-10-13 07:00:00	SPY	ETF	432.96	433.77	432.92	433.53	257517.0
2023-10-13 08:00:00	SPY	ETF	432.93	435.2	432.3496	435.1	663884.0
2023-10-13 09:00:00	SPY	ETF	435.1	436.45	434.98	435.91	6157632.0
2023-10-13 10:00:00	SPY	ETF	435.84	435.91	432.585	432.78	10268492.0
2023-10-13 11:00:00	SPY	ETF	432.79	432.88	431.04	431.33	9429872.0
2023-10-13 12:00:00	SPY	ETF	431.33	433.36	431.17	432.1	7963872.0
2023-10-13 13:00:00	SPY	ETF	432.1	432.33	429.88	431.4	10164846.0
2023-10-13 14:00:00	SPY	ETF	431.4	432.115	430.77	431.56	7536722.0
2023-10-13 15:00:00	SPY	ETF	431.6	432.47	430.33	431.55	18308073.0
2023-10-13 16:00:00	SPY	ETF	431.55	431.55	430.83	430.93	4469356.0
2023-10-13 17:00:00	SPY	ETF	430.89	431.05	430.7	430.85	162783.0
2023-10-13 18:00:00	SPY	ETF	430.77	430.95	430.65	430.65	39352.0
2023-10-13 19:00:00	SPY	ETF	430.74	430.8	430.45	430.45	18424.0
2023-10-13 04:00:00	QQQ	ETF	370.15	370.36	369.34	369.43	60782.0
2023-10-13 05:00:00	QQQ	ETF	369.45	369.49	367.9	367.9	161475.0
2023-10-13 06:00:00	QQQ	ETF	368.0	368.4	367.61	368.25	124688.0
2023-10-13 07:00:00	QQQ	ETF	368.28	368.92	368.23	368.8	294734.0
2023-10-13 08:00:00	QQQ	ETF	368.6693	370.35	367.8296	370.25	521083.0
2023-10-13 09:00:00	QQQ	ETF	370.2	371.16	369.6225	370.6287	3674791.0
2023-10-13 10:00:00	QQQ	ETF	370.57	370.59	366.84	367.1837	6366754.0
2023-10-13 11:00:00	QQQ	ETF	367.17	367.3891	365.0	365.22	6157645.0
2023-10-13 12:00:00	QQQ	ETF	365.21	367.19	365.0601	366.3138	4752223.0
2023-10-13 13:00:00	QQQ	ETF	366.32	366.38	363.86	365.18	5677854.0
2023-10-13 14:00:00	QQQ	ETF	365.18	365.8099	364.54	365.5075	4124989.0
2023-10-13 15:00:00	QQQ	ETF	365.52	366.43	364.325	365.25	9760162.0
2023-10-13 16:00:00	QQQ	ETF	365.25	365.28	364.79	365.22	1467017.0
2023-10-13 17:00:00	QQQ	ETF	364.95	364.98	364.68	364.7	35650.0
2023-10-13 18:00:00	QQQ	ETF	364.71	364.86	364.65	364.66	12408.0
2023-10-13 19:00:00	QQQ	ETF	364.7	364.84	364.26	364.39	26828.0
2023-10-13 04:00:00	IWM	ETF	172.3	172.46	171.87	171.93	13046.0
2023-10-13 05:00:00	IWM	ETF	171.65	171.65	171.3	171.3	17237.0
2023-10-13 06:00:00	IWM	ETF	171.36	171.67	171.2	171.5	32972.0
2023-10-13 07:00:00	IWM	ETF	171.54	171.89	171.43	171.77	74436.0
2023-10-13 08:00:00	IWM	ETF	171.81	172.57	171.4804	172.51	301176.0
2023-10-13 09:00:00	IWM	ETF	172.45	172.7	171.44	171.68	3832597.0
2023-10-13 10:00:00	IWM	ETF	171.66	171.8	170.585	170.71	4686508.0
2023-10-13 11:00:00	IWM	ETF	170.71	170.9501	170.2	170.28	3635113.0
2023-10-13 12:00:00	IWM	ETF	170.27	170.99	170.21	170.525	3195783.0
2023-10-13 13:00:00	IWM	ETF	170.52	170.615	169.69	170.12	4302380.0
2023-10-13 14:00:00	IWM	ETF	170.11	170.44	170.02	170.265	2471662.0
2023-10-13 15:00:00	IWM	ETF	170.265	170.545	169.99	170.27	5083581.0
2023-10-13 16:00:00	IWM	ETF	170.27	170.28	169.9	169.95	775446.0
2023-10-13 17:00:00	IWM	ETF	170.0	170.18	169.91	170.06	5335.0
2023-10-13 18:00:00	IWM	ETF	170.02	170.06	169.86	169.86	3482.0
2023-10-13 19:00:00	IWM	ETF	169.85	169.85	169.71	169.8	3439.0
2023-10-13 04:00:00	DIA	ETF	337.15	337.29	337.1	337.17	1586.0
2023-10-13 05:00:00	DIA	ETF	336.36	336.39	335.84	336.03	3400.0

> showing 50 of 17,573 rows — these rows as CSV

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