PREVIEW / etf_1hour / 2023-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-03.parquet
  size:    500 KB
  rows:    18,265

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-03 04:00:00	SPY	ETF	427.46	428.46	427.45	428.05	41287.0
2023-10-03 05:00:00	SPY	ETF	428.05	428.05	427.48	427.71	17044.0
2023-10-03 06:00:00	SPY	ETF	427.67	428.12	427.26	427.26	25277.0
2023-10-03 07:00:00	SPY	ETF	427.13	427.22	425.08	425.39	861927.0
2023-10-03 08:00:00	SPY	ETF	425.89	428.2896	424.24	424.39	1025157.0
2023-10-03 09:00:00	SPY	ETF	424.39	426.65	424.22	426.29	6448709.0
2023-10-03 10:00:00	SPY	ETF	426.29	426.34	421.46	421.763	19683026.0
2023-10-03 11:00:00	SPY	ETF	421.75	422.16	420.76	421.199	10405083.0
2023-10-03 12:00:00	SPY	ETF	421.19	422.58	421.11	422.22	9131816.0
2023-10-03 13:00:00	SPY	ETF	422.21	422.83	420.74	420.89	8368237.0
2023-10-03 14:00:00	SPY	ETF	420.9	421.55	420.18	421.14	9355602.0
2023-10-03 15:00:00	SPY	ETF	421.15	421.74	420.29	421.67	17984678.0
2023-10-03 16:00:00	SPY	ETF	421.68	422.0713	421.27	421.2803	4682037.0
2023-10-03 17:00:00	SPY	ETF	421.28	421.37	421.11	421.24	140092.0
2023-10-03 18:00:00	SPY	ETF	421.25	421.55	421.08	421.53	191154.0
2023-10-03 19:00:00	SPY	ETF	421.53	421.65	421.1	421.57	56561.0
2023-10-03 04:00:00	QQQ	ETF	361.16	362.34	361.16	361.73	37809.0
2023-10-03 05:00:00	QQQ	ETF	361.75	361.75	360.93	361.14	21962.0
2023-10-03 06:00:00	QQQ	ETF	361.39	361.8	360.88	360.88	44929.0
2023-10-03 07:00:00	QQQ	ETF	360.86	360.87	358.9	359.26	345990.0
2023-10-03 08:00:00	QQQ	ETF	359.23	362.3104	358.0	358.1	628347.0
2023-10-03 09:00:00	QQQ	ETF	358.16	361.01	358.02	360.44	5204962.0
2023-10-03 10:00:00	QQQ	ETF	360.45	360.51	355.46	355.59	12256376.0
2023-10-03 11:00:00	QQQ	ETF	355.58	355.8587	354.7127	355.16	5773175.0
2023-10-03 12:00:00	QQQ	ETF	355.17	356.3	355.09	355.99	4692764.0
2023-10-03 13:00:00	QQQ	ETF	355.98	356.51	354.22	354.3901	4692148.0
2023-10-03 14:00:00	QQQ	ETF	354.39	354.85	353.76	354.43	5303780.0
2023-10-03 15:00:00	QQQ	ETF	354.42	355.0	353.275	354.9	9938111.0
2023-10-03 16:00:00	QQQ	ETF	354.87	355.22	354.68	354.73	1770744.0
2023-10-03 17:00:00	QQQ	ETF	354.77	354.77	354.5	354.56	90839.0
2023-10-03 18:00:00	QQQ	ETF	354.64	354.86	354.4	354.86	87723.0
2023-10-03 19:00:00	QQQ	ETF	354.78	355.0	354.35	354.79	118946.0
2023-10-03 04:00:00	IWM	ETF	173.95	174.37	173.92	174.27	13600.0
2023-10-03 05:00:00	IWM	ETF	174.19	174.2	173.97	174.06	7878.0
2023-10-03 06:00:00	IWM	ETF	174.08	174.1	173.75	173.82	21537.0
2023-10-03 07:00:00	IWM	ETF	173.73	173.76	172.93	173.05	107485.0
2023-10-03 08:00:00	IWM	ETF	173.1897	174.0896	172.5799	172.62	326846.0
2023-10-03 09:00:00	IWM	ETF	172.63	173.5	172.42	173.11	4231972.0
2023-10-03 10:00:00	IWM	ETF	173.11	173.11	171.15	171.165	6371795.0
2023-10-03 11:00:00	IWM	ETF	171.16	171.63	170.94	171.16	4456783.0
2023-10-03 12:00:00	IWM	ETF	171.17	171.92	171.15	171.54	4125859.0
2023-10-03 13:00:00	IWM	ETF	171.53	171.84	170.585	170.64	3211301.0
2023-10-03 14:00:00	IWM	ETF	170.64	171.31	170.37	171.18	4002678.0
2023-10-03 15:00:00	IWM	ETF	171.17	171.31	170.745	171.14	6726933.0
2023-10-03 16:00:00	IWM	ETF	171.14	171.3	170.94	170.94	1074761.0
2023-10-03 17:00:00	IWM	ETF	170.92	171.13	170.85	171.02	31269.0
2023-10-03 18:00:00	IWM	ETF	170.94	171.1	170.84	171.02	80861.0
2023-10-03 19:00:00	IWM	ETF	171.0	171.2	170.9	171.14	38662.0
2023-10-03 04:00:00	DIA	ETF	334.68	334.68	334.68	334.68	100.0
2023-10-03 05:00:00	DIA	ETF	334.42	334.42	334.31	334.31	650.0

> showing 50 of 18,265 rows — these rows as CSV

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