PREVIEW / etf_1hour / 2024-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-07-05.parquet
  size:    548 KB
  rows:    20,515

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-05 04:00:00	SPY	ETF	551.95	552.16	551.7	551.75	18626.0
2024-07-05 05:00:00	SPY	ETF	551.68	551.87	551.63	551.83	1621.0
2024-07-05 06:00:00	SPY	ETF	551.74	551.8	551.67	551.71	8897.0
2024-07-05 07:00:00	SPY	ETF	551.62	551.79	551.43	551.47	77579.0
2024-07-05 08:00:00	SPY	ETF	551.66	552.92	551.0	551.66	615162.0
2024-07-05 09:00:00	SPY	ETF	551.66	552.53	551.38	552.53	2801436.0
2024-07-05 10:00:00	SPY	ETF	552.54	552.84	551.12	552.355	3654448.0
2024-07-05 11:00:00	SPY	ETF	552.35	553.72	552.1	553.535	2935900.0
2024-07-05 12:00:00	SPY	ETF	553.53	553.76	553.1	553.505	1764693.0
2024-07-05 13:00:00	SPY	ETF	553.505	554.52	553.29	554.27	2092618.0
2024-07-05 14:00:00	SPY	ETF	554.28	554.43	553.86	554.37	2308043.0
2024-07-05 15:00:00	SPY	ETF	554.36	555.05	554.24	554.7	8451094.0
2024-07-05 16:00:00	SPY	ETF	554.7	554.79	552.2221	554.09	2753824.0
2024-07-05 17:00:00	SPY	ETF	554.04	554.1	553.93	553.97	49320.0
2024-07-05 18:00:00	SPY	ETF	554.1123	554.1123	553.95	554.0066	4822.0
2024-07-05 19:00:00	SPY	ETF	554.09	554.17	554.02	554.12	49363.0
2024-07-05 04:00:00	QQQ	ETF	491.35	492.28	491.04	491.63	54727.0
2024-07-05 05:00:00	QQQ	ETF	491.65	491.96	491.61	491.74	20066.0
2024-07-05 06:00:00	QQQ	ETF	491.65	492.09	491.62	491.9	22404.0
2024-07-05 07:00:00	QQQ	ETF	491.89	492.04	491.59	491.67	72429.0
2024-07-05 08:00:00	QQQ	ETF	491.97	493.13	490.1527	491.64	312477.0
2024-07-05 09:00:00	QQQ	ETF	491.51	493.7	491.17	493.61	3075662.0
2024-07-05 10:00:00	QQQ	ETF	493.66	494.51	492.406	493.83	3395687.0
2024-07-05 11:00:00	QQQ	ETF	493.82	495.78	493.52	495.53	2915041.0
2024-07-05 12:00:00	QQQ	ETF	495.54	496.025	495.08	495.365	2235147.0
2024-07-05 13:00:00	QQQ	ETF	495.35	496.49	495.06	496.1767	2049205.0
2024-07-05 14:00:00	QQQ	ETF	496.205	496.31	495.48	495.9556	1592387.0
2024-07-05 15:00:00	QQQ	ETF	495.94	496.6	495.83	496.23	3566979.0
2024-07-05 16:00:00	QQQ	ETF	496.18	496.2426	493.3636	495.4	1588714.0
2024-07-05 17:00:00	QQQ	ETF	495.45	495.8	495.45	495.64	94400.0
2024-07-05 18:00:00	QQQ	ETF	495.68	495.74	495.55	495.6752	6669.0
2024-07-05 19:00:00	QQQ	ETF	495.73	495.79	495.6	495.7	15769.0
2024-07-05 04:00:00	IWM	ETF	202.0	202.02	201.49	201.64	35493.0
2024-07-05 05:00:00	IWM	ETF	201.6	201.64	201.25	201.36	5334.0
2024-07-05 06:00:00	IWM	ETF	201.4	201.52	201.23	201.28	6566.0
2024-07-05 07:00:00	IWM	ETF	201.33	201.45	201.12	201.37	37576.0
2024-07-05 08:00:00	IWM	ETF	201.39	202.72	200.54	201.69	362732.0
2024-07-05 09:00:00	IWM	ETF	201.7	201.96	200.41	200.76	2647175.0
2024-07-05 10:00:00	IWM	ETF	200.74	201.035	199.88	200.86	2729239.0
2024-07-05 11:00:00	IWM	ETF	200.865	201.12	200.59	200.689	1119327.0
2024-07-05 12:00:00	IWM	ETF	200.69	200.78	200.4	200.63	739145.0
2024-07-05 13:00:00	IWM	ETF	200.63	200.8177	200.29	200.78	755152.0
2024-07-05 14:00:00	IWM	ETF	200.775	200.805	200.4	200.68	790303.0
2024-07-05 15:00:00	IWM	ETF	200.67	201.25	200.59	200.88	2685283.0
2024-07-05 16:00:00	IWM	ETF	200.86	200.9	200.6	200.6	498743.0
2024-07-05 17:00:00	IWM	ETF	200.71	200.71	200.5	200.6	11184.0
2024-07-05 18:00:00	IWM	ETF	200.65	200.65	200.4	200.46	11184.0
2024-07-05 19:00:00	IWM	ETF	200.55	200.55	200.41	200.41	3404.0
2024-07-05 04:00:00	DIA	ETF	393.21	393.21	393.15	393.15	1116.0
2024-07-05 05:00:00	DIA	ETF	393.22	393.29	393.14	393.23	1851.0

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

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