PREVIEW / etf_1hour / 2023-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-31.parquet
  size:    491 KB
  rows:    17,860

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-07-31 04:00:00	SPY	ETF	456.63	457.29	456.63	457.29	25194.0
2023-07-31 05:00:00	SPY	ETF	457.32	457.43	456.94	457.04	10493.0
2023-07-31 06:00:00	SPY	ETF	457.07	457.32	456.95	457.29	7823.0
2023-07-31 07:00:00	SPY	ETF	457.32	457.63	457.32	457.63	126587.0
2023-07-31 08:00:00	SPY	ETF	457.3399	458.1	456.1	457.97	288939.0
2023-07-31 09:00:00	SPY	ETF	457.96	458.16	456.5	457.0	6211514.0
2023-07-31 10:00:00	SPY	ETF	457.0	457.82	456.66	457.513	5502215.0
2023-07-31 11:00:00	SPY	ETF	457.53	457.83	456.684	456.945	4449625.0
2023-07-31 12:00:00	SPY	ETF	456.95	457.24	456.5	456.63	3295555.0
2023-07-31 13:00:00	SPY	ETF	456.63	457.17	456.24	456.88	3569401.0
2023-07-31 14:00:00	SPY	ETF	456.89	457.18	456.48	457.05	3302521.0
2023-07-31 15:00:00	SPY	ETF	457.059	457.84	456.045	457.79	14403765.0
2023-07-31 16:00:00	SPY	ETF	457.79	458.09	457.6342	457.92	5197055.0
2023-07-31 17:00:00	SPY	ETF	457.95	457.98	457.79	457.98	489228.0
2023-07-31 18:00:00	SPY	ETF	457.95	458.08	457.74	457.8	75944.0
2023-07-31 19:00:00	SPY	ETF	457.81	457.87	457.72	457.83	29137.0
2023-07-31 04:00:00	QQQ	ETF	382.86	383.75	382.86	383.7	53459.0
2023-07-31 05:00:00	QQQ	ETF	383.7	383.83	383.12	383.22	12932.0
2023-07-31 06:00:00	QQQ	ETF	383.24	383.52	383.17	383.51	20971.0
2023-07-31 07:00:00	QQQ	ETF	383.57	384.1	383.53	384.09	108489.0
2023-07-31 08:00:00	QQQ	ETF	382.68	384.629	382.42	384.4	450137.0
2023-07-31 09:00:00	QQQ	ETF	384.42	384.88	382.49	383.03	5536277.0
2023-07-31 10:00:00	QQQ	ETF	383.0299	384.12	382.52	383.8001	5219546.0
2023-07-31 11:00:00	QQQ	ETF	383.8023	384.26	382.855	383.42	3570859.0
2023-07-31 12:00:00	QQQ	ETF	383.435	383.84	382.9105	382.985	2787537.0
2023-07-31 13:00:00	QQQ	ETF	382.985	383.7	382.56	383.28	3420946.0
2023-07-31 14:00:00	QQQ	ETF	383.3199	383.75	382.84	383.57	2455939.0
2023-07-31 15:00:00	QQQ	ETF	383.5797	383.85	382.34	383.85	5474390.0
2023-07-31 16:00:00	QQQ	ETF	383.86	384.16	383.68	383.99	1420664.0
2023-07-31 17:00:00	QQQ	ETF	384.0	384.05	383.89	384.01	37264.0
2023-07-31 18:00:00	QQQ	ETF	384.01	384.16	383.73	383.82	68687.0
2023-07-31 19:00:00	QQQ	ETF	383.83	383.85	383.6	383.82	42336.0
2023-07-31 04:00:00	IWM	ETF	196.4	196.76	196.4	196.76	34705.0
2023-07-31 05:00:00	IWM	ETF	196.76	196.86	196.5	196.52	12781.0
2023-07-31 06:00:00	IWM	ETF	196.5	196.66	196.41	196.66	6137.0
2023-07-31 07:00:00	IWM	ETF	196.7	196.75	196.56	196.67	13106.0
2023-07-31 08:00:00	IWM	ETF	196.64	197.15	196.14	197.13	58765.0
2023-07-31 09:00:00	IWM	ETF	197.08	198.4	196.915	198.08	2813145.0
2023-07-31 10:00:00	IWM	ETF	198.08	198.56	197.59	197.75	3095557.0
2023-07-31 11:00:00	IWM	ETF	197.74	198.365	197.645	198.15	1769649.0
2023-07-31 12:00:00	IWM	ETF	198.14	198.3	197.71	197.82	1336460.0
2023-07-31 13:00:00	IWM	ETF	197.815	198.28	197.52	198.23	1905225.0
2023-07-31 14:00:00	IWM	ETF	198.24	198.3701	198.08	198.3699	1132747.0
2023-07-31 15:00:00	IWM	ETF	198.38	198.75	198.03	198.7	5311358.0
2023-07-31 16:00:00	IWM	ETF	198.71	198.88	198.6	198.86	2589452.0
2023-07-31 17:00:00	IWM	ETF	198.82	198.9	198.811	198.9	5610.0
2023-07-31 18:00:00	IWM	ETF	198.9	198.98	198.77	198.77	12255.0
2023-07-31 19:00:00	IWM	ETF	198.77	198.86	198.76	198.86	15721.0
2023-07-31 06:00:00	DIA	ETF	354.79	354.96	354.79	354.96	3890.0
2023-07-31 07:00:00	DIA	ETF	354.93	355.0	354.89	354.97	3891.0

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

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