PREVIEW / etf_1hour / 2023-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-08.parquet
  size:    460 KB
  rows:    16,726

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-08 04:00:00	SPY	ETF	398.74	398.82	398.06	398.72	65699.0
2023-03-08 05:00:00	SPY	ETF	398.79	399.05	398.58	399.04	16148.0
2023-03-08 06:00:00	SPY	ETF	399.01	399.41	398.75	398.78	51723.0
2023-03-08 07:00:00	SPY	ETF	398.78	398.87	397.64	398.23	181325.0
2023-03-08 08:00:00	SPY	ETF	398.22	399.095	397.66	398.49	493875.0
2023-03-08 09:00:00	SPY	ETF	398.48	399.1	397.94	398.745	5551962.0
2023-03-08 10:00:00	SPY	ETF	398.74	399.69	396.83	398.3692	11799769.0
2023-03-08 11:00:00	SPY	ETF	398.37	399.71	397.72	399.315	7930415.0
2023-03-08 12:00:00	SPY	ETF	399.33	399.495	397.22	397.95	7737091.0
2023-03-08 13:00:00	SPY	ETF	397.955	398.17	396.59	397.0099	7361758.0
2023-03-08 14:00:00	SPY	ETF	396.9915	398.01	396.91	397.3299	5580970.0
2023-03-08 15:00:00	SPY	ETF	397.33	399.16	396.95	398.92	11324606.0
2023-03-08 16:00:00	SPY	ETF	398.92	399.2	398.76	399.16	2782793.0
2023-03-08 17:00:00	SPY	ETF	399.14	399.3	399.14	399.2	91309.0
2023-03-08 18:00:00	SPY	ETF	399.19	399.19	398.8	398.88	106233.0
2023-03-08 19:00:00	SPY	ETF	398.85	398.89	397.91	398.64	131085.0
2023-03-08 04:00:00	QQQ	ETF	297.35	297.35	296.19	296.7	77187.0
2023-03-08 05:00:00	QQQ	ETF	296.7	297.06	296.47	297.02	47692.0
2023-03-08 06:00:00	QQQ	ETF	297.1	297.53	296.88	296.9	51151.0
2023-03-08 07:00:00	QQQ	ETF	296.86	297.02	295.95	296.36	179844.0
2023-03-08 08:00:00	QQQ	ETF	296.86	297.0696	295.82	296.57	568280.0
2023-03-08 09:00:00	QQQ	ETF	296.57	297.49	296.02	296.57	4241050.0
2023-03-08 10:00:00	QQQ	ETF	296.56	297.68	294.88	296.8899	9140857.0
2023-03-08 11:00:00	QQQ	ETF	296.89	298.43	296.24	298.2	5095529.0
2023-03-08 12:00:00	QQQ	ETF	298.2	298.37	296.171	296.925	4318376.0
2023-03-08 13:00:00	QQQ	ETF	296.96	297.13	295.72	296.04	4540803.0
2023-03-08 14:00:00	QQQ	ETF	296.05	297.32	295.95	296.635	3721401.0
2023-03-08 15:00:00	QQQ	ETF	296.64	298.24	296.12	297.88	6902856.0
2023-03-08 16:00:00	QQQ	ETF	297.87	298.06	297.6	298.03	1314017.0
2023-03-08 17:00:00	QQQ	ETF	298.04	298.12	297.82	298.09	52124.0
2023-03-08 18:00:00	QQQ	ETF	298.05	298.05	297.7	297.77	133128.0
2023-03-08 19:00:00	QQQ	ETF	297.73	297.74	296.85	297.42	160351.0
2023-03-08 04:00:00	IWM	ETF	186.85	186.91	186.7	186.9	2977.0
2023-03-08 05:00:00	IWM	ETF	187.04	187.11	186.9	187.09	8437.0
2023-03-08 06:00:00	IWM	ETF	187.07	187.25	186.97	187.0	12495.0
2023-03-08 07:00:00	IWM	ETF	187.0	187.0	186.51	186.75	89103.0
2023-03-08 08:00:00	IWM	ETF	186.57	187.26	186.57	187.07	56103.0
2023-03-08 09:00:00	IWM	ETF	187.12	187.13	185.93	186.92	2395829.0
2023-03-08 10:00:00	IWM	ETF	186.92	187.61	186.03	186.8	3706037.0
2023-03-08 11:00:00	IWM	ETF	186.81	187.25	186.2	186.81	1950905.0
2023-03-08 12:00:00	IWM	ETF	186.82	186.9299	185.52	185.835	2169622.0
2023-03-08 13:00:00	IWM	ETF	185.84	185.98	185.12	185.32	2145442.0
2023-03-08 14:00:00	IWM	ETF	185.32	185.84	185.3	185.53	1185386.0
2023-03-08 15:00:00	IWM	ETF	185.53	186.69	185.4	186.61	2884666.0
2023-03-08 16:00:00	IWM	ETF	186.6	186.7	186.5	186.7	1136655.0
2023-03-08 17:00:00	IWM	ETF	186.56	186.79	186.56	186.79	2576.0
2023-03-08 18:00:00	IWM	ETF	186.62	186.75	186.56	186.59	15871.0
2023-03-08 19:00:00	IWM	ETF	186.61	186.73	186.27	186.58	34201.0
2023-03-08 07:00:00	DIA	ETF	329.11	329.12	328.5	328.76	5950.0
2023-03-08 08:00:00	DIA	ETF	328.5104	329.36	328.5104	329.01	16217.0

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

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