PREVIEW / etf_1hour / 2023-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-11.parquet
  size:    513 KB
  rows:    18,836

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-12-11 04:00:00	SPY	ETF	459.82	460.4	459.69	459.96	18063.0
2023-12-11 05:00:00	SPY	ETF	459.9	460.13	459.69	459.69	12118.0
2023-12-11 06:00:00	SPY	ETF	459.68	459.98	459.41	459.98	31425.0
2023-12-11 07:00:00	SPY	ETF	459.95	460.11	459.8	460.05	57947.0
2023-12-11 08:00:00	SPY	ETF	460.05	460.2796	459.41	459.94	167350.0
2023-12-11 09:00:00	SPY	ETF	459.92	460.42	459.47	460.405	6182749.0
2023-12-11 10:00:00	SPY	ETF	460.4	461.16	459.95	460.79	7337081.0
2023-12-11 11:00:00	SPY	ETF	460.795	461.23	459.905	460.53	6346808.0
2023-12-11 12:00:00	SPY	ETF	460.53	461.02	460.3034	460.9603	3673392.0
2023-12-11 13:00:00	SPY	ETF	460.965	461.7487	460.655	461.6408	4717813.0
2023-12-11 14:00:00	SPY	ETF	461.64	461.85	461.44	461.54	3925121.0
2023-12-11 15:00:00	SPY	ETF	461.545	462.17	461.3396	461.97	11610473.0
2023-12-11 16:00:00	SPY	ETF	461.96	462.14	461.4146	461.95	3540338.0
2023-12-11 17:00:00	SPY	ETF	462.0	462.0	461.85	461.99	690759.0
2023-12-11 18:00:00	SPY	ETF	461.92	462.06	456.99	462.03	859734.0
2023-12-11 19:00:00	SPY	ETF	462.06	462.42	462.01	462.3	61891.0
2023-12-11 04:00:00	QQQ	ETF	391.4	392.01	391.28	391.6	36158.0
2023-12-11 05:00:00	QQQ	ETF	391.56	391.81	391.3	391.31	24431.0
2023-12-11 06:00:00	QQQ	ETF	391.32	391.56	390.96	391.5	36146.0
2023-12-11 07:00:00	QQQ	ETF	391.54	391.92	391.44	391.74	88802.0
2023-12-11 08:00:00	QQQ	ETF	391.5397	392.464	391.14	391.7735	148462.0
2023-12-11 09:00:00	QQQ	ETF	391.81	393.81	391.53	393.73	6710779.0
2023-12-11 10:00:00	QQQ	ETF	393.73	394.6697	393.12	394.1203	5327889.0
2023-12-11 11:00:00	QQQ	ETF	394.13	394.35	392.8	393.7687	4288287.0
2023-12-11 12:00:00	QQQ	ETF	393.76	394.78	393.41	394.73	2666726.0
2023-12-11 13:00:00	QQQ	ETF	394.73	395.745	394.39	395.5499	2987868.0
2023-12-11 14:00:00	QQQ	ETF	395.53	395.79	395.1	395.27	2309458.0
2023-12-11 15:00:00	QQQ	ETF	395.28	395.71	394.9499	395.53	4568194.0
2023-12-11 16:00:00	QQQ	ETF	395.53	395.84	395.4	395.75	1248370.0
2023-12-11 17:00:00	QQQ	ETF	395.75	395.76	395.64	395.68	23550.0
2023-12-11 18:00:00	QQQ	ETF	395.64	395.73	395.45	395.7	67701.0
2023-12-11 19:00:00	QQQ	ETF	395.71	396.38	395.67	396.06	129204.0
2023-12-11 04:00:00	IWM	ETF	186.51	187.02	186.48	186.58	11362.0
2023-12-11 05:00:00	IWM	ETF	186.56	186.82	186.54	186.54	3695.0
2023-12-11 06:00:00	IWM	ETF	186.55	186.75	186.39	186.75	54065.0
2023-12-11 07:00:00	IWM	ETF	186.74	186.98	186.73	186.92	117618.0
2023-12-11 08:00:00	IWM	ETF	186.91	187.17	186.574	186.72	72899.0
2023-12-11 09:00:00	IWM	ETF	186.71	187.62	186.01	186.23	3440148.0
2023-12-11 10:00:00	IWM	ETF	186.24	186.79	185.885	186.55	2810667.0
2023-12-11 11:00:00	IWM	ETF	186.545	186.92	185.96	186.91	2814922.0
2023-12-11 12:00:00	IWM	ETF	186.91	187.04	186.51	186.88	1812333.0
2023-12-11 13:00:00	IWM	ETF	186.87	187.225	186.69	187.2	2223568.0
2023-12-11 14:00:00	IWM	ETF	187.205	187.418	187.06	187.155	2076808.0
2023-12-11 15:00:00	IWM	ETF	187.15	187.27	186.96	187.16	4745213.0
2023-12-11 16:00:00	IWM	ETF	187.19	187.36	186.98	187.3	732510.0
2023-12-11 17:00:00	IWM	ETF	187.29	187.29	187.13	187.26	10009.0
2023-12-11 18:00:00	IWM	ETF	187.19	187.35	187.19	187.3	30368.0
2023-12-11 19:00:00	IWM	ETF	187.31	187.53	187.31	187.49	74160.0
2023-12-11 07:00:00	DIA	ETF	363.2	363.25	363.05	363.05	1756.0
2023-12-11 08:00:00	DIA	ETF	363.2	363.21	363.0796	363.21	565.0

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

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