PREVIEW / etf_1hour / 2023-11-24

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-24.parquet
  size:    308 KB
  rows:    10,834

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-11-24 04:00:00	SPY	ETF	455.18	455.76	454.87	455.58	17436.0
2023-11-24 05:00:00	SPY	ETF	455.58	455.75	455.4	455.75	5566.0
2023-11-24 06:00:00	SPY	ETF	455.69	455.69	455.4	455.56	5099.0
2023-11-24 07:00:00	SPY	ETF	455.57	455.79	455.53	455.62	23645.0
2023-11-24 08:00:00	SPY	ETF	455.63	455.78	455.05	455.4	133715.0
2023-11-24 09:00:00	SPY	ETF	455.41	455.44	454.73	455.2501	2853106.0
2023-11-24 10:00:00	SPY	ETF	455.26	455.5	454.73	455.13	3721145.0
2023-11-24 11:00:00	SPY	ETF	455.14	455.24	454.88	454.95	2729761.0
2023-11-24 12:00:00	SPY	ETF	454.96	455.33	454.82	455.26	4911392.0
2023-11-24 13:00:00	SPY	ETF	455.26	455.6	454.87	455.03	2435809.0
2023-11-24 14:00:00	SPY	ETF	455.0	455.32	454.92	455.3	86932.0
2023-11-24 15:00:00	SPY	ETF	455.3	455.59	455.28	455.5	31896.0
2023-11-24 16:00:00	SPY	ETF	455.4	455.46	455.1	455.4	16679.0
2023-11-24 04:00:00	QQQ	ETF	389.99	390.66	389.99	390.28	26747.0
2023-11-24 05:00:00	QQQ	ETF	390.29	390.29	389.67	390.18	55144.0
2023-11-24 06:00:00	QQQ	ETF	390.12	390.16	389.62	389.82	19817.0
2023-11-24 07:00:00	QQQ	ETF	389.88	390.11	389.79	389.84	47906.0
2023-11-24 08:00:00	QQQ	ETF	389.8701	390.47	389.62	390.2	126700.0
2023-11-24 09:00:00	QQQ	ETF	390.14	390.25	389.0	389.6087	2704248.0
2023-11-24 10:00:00	QQQ	ETF	389.61	389.86	388.5	389.015	3470771.0
2023-11-24 11:00:00	QQQ	ETF	389.02	389.54	388.85	389.395	2050032.0
2023-11-24 12:00:00	QQQ	ETF	389.39	389.51	389.05	389.5	2949508.0
2023-11-24 13:00:00	QQQ	ETF	389.5	389.5575	389.11	389.2	777381.0
2023-11-24 14:00:00	QQQ	ETF	389.14	389.3099	389.1	389.25	34971.0
2023-11-24 15:00:00	QQQ	ETF	389.2501	389.3	389.21	389.3	7651.0
2023-11-24 16:00:00	QQQ	ETF	389.26	389.26	389.21	389.22	1405.0
2023-11-24 04:00:00	IWM	ETF	177.95	177.99	177.89	177.89	5261.0
2023-11-24 05:00:00	IWM	ETF	177.89	178.04	177.88	178.04	3839.0
2023-11-24 06:00:00	IWM	ETF	178.0	178.24	178.0	178.24	14693.0
2023-11-24 07:00:00	IWM	ETF	178.27	178.6	178.27	178.3	26518.0
2023-11-24 08:00:00	IWM	ETF	178.48	178.53	177.9596	178.2	85079.0
2023-11-24 09:00:00	IWM	ETF	178.2	179.13	177.8	178.92	2697577.0
2023-11-24 10:00:00	IWM	ETF	178.915	179.73	178.89	179.45	2934002.0
2023-11-24 11:00:00	IWM	ETF	179.46	179.53	179.01	179.025	1800550.0
2023-11-24 12:00:00	IWM	ETF	179.02	179.4392	178.97	179.29	3142058.0
2023-11-24 13:00:00	IWM	ETF	179.33	179.46	179.01	179.2	497616.0
2023-11-24 14:00:00	IWM	ETF	179.2	179.2	179.12	179.2	9506.0
2023-11-24 15:00:00	IWM	ETF	179.21	179.49	179.15	179.49	4062.0
2023-11-24 16:00:00	IWM	ETF	179.27	179.29	179.21	179.21	2289.0
2023-11-24 04:00:00	DIA	ETF	353.18	353.32	353.18	353.32	1575.0
2023-11-24 05:00:00	DIA	ETF	353.45	353.63	353.45	353.52	4851.0
2023-11-24 06:00:00	DIA	ETF	353.66	353.66	353.57	353.57	600.0
2023-11-24 07:00:00	DIA	ETF	353.63	353.77	353.55	353.55	3697.0
2023-11-24 08:00:00	DIA	ETF	353.6409	353.6409	353.1	353.24	1624.0
2023-11-24 09:00:00	DIA	ETF	353.21	353.595	353.04	353.54	257994.0
2023-11-24 10:00:00	DIA	ETF	353.57	353.95	353.56	353.8484	201110.0
2023-11-24 11:00:00	DIA	ETF	353.82	353.95	353.26	353.35	148509.0
2023-11-24 12:00:00	DIA	ETF	353.37	353.9	353.3	353.8299	243289.0
2023-11-24 13:00:00	DIA	ETF	353.88	353.9104	353.75	353.75	15338.0
2023-11-24 14:00:00	DIA	ETF	353.7999	353.7999	353.7999	353.7999	200.0

> showing 50 of 10,834 rows — these rows as CSV

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