PREVIEW / etf_1hour / 2024-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-06-14.parquet
  size:    537 KB
  rows:    19,964

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-06-14 04:00:00	SPY	ETF	542.53	542.53	541.67	541.67	8648.0
2024-06-14 05:00:00	SPY	ETF	541.68	541.79	540.38	540.38	35879.0
2024-06-14 06:00:00	SPY	ETF	540.38	540.43	539.33	539.69	97244.0
2024-06-14 07:00:00	SPY	ETF	539.71	540.76	538.87	540.1	366146.0
2024-06-14 08:00:00	SPY	ETF	539.47	543.16	539.03	540.49	299791.0
2024-06-14 09:00:00	SPY	ETF	540.42	541.6295	540.28	541.53	3079932.0
2024-06-14 10:00:00	SPY	ETF	541.51	541.51	539.85	541.23	4675877.0
2024-06-14 11:00:00	SPY	ETF	541.22	541.79	540.28	541.405	3186273.0
2024-06-14 12:00:00	SPY	ETF	541.42	541.91	540.9301	541.805	2475560.0
2024-06-14 13:00:00	SPY	ETF	541.81	542.4201	541.54	541.77	2231750.0
2024-06-14 14:00:00	SPY	ETF	541.765	542.33	541.172	542.075	2616644.0
2024-06-14 15:00:00	SPY	ETF	542.07	542.81	541.86	542.73	6138868.0
2024-06-14 16:00:00	SPY	ETF	542.72	542.78	542.36	542.46	4173102.0
2024-06-14 17:00:00	SPY	ETF	542.48	543.1	542.35	543.07	144605.0
2024-06-14 18:00:00	SPY	ETF	543.07	543.08	542.72	542.76	35189.0
2024-06-14 19:00:00	SPY	ETF	542.72	542.82	542.56	542.82	15295.0
2024-06-14 20:00:00	SPY	ETF	542.85	542.85	542.85	542.85	200.0
2024-06-14 04:00:00	QQQ	ETF	477.36	478.39	477.36	477.51	46980.0
2024-06-14 05:00:00	QQQ	ETF	477.52	477.55	476.08	476.11	97080.0
2024-06-14 06:00:00	QQQ	ETF	476.0	476.14	475.18	475.79	264825.0
2024-06-14 07:00:00	QQQ	ETF	475.57	476.25	474.7	475.54	181550.0
2024-06-14 08:00:00	QQQ	ETF	475.5	478.34	474.75	476.11	205822.0
2024-06-14 09:00:00	QQQ	ETF	476.02	478.14	475.95	478.04	2355976.0
2024-06-14 10:00:00	QQQ	ETF	478.02	478.27	476.46	477.8	3062311.0
2024-06-14 11:00:00	QQQ	ETF	477.8	477.88	476.2	477.53	2307078.0
2024-06-14 12:00:00	QQQ	ETF	477.51	478.12	477.12	477.86	1289689.0
2024-06-14 13:00:00	QQQ	ETF	477.88	478.93	477.75	478.51	1621957.0
2024-06-14 14:00:00	QQQ	ETF	478.46	478.88	477.7899	478.68	1783093.0
2024-06-14 15:00:00	QQQ	ETF	478.62	479.26	478.17	479.1708	3004766.0
2024-06-14 16:00:00	QQQ	ETF	479.16	479.5	478.97	479.35	778484.0
2024-06-14 17:00:00	QQQ	ETF	479.37	479.56	479.19	479.51	57576.0
2024-06-14 18:00:00	QQQ	ETF	479.5	479.9	479.3	479.3782	16944.0
2024-06-14 19:00:00	QQQ	ETF	479.3785	479.3785	479.1	479.2	24979.0
2024-06-14 04:00:00	IWM	ETF	200.8	200.88	200.0	200.09	60837.0
2024-06-14 05:00:00	IWM	ETF	200.1	200.1	199.0	199.2	85810.0
2024-06-14 06:00:00	IWM	ETF	199.19	199.49	198.67	199.21	119191.0
2024-06-14 07:00:00	IWM	ETF	199.22	199.85	198.69	199.66	252479.0
2024-06-14 08:00:00	IWM	ETF	198.88	201.47	198.71	199.38	278251.0
2024-06-14 09:00:00	IWM	ETF	199.41	200.04	199.12	199.43	3060576.0
2024-06-14 10:00:00	IWM	ETF	199.42	199.425	198.01	198.8401	5276052.0
2024-06-14 11:00:00	IWM	ETF	198.84	199.03	198.13	198.46	3272453.0
2024-06-14 12:00:00	IWM	ETF	198.45	198.685	197.94	198.46	2478960.0
2024-06-14 13:00:00	IWM	ETF	198.46	198.9	198.11	198.21	2110005.0
2024-06-14 14:00:00	IWM	ETF	198.21	198.6	198.05	198.54	2211692.0
2024-06-14 15:00:00	IWM	ETF	198.54	198.84	198.39	198.78	4764324.0
2024-06-14 16:00:00	IWM	ETF	198.73	198.92	198.45	198.59	1241895.0
2024-06-14 17:00:00	IWM	ETF	198.6	198.73	198.536	198.7	20997.0
2024-06-14 18:00:00	IWM	ETF	198.64	198.73	198.41	198.59	19044.0
2024-06-14 19:00:00	IWM	ETF	198.5	198.5	198.35	198.49	2971.0
2024-06-14 04:00:00	DIA	ETF	385.57	385.59	385.3	385.3	1587.0

> showing 50 of 19,964 rows — these rows as CSV

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