PREVIEW / etf_1hour / 2023-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-06.parquet
  size:    487 KB
  rows:    17,679

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-07-06 04:00:00	SPY	ETF	441.5	441.74	441.24	441.45	24924.0
2023-07-06 05:00:00	SPY	ETF	441.28	441.59	441.18	441.53	32555.0
2023-07-06 06:00:00	SPY	ETF	441.42	441.64	441.32	441.38	33360.0
2023-07-06 07:00:00	SPY	ETF	441.43	441.75	441.15	441.16	385581.0
2023-07-06 08:00:00	SPY	ETF	441.4695	442.0	439.28	439.71	1217648.0
2023-07-06 09:00:00	SPY	ETF	439.68	441.8	438.04	438.49	8739588.0
2023-07-06 10:00:00	SPY	ETF	438.51	438.53	437.13	437.2	11825291.0
2023-07-06 11:00:00	SPY	ETF	437.2	438.22	437.06	438.1	7762452.0
2023-07-06 12:00:00	SPY	ETF	438.115	439.24	438.105	439.19	5988160.0
2023-07-06 13:00:00	SPY	ETF	439.19	439.76	438.995	439.72	5803110.0
2023-07-06 14:00:00	SPY	ETF	439.73	440.1	439.24	440.04	4651095.0
2023-07-06 15:00:00	SPY	ETF	440.04	440.08	439.47	439.67	12007556.0
2023-07-06 16:00:00	SPY	ETF	439.68	439.89	439.42	439.51	2302800.0
2023-07-06 17:00:00	SPY	ETF	439.5	439.57	439.4	439.43	46615.0
2023-07-06 18:00:00	SPY	ETF	439.41	439.63	439.25	439.5	65309.0
2023-07-06 19:00:00	SPY	ETF	439.56	439.72	439.49	439.49	33068.0
2023-07-06 04:00:00	QQQ	ETF	368.46	369.1	368.46	368.91	43600.0
2023-07-06 05:00:00	QQQ	ETF	368.85	369.14	368.56	369.08	29567.0
2023-07-06 06:00:00	QQQ	ETF	369.03	369.12	368.58	368.6	40606.0
2023-07-06 07:00:00	QQQ	ETF	368.67	369.15	368.64	368.79	160350.0
2023-07-06 08:00:00	QQQ	ETF	368.8691	370.557	365.8	366.46	1255764.0
2023-07-06 09:00:00	QQQ	ETF	366.41	366.96	364.94	365.66	8117356.0
2023-07-06 10:00:00	QQQ	ETF	365.68	366.07	364.52	364.8099	6826044.0
2023-07-06 11:00:00	QQQ	ETF	364.82	366.06	364.57	365.67	4861715.0
2023-07-06 12:00:00	QQQ	ETF	365.68	367.13	365.6507	367.0399	3613878.0
2023-07-06 13:00:00	QQQ	ETF	367.04	367.565	366.44	367.565	3407228.0
2023-07-06 14:00:00	QQQ	ETF	367.57	367.91	366.93	367.8102	2848598.0
2023-07-06 15:00:00	QQQ	ETF	367.8299	367.89	367.17	367.475	5339538.0
2023-07-06 16:00:00	QQQ	ETF	367.48	367.65	367.0309	367.17	1309769.0
2023-07-06 17:00:00	QQQ	ETF	367.18	367.2	367.12	367.16	19221.0
2023-07-06 18:00:00	QQQ	ETF	367.1	367.29	367.0	367.23	37966.0
2023-07-06 19:00:00	QQQ	ETF	367.21	367.48	367.21	367.26	55558.0
2023-07-06 04:00:00	IWM	ETF	184.59	184.68	184.28	184.51	16288.0
2023-07-06 05:00:00	IWM	ETF	184.36	184.58	184.3	184.51	3209.0
2023-07-06 06:00:00	IWM	ETF	184.41	184.6	184.36	184.47	12651.0
2023-07-06 07:00:00	IWM	ETF	184.48	184.75	184.37	184.38	88665.0
2023-07-06 08:00:00	IWM	ETF	184.5	185.1	183.44	183.8	528527.0
2023-07-06 09:00:00	IWM	ETF	183.75	184.2207	182.42	182.83	4395206.0
2023-07-06 10:00:00	IWM	ETF	182.83	182.88	180.841	180.96	6195071.0
2023-07-06 11:00:00	IWM	ETF	180.96	181.57	180.72	181.55	3972817.0
2023-07-06 12:00:00	IWM	ETF	181.56	182.11	181.39	182.09	2886888.0
2023-07-06 13:00:00	IWM	ETF	182.09	182.6242	181.99	182.52	2316434.0
2023-07-06 14:00:00	IWM	ETF	182.52	182.92	182.16	182.865	1704247.0
2023-07-06 15:00:00	IWM	ETF	182.87	182.885	182.26	182.77	4063105.0
2023-07-06 16:00:00	IWM	ETF	182.78	182.86	182.49	182.61	1167494.0
2023-07-06 17:00:00	IWM	ETF	182.59	182.63	182.46	182.52	4680.0
2023-07-06 18:00:00	IWM	ETF	182.5	182.7	182.5	182.61	13845.0
2023-07-06 19:00:00	IWM	ETF	182.6	182.7	182.56	182.56	19511.0
2023-07-06 04:00:00	DIA	ETF	341.55	341.64	341.35	341.64	2836.0
2023-07-06 06:00:00	DIA	ETF	341.63	341.63	341.63	341.63	400.0

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

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