PREVIEW / etf_1hour / 2023-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-26.parquet
  size:    485 KB
  rows:    17,532

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-26 04:00:00	SPY	ETF	430.21	430.82	429.77	430.3	38630.0
2023-09-26 05:00:00	SPY	ETF	430.31	430.5	429.72	429.73	37572.0
2023-09-26 06:00:00	SPY	ETF	429.87	430.58	429.87	430.58	86882.0
2023-09-26 07:00:00	SPY	ETF	430.56	430.91	429.87	430.56	175025.0
2023-09-26 08:00:00	SPY	ETF	430.58	431.03	428.91	429.67	475195.0
2023-09-26 09:00:00	SPY	ETF	429.62	429.82	428.53	428.7	7230736.0
2023-09-26 10:00:00	SPY	ETF	428.69	428.94	426.9917	428.025	13517269.0
2023-09-26 11:00:00	SPY	ETF	428.01	428.24	426.63	427.1	8744948.0
2023-09-26 12:00:00	SPY	ETF	427.11	427.965	426.87	427.56	5720641.0
2023-09-26 13:00:00	SPY	ETF	427.57	427.98	426.01	426.71	7869015.0
2023-09-26 14:00:00	SPY	ETF	426.73	426.74	425.47	425.82	7881113.0
2023-09-26 15:00:00	SPY	ETF	425.815	426.04	425.02	425.83	17854552.0
2023-09-26 16:00:00	SPY	ETF	425.83	429.5678	425.7864	426.42	4623973.0
2023-09-26 17:00:00	SPY	ETF	426.44	426.57	426.38	426.51	57730.0
2023-09-26 18:00:00	SPY	ETF	426.54	426.6	426.18	426.25	89400.0
2023-09-26 19:00:00	SPY	ETF	426.25	426.61	426.25	426.55	44124.0
2023-09-26 04:00:00	QQQ	ETF	357.58	358.49	357.5	357.86	104750.0
2023-09-26 05:00:00	QQQ	ETF	357.86	358.03	357.3	357.36	44309.0
2023-09-26 06:00:00	QQQ	ETF	357.45	358.15	357.42	358.15	33150.0
2023-09-26 07:00:00	QQQ	ETF	358.11	358.52	357.45	358.19	173505.0
2023-09-26 08:00:00	QQQ	ETF	358.3	359.879	356.53	357.48	347620.0
2023-09-26 09:00:00	QQQ	ETF	357.5	357.54	355.5739	355.7499	5501024.0
2023-09-26 10:00:00	QQQ	ETF	355.72	356.58	354.63	355.69	8978973.0
2023-09-26 11:00:00	QQQ	ETF	355.69	355.89	354.63	354.94	4740938.0
2023-09-26 12:00:00	QQQ	ETF	354.95	355.99	354.59	355.53	3389716.0
2023-09-26 13:00:00	QQQ	ETF	355.55	356.025	354.15	354.9301	4945235.0
2023-09-26 14:00:00	QQQ	ETF	354.94	354.94	353.81	354.22	4273289.0
2023-09-26 15:00:00	QQQ	ETF	354.205	354.47	353.2101	354.215	9254743.0
2023-09-26 16:00:00	QQQ	ETF	354.21	355.7285	354.14	354.61	1327718.0
2023-09-26 17:00:00	QQQ	ETF	354.62	354.69	354.5	354.6	39532.0
2023-09-26 18:00:00	QQQ	ETF	354.66	354.66	354.3701	354.49	96844.0
2023-09-26 19:00:00	QQQ	ETF	354.45	355.0	354.45	354.91	81615.0
2023-09-26 04:00:00	IWM	ETF	176.24	176.24	175.42	175.68	16755.0
2023-09-26 05:00:00	IWM	ETF	175.7	175.77	175.45	175.45	4954.0
2023-09-26 06:00:00	IWM	ETF	175.51	175.72	175.5	175.69	11434.0
2023-09-26 07:00:00	IWM	ETF	175.82	175.97	175.54	175.88	38496.0
2023-09-26 08:00:00	IWM	ETF	175.78	176.17	175.0	175.58	123419.0
2023-09-26 09:00:00	IWM	ETF	175.53	177.02	175.37	176.39	3763169.0
2023-09-26 10:00:00	IWM	ETF	176.4	176.58	175.6	176.17	4498159.0
2023-09-26 11:00:00	IWM	ETF	176.165	176.28	175.39	175.58	2402730.0
2023-09-26 12:00:00	IWM	ETF	175.59	175.735	175.365	175.37	1430798.0
2023-09-26 13:00:00	IWM	ETF	175.365	175.52	174.715	175.04	3134405.0
2023-09-26 14:00:00	IWM	ETF	175.045	175.045	174.675	174.87	1946126.0
2023-09-26 15:00:00	IWM	ETF	174.87	174.98	174.29	174.4	5514855.0
2023-09-26 16:00:00	IWM	ETF	174.36	174.92	174.2594	174.85	1999000.0
2023-09-26 17:00:00	IWM	ETF	174.82	175.1	174.82	174.84	83148.0
2023-09-26 18:00:00	IWM	ETF	174.86	174.91	174.79	174.9	9148.0
2023-09-26 19:00:00	IWM	ETF	174.89	174.98	174.82	174.83	29724.0
2023-09-26 04:00:00	DIA	ETF	338.84	338.84	338.84	338.84	250.0
2023-09-26 05:00:00	DIA	ETF	338.62	338.65	338.62	338.65	2050.0

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

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