PREVIEW / etf_1hour / 2023-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-20.parquet
  size:    475 KB
  rows:    17,333

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-09-20 04:00:00	SPY	ETF	442.98	443.44	442.65	443.39	34499.0
2023-09-20 05:00:00	SPY	ETF	443.45	443.68	443.24	443.6	29152.0
2023-09-20 06:00:00	SPY	ETF	443.53	443.67	443.33	443.63	33308.0
2023-09-20 07:00:00	SPY	ETF	443.59	443.8	443.5	443.69	123759.0
2023-09-20 08:00:00	SPY	ETF	443.5919	444.26	442.24	444.25	412528.0
2023-09-20 09:00:00	SPY	ETF	444.23	444.45	443.44	444.1	4559682.0
2023-09-20 10:00:00	SPY	ETF	444.11	444.435	443.4	443.63	4833231.0
2023-09-20 11:00:00	SPY	ETF	443.63	443.9469	443.16	443.745	3921529.0
2023-09-20 12:00:00	SPY	ETF	443.74	444.01	443.48	443.9703	2474508.0
2023-09-20 13:00:00	SPY	ETF	443.98	444.01	443.07	443.575	3087876.0
2023-09-20 14:00:00	SPY	ETF	443.59	443.75	441.47	441.81	15369772.0
2023-09-20 15:00:00	SPY	ETF	441.8	442.26	438.43	438.58	20977809.0
2023-09-20 16:00:00	SPY	ETF	438.58	438.76	438.19	438.24	4656549.0
2023-09-20 17:00:00	SPY	ETF	438.24	438.37	438.18	438.27	68017.0
2023-09-20 18:00:00	SPY	ETF	438.3	438.49	437.97	438.12	86773.0
2023-09-20 19:00:00	SPY	ETF	438.08	438.18	437.85	437.9	67489.0
2023-09-20 04:00:00	QQQ	ETF	370.05	370.6	369.67	370.56	29884.0
2023-09-20 05:00:00	QQQ	ETF	370.6	370.7	370.37	370.6	17503.0
2023-09-20 06:00:00	QQQ	ETF	370.51	370.63	370.25	370.57	82119.0
2023-09-20 07:00:00	QQQ	ETF	370.55	370.75	370.33	370.6	61509.0
2023-09-20 08:00:00	QQQ	ETF	369.24	371.21	369.11	371.2	223891.0
2023-09-20 09:00:00	QQQ	ETF	371.2	371.33	369.87	370.765	2727634.0
2023-09-20 10:00:00	QQQ	ETF	370.78	370.9692	369.42	369.58	3554478.0
2023-09-20 11:00:00	QQQ	ETF	369.59	369.91	368.77	369.89	2723827.0
2023-09-20 12:00:00	QQQ	ETF	369.89	370.11	369.5	370.05	1814603.0
2023-09-20 13:00:00	QQQ	ETF	370.06	370.15	369.22	369.76	1722253.0
2023-09-20 14:00:00	QQQ	ETF	369.73	370.28	367.75	368.19	11302981.0
2023-09-20 15:00:00	QQQ	ETF	368.17	368.68	364.46	364.54	11960955.0
2023-09-20 16:00:00	QQQ	ETF	364.54	364.69	363.97	364.08	1527443.0
2023-09-20 17:00:00	QQQ	ETF	364.12	364.21	363.95	364.091	65370.0
2023-09-20 18:00:00	QQQ	ETF	364.19	364.44	363.7	363.92	136137.0
2023-09-20 19:00:00	QQQ	ETF	363.85	364.07	363.55	363.6	107958.0
2023-09-20 04:00:00	IWM	ETF	181.78	182.06	181.76	182.06	12248.0
2023-09-20 05:00:00	IWM	ETF	182.18	182.18	182.1	182.15	4265.0
2023-09-20 06:00:00	IWM	ETF	182.3	182.42	182.3	182.34	3641.0
2023-09-20 07:00:00	IWM	ETF	182.44	182.57	182.42	182.42	47074.0
2023-09-20 08:00:00	IWM	ETF	182.4	182.69	181.5	182.6	70170.0
2023-09-20 09:00:00	IWM	ETF	182.59	183.42	182.23	183.3	2492054.0
2023-09-20 10:00:00	IWM	ETF	183.3	183.509	182.61	182.71	1898021.0
2023-09-20 11:00:00	IWM	ETF	182.7	182.995	182.5506	182.635	1279548.0
2023-09-20 12:00:00	IWM	ETF	182.63	182.82	182.53	182.565	714806.0
2023-09-20 13:00:00	IWM	ETF	182.57	182.61	182.165	182.53	921246.0
2023-09-20 14:00:00	IWM	ETF	182.51	182.59	181.66	181.735	3863826.0
2023-09-20 15:00:00	IWM	ETF	181.73	181.87	179.82	179.87	8056114.0
2023-09-20 16:00:00	IWM	ETF	179.86	179.95	179.69	179.8	885024.0
2023-09-20 17:00:00	IWM	ETF	179.81	179.86	179.71	179.81	8515.0
2023-09-20 18:00:00	IWM	ETF	179.85	179.9	179.61	179.68	35586.0
2023-09-20 19:00:00	IWM	ETF	179.71	179.72	179.5	179.5599	37478.0
2023-09-20 05:00:00	DIA	ETF	345.66	345.66	345.66	345.66	300.0
2023-09-20 06:00:00	DIA	ETF	345.72	345.72	345.68	345.68	490.0

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

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