PREVIEW / etf_1hour / 2023-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-23.parquet
  size:    482 KB
  rows:    17,673

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-23 04:00:00	SPY	ETF	389.05	395.91	389.05	395.76	26006.0
2023-01-23 05:00:00	SPY	ETF	395.9	395.91	395.26	395.7	54956.0
2023-01-23 06:00:00	SPY	ETF	395.6	395.85	395.16	395.38	93882.0
2023-01-23 07:00:00	SPY	ETF	395.43	396.44	395.43	395.86	176153.0
2023-01-23 08:00:00	SPY	ETF	395.5	397.13	395.5	396.58	644234.0
2023-01-23 09:00:00	SPY	ETF	396.57	398.3	395.72	397.855	6281048.0
2023-01-23 10:00:00	SPY	ETF	397.87	400.28	397.62	399.88	10069049.0
2023-01-23 11:00:00	SPY	ETF	399.9	402.11	399.89	401.53	9288716.0
2023-01-23 12:00:00	SPY	ETF	401.55	401.63	400.375	401.5	4419661.0
2023-01-23 13:00:00	SPY	ETF	401.475	402.645	401.4	402.005	4713838.0
2023-01-23 14:00:00	SPY	ETF	402.03	402.03	398.7201	399.53	9197383.0
2023-01-23 15:00:00	SPY	ETF	399.54	401.0	399.06	400.59	13329665.0
2023-01-23 16:00:00	SPY	ETF	400.59	400.74	400.11	400.72	5896652.0
2023-01-23 17:00:00	SPY	ETF	400.72	400.79	400.36	400.66	120333.0
2023-01-23 18:00:00	SPY	ETF	400.73	400.73	400.16	400.3	99502.0
2023-01-23 19:00:00	SPY	ETF	400.25	400.47	400.21	400.4	44776.0
2023-01-23 04:00:00	QQQ	ETF	282.56	282.97	282.31	282.87	63332.0
2023-01-23 05:00:00	QQQ	ETF	282.99	282.99	282.34	282.68	58917.0
2023-01-23 06:00:00	QQQ	ETF	282.62	282.72	282.31	282.44	41049.0
2023-01-23 07:00:00	QQQ	ETF	282.47	283.47	282.46	283.06	109034.0
2023-01-23 08:00:00	QQQ	ETF	282.6299	283.96	282.3504	283.35	415645.0
2023-01-23 09:00:00	QQQ	ETF	283.32	286.35	282.68	285.85	6493280.0
2023-01-23 10:00:00	QQQ	ETF	285.87	287.82	285.64	287.49	6187825.0
2023-01-23 11:00:00	QQQ	ETF	287.5	289.6	287.5	289.31	5129719.0
2023-01-23 12:00:00	QQQ	ETF	289.315	289.34	288.4	289.23	3048851.0
2023-01-23 13:00:00	QQQ	ETF	289.24	290.21	289.14	289.627	3725285.0
2023-01-23 14:00:00	QQQ	ETF	289.63	289.65	287.27	288.03	4860661.0
2023-01-23 15:00:00	QQQ	ETF	288.03	289.25	287.43	289.0	8116695.0
2023-01-23 16:00:00	QQQ	ETF	289.0	289.12	288.6	289.08	2244560.0
2023-01-23 17:00:00	QQQ	ETF	289.09	289.2	288.96	289.11	93902.0
2023-01-23 18:00:00	QQQ	ETF	289.07	289.1	288.66	288.71	82231.0
2023-01-23 19:00:00	QQQ	ETF	288.69	288.81	288.61	288.74	81853.0
2023-01-23 04:00:00	IWM	ETF	184.95	185.1	184.77	185.06	7650.0
2023-01-23 05:00:00	IWM	ETF	185.0	185.01	184.64	184.9	10721.0
2023-01-23 06:00:00	IWM	ETF	184.88	184.88	184.57	184.57	7220.0
2023-01-23 07:00:00	IWM	ETF	184.73	185.13	184.73	184.89	146804.0
2023-01-23 08:00:00	IWM	ETF	184.92	185.57	184.74	185.34	103118.0
2023-01-23 09:00:00	IWM	ETF	185.29	186.01	184.58	185.67	2026578.0
2023-01-23 10:00:00	IWM	ETF	185.68	186.79	185.62	186.675	1940538.0
2023-01-23 11:00:00	IWM	ETF	186.7	187.35	186.64	187.14	2223381.0
2023-01-23 12:00:00	IWM	ETF	187.16	187.74	186.73	187.68	1540537.0
2023-01-23 13:00:00	IWM	ETF	187.6736	188.115	187.66	187.835	1480318.0
2023-01-23 14:00:00	IWM	ETF	187.8	187.8	186.11	186.44	2173119.0
2023-01-23 15:00:00	IWM	ETF	186.44	187.61	186.27	187.38	3190896.0
2023-01-23 16:00:00	IWM	ETF	187.33	187.42	187.17	187.33	745685.0
2023-01-23 17:00:00	IWM	ETF	187.26	187.44	187.24	187.44	5578.0
2023-01-23 18:00:00	IWM	ETF	187.35	187.42	187.14	187.16	20247.0
2023-01-23 19:00:00	IWM	ETF	187.18	187.33	187.15	187.26	27224.0
2023-01-23 04:00:00	DIA	ETF	333.68	333.96	333.68	333.75	2724.0
2023-01-23 05:00:00	DIA	ETF	333.66	333.69	333.66	333.69	836.0

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

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