PREVIEW / etf_1hour / 2023-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-22.parquet
  size:    493 KB
  rows:    18,010

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-22 04:00:00	SPY	ETF	453.27	453.79	453.27	453.62	31557.0
2023-11-22 05:00:00	SPY	ETF	453.55	454.29	453.55	454.29	17433.0
2023-11-22 06:00:00	SPY	ETF	454.3	454.45	454.03	454.11	47060.0
2023-11-22 07:00:00	SPY	ETF	454.1	454.7	454.09	454.46	104251.0
2023-11-22 08:00:00	SPY	ETF	454.16	455.02	453.0	454.95	352886.0
2023-11-22 09:00:00	SPY	ETF	454.99	456.38	454.34	454.935	7555661.0
2023-11-22 10:00:00	SPY	ETF	454.93	455.53	453.8895	454.5084	8730931.0
2023-11-22 11:00:00	SPY	ETF	454.51	455.57	454.45	455.51	4679211.0
2023-11-22 12:00:00	SPY	ETF	455.51	455.9	454.62	455.0805	4834103.0
2023-11-22 13:00:00	SPY	ETF	455.08	455.6	455.0	455.32	3272734.0
2023-11-22 14:00:00	SPY	ETF	455.31	455.62	453.925	454.84	6437809.0
2023-11-22 15:00:00	SPY	ETF	454.84	455.41	454.67	455.03	9475908.0
2023-11-22 16:00:00	SPY	ETF	455.03	455.1399	454.87	454.94	2503314.0
2023-11-22 17:00:00	SPY	ETF	455.02	455.02	454.88	454.88	161034.0
2023-11-22 18:00:00	SPY	ETF	454.86	454.88	454.69	454.72	62606.0
2023-11-22 19:00:00	SPY	ETF	454.7	454.85	454.6	454.85	25028.0
2023-11-22 04:00:00	QQQ	ETF	387.91	388.6	387.84	388.6	54777.0
2023-11-22 05:00:00	QQQ	ETF	388.6	389.56	388.6	389.56	94992.0
2023-11-22 06:00:00	QQQ	ETF	389.54	389.93	389.38	389.6	82209.0
2023-11-22 07:00:00	QQQ	ETF	389.62	390.36	389.57	390.01	275734.0
2023-11-22 08:00:00	QQQ	ETF	389.66	390.58	387.6	390.4503	553484.0
2023-11-22 09:00:00	QQQ	ETF	390.55	393.07	389.74	390.5	8045860.0
2023-11-22 10:00:00	QQQ	ETF	390.48	391.29	389.04	389.8599	7293795.0
2023-11-22 11:00:00	QQQ	ETF	389.87	390.96	389.75	390.91	3426070.0
2023-11-22 12:00:00	QQQ	ETF	390.91	391.34	390.3	390.645	2831860.0
2023-11-22 13:00:00	QQQ	ETF	390.64	391.42	390.53	391.08	2250621.0
2023-11-22 14:00:00	QQQ	ETF	391.08	391.32	389.2	390.2499	4256692.0
2023-11-22 15:00:00	QQQ	ETF	390.23	390.43	389.9623	390.04	5311920.0
2023-11-22 16:00:00	QQQ	ETF	390.04	390.17	389.83	389.99	972755.0
2023-11-22 17:00:00	QQQ	ETF	389.94	390.0	389.91	389.93	11077.0
2023-11-22 18:00:00	QQQ	ETF	389.83	389.99	389.78	389.98	25905.0
2023-11-22 19:00:00	QQQ	ETF	389.98	390.03	389.82	390.03	33955.0
2023-11-22 04:00:00	IWM	ETF	177.54	177.63	177.47	177.48	10830.0
2023-11-22 05:00:00	IWM	ETF	177.65	177.95	177.65	177.95	12897.0
2023-11-22 06:00:00	IWM	ETF	177.91	178.13	177.82	177.82	71429.0
2023-11-22 07:00:00	IWM	ETF	177.85	178.23	177.81	178.08	43223.0
2023-11-22 08:00:00	IWM	ETF	178.11	178.5	177.16	178.3	243179.0
2023-11-22 09:00:00	IWM	ETF	178.25	179.39	177.53	178.44	4998039.0
2023-11-22 10:00:00	IWM	ETF	178.43	178.91	177.735	178.38	3766043.0
2023-11-22 11:00:00	IWM	ETF	178.38	178.79	178.21	178.75	1360886.0
2023-11-22 12:00:00	IWM	ETF	178.76	178.81	177.78	177.96	2198822.0
2023-11-22 13:00:00	IWM	ETF	177.96	178.225	177.9087	178.07	1489799.0
2023-11-22 14:00:00	IWM	ETF	178.065	178.25	177.42	177.95	1519844.0
2023-11-22 15:00:00	IWM	ETF	177.955	178.4	177.93	178.13	3431603.0
2023-11-22 16:00:00	IWM	ETF	178.13	178.26	178.08	178.23	722976.0
2023-11-22 17:00:00	IWM	ETF	178.18	178.24	178.13	178.15	4044.0
2023-11-22 18:00:00	IWM	ETF	178.13	178.13	177.94	177.94	24108.0
2023-11-22 19:00:00	IWM	ETF	177.91	178.04	177.9	178.01	19963.0
2023-11-22 04:00:00	DIA	ETF	351.55	351.55	351.55	351.55	125.0
2023-11-22 05:00:00	DIA	ETF	351.5	351.5	351.5	351.5	100.0

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

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