PREVIEW / etf_1hour / 2023-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-30.parquet
  size:    483 KB
  rows:    17,549

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-30 04:00:00	SPY	ETF	438.65	439.28	438.35	439.28	49291.0
2023-06-30 05:00:00	SPY	ETF	439.35	439.73	439.23	439.63	35212.0
2023-06-30 06:00:00	SPY	ETF	439.56	440.24	439.55	440.01	57439.0
2023-06-30 07:00:00	SPY	ETF	439.97	440.12	439.67	439.79	160952.0
2023-06-30 08:00:00	SPY	ETF	439.9514	441.22	438.36	441.06	835798.0
2023-06-30 09:00:00	SPY	ETF	441.08	442.6695	441.06	442.32	8814008.0
2023-06-30 10:00:00	SPY	ETF	442.34	443.36	442.04	442.655	13005501.0
2023-06-30 11:00:00	SPY	ETF	442.66	443.12	442.01	442.46	7090332.0
2023-06-30 12:00:00	SPY	ETF	442.46	443.61	442.22	443.49	6418629.0
2023-06-30 13:00:00	SPY	ETF	443.5	443.95	443.26	443.8	6192859.0
2023-06-30 14:00:00	SPY	ETF	443.8	444.13	443.61	443.88	5723936.0
2023-06-30 15:00:00	SPY	ETF	443.88	444.3	443.18	443.25	19808329.0
2023-06-30 16:00:00	SPY	ETF	443.24	443.4351	442.67	442.85	6244330.0
2023-06-30 17:00:00	SPY	ETF	442.95	443.4351	442.7	442.85	873068.0
2023-06-30 18:00:00	SPY	ETF	442.81	442.86	442.71	442.84	25060.0
2023-06-30 19:00:00	SPY	ETF	442.9	442.94	442.4	442.81	24401.0
2023-06-30 04:00:00	QQQ	ETF	364.95	365.55	364.94	365.47	38561.0
2023-06-30 05:00:00	QQQ	ETF	365.45	365.83	365.43	365.63	28307.0
2023-06-30 06:00:00	QQQ	ETF	365.6	365.93	365.48	365.7	26812.0
2023-06-30 07:00:00	QQQ	ETF	365.69	365.94	365.55	365.66	114712.0
2023-06-30 08:00:00	QQQ	ETF	365.7204	367.73	364.62	367.18	1295971.0
2023-06-30 09:00:00	QQQ	ETF	367.18	369.41	367.16	369.05	6969104.0
2023-06-30 10:00:00	QQQ	ETF	369.09	370.49	368.95	369.47	8337428.0
2023-06-30 11:00:00	QQQ	ETF	369.47	370.06	368.3	368.97	5874124.0
2023-06-30 12:00:00	QQQ	ETF	368.98	370.1	368.7505	370.01	3470498.0
2023-06-30 13:00:00	QQQ	ETF	370.0164	370.1399	369.61	370.0201	2940801.0
2023-06-30 14:00:00	QQQ	ETF	370.03	370.21	369.53	369.805	2838678.0
2023-06-30 15:00:00	QQQ	ETF	369.81	370.36	369.39	369.42	7792113.0
2023-06-30 16:00:00	QQQ	ETF	369.44	369.6021	368.9	369.11	2053428.0
2023-06-30 17:00:00	QQQ	ETF	369.14	369.42	369.07	369.11	167102.0
2023-06-30 18:00:00	QQQ	ETF	369.14	369.19	369.11	369.12	7353.0
2023-06-30 19:00:00	QQQ	ETF	369.19	369.7	369.15	369.25	27707.0
2023-06-30 04:00:00	IWM	ETF	186.8	187.31	186.8	187.31	11472.0
2023-06-30 05:00:00	IWM	ETF	187.3	187.64	187.3	187.62	20196.0
2023-06-30 06:00:00	IWM	ETF	187.54	188.13	187.54	187.95	37465.0
2023-06-30 07:00:00	IWM	ETF	187.95	188.0	187.62	187.7	35644.0
2023-06-30 08:00:00	IWM	ETF	187.6	188.27	187.6	187.92	301012.0
2023-06-30 09:00:00	IWM	ETF	187.92	188.37	187.28	187.92	3211088.0
2023-06-30 10:00:00	IWM	ETF	187.93	188.19	186.91	187.4	4031052.0
2023-06-30 11:00:00	IWM	ETF	187.42	187.69	187.25	187.56	2764254.0
2023-06-30 12:00:00	IWM	ETF	187.56	188.4341	187.47	188.22	2555876.0
2023-06-30 13:00:00	IWM	ETF	188.215	188.33	187.97	188.02	1183399.0
2023-06-30 14:00:00	IWM	ETF	188.03	188.275	187.93	188.035	1921404.0
2023-06-30 15:00:00	IWM	ETF	188.04	188.07	187.15	187.18	5799127.0
2023-06-30 16:00:00	IWM	ETF	187.17	187.3088	186.88	187.11	3300145.0
2023-06-30 17:00:00	IWM	ETF	187.08	187.31	187.08	187.25	260449.0
2023-06-30 18:00:00	IWM	ETF	187.26	187.26	187.19	187.26	2878.0
2023-06-30 19:00:00	IWM	ETF	187.26	187.34	187.14	187.14	7568.0
2023-06-30 04:00:00	DIA	ETF	341.24	341.42	341.2	341.42	6100.0
2023-06-30 05:00:00	DIA	ETF	341.66	341.66	341.66	341.66	160.0

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

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