PREVIEW / etf_1hour / 2023-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-30.parquet
  size:    509 KB
  rows:    18,643

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-30 04:00:00	SPY	ETF	455.09	455.59	455.04	455.44	19594.0
2023-11-30 05:00:00	SPY	ETF	455.5	455.87	455.42	455.8	11790.0
2023-11-30 06:00:00	SPY	ETF	455.75	455.78	455.54	455.56	22972.0
2023-11-30 07:00:00	SPY	ETF	455.51	456.15	455.5	456.11	117734.0
2023-11-30 08:00:00	SPY	ETF	455.98	456.65	454.85	455.8899	451490.0
2023-11-30 09:00:00	SPY	ETF	455.88	455.88	454.14	455.2	5916514.0
2023-11-30 10:00:00	SPY	ETF	455.2	455.6	454.01	454.93	7847033.0
2023-11-30 11:00:00	SPY	ETF	454.92	455.18	453.78	453.81	5891367.0
2023-11-30 12:00:00	SPY	ETF	453.82	454.4	453.48	454.1198	4536553.0
2023-11-30 13:00:00	SPY	ETF	454.11	454.145	453.34	453.924	3365291.0
2023-11-30 14:00:00	SPY	ETF	453.92	455.15	453.89	455.1	5176458.0
2023-11-30 15:00:00	SPY	ETF	455.1	456.76	453.84	456.31	21985749.0
2023-11-30 16:00:00	SPY	ETF	456.31	456.5	454.0131	456.06	5953556.0
2023-11-30 17:00:00	SPY	ETF	456.06	456.11	455.89	456.02	117012.0
2023-11-30 18:00:00	SPY	ETF	455.95	456.17	455.92	456.09	60055.0
2023-11-30 19:00:00	SPY	ETF	456.1	456.19	456.02	456.18	26232.0
2023-11-30 04:00:00	QQQ	ETF	390.21	390.73	390.21	390.41	17355.0
2023-11-30 05:00:00	QQQ	ETF	390.57	390.93	390.48	390.85	46641.0
2023-11-30 06:00:00	QQQ	ETF	390.71	390.83	390.6	390.6	21294.0
2023-11-30 07:00:00	QQQ	ETF	390.57	391.2	390.57	391.12	79408.0
2023-11-30 08:00:00	QQQ	ETF	390.64	391.82	390.102	390.52	420497.0
2023-11-30 09:00:00	QQQ	ETF	390.52	390.55	388.01	388.75	4910077.0
2023-11-30 10:00:00	QQQ	ETF	388.75	389.3	386.46	387.37	7007093.0
2023-11-30 11:00:00	QQQ	ETF	387.365	387.63	386.05	386.07	3760539.0
2023-11-30 12:00:00	QQQ	ETF	386.08	387.175	385.93	387.01	2754029.0
2023-11-30 13:00:00	QQQ	ETF	386.99	386.99	385.82	386.3	2722529.0
2023-11-30 14:00:00	QQQ	ETF	386.29	387.585	386.27	387.495	2851486.0
2023-11-30 15:00:00	QQQ	ETF	387.49	389.1	386.16	388.83	9081532.0
2023-11-30 16:00:00	QQQ	ETF	388.84	388.94	388.27	388.29	1604864.0
2023-11-30 17:00:00	QQQ	ETF	388.31	388.83	388.16	388.21	245465.0
2023-11-30 18:00:00	QQQ	ETF	388.14	388.48	388.13	388.4	77584.0
2023-11-30 19:00:00	QQQ	ETF	388.4	388.41	388.22	388.3	60219.0
2023-11-30 04:00:00	IWM	ETF	178.68	179.28	178.67	179.12	31977.0
2023-11-30 05:00:00	IWM	ETF	179.21	179.44	179.05	179.43	3635.0
2023-11-30 06:00:00	IWM	ETF	179.38	179.47	179.14	179.14	10293.0
2023-11-30 07:00:00	IWM	ETF	179.15	179.84	179.15	179.71	92693.0
2023-11-30 08:00:00	IWM	ETF	179.18	180.44	178.63	179.82	464028.0
2023-11-30 09:00:00	IWM	ETF	179.68	180.41	178.76	180.05	4239819.0
2023-11-30 10:00:00	IWM	ETF	180.04	180.41	179.55	180.339	4236481.0
2023-11-30 11:00:00	IWM	ETF	180.33	180.64	179.33	179.33	3571262.0
2023-11-30 12:00:00	IWM	ETF	179.33	179.68	179.06	179.52	2338869.0
2023-11-30 13:00:00	IWM	ETF	179.51	179.8	179.23	179.5	1667977.0
2023-11-30 14:00:00	IWM	ETF	179.5	179.97	179.48	179.935	1533371.0
2023-11-30 15:00:00	IWM	ETF	179.93	179.945	179.21	179.57	5863146.0
2023-11-30 16:00:00	IWM	ETF	179.57	179.67	179.51	179.52	2151976.0
2023-11-30 17:00:00	IWM	ETF	179.5	179.64	179.36	179.48	36581.0
2023-11-30 18:00:00	IWM	ETF	179.47	179.74	179.46	179.7	51438.0
2023-11-30 19:00:00	IWM	ETF	179.67	179.78	179.62	179.62	65821.0
2023-11-30 04:00:00	DIA	ETF	355.95	356.24	355.95	356.24	2148.0
2023-11-30 05:00:00	DIA	ETF	356.39	356.48	356.39	356.48	1752.0

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

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