PREVIEW / etf_1hour / 2023-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-24.parquet
  size:    485 KB
  rows:    17,723

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-24 04:00:00	SPY	ETF	453.02	453.26	452.78	453.12	32545.0
2023-07-24 05:00:00	SPY	ETF	453.11	453.5	453.08	453.33	14133.0
2023-07-24 06:00:00	SPY	ETF	453.28	453.37	453.11	453.11	9837.0
2023-07-24 07:00:00	SPY	ETF	453.11	453.4	452.89	453.06	72108.0
2023-07-24 08:00:00	SPY	ETF	452.97	453.4004	452.33	453.2	121183.0
2023-07-24 09:00:00	SPY	ETF	453.22	454.45	452.75	453.2	5772872.0
2023-07-24 10:00:00	SPY	ETF	453.195	454.3699	452.91	454.245	6948206.0
2023-07-24 11:00:00	SPY	ETF	454.25	454.58	453.75	454.49	4187538.0
2023-07-24 12:00:00	SPY	ETF	454.48	454.705	453.995	454.3	2730642.0
2023-07-24 13:00:00	SPY	ETF	454.3	454.82	454.03	454.77	3195978.0
2023-07-24 14:00:00	SPY	ETF	454.77	455.04	453.82	454.29	4380366.0
2023-07-24 15:00:00	SPY	ETF	454.28	454.4377	453.43	454.2	9361723.0
2023-07-24 16:00:00	SPY	ETF	454.2	454.55	453.87	454.37	3488714.0
2023-07-24 17:00:00	SPY	ETF	454.42	454.47	454.39	454.4	20277.0
2023-07-24 18:00:00	SPY	ETF	454.4	454.4	454.17	454.26	27579.0
2023-07-24 19:00:00	SPY	ETF	454.28	454.4	454.23	454.28	26267.0
2023-07-24 04:00:00	QQQ	ETF	376.35	376.97	376.31	376.45	40573.0
2023-07-24 05:00:00	QQQ	ETF	376.54	376.97	376.54	376.76	18892.0
2023-07-24 06:00:00	QQQ	ETF	376.68	376.84	376.52	376.52	36130.0
2023-07-24 07:00:00	QQQ	ETF	376.52	376.87	376.29	376.7	56463.0
2023-07-24 08:00:00	QQQ	ETF	376.68	376.89	375.69	376.51	177822.0
2023-07-24 09:00:00	QQQ	ETF	376.52	377.58	374.34	374.88	5630043.0
2023-07-24 10:00:00	QQQ	ETF	374.86	376.96	374.67	376.24	5881626.0
2023-07-24 11:00:00	QQQ	ETF	376.24	376.97	375.17	376.21	4184318.0
2023-07-24 12:00:00	QQQ	ETF	376.21	376.67	375.515	375.9001	2801450.0
2023-07-24 13:00:00	QQQ	ETF	375.91	376.91	375.61	376.74	2452539.0
2023-07-24 14:00:00	QQQ	ETF	376.74	377.06	375.67	376.28	2400828.0
2023-07-24 15:00:00	QQQ	ETF	376.28	376.488	375.325	376.24	4187350.0
2023-07-24 16:00:00	QQQ	ETF	376.24	376.52	376.0712	376.37	2583683.0
2023-07-24 17:00:00	QQQ	ETF	376.47	376.53	376.4	376.53	27601.0
2023-07-24 18:00:00	QQQ	ETF	376.41	376.47	376.2	376.28	29378.0
2023-07-24 19:00:00	QQQ	ETF	376.28	376.45	376.16	376.36	49661.0
2023-07-24 04:00:00	IWM	ETF	194.22	194.98	194.22	194.89	12122.0
2023-07-24 05:00:00	IWM	ETF	194.89	195.16	194.84	195.12	4353.0
2023-07-24 06:00:00	IWM	ETF	195.03	195.03	194.78	194.78	15846.0
2023-07-24 07:00:00	IWM	ETF	194.78	194.89	194.55	194.61	36530.0
2023-07-24 08:00:00	IWM	ETF	194.84	195.0496	194.24	194.47	53446.0
2023-07-24 09:00:00	IWM	ETF	194.52	196.255	194.3	194.5	2771196.0
2023-07-24 10:00:00	IWM	ETF	194.5	194.87	193.99	194.35	3038970.0
2023-07-24 11:00:00	IWM	ETF	194.4	195.05	194.16	195.05	1478091.0
2023-07-24 12:00:00	IWM	ETF	195.05	195.3	194.63	195.09	1087142.0
2023-07-24 13:00:00	IWM	ETF	195.08	195.27	194.81	194.985	999142.0
2023-07-24 14:00:00	IWM	ETF	194.99	195.325	194.67	194.91	1059395.0
2023-07-24 15:00:00	IWM	ETF	194.91	195.11	194.5299	194.93	2313756.0
2023-07-24 16:00:00	IWM	ETF	194.94	195.03	194.88	194.96	394599.0
2023-07-24 17:00:00	IWM	ETF	194.97	195.08	194.97	195.07	7114.0
2023-07-24 18:00:00	IWM	ETF	194.96	194.97	194.9	194.9	10097.0
2023-07-24 19:00:00	IWM	ETF	194.89	194.98	194.85	194.8801	24962.0
2023-07-24 04:00:00	DIA	ETF	352.64	352.64	352.64	352.64	100.0
2023-07-24 05:00:00	DIA	ETF	352.74	352.74	352.74	352.74	200.0

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

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