PREVIEW / etf_1hour / 2023-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-04.parquet
  size:    495 KB
  rows:    18,159

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-10-04 04:00:00	SPY	ETF	420.33	421.31	420.07	421.04	44125.0
2023-10-04 05:00:00	SPY	ETF	420.93	421.75	420.87	421.68	62815.0
2023-10-04 06:00:00	SPY	ETF	421.68	421.95	421.05	421.45	105291.0
2023-10-04 07:00:00	SPY	ETF	421.42	422.57	421.24	422.37	525205.0
2023-10-04 08:00:00	SPY	ETF	422.2385	423.28	418.81	422.63	1130617.0
2023-10-04 09:00:00	SPY	ETF	422.62	423.37	421.91	422.5201	6512059.0
2023-10-04 10:00:00	SPY	ETF	422.52	422.91	420.56	421.05	12572135.0
2023-10-04 11:00:00	SPY	ETF	421.05	423.965	420.68	423.955	9688767.0
2023-10-04 12:00:00	SPY	ETF	423.93	424.36	423.25	423.6017	7508423.0
2023-10-04 13:00:00	SPY	ETF	423.645	423.72	422.04	422.2	6856587.0
2023-10-04 14:00:00	SPY	ETF	422.17	423.33	421.64	423.19	7623702.0
2023-10-04 15:00:00	SPY	ETF	423.2	425.4299	423.04	424.71	17875028.0
2023-10-04 16:00:00	SPY	ETF	424.7	424.7562	423.2127	424.18	3202002.0
2023-10-04 17:00:00	SPY	ETF	424.23	424.23	424.01	424.15	88993.0
2023-10-04 18:00:00	SPY	ETF	424.15	424.28	423.97	424.16	98491.0
2023-10-04 19:00:00	SPY	ETF	424.2	424.25	424.05	424.19	35314.0
2023-10-04 04:00:00	QQQ	ETF	353.2	354.1	352.89	353.85	60311.0
2023-10-04 05:00:00	QQQ	ETF	353.85	354.58	353.74	354.48	49104.0
2023-10-04 06:00:00	QQQ	ETF	354.53	354.92	353.95	354.43	72891.0
2023-10-04 07:00:00	QQQ	ETF	354.48	355.8	354.33	355.48	389021.0
2023-10-04 08:00:00	QQQ	ETF	355.22	356.91	351.96	356.39	974005.0
2023-10-04 09:00:00	QQQ	ETF	356.36	357.73	354.654	356.9501	5577791.0
2023-10-04 10:00:00	QQQ	ETF	356.93	358.08	355.3	356.31	8234660.0
2023-10-04 11:00:00	QQQ	ETF	356.29	359.23	355.94	359.195	5463313.0
2023-10-04 12:00:00	QQQ	ETF	359.17	359.26	358.261	358.69	3666599.0
2023-10-04 13:00:00	QQQ	ETF	358.685	358.77	357.25	357.39	3429078.0
2023-10-04 14:00:00	QQQ	ETF	357.37	358.69	357.0	358.56	3870803.0
2023-10-04 15:00:00	QQQ	ETF	358.57	360.61	358.46	359.76	9566911.0
2023-10-04 16:00:00	QQQ	ETF	359.76	359.76	358.2556	359.36	1653312.0
2023-10-04 17:00:00	QQQ	ETF	359.36	359.75	359.27	359.36	318221.0
2023-10-04 18:00:00	QQQ	ETF	359.33	359.6	359.2	359.4892	99914.0
2023-10-04 19:00:00	QQQ	ETF	359.54	359.65	359.42	359.65	30621.0
2023-10-04 04:00:00	IWM	ETF	170.64	170.81	170.0	170.73	16251.0
2023-10-04 05:00:00	IWM	ETF	170.72	171.11	170.65	171.11	12649.0
2023-10-04 06:00:00	IWM	ETF	171.1	171.29	170.77	170.9	97888.0
2023-10-04 07:00:00	IWM	ETF	170.92	171.53	170.84	171.35	113620.0
2023-10-04 08:00:00	IWM	ETF	170.87	171.81	169.6	171.48	370059.0
2023-10-04 09:00:00	IWM	ETF	171.51	171.57	170.16	170.376	4419009.0
2023-10-04 10:00:00	IWM	ETF	170.36	170.47	169.09	169.37	5590020.0
2023-10-04 11:00:00	IWM	ETF	169.37	170.93	169.17	170.93	5725049.0
2023-10-04 12:00:00	IWM	ETF	170.92	171.5	170.61	171.2	3194563.0
2023-10-04 13:00:00	IWM	ETF	171.19	171.26	170.24	170.3	3594170.0
2023-10-04 14:00:00	IWM	ETF	170.29	170.62	169.97	170.59	2740300.0
2023-10-04 15:00:00	IWM	ETF	170.59	171.61	170.53	171.17	6905192.0
2023-10-04 16:00:00	IWM	ETF	171.22	171.22	170.91	170.94	988908.0
2023-10-04 17:00:00	IWM	ETF	170.97	171.07	170.79	171.07	12400.0
2023-10-04 18:00:00	IWM	ETF	170.91	171.03	170.8509	170.95	14809.0
2023-10-04 19:00:00	IWM	ETF	170.95	170.99	170.84	170.91	11466.0
2023-10-04 04:00:00	DIA	ETF	329.42	329.98	329.18	329.87	2990.0
2023-10-04 05:00:00	DIA	ETF	329.85	330.24	329.84	330.18	4990.0

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

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