PREVIEW / etf_1hour / 2023-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-26.parquet
  size:    471 KB
  rows:    17,230

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-06-26 04:00:00	SPY	ETF	432.85	432.85	431.99	432.17	243168.0
2023-06-26 05:00:00	SPY	ETF	432.3	432.92	432.3	432.75	19786.0
2023-06-26 06:00:00	SPY	ETF	432.72	432.84	432.5	432.55	18699.0
2023-06-26 07:00:00	SPY	ETF	432.59	433.15	432.45	432.99	76880.0
2023-06-26 08:00:00	SPY	ETF	432.57	434.37	432.0	433.02	254903.0
2023-06-26 09:00:00	SPY	ETF	432.96	434.44	432.55	434.27	4743768.0
2023-06-26 10:00:00	SPY	ETF	434.27	434.61	432.28	433.5	7982851.0
2023-06-26 11:00:00	SPY	ETF	433.49	433.52	432.275	433.15	6054091.0
2023-06-26 12:00:00	SPY	ETF	433.15	433.2796	431.65	432.39	6685009.0
2023-06-26 13:00:00	SPY	ETF	432.395	432.715	431.965	432.1879	3934971.0
2023-06-26 14:00:00	SPY	ETF	432.18	432.9	431.75	432.665	4657129.0
2023-06-26 15:00:00	SPY	ETF	432.67	432.92	431.19	431.43	15998266.0
2023-06-26 16:00:00	SPY	ETF	431.42	431.96	431.41	431.8	3142251.0
2023-06-26 17:00:00	SPY	ETF	431.85	431.85	431.44	431.77	34328.0
2023-06-26 18:00:00	SPY	ETF	431.79	432.0	431.7	431.97	102169.0
2023-06-26 19:00:00	SPY	ETF	431.98	432.25	431.97	432.22	92574.0
2023-06-26 04:00:00	QQQ	ETF	362.36	363.0	361.27	361.39	63831.0
2023-06-26 05:00:00	QQQ	ETF	361.47	362.14	361.47	361.94	31243.0
2023-06-26 06:00:00	QQQ	ETF	361.91	362.04	361.6	361.7	15139.0
2023-06-26 07:00:00	QQQ	ETF	361.69	362.43	361.55	362.31	83694.0
2023-06-26 08:00:00	QQQ	ETF	361.8718	363.6	361.5801	362.61	182734.0
2023-06-26 09:00:00	QQQ	ETF	362.61	364.555	361.78	364.49	3777585.0
2023-06-26 10:00:00	QQQ	ETF	364.49	364.84	361.91	363.15	5644173.0
2023-06-26 11:00:00	QQQ	ETF	363.14	363.185	360.67	361.51	5038106.0
2023-06-26 12:00:00	QQQ	ETF	361.5	361.53	358.25	359.13	6530169.0
2023-06-26 13:00:00	QQQ	ETF	359.135	359.48	358.46	358.792	4057144.0
2023-06-26 14:00:00	QQQ	ETF	358.79	359.95	358.5907	359.5104	3342880.0
2023-06-26 15:00:00	QQQ	ETF	359.53	359.93	357.59	357.73	8604781.0
2023-06-26 16:00:00	QQQ	ETF	357.68	358.53	357.6522	358.11	2322575.0
2023-06-26 17:00:00	QQQ	ETF	358.11	358.28	357.68	358.2	107194.0
2023-06-26 18:00:00	QQQ	ETF	358.2	358.32	357.86	358.25	83455.0
2023-06-26 19:00:00	QQQ	ETF	358.26	358.6	358.26	358.6	62967.0
2023-06-26 04:00:00	IWM	ETF	180.07	180.14	179.53	179.65	27266.0
2023-06-26 05:00:00	IWM	ETF	179.77	180.45	179.77	180.35	7958.0
2023-06-26 06:00:00	IWM	ETF	180.31	180.36	180.09	180.24	4976.0
2023-06-26 07:00:00	IWM	ETF	180.19	180.45	180.11	180.31	19645.0
2023-06-26 08:00:00	IWM	ETF	180.2181	180.58	180.1	180.4	102573.0
2023-06-26 09:00:00	IWM	ETF	180.4	182.74	180.22	182.17	3977299.0
2023-06-26 10:00:00	IWM	ETF	182.16	182.17	180.91	181.6	3653429.0
2023-06-26 11:00:00	IWM	ETF	181.6	181.91	181.0097	181.83	2463252.0
2023-06-26 12:00:00	IWM	ETF	181.82	181.89	180.52	181.2	2993670.0
2023-06-26 13:00:00	IWM	ETF	181.2	181.9	181.2	181.56	1960242.0
2023-06-26 14:00:00	IWM	ETF	181.56	182.02	181.49	181.97	1831370.0
2023-06-26 15:00:00	IWM	ETF	181.97	182.155	180.69	180.775	5649530.0
2023-06-26 16:00:00	IWM	ETF	180.75	181.12	180.75	181.0	1967901.0
2023-06-26 17:00:00	IWM	ETF	180.99	181.03	180.75	180.86	27284.0
2023-06-26 18:00:00	IWM	ETF	180.95	181.18	180.94	181.08	11335.0
2023-06-26 19:00:00	IWM	ETF	181.14	181.18	181.04	181.18	10961.0
2023-06-26 04:00:00	DIA	ETF	336.71	336.79	336.43	336.43	2100.0
2023-06-26 05:00:00	DIA	ETF	336.95	336.95	336.95	336.95	500.0

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

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