PREVIEW / etf_1hour / 2024-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-07-09.parquet
  size:    547 KB
  rows:    20,438

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
2024-07-09 04:00:00	SPY	ETF	556.34	556.59	556.29	556.49	7388.0
2024-07-09 05:00:00	SPY	ETF	556.55	556.63	556.52	556.57	4683.0
2024-07-09 06:00:00	SPY	ETF	556.5	556.57	556.45	556.49	2109.0
2024-07-09 07:00:00	SPY	ETF	556.46	556.57	556.21	556.25	67687.0
2024-07-09 08:00:00	SPY	ETF	556.5204	556.65	555.95	556.21	101244.0
2024-07-09 09:00:00	SPY	ETF	556.21	556.82	556.11	556.67	2039370.0
2024-07-09 10:00:00	SPY	ETF	556.69	556.91	555.67	556.35	3061426.0
2024-07-09 11:00:00	SPY	ETF	556.33	556.59	555.72	556.525	2178770.0
2024-07-09 12:00:00	SPY	ETF	556.52	556.8015	556.11	556.72	1692111.0
2024-07-09 13:00:00	SPY	ETF	556.7	557.18	555.7301	556.14	2922497.0
2024-07-09 14:00:00	SPY	ETF	556.13	556.18	555.61	555.895	2742692.0
2024-07-09 15:00:00	SPY	ETF	555.9	556.08	555.52	555.85	4182868.0
2024-07-09 16:00:00	SPY	ETF	555.85	556.01	555.7	555.86	1068258.0
2024-07-09 17:00:00	SPY	ETF	555.83	555.85	555.6601	555.7	23900.0
2024-07-09 18:00:00	SPY	ETF	555.78	556.01	555.78	555.97	34256.0
2024-07-09 19:00:00	SPY	ETF	556.01	556.09	556.01	556.01	7246.0
2024-07-09 04:00:00	QQQ	ETF	499.17	499.26	498.8	499.1	21437.0
2024-07-09 05:00:00	QQQ	ETF	499.12	499.37	499.11	499.29	8212.0
2024-07-09 06:00:00	QQQ	ETF	499.22	499.34	499.1	499.25	17062.0
2024-07-09 07:00:00	QQQ	ETF	499.28	499.4	498.76	498.91	52807.0
2024-07-09 08:00:00	QQQ	ETF	499.39	499.4	498.41	498.8	148163.0
2024-07-09 09:00:00	QQQ	ETF	498.82	499.835	498.71	499.5063	2162731.0
2024-07-09 10:00:00	QQQ	ETF	499.52	500.0	497.8	498.48	4210207.0
2024-07-09 11:00:00	QQQ	ETF	498.48	498.92	497.56	498.4075	2016607.0
2024-07-09 12:00:00	QQQ	ETF	498.4	498.69	496.9101	497.716	2162565.0
2024-07-09 13:00:00	QQQ	ETF	497.7	498.07	496.24	497.315	1985245.0
2024-07-09 14:00:00	QQQ	ETF	497.3	497.78	496.87	497.61	1517831.0
2024-07-09 15:00:00	QQQ	ETF	497.61	497.91	497.17	497.77	2504098.0
2024-07-09 16:00:00	QQQ	ETF	497.77	497.98	497.57	497.96	1022238.0
2024-07-09 17:00:00	QQQ	ETF	497.9	497.98	497.74	497.74	17959.0
2024-07-09 18:00:00	QQQ	ETF	497.87	498.2	497.72	498.09	68259.0
2024-07-09 19:00:00	QQQ	ETF	498.2	498.3	498.11	498.16	25084.0
2024-07-09 04:00:00	IWM	ETF	202.85	202.99	202.75	202.86	34979.0
2024-07-09 05:00:00	IWM	ETF	202.87	202.88	202.7	202.77	2025.0
2024-07-09 06:00:00	IWM	ETF	202.71	202.71	202.61	202.65	1975.0
2024-07-09 07:00:00	IWM	ETF	202.56	202.56	202.08	202.22	31799.0
2024-07-09 08:00:00	IWM	ETF	202.42	202.89	201.77	202.06	90450.0
2024-07-09 09:00:00	IWM	ETF	202.04	202.05	201.17	201.635	2198999.0
2024-07-09 10:00:00	IWM	ETF	201.65	201.91	200.82	200.9	2634177.0
2024-07-09 11:00:00	IWM	ETF	200.9	201.47	200.53	201.4586	1652890.0
2024-07-09 12:00:00	IWM	ETF	201.46	201.95	201.41	201.95	1134107.0
2024-07-09 13:00:00	IWM	ETF	201.95	202.52	201.655	201.6665	2216765.0
2024-07-09 14:00:00	IWM	ETF	201.66	201.78	201.375	201.46	853672.0
2024-07-09 15:00:00	IWM	ETF	201.46	201.51	201.17	201.37	2895935.0
2024-07-09 16:00:00	IWM	ETF	201.37	201.5	201.34	201.45	451886.0
2024-07-09 17:00:00	IWM	ETF	201.43	201.5	201.31	201.32	16799.0
2024-07-09 18:00:00	IWM	ETF	201.4	201.48	201.35	201.41	37172.0
2024-07-09 19:00:00	IWM	ETF	201.42	201.56	201.42	201.46	16122.0
2024-07-09 04:00:00	DIA	ETF	393.86	393.86	393.86	393.86	244.0
2024-07-09 05:00:00	DIA	ETF	393.92	393.92	393.79	393.79	1381.0

> showing 50 of 20,438 rows — these rows as CSV

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