PREVIEW / etf_1hour / 2023-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-23.parquet
  size:    467 KB
  rows:    16,844

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-02-23 04:00:00	SPY	ETF	400.53	401.0	399.82	400.2	21772.0
2023-02-23 05:00:00	SPY	ETF	400.27	400.38	399.96	400.25	25659.0
2023-02-23 06:00:00	SPY	ETF	400.48	400.72	399.98	400.72	221660.0
2023-02-23 07:00:00	SPY	ETF	400.7	400.87	400.4	400.691	462470.0
2023-02-23 08:00:00	SPY	ETF	400.55	401.24	399.85	400.64	937805.0
2023-02-23 09:00:00	SPY	ETF	400.55	402.2	400.47	401.815	10609130.0
2023-02-23 10:00:00	SPY	ETF	401.82	402.18	398.85	399.17	11281289.0
2023-02-23 11:00:00	SPY	ETF	399.16	399.65	396.4	396.47	12597030.0
2023-02-23 12:00:00	SPY	ETF	396.47	397.63	396.25	397.57	7876290.0
2023-02-23 13:00:00	SPY	ETF	397.5899	398.42	397.03	398.195	6418672.0
2023-02-23 14:00:00	SPY	ETF	398.19	400.62	397.89	400.12	10985282.0
2023-02-23 15:00:00	SPY	ETF	400.12	401.62	400.115	400.65	14990978.0
2023-02-23 16:00:00	SPY	ETF	400.64	400.76	400.24	400.32	3040901.0
2023-02-23 17:00:00	SPY	ETF	400.36	400.55	400.35	400.43	107745.0
2023-02-23 18:00:00	SPY	ETF	400.42	400.42	399.95	400.0	147158.0
2023-02-23 19:00:00	SPY	ETF	400.0	400.65	399.89	400.57	209215.0
2023-02-23 04:00:00	QQQ	ETF	296.6	297.25	295.55	296.16	87170.0
2023-02-23 05:00:00	QQQ	ETF	296.2	296.43	296.14	296.43	16443.0
2023-02-23 06:00:00	QQQ	ETF	296.46	296.92	296.24	296.78	111779.0
2023-02-23 07:00:00	QQQ	ETF	296.88	297.18	296.61	297.06	349808.0
2023-02-23 08:00:00	QQQ	ETF	297.03	297.55	296.1996	297.23	846688.0
2023-02-23 09:00:00	QQQ	ETF	297.21	298.15	296.62	297.46	7579573.0
2023-02-23 10:00:00	QQQ	ETF	297.48	297.83	294.33	294.6006	9062829.0
2023-02-23 11:00:00	QQQ	ETF	294.57	295.1205	292.59	292.634	7766770.0
2023-02-23 12:00:00	QQQ	ETF	292.65	293.87	292.55	293.79	5174686.0
2023-02-23 13:00:00	QQQ	ETF	293.8	294.88	293.22	294.67	5053488.0
2023-02-23 14:00:00	QQQ	ETF	294.67	297.03	294.39	296.44	8380696.0
2023-02-23 15:00:00	QQQ	ETF	296.47	297.88	296.469	296.83	8794858.0
2023-02-23 16:00:00	QQQ	ETF	296.85	296.95	296.4	296.5	1329262.0
2023-02-23 17:00:00	QQQ	ETF	296.48	296.6	296.44	296.45	25253.0
2023-02-23 18:00:00	QQQ	ETF	296.45	296.46	296.01	296.05	88635.0
2023-02-23 19:00:00	QQQ	ETF	296.07	296.62	296.0	296.52	130375.0
2023-02-23 04:00:00	IWM	ETF	188.86	189.06	188.53	188.63	12670.0
2023-02-23 05:00:00	IWM	ETF	188.72	188.75	188.55	188.55	3830.0
2023-02-23 06:00:00	IWM	ETF	188.8	188.85	188.51	188.82	30829.0
2023-02-23 07:00:00	IWM	ETF	188.82	188.95	188.66	188.74	31580.0
2023-02-23 08:00:00	IWM	ETF	188.85	189.0	188.25	188.58	56414.0
2023-02-23 09:00:00	IWM	ETF	188.55	190.3	188.51	189.89	2619074.0
2023-02-23 10:00:00	IWM	ETF	189.91	190.17	187.88	188.25	2516765.0
2023-02-23 11:00:00	IWM	ETF	188.23	188.6359	186.99	187.02	2224656.0
2023-02-23 12:00:00	IWM	ETF	187.02	187.465	186.7	187.41	1737123.0
2023-02-23 13:00:00	IWM	ETF	187.42	187.9	187.13	187.7891	1656292.0
2023-02-23 14:00:00	IWM	ETF	187.775	189.13	187.65	188.87	1783226.0
2023-02-23 15:00:00	IWM	ETF	188.9	189.745	188.89	189.32	3151432.0
2023-02-23 16:00:00	IWM	ETF	189.32	189.41	189.11	189.25	923426.0
2023-02-23 17:00:00	IWM	ETF	189.35	189.35	189.19	189.26	7018.0
2023-02-23 18:00:00	IWM	ETF	189.26	189.28	189.04	189.13	26960.0
2023-02-23 19:00:00	IWM	ETF	189.1	189.45	189.1	189.39	24463.0
2023-02-23 06:00:00	DIA	ETF	331.42	331.42	331.42	331.42	100.0
2023-02-23 07:00:00	DIA	ETF	331.67	331.67	331.49	331.53	1034.0

> showing 50 of 16,844 rows — these rows as CSV

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