PREVIEW / etf_1hour / 2024-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-07-17.parquet
  size:    564 KB
  rows:    21,256

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
2024-07-17 04:00:00	SPY	ETF	562.5	562.5	560.13	560.71	57325.0
2024-07-17 05:00:00	SPY	ETF	560.86	561.0	560.47	560.92	32946.0
2024-07-17 06:00:00	SPY	ETF	560.88	561.0	560.18	560.43	70852.0
2024-07-17 07:00:00	SPY	ETF	560.42	560.65	558.8	559.6	579390.0
2024-07-17 08:00:00	SPY	ETF	559.57	564.18	558.87	559.13	563497.0
2024-07-17 09:00:00	SPY	ETF	559.12	560.51	558.59	559.875	5037230.0
2024-07-17 10:00:00	SPY	ETF	559.87	559.89	557.9099	558.25	5482905.0
2024-07-17 11:00:00	SPY	ETF	558.26	558.77	557.79	558.42	3262734.0
2024-07-17 12:00:00	SPY	ETF	558.43	558.55	557.05	557.97	3392432.0
2024-07-17 13:00:00	SPY	ETF	557.96	557.96	556.61	557.3156	3223866.0
2024-07-17 14:00:00	SPY	ETF	557.33	558.375	556.84	557.45	3369293.0
2024-07-17 15:00:00	SPY	ETF	557.45	558.28	556.95	556.95	9161672.0
2024-07-17 16:00:00	SPY	ETF	556.95	558.167	556.4295	557.48	3309646.0
2024-07-17 17:00:00	SPY	ETF	557.45	557.54	557.25	557.49	94863.0
2024-07-17 18:00:00	SPY	ETF	557.5	558.2	557.41	558.14	109913.0
2024-07-17 19:00:00	SPY	ETF	558.17	558.19	558.0	558.08	119348.0
2024-07-17 04:00:00	QQQ	ETF	492.97	492.97	489.5	490.37	131356.0
2024-07-17 05:00:00	QQQ	ETF	490.33	490.5	489.79	490.41	36387.0
2024-07-17 06:00:00	QQQ	ETF	490.3	490.87	489.73	490.13	103113.0
2024-07-17 07:00:00	QQQ	ETF	490.07	490.44	488.31	488.94	414568.0
2024-07-17 08:00:00	QQQ	ETF	488.9	496.712	488.3201	488.8	446615.0
2024-07-17 09:00:00	QQQ	ETF	488.76	489.18	487.0	487.055	6648387.0
2024-07-17 10:00:00	QQQ	ETF	487.04	487.1	484.36	484.98	6541915.0
2024-07-17 11:00:00	QQQ	ETF	484.96	485.65	483.29	484.09	3557424.0
2024-07-17 12:00:00	QQQ	ETF	484.11	484.18	482.2	483.5698	4438383.0
2024-07-17 13:00:00	QQQ	ETF	483.49	484.04	482.3	482.77	2628143.0
2024-07-17 14:00:00	QQQ	ETF	482.78	483.81	482.2925	482.67	3027554.0
2024-07-17 15:00:00	QQQ	ETF	482.65	483.74	481.7	481.8	6824486.0
2024-07-17 16:00:00	QQQ	ETF	481.81	482.57	481.19	482.31	2826832.0
2024-07-17 17:00:00	QQQ	ETF	482.22	482.64	482.17	482.6	57711.0
2024-07-17 18:00:00	QQQ	ETF	482.6	483.52	482.6	483.43	177668.0
2024-07-17 19:00:00	QQQ	ETF	483.48	483.6	483.27	483.4399	47586.0
2024-07-17 04:00:00	IWM	ETF	223.46	224.82	223.33	224.82	113153.0
2024-07-17 05:00:00	IWM	ETF	224.78	225.38	224.62	225.33	127071.0
2024-07-17 06:00:00	IWM	ETF	225.36	225.65	224.18	224.28	330608.0
2024-07-17 07:00:00	IWM	ETF	224.27	224.27	222.58	223.67	565210.0
2024-07-17 08:00:00	IWM	ETF	223.61	224.93	222.0	222.19	701077.0
2024-07-17 09:00:00	IWM	ETF	222.21	226.64	222.05	225.71	9656696.0
2024-07-17 10:00:00	IWM	ETF	225.715	225.79	222.86	223.0	10706497.0
2024-07-17 11:00:00	IWM	ETF	222.99	223.76	222.6301	223.39	5065865.0
2024-07-17 12:00:00	IWM	ETF	223.385	223.61	221.89	222.4601	4490721.0
2024-07-17 13:00:00	IWM	ETF	222.4425	222.79	221.66	222.2705	3306579.0
2024-07-17 14:00:00	IWM	ETF	222.27	223.14	222.05	222.575	3356143.0
2024-07-17 15:00:00	IWM	ETF	222.555	223.45	222.2	222.32	6478879.0
2024-07-17 16:00:00	IWM	ETF	222.25	222.89	222.12	222.73	2953087.0
2024-07-17 17:00:00	IWM	ETF	222.76	222.92	222.0921	222.68	487462.0
2024-07-17 18:00:00	IWM	ETF	222.96	223.3	222.25	223.28	60574.0
2024-07-17 19:00:00	IWM	ETF	223.28	223.78	223.2612	223.5	86320.0
2024-07-17 04:00:00	DIA	ETF	408.64	409.02	408.58	408.88	22782.0
2024-07-17 05:00:00	DIA	ETF	408.84	409.07	408.73	408.79	2567.0

> showing 50 of 21,256 rows — these rows as CSV

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