PREVIEW / etf_1hour / 2023-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-24.parquet
  size:    487 KB
  rows:    17,910

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-24 04:00:00	SPY	ETF	421.88	422.22	421.26	422.2	31523.0
2023-10-24 05:00:00	SPY	ETF	422.15	422.74	422.05	422.57	59981.0
2023-10-24 06:00:00	SPY	ETF	422.77	422.87	422.36	422.84	69925.0
2023-10-24 07:00:00	SPY	ETF	422.81	423.24	422.2	423.05	318608.0
2023-10-24 08:00:00	SPY	ETF	423.2	423.25	421.2604	423.17	335867.0
2023-10-24 09:00:00	SPY	ETF	423.13	423.89	422.38	423.835	7956556.0
2023-10-24 10:00:00	SPY	ETF	423.83	424.82	422.55	424.19	10107794.0
2023-10-24 11:00:00	SPY	ETF	424.18	424.23	422.55	423.27	7572948.0
2023-10-24 12:00:00	SPY	ETF	423.27	423.56	420.74	421.25	7911267.0
2023-10-24 13:00:00	SPY	ETF	421.25	422.5899	421.02	422.16	6454877.0
2023-10-24 14:00:00	SPY	ETF	422.16	423.7688	421.98	423.53	5953655.0
2023-10-24 15:00:00	SPY	ETF	423.54	424.18	423.22	423.62	12997989.0
2023-10-24 16:00:00	SPY	ETF	423.61	425.5	421.1579	423.5	3887600.0
2023-10-24 17:00:00	SPY	ETF	423.5691	423.6	422.97	423.3	156445.0
2023-10-24 18:00:00	SPY	ETF	423.28	423.74	422.38	423.15	261472.0
2023-10-24 19:00:00	SPY	ETF	423.15	423.37	423.02	423.24	62937.0
2023-10-24 04:00:00	QQQ	ETF	357.66	357.87	356.62	357.5	74947.0
2023-10-24 05:00:00	QQQ	ETF	357.45	358.35	357.44	358.08	74559.0
2023-10-24 06:00:00	QQQ	ETF	358.32	358.32	357.58	357.88	43611.0
2023-10-24 07:00:00	QQQ	ETF	357.9	358.46	357.8	358.26	180460.0
2023-10-24 08:00:00	QQQ	ETF	357.83	358.49	355.936	358.06	238301.0
2023-10-24 09:00:00	QQQ	ETF	358.06	358.97	357.06	358.7	6058662.0
2023-10-24 10:00:00	QQQ	ETF	358.68	359.91	357.55	359.1494	6269870.0
2023-10-24 11:00:00	QQQ	ETF	359.15	359.5	357.51	358.5399	3880930.0
2023-10-24 12:00:00	QQQ	ETF	358.56	358.86	355.79	356.21	4412912.0
2023-10-24 13:00:00	QQQ	ETF	356.2	357.806	356.101	357.39	3397567.0
2023-10-24 14:00:00	QQQ	ETF	357.38	358.93	357.23	358.69	3061520.0
2023-10-24 15:00:00	QQQ	ETF	358.72	359.51	358.44	359.19	5991690.0
2023-10-24 16:00:00	QQQ	ETF	359.18	361.6	358.15	358.81	3178028.0
2023-10-24 17:00:00	QQQ	ETF	358.8	358.8	358.12	358.68	211225.0
2023-10-24 18:00:00	QQQ	ETF	358.64	359.41	357.42	358.33	484927.0
2023-10-24 19:00:00	QQQ	ETF	358.26	358.54	358.14	358.35	82891.0
2023-10-24 04:00:00	IWM	ETF	165.83	166.17	165.51	166.17	17592.0
2023-10-24 05:00:00	IWM	ETF	166.12	166.45	166.07	166.4	8300.0
2023-10-24 06:00:00	IWM	ETF	166.36	166.5	166.22	166.43	11346.0
2023-10-24 07:00:00	IWM	ETF	166.45	166.65	166.43	166.62	87354.0
2023-10-24 08:00:00	IWM	ETF	166.4401	166.75	165.99	166.7	84360.0
2023-10-24 09:00:00	IWM	ETF	166.6	167.23	166.22	167.11	4306019.0
2023-10-24 10:00:00	IWM	ETF	167.12	167.62	166.545	167.29	3887381.0
2023-10-24 11:00:00	IWM	ETF	167.29	167.3	166.085	166.295	3937933.0
2023-10-24 12:00:00	IWM	ETF	166.3	166.435	165.41	165.67	2954514.0
2023-10-24 13:00:00	IWM	ETF	165.66	166.255	165.5	166.035	2682476.0
2023-10-24 14:00:00	IWM	ETF	166.03	166.5	165.97	166.305	2146762.0
2023-10-24 15:00:00	IWM	ETF	166.31	166.67	166.235	166.43	4487639.0
2023-10-24 16:00:00	IWM	ETF	166.47	166.65	166.21	166.29	597336.0
2023-10-24 17:00:00	IWM	ETF	166.25	166.39	165.99	166.11	67210.0
2023-10-24 18:00:00	IWM	ETF	166.23	166.4	166.13	166.31	99191.0
2023-10-24 19:00:00	IWM	ETF	166.31	166.36	166.22	166.29	43035.0
2023-10-24 04:00:00	DIA	ETF	330.03	330.24	329.58	330.24	1250.0
2023-10-24 05:00:00	DIA	ETF	330.18	330.18	330.18	330.18	100.0

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

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