PREVIEW / etf_1hour / 2023-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-04.parquet
  size:    474 KB
  rows:    17,402

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-08-04 04:00:00	SPY	ETF	450.86	451.51	450.55	450.66	60673.0
2023-08-04 05:00:00	SPY	ETF	450.73	451.27	450.68	450.77	14219.0
2023-08-04 06:00:00	SPY	ETF	450.56	450.64	449.88	449.88	52240.0
2023-08-04 07:00:00	SPY	ETF	449.97	449.97	448.9	449.28	176528.0
2023-08-04 08:00:00	SPY	ETF	450.61	451.4104	448.31	450.52	1705737.0
2023-08-04 09:00:00	SPY	ETF	450.52	451.87	450.15	450.2993	6972963.0
2023-08-04 10:00:00	SPY	ETF	450.2999	451.4399	448.77	451.3	9604640.0
2023-08-04 11:00:00	SPY	ETF	451.3	451.93	451.1305	451.83	5536008.0
2023-08-04 12:00:00	SPY	ETF	451.82	452.895	451.52	452.74	5204474.0
2023-08-04 13:00:00	SPY	ETF	452.7301	452.785	450.62	450.76	6310149.0
2023-08-04 14:00:00	SPY	ETF	450.755	450.755	446.76	447.1098	14604610.0
2023-08-04 15:00:00	SPY	ETF	447.1	447.72	446.27	446.8	18311607.0
2023-08-04 16:00:00	SPY	ETF	446.79	447.13	446.0	446.73	5793252.0
2023-08-04 17:00:00	SPY	ETF	446.66	446.85	446.65	446.7999	145791.0
2023-08-04 18:00:00	SPY	ETF	446.76	446.89	446.72	446.84	33631.0
2023-08-04 19:00:00	SPY	ETF	446.8	446.91	446.61	446.82	29385.0
2023-08-04 04:00:00	QQQ	ETF	375.87	376.86	375.76	375.95	73048.0
2023-08-04 05:00:00	QQQ	ETF	376.13	376.54	375.95	376.12	34576.0
2023-08-04 06:00:00	QQQ	ETF	375.92	376.06	375.06	375.2	31854.0
2023-08-04 07:00:00	QQQ	ETF	375.25	375.25	373.85	374.35	200074.0
2023-08-04 08:00:00	QQQ	ETF	374.809	376.71	373.12	375.8	1613238.0
2023-08-04 09:00:00	QQQ	ETF	375.82	377.47	374.02	374.2	7555399.0
2023-08-04 10:00:00	QQQ	ETF	374.24	376.14	372.88	375.905	7448936.0
2023-08-04 11:00:00	QQQ	ETF	375.91	377.4	375.76	377.17	3843650.0
2023-08-04 12:00:00	QQQ	ETF	377.14	378.1	376.61	377.735	3346702.0
2023-08-04 13:00:00	QQQ	ETF	377.74	377.81	375.85	376.05	3672266.0
2023-08-04 14:00:00	QQQ	ETF	376.045	376.045	372.07	372.4266	8608165.0
2023-08-04 15:00:00	QQQ	ETF	372.42	373.28	371.53	372.01	9038455.0
2023-08-04 16:00:00	QQQ	ETF	372.06	372.48	372.03	372.19	1260564.0
2023-08-04 17:00:00	QQQ	ETF	372.2	372.27	371.95	372.05	346502.0
2023-08-04 18:00:00	QQQ	ETF	372.09	372.1601	372.02	372.08	20914.0
2023-08-04 19:00:00	QQQ	ETF	372.03	372.11	371.81	371.81	25884.0
2023-08-04 04:00:00	IWM	ETF	195.11	195.25	194.56	194.58	15321.0
2023-08-04 05:00:00	IWM	ETF	194.61	194.88	194.5	194.55	5563.0
2023-08-04 06:00:00	IWM	ETF	194.49	194.59	194.18	194.21	36696.0
2023-08-04 07:00:00	IWM	ETF	194.22	194.26	193.83	194.02	29627.0
2023-08-04 08:00:00	IWM	ETF	194.0	195.1996	193.45	194.65	262788.0
2023-08-04 09:00:00	IWM	ETF	194.54	195.43	194.15	194.37	3918102.0
2023-08-04 10:00:00	IWM	ETF	194.38	195.59	193.71	195.585	3126201.0
2023-08-04 11:00:00	IWM	ETF	195.59	195.86	195.11	195.685	2178198.0
2023-08-04 12:00:00	IWM	ETF	195.7	196.31	195.53	196.17	1449281.0
2023-08-04 13:00:00	IWM	ETF	196.18	196.225	195.49	195.56	1529997.0
2023-08-04 14:00:00	IWM	ETF	195.56	195.56	193.94	194.15	4011983.0
2023-08-04 15:00:00	IWM	ETF	194.15	194.445	193.94	194.19	3767281.0
2023-08-04 16:00:00	IWM	ETF	194.17	194.26	194.03	194.1	478702.0
2023-08-04 17:00:00	IWM	ETF	194.13	194.17	194.03	194.03	4401.0
2023-08-04 18:00:00	IWM	ETF	194.12	194.15	194.02	194.14	3814.0
2023-08-04 19:00:00	IWM	ETF	194.12	194.15	194.01	194.02	7773.0
2023-08-04 04:00:00	DIA	ETF	353.22	353.22	353.22	353.22	199.0
2023-08-04 05:00:00	DIA	ETF	352.98	352.98	352.55	352.72	300.0

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

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