PREVIEW / etf_1hour / 2023-11-28

all etf 1-hour files

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

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-28 04:00:00	SPY	ETF	454.12	454.52	453.92	454.52	16632.0
2023-11-28 05:00:00	SPY	ETF	454.52	454.56	454.35	454.35	4413.0
2023-11-28 06:00:00	SPY	ETF	454.59	454.59	454.15	454.18	19923.0
2023-11-28 07:00:00	SPY	ETF	454.2	454.33	453.7	453.72	135681.0
2023-11-28 08:00:00	SPY	ETF	454.3292	454.99	453.3	453.94	427966.0
2023-11-28 09:00:00	SPY	ETF	453.96	454.23	453.5	453.6131	3671620.0
2023-11-28 10:00:00	SPY	ETF	453.63	455.44	453.6	455.17	7455567.0
2023-11-28 11:00:00	SPY	ETF	455.18	456.27	454.92	456.02	6294605.0
2023-11-28 12:00:00	SPY	ETF	456.02	456.055	454.6	454.9001	5306058.0
2023-11-28 13:00:00	SPY	ETF	454.91	454.92	453.77	454.39	6508966.0
2023-11-28 14:00:00	SPY	ETF	454.39	454.945	453.97	454.75	3961374.0
2023-11-28 15:00:00	SPY	ETF	454.76	455.1	453.99	454.88	11503374.0
2023-11-28 16:00:00	SPY	ETF	454.88	455.25	454.87	455.0	2773169.0
2023-11-28 17:00:00	SPY	ETF	455.04	455.04	454.88	455.0	51649.0
2023-11-28 18:00:00	SPY	ETF	455.0	455.08	454.85	455.01	31815.0
2023-11-28 19:00:00	SPY	ETF	455.0	455.35	454.96	455.29	61005.0
2023-11-28 04:00:00	QQQ	ETF	388.32	388.79	388.25	388.79	23479.0
2023-11-28 05:00:00	QQQ	ETF	388.78	389.17	388.68	389.17	10007.0
2023-11-28 06:00:00	QQQ	ETF	389.15	389.24	388.82	388.83	15994.0
2023-11-28 07:00:00	QQQ	ETF	388.8	389.04	388.28	388.35	49772.0
2023-11-28 08:00:00	QQQ	ETF	388.8007	389.461	387.745	388.7	280369.0
2023-11-28 09:00:00	QQQ	ETF	388.68	389.23	388.05	388.25	3903702.0
2023-11-28 10:00:00	QQQ	ETF	388.254	390.21	388.21	389.3497	5237746.0
2023-11-28 11:00:00	QQQ	ETF	389.35	390.78	389.07	390.3699	3025122.0
2023-11-28 12:00:00	QQQ	ETF	390.38	390.474	389.23	389.612	2316203.0
2023-11-28 13:00:00	QQQ	ETF	389.63	389.635	388.3	389.105	3313783.0
2023-11-28 14:00:00	QQQ	ETF	389.11	389.71	388.69	389.55	2434610.0
2023-11-28 15:00:00	QQQ	ETF	389.56	390.31	388.81	390.215	4823735.0
2023-11-28 16:00:00	QQQ	ETF	390.21	390.44	390.15	390.31	1450090.0
2023-11-28 17:00:00	QQQ	ETF	390.3	390.38	390.26	390.38	25436.0
2023-11-28 18:00:00	QQQ	ETF	390.32	390.4	390.05	390.33	66457.0
2023-11-28 19:00:00	QQQ	ETF	390.33	390.71	390.23	390.62	44255.0
2023-11-28 04:00:00	IWM	ETF	178.68	178.87	178.55	178.72	3490.0
2023-11-28 05:00:00	IWM	ETF	178.85	178.85	178.76	178.81	1577.0
2023-11-28 06:00:00	IWM	ETF	178.79	178.87	178.6	178.6	8874.0
2023-11-28 07:00:00	IWM	ETF	178.57	178.7	178.19	178.25	29728.0
2023-11-28 08:00:00	IWM	ETF	178.2703	179.01	178.07	178.45	68534.0
2023-11-28 09:00:00	IWM	ETF	178.5	178.71	177.2	177.54	3657612.0
2023-11-28 10:00:00	IWM	ETF	177.54	178.88	177.43	178.84	4472989.0
2023-11-28 11:00:00	IWM	ETF	178.85	179.22	178.57	178.92	3642852.0
2023-11-28 12:00:00	IWM	ETF	178.93	178.97	178.08	178.125	2344888.0
2023-11-28 13:00:00	IWM	ETF	178.13	178.135	177.5205	177.85	2384539.0
2023-11-28 14:00:00	IWM	ETF	177.86	178.24	177.76	178.19	1523464.0
2023-11-28 15:00:00	IWM	ETF	178.19	178.224	177.83	178.01	3896397.0
2023-11-28 16:00:00	IWM	ETF	178.04	178.22	177.98	178.2	910897.0
2023-11-28 17:00:00	IWM	ETF	178.2	178.2	178.02	178.1	9195.0
2023-11-28 18:00:00	IWM	ETF	178.1	178.21	178.08	178.17	15340.0
2023-11-28 19:00:00	IWM	ETF	178.2	178.38	178.13	178.3	8364.0
2023-11-28 05:00:00	DIA	ETF	353.5	353.5	353.49	353.49	5750.0
2023-11-28 06:00:00	DIA	ETF	353.5	353.53	353.4	353.4	4432.0

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

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