PREVIEW / etf_1hour / 2023-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-22.parquet
  size:    475 KB
  rows:    17,315

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-22 04:00:00	SPY	ETF	440.55	440.9	439.52	440.69	167693.0
2023-08-22 05:00:00	SPY	ETF	440.71	441.27	440.54	440.96	33047.0
2023-08-22 06:00:00	SPY	ETF	441.2	441.36	441.0	441.07	24883.0
2023-08-22 07:00:00	SPY	ETF	441.08	441.87	440.86	441.78	243694.0
2023-08-22 08:00:00	SPY	ETF	441.08	442.06	438.85	441.2	400853.0
2023-08-22 09:00:00	SPY	ETF	441.2	441.27	439.58	439.64	5691523.0
2023-08-22 10:00:00	SPY	ETF	439.65	440.41	438.64	439.7606	7488086.0
2023-08-22 11:00:00	SPY	ETF	439.77	439.86	438.58	438.7	6097961.0
2023-08-22 12:00:00	SPY	ETF	438.71	439.369	437.76	438.6999	5957748.0
2023-08-22 13:00:00	SPY	ETF	438.7	438.79	437.625	438.18	4898751.0
2023-08-22 14:00:00	SPY	ETF	438.18	438.93	437.74	438.5	4979122.0
2023-08-22 15:00:00	SPY	ETF	438.51	439.48	437.57	438.11	12300852.0
2023-08-22 16:00:00	SPY	ETF	438.1	438.21	437.96	438.2	2657387.0
2023-08-22 17:00:00	SPY	ETF	438.2	438.5	438.14	438.24	253087.0
2023-08-22 18:00:00	SPY	ETF	438.24	438.51	438.16	438.35	77330.0
2023-08-22 19:00:00	SPY	ETF	438.35	438.38	438.15	438.24	48633.0
2023-08-22 04:00:00	QQQ	ETF	365.29	365.87	364.77	365.7	89515.0
2023-08-22 05:00:00	QQQ	ETF	365.73	366.1	365.38	365.98	39748.0
2023-08-22 06:00:00	QQQ	ETF	365.94	366.23	365.77	365.86	101004.0
2023-08-22 07:00:00	QQQ	ETF	365.9	366.88	365.63	366.7	155857.0
2023-08-22 08:00:00	QQQ	ETF	365.9311	367.15	363.26	366.42	443622.0
2023-08-22 09:00:00	QQQ	ETF	366.42	366.66	364.22	364.41	4963010.0
2023-08-22 10:00:00	QQQ	ETF	364.41	365.7	363.58	365.465	5672413.0
2023-08-22 11:00:00	QQQ	ETF	365.47	365.6585	363.65	363.94	3802831.0
2023-08-22 12:00:00	QQQ	ETF	363.9494	364.2546	362.7039	363.67	4062200.0
2023-08-22 13:00:00	QQQ	ETF	363.67	363.86	362.68	363.3453	3557416.0
2023-08-22 14:00:00	QQQ	ETF	363.33	364.08	362.85	363.71	3222258.0
2023-08-22 15:00:00	QQQ	ETF	363.71	364.57	362.7	363.37	5514061.0
2023-08-22 16:00:00	QQQ	ETF	363.38	363.599	363.28	363.46	2475839.0
2023-08-22 17:00:00	QQQ	ETF	363.39	363.59	363.38	363.38	43233.0
2023-08-22 18:00:00	QQQ	ETF	363.39	363.85	363.39	363.58	60153.0
2023-08-22 19:00:00	QQQ	ETF	363.58	363.64	363.31	363.44	43729.0
2023-08-22 04:00:00	IWM	ETF	184.96	184.99	184.79	184.97	12745.0
2023-08-22 05:00:00	IWM	ETF	184.96	185.2	184.89	185.1	9609.0
2023-08-22 06:00:00	IWM	ETF	185.12	185.3	185.12	185.18	10417.0
2023-08-22 07:00:00	IWM	ETF	185.29	185.46	185.16	185.44	43346.0
2023-08-22 08:00:00	IWM	ETF	185.2794	185.63	185.0796	185.0796	59777.0
2023-08-22 09:00:00	IWM	ETF	185.04	185.545	183.88	183.951	2881068.0
2023-08-22 10:00:00	IWM	ETF	183.97	184.31	183.5	184.04	2726381.0
2023-08-22 11:00:00	IWM	ETF	184.04	184.24	183.61	183.835	1441100.0
2023-08-22 12:00:00	IWM	ETF	183.83	183.89	183.25	183.65	1922424.0
2023-08-22 13:00:00	IWM	ETF	183.66	183.71	183.22	183.61	1932657.0
2023-08-22 14:00:00	IWM	ETF	183.6	184.135	183.43	184.02	1496129.0
2023-08-22 15:00:00	IWM	ETF	184.02	184.425	183.69	183.86	3659560.0
2023-08-22 16:00:00	IWM	ETF	183.83	183.95	183.8	183.95	625502.0
2023-08-22 17:00:00	IWM	ETF	183.97	184.0	183.83	183.9	10820.0
2023-08-22 18:00:00	IWM	ETF	183.94	184.12	183.94	184.0	19430.0
2023-08-22 19:00:00	IWM	ETF	184.05	184.1	183.94	184.01	23541.0
2023-08-22 04:00:00	DIA	ETF	345.14	345.19	345.14	345.19	1100.0
2023-08-22 05:00:00	DIA	ETF	345.28	345.28	345.28	345.28	400.0

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

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