PREVIEW / etf_1hour / 2023-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-28.parquet
  size:    472 KB
  rows:    17,269

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-06-28 04:00:00	SPY	ETF	435.52	435.74	435.09	435.2	24526.0
2023-06-28 05:00:00	SPY	ETF	435.2	435.47	435.13	435.39	14484.0
2023-06-28 06:00:00	SPY	ETF	435.41	435.79	435.38	435.64	13885.0
2023-06-28 07:00:00	SPY	ETF	435.66	436.08	435.43	435.43	83008.0
2023-06-28 08:00:00	SPY	ETF	435.6611	436.0496	435.05	435.24	343247.0
2023-06-28 09:00:00	SPY	ETF	435.24	435.35	434.41	435.2	6684926.0
2023-06-28 10:00:00	SPY	ETF	435.19	436.47	434.44	435.8788	8998441.0
2023-06-28 11:00:00	SPY	ETF	435.87	436.73	435.39	436.625	5960030.0
2023-06-28 12:00:00	SPY	ETF	436.62	437.44	434.56	435.17	8686839.0
2023-06-28 13:00:00	SPY	ETF	435.14	435.97	434.67	435.38	5334951.0
2023-06-28 14:00:00	SPY	ETF	435.3901	436.04	435.28	435.525	4354441.0
2023-06-28 15:00:00	SPY	ETF	435.525	436.43	434.59	436.38	14604335.0
2023-06-28 16:00:00	SPY	ETF	436.38	436.9	435.4557	436.59	4208314.0
2023-06-28 17:00:00	SPY	ETF	436.67	436.79	436.63	436.74	48847.0
2023-06-28 18:00:00	SPY	ETF	436.74	437.31	436.72	437.13	95649.0
2023-06-28 19:00:00	SPY	ETF	437.12	437.17	436.94	436.95	76487.0
2023-06-28 04:00:00	QQQ	ETF	362.8	362.93	361.9	361.99	35751.0
2023-06-28 05:00:00	QQQ	ETF	362.12	362.33	361.79	362.33	40435.0
2023-06-28 06:00:00	QQQ	ETF	362.3	362.82	362.26	362.82	60042.0
2023-06-28 07:00:00	QQQ	ETF	362.82	363.41	362.41	362.46	230037.0
2023-06-28 08:00:00	QQQ	ETF	362.84	364.102	361.9896	362.38	319940.0
2023-06-28 09:00:00	QQQ	ETF	362.38	363.89	361.9038	363.48	5651533.0
2023-06-28 10:00:00	QQQ	ETF	363.46	366.22	362.31	365.53	6066613.0
2023-06-28 11:00:00	QQQ	ETF	365.53	365.94	364.02	365.6809	4297230.0
2023-06-28 12:00:00	QQQ	ETF	365.67	366.52	362.6901	363.37	5727009.0
2023-06-28 13:00:00	QQQ	ETF	363.36	364.56	362.86	363.81	4513494.0
2023-06-28 14:00:00	QQQ	ETF	363.8199	364.83	363.7	364.2	2923314.0
2023-06-28 15:00:00	QQQ	ETF	364.22	364.59	362.82	364.58	6595626.0
2023-06-28 16:00:00	QQQ	ETF	364.58	365.51	364.45	364.99	1345828.0
2023-06-28 17:00:00	QQQ	ETF	364.97	365.17	364.97	365.15	49551.0
2023-06-28 18:00:00	QQQ	ETF	365.1	365.68	365.01	365.6	59559.0
2023-06-28 19:00:00	QQQ	ETF	365.62	365.63	365.37	365.4	41800.0
2023-06-28 04:00:00	IWM	ETF	183.25	183.61	183.13	183.15	11375.0
2023-06-28 05:00:00	IWM	ETF	183.18	183.34	183.17	183.17	6921.0
2023-06-28 06:00:00	IWM	ETF	183.35	183.48	183.15	183.2	3791.0
2023-06-28 07:00:00	IWM	ETF	183.22	183.36	183.0	183.0	18669.0
2023-06-28 08:00:00	IWM	ETF	183.3695	183.3695	182.94	183.05	153579.0
2023-06-28 09:00:00	IWM	ETF	183.06	183.45	182.12	183.435	3557504.0
2023-06-28 10:00:00	IWM	ETF	183.45	183.87	182.91	183.07	3666135.0
2023-06-28 11:00:00	IWM	ETF	183.06	184.14	183.05	183.87	2498520.0
2023-06-28 12:00:00	IWM	ETF	183.86	184.42	183.205	183.46	2729515.0
2023-06-28 13:00:00	IWM	ETF	183.46	183.95	183.26	183.7799	1336021.0
2023-06-28 14:00:00	IWM	ETF	183.77	184.18	183.72	183.895	1453739.0
2023-06-28 15:00:00	IWM	ETF	183.9	184.3	183.53	184.3	2993901.0
2023-06-28 16:00:00	IWM	ETF	184.26	184.58	184.26	184.4	653193.0
2023-06-28 17:00:00	IWM	ETF	184.4	184.55	184.36	184.5	21378.0
2023-06-28 18:00:00	IWM	ETF	184.46	184.87	184.45	184.77	18419.0
2023-06-28 19:00:00	IWM	ETF	184.74	184.84	184.69	184.74	19976.0
2023-06-28 04:00:00	DIA	ETF	339.31	339.39	339.31	339.39	1930.0
2023-06-28 05:00:00	DIA	ETF	339.21	339.27	339.21	339.23	2460.0

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

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