PREVIEW / etf_1hour / 2024-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-06-18.parquet
  size:    549 KB
  rows:    20,249

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-18 04:00:00	SPY	ETF	546.88	547.22	546.61	547.17	21873.0
2024-06-18 05:00:00	SPY	ETF	547.32	547.49	547.05	547.2	6404.0
2024-06-18 06:00:00	SPY	ETF	547.13	547.5	547.01	547.04	7108.0
2024-06-18 07:00:00	SPY	ETF	547.07	547.11	546.94	547.0	47229.0
2024-06-18 08:00:00	SPY	ETF	547.0686	547.75	546.75	546.94	256966.0
2024-06-18 09:00:00	SPY	ETF	546.95	548.22	546.66	547.53	2668213.0
2024-06-18 10:00:00	SPY	ETF	547.54	547.96	546.9696	547.1	2413079.0
2024-06-18 11:00:00	SPY	ETF	547.1112	547.8202	546.73	547.805	1926025.0
2024-06-18 12:00:00	SPY	ETF	547.8001	548.07	547.23	547.85	1994323.0
2024-06-18 13:00:00	SPY	ETF	547.84	548.62	547.46	548.12	2166569.0
2024-06-18 14:00:00	SPY	ETF	548.11	548.15	547.09	548.03	3227730.0
2024-06-18 15:00:00	SPY	ETF	548.04	548.5	547.4105	548.49	7226367.0
2024-06-18 16:00:00	SPY	ETF	548.48	548.64	548.11	548.49	2879832.0
2024-06-18 17:00:00	SPY	ETF	548.48	548.55	548.4	548.47	49537.0
2024-06-18 18:00:00	SPY	ETF	548.49	548.979	548.41	548.9	39016.0
2024-06-18 19:00:00	SPY	ETF	548.87	548.89	548.68	548.8	12141.0
2024-06-18 04:00:00	QQQ	ETF	485.38	486.05	485.38	485.85	44445.0
2024-06-18 05:00:00	QQQ	ETF	486.06	486.5	485.84	486.05	25658.0
2024-06-18 06:00:00	QQQ	ETF	486.11	486.31	485.72	485.87	21096.0
2024-06-18 07:00:00	QQQ	ETF	485.91	486.07	485.55	485.83	127199.0
2024-06-18 08:00:00	QQQ	ETF	485.74	486.88	484.69	485.46	363995.0
2024-06-18 09:00:00	QQQ	ETF	485.46	485.68	484.38	484.71	3098044.0
2024-06-18 10:00:00	QQQ	ETF	484.72	485.54	484.135	484.26	2388233.0
2024-06-18 11:00:00	QQQ	ETF	484.275	484.92	483.43	484.885	2198067.0
2024-06-18 12:00:00	QQQ	ETF	484.88	485.44	484.45	485.33	1373617.0
2024-06-18 13:00:00	QQQ	ETF	485.31	485.9	484.87	485.27	1676669.0
2024-06-18 14:00:00	QQQ	ETF	485.29	485.3751	484.26	485.2073	1467876.0
2024-06-18 15:00:00	QQQ	ETF	485.2	485.42	484.58	485.23	3785996.0
2024-06-18 16:00:00	QQQ	ETF	485.22	485.41	485.01	485.401	948159.0
2024-06-18 17:00:00	QQQ	ETF	485.38	485.44	485.23	485.44	7379.0
2024-06-18 18:00:00	QQQ	ETF	485.42	485.9	485.32	485.87	40528.0
2024-06-18 19:00:00	QQQ	ETF	485.82	485.82	485.56	485.76	20167.0
2024-06-18 04:00:00	IWM	ETF	200.26	200.26	199.49	199.86	31376.0
2024-06-18 05:00:00	IWM	ETF	199.9	200.21	199.89	199.97	8629.0
2024-06-18 06:00:00	IWM	ETF	199.96	200.11	199.75	199.77	13082.0
2024-06-18 07:00:00	IWM	ETF	199.78	200.0	199.78	199.98	29318.0
2024-06-18 08:00:00	IWM	ETF	199.91	201.2	199.6096	200.14	338052.0
2024-06-18 09:00:00	IWM	ETF	200.15	201.33	199.76	200.47	2716432.0
2024-06-18 10:00:00	IWM	ETF	200.47	201.2	200.11	200.56	2336073.0
2024-06-18 11:00:00	IWM	ETF	200.57	201.3	200.51	201.26	1871345.0
2024-06-18 12:00:00	IWM	ETF	201.25	201.69	201.15	201.15	1479395.0
2024-06-18 13:00:00	IWM	ETF	201.15	201.32	200.9	201.19	1293349.0
2024-06-18 14:00:00	IWM	ETF	201.192	201.3	200.73	201.18	1032787.0
2024-06-18 15:00:00	IWM	ETF	201.17	201.17	200.655	200.78	3035536.0
2024-06-18 16:00:00	IWM	ETF	200.75	200.85	200.61	200.75	1216616.0
2024-06-18 17:00:00	IWM	ETF	200.74	200.8	200.65	200.8	18212.0
2024-06-18 18:00:00	IWM	ETF	200.8	201.01	200.75	200.86	21071.0
2024-06-18 19:00:00	IWM	ETF	200.84	200.84	200.68	200.81	11616.0
2024-06-18 04:00:00	DIA	ETF	388.38	388.38	388.21	388.31	738.0
2024-06-18 05:00:00	DIA	ETF	388.65	388.76	388.5	388.76	525.0

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

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