PREVIEW / etf_1hour / 2023-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-23.parquet
  size:    502 KB
  rows:    18,591

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-23 04:00:00	SPY	ETF	420.42	421.13	420.15	420.52	61076.0
2023-10-23 05:00:00	SPY	ETF	420.57	420.57	418.1	418.19	117255.0
2023-10-23 06:00:00	SPY	ETF	418.2	419.13	418.16	419.13	58742.0
2023-10-23 07:00:00	SPY	ETF	419.16	419.94	418.9	419.46	173834.0
2023-10-23 08:00:00	SPY	ETF	419.1501	422.38	418.1796	419.52	601018.0
2023-10-23 09:00:00	SPY	ETF	419.61	420.7	417.8	420.6443	10008704.0
2023-10-23 10:00:00	SPY	ETF	420.64	421.64	420.07	421.405	11386442.0
2023-10-23 11:00:00	SPY	ETF	421.4	423.02	421.2	422.8267	9957426.0
2023-10-23 12:00:00	SPY	ETF	422.83	424.41	421.89	424.41	6697859.0
2023-10-23 13:00:00	SPY	ETF	424.42	424.45	422.63	422.96	7500704.0
2023-10-23 14:00:00	SPY	ETF	422.965	423.305	421.97	422.75	6686151.0
2023-10-23 15:00:00	SPY	ETF	422.74	423.1	420.24	420.45	19180878.0
2023-10-23 16:00:00	SPY	ETF	420.45	423.8003	420.44	421.41	3596071.0
2023-10-23 17:00:00	SPY	ETF	421.45	421.55	421.42	421.51	38749.0
2023-10-23 18:00:00	SPY	ETF	421.51	421.58	421.3	421.58	39409.0
2023-10-23 19:00:00	SPY	ETF	421.6	421.85	421.56	421.81	79546.0
2023-10-23 04:00:00	QQQ	ETF	354.12	354.82	353.91	353.95	88063.0
2023-10-23 05:00:00	QQQ	ETF	353.8	353.8	351.34	351.62	231818.0
2023-10-23 06:00:00	QQQ	ETF	351.7	352.58	351.67	352.58	352091.0
2023-10-23 07:00:00	QQQ	ETF	352.58	353.59	352.32	353.02	376585.0
2023-10-23 08:00:00	QQQ	ETF	353.04	355.74	351.48	353.35	385273.0
2023-10-23 09:00:00	QQQ	ETF	353.37	354.2	351.1199	354.06	7456719.0
2023-10-23 10:00:00	QQQ	ETF	354.06	355.62	353.41	355.61	7493481.0
2023-10-23 11:00:00	QQQ	ETF	355.64	357.2	355.3201	356.995	5531330.0
2023-10-23 12:00:00	QQQ	ETF	356.995	359.22	356.69	359.21	4417675.0
2023-10-23 13:00:00	QQQ	ETF	359.22	359.26	357.51	357.94	4342967.0
2023-10-23 14:00:00	QQQ	ETF	357.94	358.44	357.04	357.4599	4944533.0
2023-10-23 15:00:00	QQQ	ETF	357.45	357.995	355.51	355.67	9090524.0
2023-10-23 16:00:00	QQQ	ETF	355.68	356.8	355.66	356.7	1185738.0
2023-10-23 17:00:00	QQQ	ETF	356.7	356.8	355.67	356.7	350837.0
2023-10-23 18:00:00	QQQ	ETF	356.69	356.73	356.45	356.6494	37607.0
2023-10-23 19:00:00	QQQ	ETF	356.71	357.08	356.68	357.0501	86286.0
2023-10-23 04:00:00	IWM	ETF	165.98	166.44	165.98	166.24	13833.0
2023-10-23 05:00:00	IWM	ETF	166.18	166.24	165.25	165.34	38341.0
2023-10-23 06:00:00	IWM	ETF	165.45	165.73	165.43	165.65	15462.0
2023-10-23 07:00:00	IWM	ETF	165.73	165.91	165.45	165.67	65165.0
2023-10-23 08:00:00	IWM	ETF	165.7289	167.05	165.4	165.93	100615.0
2023-10-23 09:00:00	IWM	ETF	165.96	166.35	164.645	166.16	4651428.0
2023-10-23 10:00:00	IWM	ETF	166.16	166.915	165.85	166.32	5751336.0
2023-10-23 11:00:00	IWM	ETF	166.31	167.33	166.15	166.92	4893345.0
2023-10-23 12:00:00	IWM	ETF	166.91	167.43	166.26	167.43	4109107.0
2023-10-23 13:00:00	IWM	ETF	167.43	167.455	166.42	166.505	4114303.0
2023-10-23 14:00:00	IWM	ETF	166.51	166.695	166.13	166.38	3643378.0
2023-10-23 15:00:00	IWM	ETF	166.37	166.485	165.08	165.09	7542946.0
2023-10-23 16:00:00	IWM	ETF	165.03	165.76	165.03	165.66	1620430.0
2023-10-23 17:00:00	IWM	ETF	165.65	165.8	165.03	165.65	1215080.0
2023-10-23 18:00:00	IWM	ETF	165.64	165.74	165.57	165.7	16275.0
2023-10-23 19:00:00	IWM	ETF	165.73	166.0	165.73	165.98	95839.0
2023-10-23 04:00:00	DIA	ETF	330.28	330.75	330.28	330.59	1120.0
2023-10-23 05:00:00	DIA	ETF	330.13	330.19	329.22	329.22	2750.0

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

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