PREVIEW / etf_1hour / 2022-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-26.parquet
  size:    429 KB
  rows:    15,279

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
2022-07-26 04:00:00	SPY	ETF	394.88	394.88	394.21	394.62	39268.0
2022-07-26 05:00:00	SPY	ETF	394.63	395.0	394.2	394.74	83312.0
2022-07-26 06:00:00	SPY	ETF	394.65	394.86	393.65	394.09	216777.0
2022-07-26 07:00:00	SPY	ETF	394.1	394.41	393.78	394.0	253276.0
2022-07-26 08:00:00	SPY	ETF	394.2	394.54	393.55	394.0	360143.0
2022-07-26 09:00:00	SPY	ETF	393.97	394.23	392.42	393.24	5380728.0
2022-07-26 10:00:00	SPY	ETF	393.24	393.75	392.13	392.8724	5202463.0
2022-07-26 11:00:00	SPY	ETF	392.88	393.09	390.51	390.62	5565879.0
2022-07-26 12:00:00	SPY	ETF	390.61	391.79	390.42	391.6	4640001.0
2022-07-26 13:00:00	SPY	ETF	391.62	392.38	391.23	391.27	3702919.0
2022-07-26 14:00:00	SPY	ETF	391.275	392.34	390.22	390.7301	4288364.0
2022-07-26 15:00:00	SPY	ETF	390.74	391.51	389.95	390.91	9484835.0
2022-07-26 16:00:00	SPY	ETF	390.91	392.71	390.14	392.51	3105005.0
2022-07-26 17:00:00	SPY	ETF	392.51	392.58	392.07	392.5	121927.0
2022-07-26 18:00:00	SPY	ETF	392.5	394.42	392.5	393.25	313038.0
2022-07-26 19:00:00	SPY	ETF	393.27	395.23	393.17	394.06	107397.0
2022-07-26 04:00:00	QQQ	ETF	298.9	299.68	298.9	299.41	54071.0
2022-07-26 05:00:00	QQQ	ETF	299.45	299.68	299.29	299.63	29867.0
2022-07-26 06:00:00	QQQ	ETF	299.66	299.72	298.5	298.99	71192.0
2022-07-26 07:00:00	QQQ	ETF	298.76	299.34	298.6	298.8	164867.0
2022-07-26 08:00:00	QQQ	ETF	298.97	300.495	298.13	298.53	504597.0
2022-07-26 09:00:00	QQQ	ETF	298.55	298.91	296.46	297.43	5987001.0
2022-07-26 10:00:00	QQQ	ETF	297.4	298.03	295.57	296.48	5224909.0
2022-07-26 11:00:00	QQQ	ETF	296.4899	296.66	294.385	294.4737	3886346.0
2022-07-26 12:00:00	QQQ	ETF	294.47	295.402	294.3	295.11	3563959.0
2022-07-26 13:00:00	QQQ	ETF	295.11	295.67	294.56	294.62	3174371.0
2022-07-26 14:00:00	QQQ	ETF	294.63	295.64	293.79	294.27	3695554.0
2022-07-26 15:00:00	QQQ	ETF	294.25	294.9001	293.54	294.35	7573604.0
2022-07-26 16:00:00	QQQ	ETF	294.38	296.43	293.43	296.41	2990908.0
2022-07-26 17:00:00	QQQ	ETF	296.6	296.62	295.77	296.32	184517.0
2022-07-26 18:00:00	QQQ	ETF	296.37	299.15	296.37	297.85	1412692.0
2022-07-26 19:00:00	QQQ	ETF	297.85	298.79	297.71	298.58	157766.0
2022-07-26 04:00:00	IWM	ETF	180.41	180.49	180.17	180.43	16550.0
2022-07-26 05:00:00	IWM	ETF	180.44	180.62	180.22	180.42	10302.0
2022-07-26 06:00:00	IWM	ETF	180.39	180.4	179.71	179.91	86783.0
2022-07-26 07:00:00	IWM	ETF	179.91	180.09	179.77	179.95	10935.0
2022-07-26 08:00:00	IWM	ETF	179.91	180.2	179.62	179.85	35571.0
2022-07-26 09:00:00	IWM	ETF	179.8504	180.0176	178.87	179.35	2259419.0
2022-07-26 10:00:00	IWM	ETF	179.36	179.83	178.54	179.78	1544374.0
2022-07-26 11:00:00	IWM	ETF	179.78	179.93	178.66	178.69	1517000.0
2022-07-26 12:00:00	IWM	ETF	178.69	179.73	178.59	179.63	1548883.0
2022-07-26 13:00:00	IWM	ETF	179.61	179.91	179.46	179.74	950297.0
2022-07-26 14:00:00	IWM	ETF	179.74	180.21	179.07	179.44	1404241.0
2022-07-26 15:00:00	IWM	ETF	179.45	179.59	179.04	179.3	2193788.0
2022-07-26 16:00:00	IWM	ETF	179.33	179.95	179.14	179.57	1237386.0
2022-07-26 17:00:00	IWM	ETF	179.73	179.82	179.53	179.82	9862.0
2022-07-26 18:00:00	IWM	ETF	179.67	180.14	179.41	179.53	92634.0
2022-07-26 19:00:00	IWM	ETF	179.57	180.1	179.46	179.96	38060.0
2022-07-26 04:00:00	DIA	ETF	318.94	318.94	318.71	318.76	3800.0
2022-07-26 06:00:00	DIA	ETF	318.11	318.54	318.11	318.54	400.0

> showing 50 of 15,279 rows — these rows as CSV

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