PREVIEW / etf_1hour / 2023-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-26.parquet
  size:    474 KB
  rows:    17,133

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-01-26 04:00:00	SPY	ETF	401.37	401.87	400.73	400.84	57821.0
2023-01-26 05:00:00	SPY	ETF	400.96	401.52	400.93	401.34	26606.0
2023-01-26 06:00:00	SPY	ETF	401.28	401.54	401.05	401.24	45592.0
2023-01-26 07:00:00	SPY	ETF	401.25	402.96	401.17	402.55	208452.0
2023-01-26 08:00:00	SPY	ETF	401.32	403.01	400.95	402.73	1134905.0
2023-01-26 09:00:00	SPY	ETF	402.74	404.07	400.8	401.4943	7271283.0
2023-01-26 10:00:00	SPY	ETF	401.55	403.25	400.03	400.35	8946329.0
2023-01-26 11:00:00	SPY	ETF	400.345	401.7794	400.06	401.68	6216790.0
2023-01-26 12:00:00	SPY	ETF	401.71	402.82	401.641	402.18	5321884.0
2023-01-26 13:00:00	SPY	ETF	402.17	403.5197	401.598	402.905	4102255.0
2023-01-26 14:00:00	SPY	ETF	402.9	403.7	402.505	403.45	5435246.0
2023-01-26 15:00:00	SPY	ETF	403.47	404.92	403.1299	404.71	10552239.0
2023-01-26 16:00:00	SPY	ETF	404.71	404.9	403.95	404.07	3726574.0
2023-01-26 17:00:00	SPY	ETF	404.1	404.75	403.5	403.76	588880.0
2023-01-26 18:00:00	SPY	ETF	403.76	403.909	403.46	403.52	182448.0
2023-01-26 19:00:00	SPY	ETF	403.52	403.99	403.45	403.7	64312.0
2023-01-26 04:00:00	QQQ	ETF	289.06	289.86	288.85	288.9	84039.0
2023-01-26 05:00:00	QQQ	ETF	288.89	289.57	288.84	289.46	43353.0
2023-01-26 06:00:00	QQQ	ETF	289.4	289.72	289.28	289.45	27934.0
2023-01-26 07:00:00	QQQ	ETF	289.52	290.88	289.52	290.67	242844.0
2023-01-26 08:00:00	QQQ	ETF	289.6	291.04	287.945	290.72	906527.0
2023-01-26 09:00:00	QQQ	ETF	290.74	292.64	289.54	290.2147	6785153.0
2023-01-26 10:00:00	QQQ	ETF	290.22	291.9899	288.58	288.9	6299546.0
2023-01-26 11:00:00	QQQ	ETF	288.91	290.24	288.519	290.14	4040880.0
2023-01-26 12:00:00	QQQ	ETF	290.13	291.22	290.03	290.77	3214729.0
2023-01-26 13:00:00	QQQ	ETF	290.78	291.93	290.08	291.485	2564990.0
2023-01-26 14:00:00	QQQ	ETF	291.47	292.345	291.1299	292.1701	2719185.0
2023-01-26 15:00:00	QQQ	ETF	292.18	293.52	291.8	293.38	7819648.0
2023-01-26 16:00:00	QQQ	ETF	293.39	293.53	292.17	292.2	2262312.0
2023-01-26 17:00:00	QQQ	ETF	292.16	293.34	292.0	292.05	152618.0
2023-01-26 18:00:00	QQQ	ETF	292.0	292.05	291.67	291.75	117332.0
2023-01-26 19:00:00	QQQ	ETF	291.8	292.2001	291.77	291.9901	92896.0
2023-01-26 04:00:00	IWM	ETF	187.9	188.04	187.44	187.47	25508.0
2023-01-26 05:00:00	IWM	ETF	187.53	187.89	187.53	187.77	19115.0
2023-01-26 06:00:00	IWM	ETF	187.76	187.84	187.58	187.65	9024.0
2023-01-26 07:00:00	IWM	ETF	187.7	188.54	187.69	188.36	106935.0
2023-01-26 08:00:00	IWM	ETF	187.6104	188.83	187.6104	188.73	200593.0
2023-01-26 09:00:00	IWM	ETF	188.76	189.85	186.965	187.31	3916680.0
2023-01-26 10:00:00	IWM	ETF	187.32	187.92	186.37	186.41	2023320.0
2023-01-26 11:00:00	IWM	ETF	186.4	187.23	186.29	187.14	1339156.0
2023-01-26 12:00:00	IWM	ETF	187.1546	187.63	186.99	187.28	1269027.0
2023-01-26 13:00:00	IWM	ETF	187.28	187.84	186.95	187.47	989808.0
2023-01-26 14:00:00	IWM	ETF	187.47	187.92	187.32	187.745	1085267.0
2023-01-26 15:00:00	IWM	ETF	187.75	188.7	187.53	188.56	2180119.0
2023-01-26 16:00:00	IWM	ETF	188.56	188.67	188.28	188.3	571477.0
2023-01-26 17:00:00	IWM	ETF	188.17	188.43	188.17	188.3	10209.0
2023-01-26 18:00:00	IWM	ETF	188.24	188.28	188.08	188.09	24620.0
2023-01-26 19:00:00	IWM	ETF	188.08	188.3	188.08	188.1	24041.0
2023-01-26 04:00:00	DIA	ETF	337.5	337.5	337.15	337.15	450.0
2023-01-26 06:00:00	DIA	ETF	337.57	337.57	337.57	337.57	1583.0

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

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