PREVIEW / etf_1hour / 2022-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-07.parquet
  size:    453 KB
  rows:    16,136

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
2022-02-07 04:00:00	SPY	ETF	448.37	448.8	447.0	447.55	18314.0
2022-02-07 05:00:00	SPY	ETF	448.04	448.25	447.53	447.53	73817.0
2022-02-07 06:00:00	SPY	ETF	447.59	448.62	447.33	448.5	81858.0
2022-02-07 07:00:00	SPY	ETF	448.34	449.82	448.34	449.52	218943.0
2022-02-07 08:00:00	SPY	ETF	449.5	450.35	447.25	449.81	482271.0
2022-02-07 09:00:00	SPY	ETF	449.79	450.41	448.21	449.93	8214625.0
2022-02-07 10:00:00	SPY	ETF	449.93	450.86	448.48	449.79	8434566.0
2022-02-07 11:00:00	SPY	ETF	449.79	450.09	447.11	448.19	8103740.0
2022-02-07 12:00:00	SPY	ETF	448.19	448.24	446.765	447.6201	5862909.0
2022-02-07 13:00:00	SPY	ETF	447.63	449.61	447.44	449.42	5390565.0
2022-02-07 14:00:00	SPY	ETF	449.43	450.46	448.84	449.93	5630783.0
2022-02-07 15:00:00	SPY	ETF	449.9	450.99	445.85	447.23	19481422.0
2022-02-07 16:00:00	SPY	ETF	447.23	448.08	447.1226	447.95	4041419.0
2022-02-07 17:00:00	SPY	ETF	447.96	448.13	447.87	448.05	63138.0
2022-02-07 18:00:00	SPY	ETF	448.05	448.3	447.26	448.25	175052.0
2022-02-07 19:00:00	SPY	ETF	448.3	448.4	447.75	448.13	53999.0
2022-02-07 04:00:00	QQQ	ETF	357.0	358.09	356.64	357.5	56085.0
2022-02-07 05:00:00	QQQ	ETF	357.46	358.01	357.25	357.3	109298.0
2022-02-07 06:00:00	QQQ	ETF	357.45	358.3	357.15	358.0	51110.0
2022-02-07 07:00:00	QQQ	ETF	357.95	359.36	357.95	359.1	497639.0
2022-02-07 08:00:00	QQQ	ETF	359.1	359.91	356.82	359.15	445225.0
2022-02-07 09:00:00	QQQ	ETF	359.21	361.05	357.74	360.42	6814863.0
2022-02-07 10:00:00	QQQ	ETF	360.46	360.65	358.15	359.02	6991465.0
2022-02-07 11:00:00	QQQ	ETF	359.01	359.53	355.28	356.3001	6685791.0
2022-02-07 12:00:00	QQQ	ETF	356.28	356.85	354.95	355.92	4568386.0
2022-02-07 13:00:00	QQQ	ETF	355.88	357.84	355.67	357.65	3673115.0
2022-02-07 14:00:00	QQQ	ETF	357.67	358.6	356.8	357.9192	3661427.0
2022-02-07 15:00:00	QQQ	ETF	357.91	359.065	353.84	355.17	10420762.0
2022-02-07 16:00:00	QQQ	ETF	355.17	356.17	355.13	356.01	1062505.0
2022-02-07 17:00:00	QQQ	ETF	356.0	356.2	355.75	355.92	61943.0
2022-02-07 18:00:00	QQQ	ETF	355.97	356.35	355.67	356.28	260891.0
2022-02-07 19:00:00	QQQ	ETF	356.3	356.55	355.76	356.14	91133.0
2022-02-07 04:00:00	IWM	ETF	197.74	197.89	196.88	197.37	22355.0
2022-02-07 05:00:00	IWM	ETF	197.4	197.78	197.21	197.28	75821.0
2022-02-07 06:00:00	IWM	ETF	197.22	197.84	196.99	197.8	134561.0
2022-02-07 07:00:00	IWM	ETF	197.8	198.65	197.79	198.41	44769.0
2022-02-07 08:00:00	IWM	ETF	198.42	198.99	197.43	198.79	102074.0
2022-02-07 09:00:00	IWM	ETF	198.82	200.68	198.03	200.61	3368338.0
2022-02-07 10:00:00	IWM	ETF	200.63	200.709	198.87	200.1	3087360.0
2022-02-07 11:00:00	IWM	ETF	200.09	200.33	197.99	198.82	2625417.0
2022-02-07 12:00:00	IWM	ETF	198.81	199.46	198.37	199.18	1808578.0
2022-02-07 13:00:00	IWM	ETF	199.16	200.22	199.07	200.13	1472815.0
2022-02-07 14:00:00	IWM	ETF	200.13	200.83	199.84	200.66	1703715.0
2022-02-07 15:00:00	IWM	ETF	200.65	201.16	199.07	199.48	5493023.0
2022-02-07 16:00:00	IWM	ETF	199.36	199.92	199.36	199.74	3147933.0
2022-02-07 17:00:00	IWM	ETF	199.68	199.8	199.36	199.8	68178.0
2022-02-07 18:00:00	IWM	ETF	199.72	199.8	199.6	199.79	14006.0
2022-02-07 19:00:00	IWM	ETF	199.8	199.93	199.55	199.76	47558.0
2022-02-07 04:00:00	DIA	ETF	350.63	350.63	349.68	349.68	1444.0
2022-02-07 05:00:00	DIA	ETF	349.96	349.98	349.95	349.98	2000.0

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

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