PREVIEW / etf_1hour / 2024-07-08

all etf 1-hour files

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

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-08 04:00:00	SPY	ETF	553.85	554.65	553.85	554.53	8329.0
2024-07-08 05:00:00	SPY	ETF	554.46	554.65	554.43	554.5	8383.0
2024-07-08 06:00:00	SPY	ETF	554.51	554.6	554.44	554.49	37522.0
2024-07-08 07:00:00	SPY	ETF	554.44	554.92	554.42	554.89	38935.0
2024-07-08 08:00:00	SPY	ETF	554.5	555.22	553.75	555.2	157516.0
2024-07-08 09:00:00	SPY	ETF	555.18	556.2501	555.15	556.02	2661385.0
2024-07-08 10:00:00	SPY	ETF	556.01	556.04	554.91	555.2	2711990.0
2024-07-08 11:00:00	SPY	ETF	555.21	555.54	554.732	555.09	2163159.0
2024-07-08 12:00:00	SPY	ETF	555.08	555.1	554.295	554.8001	2036175.0
2024-07-08 13:00:00	SPY	ETF	554.81	555.37	554.47	555.23	1510707.0
2024-07-08 14:00:00	SPY	ETF	555.22	555.29	554.19	554.95	1676436.0
2024-07-08 15:00:00	SPY	ETF	554.95	555.56	554.51	555.34	6779482.0
2024-07-08 16:00:00	SPY	ETF	555.34	555.58	555.15	555.43	3756827.0
2024-07-08 17:00:00	SPY	ETF	555.42	555.49	555.38	555.4	25526.0
2024-07-08 18:00:00	SPY	ETF	555.38	555.68	555.28	555.6	31695.0
2024-07-08 19:00:00	SPY	ETF	555.65	556.45	555.65	556.4	78627.0
2024-07-08 04:00:00	QQQ	ETF	495.88	496.1	495.81	495.83	41550.0
2024-07-08 05:00:00	QQQ	ETF	495.83	496.22	495.8	496.0	16289.0
2024-07-08 06:00:00	QQQ	ETF	496.03	496.19	495.97	496.01	31917.0
2024-07-08 07:00:00	QQQ	ETF	495.96	496.51	495.92	496.45	127247.0
2024-07-08 08:00:00	QQQ	ETF	496.45	496.65	495.4	496.47	123809.0
2024-07-08 09:00:00	QQQ	ETF	496.44	497.04	495.781	496.62	2663389.0
2024-07-08 10:00:00	QQQ	ETF	496.62	496.78	495.5	496.0	2457471.0
2024-07-08 11:00:00	QQQ	ETF	496.0	497.48	495.875	497.4108	2455335.0
2024-07-08 12:00:00	QQQ	ETF	497.43	497.47	496.01	496.626	1721899.0
2024-07-08 13:00:00	QQQ	ETF	496.65	497.45	496.46	497.11	1117686.0
2024-07-08 14:00:00	QQQ	ETF	497.1	497.15	496.02	496.915	1533496.0
2024-07-08 15:00:00	QQQ	ETF	496.91	497.895	496.225	497.41	2575707.0
2024-07-08 16:00:00	QQQ	ETF	497.4	497.88	497.15	497.77	1103268.0
2024-07-08 17:00:00	QQQ	ETF	497.72	497.8	497.68	497.7692	7550.0
2024-07-08 18:00:00	QQQ	ETF	497.7	498.13	497.5602	497.9	35509.0
2024-07-08 19:00:00	QQQ	ETF	497.94	499.1	497.34	499.09	164847.0
2024-07-08 04:00:00	IWM	ETF	200.9	201.29	200.9	201.23	25839.0
2024-07-08 05:00:00	IWM	ETF	201.13	201.42	201.07	201.33	6124.0
2024-07-08 06:00:00	IWM	ETF	201.3	201.44	201.29	201.35	7039.0
2024-07-08 07:00:00	IWM	ETF	201.33	201.65	201.33	201.59	67374.0
2024-07-08 08:00:00	IWM	ETF	201.4182	202.32	200.43	202.31	168314.0
2024-07-08 09:00:00	IWM	ETF	202.3	203.7	202.29	203.38	3950005.0
2024-07-08 10:00:00	IWM	ETF	203.37	203.565	202.6613	203.35	3190036.0
2024-07-08 11:00:00	IWM	ETF	203.35	203.429	201.975	202.1	2180022.0
2024-07-08 12:00:00	IWM	ETF	202.09	202.62	201.9	202.49	1467014.0
2024-07-08 13:00:00	IWM	ETF	202.48	202.5	202.08	202.355	974761.0
2024-07-08 14:00:00	IWM	ETF	202.35	202.48	201.84	202.25	1234575.0
2024-07-08 15:00:00	IWM	ETF	202.25	202.435	202.15	202.23	2357354.0
2024-07-08 16:00:00	IWM	ETF	202.28	202.39	202.21	202.3	1192909.0
2024-07-08 17:00:00	IWM	ETF	202.3196	202.42	202.28	202.41	5750.0
2024-07-08 18:00:00	IWM	ETF	202.35	202.45	202.28	202.41	31575.0
2024-07-08 19:00:00	IWM	ETF	202.4	202.63	202.4	202.63	23000.0
2024-07-08 04:00:00	DIA	ETF	393.78	393.78	393.78	393.78	300.0
2024-07-08 05:00:00	DIA	ETF	393.78	393.82	393.78	393.82	509.0

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

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