PREVIEW / etf_1hour / 2023-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-28.parquet
  size:    523 KB
  rows:    19,485

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-12-28 04:00:00	SPY	ETF	477.05	477.1	476.93	477.0	35802.0
2023-12-28 05:00:00	SPY	ETF	477.17	477.21	476.87	476.92	13312.0
2023-12-28 06:00:00	SPY	ETF	476.96	477.1	476.85	477.0	7620.0
2023-12-28 07:00:00	SPY	ETF	476.97	477.23	476.93	477.05	144295.0
2023-12-28 08:00:00	SPY	ETF	476.96	477.58	476.65	476.65	289329.0
2023-12-28 09:00:00	SPY	ETF	476.72	477.385	476.6	477.19	3094196.0
2023-12-28 10:00:00	SPY	ETF	477.18	477.5	476.805	477.08	4520554.0
2023-12-28 11:00:00	SPY	ETF	477.08	477.14	476.59	476.8601	3178824.0
2023-12-28 12:00:00	SPY	ETF	476.86	477.41	476.78	477.2791	2797748.0
2023-12-28 13:00:00	SPY	ETF	477.27	477.55	476.43	477.0199	3738858.0
2023-12-28 14:00:00	SPY	ETF	477.02	477.5	476.9999	477.195	3737139.0
2023-12-28 15:00:00	SPY	ETF	477.2	477.345	476.26	476.68	13623807.0
2023-12-28 16:00:00	SPY	ETF	476.68	477.0	476.463	476.81	3640356.0
2023-12-28 17:00:00	SPY	ETF	476.77	476.88	476.69	476.85	235063.0
2023-12-28 18:00:00	SPY	ETF	476.82	477.05	476.78	477.03	28497.0
2023-12-28 19:00:00	SPY	ETF	476.96	477.05	476.95	477.05	26669.0
2023-12-28 04:00:00	QQQ	ETF	412.55	412.85	412.14	412.69	51752.0
2023-12-28 05:00:00	QQQ	ETF	412.73	412.83	412.65	412.68	12203.0
2023-12-28 06:00:00	QQQ	ETF	412.72	412.76	412.64	412.64	5767.0
2023-12-28 07:00:00	QQQ	ETF	412.72	412.98	412.66	412.85	75229.0
2023-12-28 08:00:00	QQQ	ETF	412.7	413.1	412.0	412.56	181059.0
2023-12-28 09:00:00	QQQ	ETF	412.62	412.92	411.84	412.0872	2186886.0
2023-12-28 10:00:00	QQQ	ETF	412.06	412.545	411.54	412.17	3053233.0
2023-12-28 11:00:00	QQQ	ETF	412.17	412.18	411.58	411.775	2212630.0
2023-12-28 12:00:00	QQQ	ETF	411.77	412.2691	411.6901	412.215	1580041.0
2023-12-28 13:00:00	QQQ	ETF	412.21	412.3499	411.29	411.825	2052710.0
2023-12-28 14:00:00	QQQ	ETF	411.82	412.19	411.715	411.825	2075543.0
2023-12-28 15:00:00	QQQ	ETF	411.83	412.0	410.94	411.21	4862574.0
2023-12-28 16:00:00	QQQ	ETF	411.22	411.48	411.14	411.2	1136801.0
2023-12-28 17:00:00	QQQ	ETF	411.22	411.22	411.1	411.1316	13360.0
2023-12-28 18:00:00	QQQ	ETF	411.17	411.5	411.1	411.5	26924.0
2023-12-28 19:00:00	QQQ	ETF	411.44	411.68	411.4	411.68	50412.0
2023-12-28 04:00:00	IWM	ETF	204.98	205.03	204.75	204.75	19466.0
2023-12-28 05:00:00	IWM	ETF	204.89	204.94	204.6	204.6	7055.0
2023-12-28 06:00:00	IWM	ETF	204.65	204.65	204.25	204.39	18488.0
2023-12-28 07:00:00	IWM	ETF	204.37	204.57	204.32	204.47	98613.0
2023-12-28 08:00:00	IWM	ETF	204.32	205.56	203.82	203.82	324049.0
2023-12-28 09:00:00	IWM	ETF	203.88	204.82	203.44	204.5905	3215634.0
2023-12-28 10:00:00	IWM	ETF	204.59	205.165	204.22	204.37	3097042.0
2023-12-28 11:00:00	IWM	ETF	204.37	204.46	203.86	204.035	2669988.0
2023-12-28 12:00:00	IWM	ETF	204.04	204.48	203.955	204.01	1469324.0
2023-12-28 13:00:00	IWM	ETF	204.01	204.06	203.28	203.59	2807319.0
2023-12-28 14:00:00	IWM	ETF	203.59	203.98	203.5297	203.57	1669287.0
2023-12-28 15:00:00	IWM	ETF	203.58	204.03	203.38	203.98	4114748.0
2023-12-28 16:00:00	IWM	ETF	204.04	204.13	203.8	204.09	1148427.0
2023-12-28 17:00:00	IWM	ETF	204.07	204.09	204.03	204.09	5127.0
2023-12-28 18:00:00	IWM	ETF	204.05	204.15	204.05	204.09	7052.0
2023-12-28 19:00:00	IWM	ETF	204.14	204.15	204.05	204.15	19062.0
2023-12-28 04:00:00	DIA	ETF	376.4	376.41	376.25	376.41	6114.0
2023-12-28 05:00:00	DIA	ETF	376.39	376.5	376.22	376.22	1735.0

> showing 50 of 19,485 rows — these rows as CSV

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