PREVIEW / etf_1hour / 2023-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-17.parquet
  size:    501 KB
  rows:    18,178

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-17 04:00:00	SPY	ETF	451.12	451.53	450.94	451.01	56166.0
2023-11-17 05:00:00	SPY	ETF	451.0	451.62	451.0	451.49	6216.0
2023-11-17 06:00:00	SPY	ETF	451.4	451.4	451.01	451.3	9406.0
2023-11-17 07:00:00	SPY	ETF	451.31	451.67	451.15	451.35	180471.0
2023-11-17 08:00:00	SPY	ETF	451.2614	451.94	450.45	451.18	401517.0
2023-11-17 09:00:00	SPY	ETF	451.17	451.37	449.46	450.15	5522020.0
2023-11-17 10:00:00	SPY	ETF	450.145	450.37	449.49	450.09	6376677.0
2023-11-17 11:00:00	SPY	ETF	450.09	450.24	449.29	450.21	4389647.0
2023-11-17 12:00:00	SPY	ETF	450.215	450.69	450.01	450.45	4312639.0
2023-11-17 13:00:00	SPY	ETF	450.47	451.1	450.25	451.04	4141758.0
2023-11-17 14:00:00	SPY	ETF	451.05	451.395	450.64	450.945	4542596.0
2023-11-17 15:00:00	SPY	ETF	450.95	451.42	450.2	450.78	11896723.0
2023-11-17 16:00:00	SPY	ETF	450.785	451.0	450.0	450.4	4737927.0
2023-11-17 17:00:00	SPY	ETF	450.45	450.68	450.38	450.38	52600.0
2023-11-17 18:00:00	SPY	ETF	450.41	450.41	450.2	450.25	53516.0
2023-11-17 19:00:00	SPY	ETF	450.25	450.4499	450.25	450.36	5184.0
2023-11-17 04:00:00	QQQ	ETF	385.84	386.55	385.84	386.03	55239.0
2023-11-17 05:00:00	QQQ	ETF	386.0	386.47	385.96	386.35	50880.0
2023-11-17 06:00:00	QQQ	ETF	386.21	386.29	385.69	386.15	46546.0
2023-11-17 07:00:00	QQQ	ETF	386.15	386.47	385.95	386.14	69772.0
2023-11-17 08:00:00	QQQ	ETF	386.1004	386.59	385.52	385.86	285864.0
2023-11-17 09:00:00	QQQ	ETF	385.79	386.02	384.45	385.47	4421096.0
2023-11-17 10:00:00	QQQ	ETF	385.48	385.531	384.34	385.21	4120333.0
2023-11-17 11:00:00	QQQ	ETF	385.21	385.63	384.29	385.625	2821824.0
2023-11-17 12:00:00	QQQ	ETF	385.62	386.045	385.245	385.93	2862993.0
2023-11-17 13:00:00	QQQ	ETF	385.925	386.59	385.79	386.3409	2926039.0
2023-11-17 14:00:00	QQQ	ETF	386.34	387.07	386.03	386.37	3214625.0
2023-11-17 15:00:00	QQQ	ETF	386.38	386.8	385.41	386.06	6003612.0
2023-11-17 16:00:00	QQQ	ETF	386.06	386.09	385.49	385.52	3341930.0
2023-11-17 17:00:00	QQQ	ETF	385.5	386.04	385.49	385.54	385887.0
2023-11-17 18:00:00	QQQ	ETF	385.53	386.04	385.53	385.67	628501.0
2023-11-17 19:00:00	QQQ	ETF	385.67	385.85	385.58	385.65	38409.0
2023-11-17 04:00:00	IWM	ETF	176.99	177.25	176.9	177.22	19433.0
2023-11-17 05:00:00	IWM	ETF	177.28	178.41	177.22	178.29	56803.0
2023-11-17 06:00:00	IWM	ETF	178.28	178.4	178.06	178.33	102339.0
2023-11-17 07:00:00	IWM	ETF	178.32	178.46	177.96	177.99	351451.0
2023-11-17 08:00:00	IWM	ETF	178.24	178.4	176.16	177.51	373081.0
2023-11-17 09:00:00	IWM	ETF	177.47	178.14	177.105	177.47	6127043.0
2023-11-17 10:00:00	IWM	ETF	177.47	178.64	177.23	178.41	4924738.0
2023-11-17 11:00:00	IWM	ETF	178.42	178.46	177.57	177.8397	3154820.0
2023-11-17 12:00:00	IWM	ETF	177.83	178.32	177.82	178.26	2475138.0
2023-11-17 13:00:00	IWM	ETF	178.26	178.59	178.11	178.42	1993765.0
2023-11-17 14:00:00	IWM	ETF	178.42	178.57	178.2	178.27	2537685.0
2023-11-17 15:00:00	IWM	ETF	178.27	178.52	177.97	178.33	4896711.0
2023-11-17 16:00:00	IWM	ETF	178.29	178.34	178.18	178.24	934365.0
2023-11-17 17:00:00	IWM	ETF	178.23	178.49	178.11	178.27	94013.0
2023-11-17 18:00:00	IWM	ETF	178.2	178.29	178.11	178.15	21657.0
2023-11-17 19:00:00	IWM	ETF	178.16	178.35	178.141	178.21	9158.0
2023-11-17 04:00:00	DIA	ETF	350.82	350.82	350.01	350.09	5266.0
2023-11-17 05:00:00	DIA	ETF	350.37	350.38	350.37	350.38	200.0

> showing 50 of 18,178 rows — these rows as CSV

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