PREVIEW / etf_1hour / 2023-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-02.parquet
  size:    511 KB
  rows:    18,796

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-11-02 04:00:00	SPY	ETF	423.94	425.0	423.8	424.75	49131.0
2023-11-02 05:00:00	SPY	ETF	424.84	425.23	424.84	424.95	215014.0
2023-11-02 06:00:00	SPY	ETF	424.95	425.06	424.6	425.0	268690.0
2023-11-02 07:00:00	SPY	ETF	424.9	425.41	424.88	425.23	216964.0
2023-11-02 08:00:00	SPY	ETF	424.94	426.98	423.52	426.81	851154.0
2023-11-02 09:00:00	SPY	ETF	426.8	428.03	426.28	427.49	9552662.0
2023-11-02 10:00:00	SPY	ETF	427.49	429.32	426.7601	429.32	10849303.0
2023-11-02 11:00:00	SPY	ETF	429.31	429.34	428.17	428.78	7789167.0
2023-11-02 12:00:00	SPY	ETF	428.77	429.56	428.43	429.12	6033724.0
2023-11-02 13:00:00	SPY	ETF	429.12	430.52	428.92	430.275	8370710.0
2023-11-02 14:00:00	SPY	ETF	430.275	430.47	429.75	430.25	6041046.0
2023-11-02 15:00:00	SPY	ETF	430.25	430.915	430.08	430.75	16936539.0
2023-11-02 16:00:00	SPY	ETF	430.75	431.04	427.5834	430.45	5697324.0
2023-11-02 17:00:00	SPY	ETF	430.47	430.63	429.75	429.75	229467.0
2023-11-02 18:00:00	SPY	ETF	429.83	430.37	429.83	430.04	86534.0
2023-11-02 19:00:00	SPY	ETF	430.02	430.15	429.85	429.91	63004.0
2023-11-02 04:00:00	QQQ	ETF	359.11	359.7	358.79	359.6	83112.0
2023-11-02 05:00:00	QQQ	ETF	359.64	360.1	359.59	359.77	88188.0
2023-11-02 06:00:00	QQQ	ETF	359.8	360.24	359.76	360.1	58703.0
2023-11-02 07:00:00	QQQ	ETF	360.14	360.7	359.97	360.48	207206.0
2023-11-02 08:00:00	QQQ	ETF	360.08	362.33	357.227	362.17	1163045.0
2023-11-02 09:00:00	QQQ	ETF	362.15	362.31	361.05	361.4203	7458781.0
2023-11-02 10:00:00	QQQ	ETF	361.42	362.62	360.3	362.465	7396657.0
2023-11-02 11:00:00	QQQ	ETF	362.48	362.76	361.702	362.02	5449046.0
2023-11-02 12:00:00	QQQ	ETF	362.037	362.71	361.6	362.32	3493913.0
2023-11-02 13:00:00	QQQ	ETF	362.33	363.46	362.09	363.31	3930623.0
2023-11-02 14:00:00	QQQ	ETF	363.31	363.62	362.9	363.42	2744543.0
2023-11-02 15:00:00	QQQ	ETF	363.4124	363.68	363.14	363.44	7112207.0
2023-11-02 16:00:00	QQQ	ETF	363.47	363.87	361.86	362.68	2707119.0
2023-11-02 17:00:00	QQQ	ETF	362.7	363.2	361.43	361.62	700129.0
2023-11-02 18:00:00	QQQ	ETF	361.61	362.42	361.61	362.06	175874.0
2023-11-02 19:00:00	QQQ	ETF	362.12	362.22	361.99	362.03	145914.0
2023-11-02 04:00:00	IWM	ETF	165.77	166.6	165.7	166.5	24920.0
2023-11-02 05:00:00	IWM	ETF	166.59	167.23	166.57	167.23	32949.0
2023-11-02 06:00:00	IWM	ETF	167.19	167.25	166.9	167.24	103400.0
2023-11-02 07:00:00	IWM	ETF	167.2	167.5	167.17	167.31	382436.0
2023-11-02 08:00:00	IWM	ETF	167.16	168.04	165.75	167.93	509105.0
2023-11-02 09:00:00	IWM	ETF	167.93	168.76	167.49	168.335	6382274.0
2023-11-02 10:00:00	IWM	ETF	168.34	168.57	167.325	168.55	5564762.0
2023-11-02 11:00:00	IWM	ETF	168.55	168.6903	168.19	168.27	4471497.0
2023-11-02 12:00:00	IWM	ETF	168.28	168.49	167.725	168.3	3862794.0
2023-11-02 13:00:00	IWM	ETF	168.3	169.145	168.26	169.105	5284018.0
2023-11-02 14:00:00	IWM	ETF	169.1	169.25	168.78	169.245	3493568.0
2023-11-02 15:00:00	IWM	ETF	169.24	170.0	169.16	169.88	7688746.0
2023-11-02 16:00:00	IWM	ETF	169.87	170.14	169.6298	170.1	2583101.0
2023-11-02 17:00:00	IWM	ETF	170.1	170.25	169.98	169.98	52859.0
2023-11-02 18:00:00	IWM	ETF	170.1	170.13	169.98	169.98	53168.0
2023-11-02 19:00:00	IWM	ETF	169.98	170.0	169.8	169.85	71738.0
2023-11-02 04:00:00	DIA	ETF	333.05	333.78	332.99	333.78	3780.0
2023-11-02 05:00:00	DIA	ETF	333.78	334.03	333.78	334.03	4003.0

> showing 50 of 18,796 rows — these rows as CSV

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