PREVIEW / etf_1hour / 2023-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-01.parquet
  size:    461 KB
  rows:    17,073

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-03-01 04:00:00	SPY	ETF	397.38	397.97	396.52	397.48	70305.0
2023-03-01 05:00:00	SPY	ETF	397.5	397.89	397.28	397.86	37159.0
2023-03-01 06:00:00	SPY	ETF	397.78	398.08	397.68	397.79	83206.0
2023-03-01 07:00:00	SPY	ETF	397.73	397.73	397.23	397.56	365489.0
2023-03-01 08:00:00	SPY	ETF	397.5183	398.0496	395.37	395.42	5573282.0
2023-03-01 09:00:00	SPY	ETF	395.41	396.69	395.03	396.08	9181183.0
2023-03-01 10:00:00	SPY	ETF	396.11	396.58	394.03	395.849	15681566.0
2023-03-01 11:00:00	SPY	ETF	395.845	396.13	393.38	395.735	12444774.0
2023-03-01 12:00:00	SPY	ETF	395.74	396.44	395.44	395.619	6904170.0
2023-03-01 13:00:00	SPY	ETF	395.62	395.6307	394.304	394.8076	6271397.0
2023-03-01 14:00:00	SPY	ETF	394.7901	394.95	393.64	394.06	7082595.0
2023-03-01 15:00:00	SPY	ETF	394.07	395.18	393.97	394.78	12743022.0
2023-03-01 16:00:00	SPY	ETF	394.78	395.3	394.5	395.16	3162292.0
2023-03-01 17:00:00	SPY	ETF	395.16	395.18	394.76	394.9	116069.0
2023-03-01 18:00:00	SPY	ETF	394.95	395.07	394.83	395.0	101714.0
2023-03-01 19:00:00	SPY	ETF	395.17	395.56	394.53	394.53	154459.0
2023-03-01 04:00:00	QQQ	ETF	294.52	295.05	294.42	294.86	90970.0
2023-03-01 05:00:00	QQQ	ETF	294.78	295.28	294.53	295.19	53418.0
2023-03-01 06:00:00	QQQ	ETF	295.13	295.38	295.0	295.11	79149.0
2023-03-01 07:00:00	QQQ	ETF	295.08	295.12	294.55	294.8	288785.0
2023-03-01 08:00:00	QQQ	ETF	294.94	295.2896	292.92	292.93	810898.0
2023-03-01 09:00:00	QQQ	ETF	292.92	293.93	292.1	293.25	6624898.0
2023-03-01 10:00:00	QQQ	ETF	293.29	293.65	290.89	292.2	10392543.0
2023-03-01 11:00:00	QQQ	ETF	292.19	292.51	290.2	292.195	8004356.0
2023-03-01 12:00:00	QQQ	ETF	292.22	292.87	291.84	292.1404	4451138.0
2023-03-01 13:00:00	QQQ	ETF	292.14	292.1699	291.01	291.45	3232967.0
2023-03-01 14:00:00	QQQ	ETF	291.46	291.58	290.45	290.8099	3446010.0
2023-03-01 15:00:00	QQQ	ETF	290.81	291.44	290.57	291.15	6678563.0
2023-03-01 16:00:00	QQQ	ETF	291.13	291.85	290.94	291.66	1481948.0
2023-03-01 17:00:00	QQQ	ETF	291.66	291.72	291.0	291.2	144819.0
2023-03-01 18:00:00	QQQ	ETF	291.24	291.41	291.15	291.36	133194.0
2023-03-01 19:00:00	QQQ	ETF	291.3	291.75	290.69	290.72	163660.0
2023-03-01 04:00:00	IWM	ETF	189.36	189.36	188.96	189.08	14009.0
2023-03-01 05:00:00	IWM	ETF	189.04	189.2	188.91	189.2	12363.0
2023-03-01 06:00:00	IWM	ETF	189.2	189.4	189.18	189.2	55863.0
2023-03-01 07:00:00	IWM	ETF	189.16	189.16	188.92	189.03	20496.0
2023-03-01 08:00:00	IWM	ETF	189.2704	189.2704	187.89	188.02	84941.0
2023-03-01 09:00:00	IWM	ETF	187.92	189.49	187.68	188.95	2797058.0
2023-03-01 10:00:00	IWM	ETF	188.95	189.21	187.58	188.8	3697986.0
2023-03-01 11:00:00	IWM	ETF	188.82	188.82	187.19	188.41	2713106.0
2023-03-01 12:00:00	IWM	ETF	188.42	188.92	188.32	188.57	1525015.0
2023-03-01 13:00:00	IWM	ETF	188.6	188.6001	187.79	188.0546	1333678.0
2023-03-01 14:00:00	IWM	ETF	188.06	188.2	187.48	187.64	1313268.0
2023-03-01 15:00:00	IWM	ETF	187.65	188.55	187.595	188.46	2799421.0
2023-03-01 16:00:00	IWM	ETF	188.42	188.67	188.28	188.66	852172.0
2023-03-01 17:00:00	IWM	ETF	188.53	188.63	188.42	188.48	105763.0
2023-03-01 18:00:00	IWM	ETF	188.49	188.54	188.44	188.54	40998.0
2023-03-01 19:00:00	IWM	ETF	188.55	188.83	188.36	188.36	48172.0
2023-03-01 04:00:00	DIA	ETF	326.57	327.66	326.57	327.66	500.0
2023-03-01 05:00:00	DIA	ETF	327.53	327.53	327.53	327.53	140.0

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

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