PREVIEW / etf_1hour / 2023-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-25.parquet
  size:    467 KB
  rows:    16,889

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-08-25 04:00:00	SPY	ETF	437.48	438.24	437.48	437.99	30450.0
2023-08-25 05:00:00	SPY	ETF	438.03	438.13	437.46	437.46	10512.0
2023-08-25 06:00:00	SPY	ETF	437.65	438.3	437.65	438.2	50865.0
2023-08-25 07:00:00	SPY	ETF	438.2	438.3	437.82	438.14	131956.0
2023-08-25 08:00:00	SPY	ETF	438.1606	439.08	436.68	438.81	1287114.0
2023-08-25 09:00:00	SPY	ETF	438.78	439.4999	438.07	439.09	5008388.0
2023-08-25 10:00:00	SPY	ETF	439.06	441.2	435.14	435.25	19324278.0
2023-08-25 11:00:00	SPY	ETF	435.25	438.7699	435.0	437.0	13407299.0
2023-08-25 12:00:00	SPY	ETF	437.0	439.1	436.94	438.67	7722117.0
2023-08-25 13:00:00	SPY	ETF	438.672	439.1	437.37	438.5696	7034042.0
2023-08-25 14:00:00	SPY	ETF	438.565	440.88	438.43	440.78	8739447.0
2023-08-25 15:00:00	SPY	ETF	440.79	441.3	439.53	439.95	17069634.0
2023-08-25 16:00:00	SPY	ETF	439.94	440.27	439.0	439.81	3201067.0
2023-08-25 17:00:00	SPY	ETF	439.72	439.99	439.72	439.92	89668.0
2023-08-25 18:00:00	SPY	ETF	439.92	439.92	439.65	439.8	18146.0
2023-08-25 19:00:00	SPY	ETF	439.78	439.89	439.73	439.85	9039.0
2023-08-25 04:00:00	QQQ	ETF	360.73	361.86	360.72	361.57	77276.0
2023-08-25 05:00:00	QQQ	ETF	361.44	361.66	361.0	361.1	39872.0
2023-08-25 06:00:00	QQQ	ETF	361.22	361.83	361.14	361.7	48372.0
2023-08-25 07:00:00	QQQ	ETF	361.61	361.78	361.1	361.62	228035.0
2023-08-25 08:00:00	QQQ	ETF	361.69	362.6	359.4	362.1201	372057.0
2023-08-25 09:00:00	QQQ	ETF	362.13	363.495	361.66	363.32	5582238.0
2023-08-25 10:00:00	QQQ	ETF	363.31	365.74	358.63	358.73	15585735.0
2023-08-25 11:00:00	QQQ	ETF	358.75	361.94	358.58	359.9	8244085.0
2023-08-25 12:00:00	QQQ	ETF	359.85	362.11	359.8	361.75	5328223.0
2023-08-25 13:00:00	QQQ	ETF	361.745	362.2788	360.64	361.7037	4370512.0
2023-08-25 14:00:00	QQQ	ETF	361.68	364.53	361.57	364.46	6352408.0
2023-08-25 15:00:00	QQQ	ETF	364.48	365.235	363.79	364.07	8060113.0
2023-08-25 16:00:00	QQQ	ETF	364.06	364.4295	363.83	363.88	1312684.0
2023-08-25 17:00:00	QQQ	ETF	363.85	363.99	363.8	363.8	56736.0
2023-08-25 18:00:00	QQQ	ETF	363.8	363.8	363.63	363.66	37128.0
2023-08-25 19:00:00	QQQ	ETF	363.67	363.8	363.61	363.76	17637.0
2023-08-25 04:00:00	IWM	ETF	183.96	184.14	183.89	184.08	27113.0
2023-08-25 05:00:00	IWM	ETF	184.16	184.16	183.9	183.9	7786.0
2023-08-25 06:00:00	IWM	ETF	183.86	184.36	183.85	184.28	39392.0
2023-08-25 07:00:00	IWM	ETF	184.27	184.38	184.15	184.38	59846.0
2023-08-25 08:00:00	IWM	ETF	184.27	184.59	183.65	184.3504	79189.0
2023-08-25 09:00:00	IWM	ETF	184.37	184.87	183.58	183.76	2183919.0
2023-08-25 10:00:00	IWM	ETF	183.76	184.765	181.73	181.7407	5640799.0
2023-08-25 11:00:00	IWM	ETF	181.75	183.455	181.61	182.8	4933845.0
2023-08-25 12:00:00	IWM	ETF	182.79	183.97	182.75	183.79	2049236.0
2023-08-25 13:00:00	IWM	ETF	183.795	183.96	183.2	183.75	1724937.0
2023-08-25 14:00:00	IWM	ETF	183.74	184.78	183.71	184.72	2917974.0
2023-08-25 15:00:00	IWM	ETF	184.73	185.0	183.82	184.0	4246962.0
2023-08-25 16:00:00	IWM	ETF	184.0	184.11	183.8	183.8	821672.0
2023-08-25 17:00:00	IWM	ETF	183.89	183.92	183.8	183.83	16754.0
2023-08-25 18:00:00	IWM	ETF	183.85	183.88	183.82	183.88	2778.0
2023-08-25 19:00:00	IWM	ETF	183.88	183.89	183.76	183.89	4819.0
2023-08-25 06:00:00	DIA	ETF	341.95	341.95	341.92	341.92	700.0
2023-08-25 07:00:00	DIA	ETF	342.23	342.27	342.181	342.21	11988.0

> showing 50 of 16,889 rows — these rows as CSV

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