PREVIEW / etf_1hour / 2023-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-29.parquet
  size:    481 KB
  rows:    17,534

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-09-29 04:00:00	SPY	ETF	429.71	430.63	429.71	430.08	42618.0
2023-09-29 05:00:00	SPY	ETF	430.18	430.56	430.05	430.54	17743.0
2023-09-29 06:00:00	SPY	ETF	430.46	430.84	430.3	430.48	40828.0
2023-09-29 07:00:00	SPY	ETF	430.53	430.77	429.87	429.93	303704.0
2023-09-29 08:00:00	SPY	ETF	430.57	432.0	428.32	431.52	1970893.0
2023-09-29 09:00:00	SPY	ETF	431.54	431.85	430.57	431.39	9038817.0
2023-09-29 10:00:00	SPY	ETF	431.41	431.76	430.04	430.5408	10382668.0
2023-09-29 11:00:00	SPY	ETF	430.56	431.36	428.635	429.23	9745275.0
2023-09-29 12:00:00	SPY	ETF	429.23	429.75	427.89	428.2201	7673825.0
2023-09-29 13:00:00	SPY	ETF	428.23	428.24	426.17	426.17	10359651.0
2023-09-29 14:00:00	SPY	ETF	426.17	428.23	425.91	428.21	11980952.0
2023-09-29 15:00:00	SPY	ETF	428.21	428.875	426.74	427.39	25227991.0
2023-09-29 16:00:00	SPY	ETF	427.39	430.5158	426.94	427.73	5208188.0
2023-09-29 17:00:00	SPY	ETF	427.67	428.02	427.54	427.7494	56980.0
2023-09-29 18:00:00	SPY	ETF	427.48	427.76	427.48	427.6	110856.0
2023-09-29 19:00:00	SPY	ETF	427.6	427.7	427.43	427.43	17695.0
2023-09-29 04:00:00	QQQ	ETF	360.24	360.68	360.01	360.05	73946.0
2023-09-29 05:00:00	QQQ	ETF	360.02	360.7	360.01	360.62	30007.0
2023-09-29 06:00:00	QQQ	ETF	360.57	360.88	360.25	360.36	42484.0
2023-09-29 07:00:00	QQQ	ETF	360.35	360.56	359.65	359.87	174403.0
2023-09-29 08:00:00	QQQ	ETF	360.21	361.73	358.278	361.56	804397.0
2023-09-29 09:00:00	QQQ	ETF	361.57	362.55	360.87	362.28	6673455.0
2023-09-29 10:00:00	QQQ	ETF	362.29	362.95	360.79	361.3001	7569921.0
2023-09-29 11:00:00	QQQ	ETF	361.33	361.78	359.3	360.095	6014925.0
2023-09-29 12:00:00	QQQ	ETF	360.1	360.67	358.8	359.03	4287240.0
2023-09-29 13:00:00	QQQ	ETF	359.04	359.04	357.2	357.21	5717235.0
2023-09-29 14:00:00	QQQ	ETF	357.205	359.24	357.02	359.21	5345683.0
2023-09-29 15:00:00	QQQ	ETF	359.22	359.8056	357.6899	358.34	9818159.0
2023-09-29 16:00:00	QQQ	ETF	358.35	359.25	357.97	358.97	1547505.0
2023-09-29 17:00:00	QQQ	ETF	358.93	359.05	358.81	358.82	131655.0
2023-09-29 18:00:00	QQQ	ETF	358.82	358.96	358.66	358.66	14597.0
2023-09-29 19:00:00	QQQ	ETF	358.63	358.71	358.4	358.6	49038.0
2023-09-29 04:00:00	IWM	ETF	178.41	178.61	178.32	178.32	19589.0
2023-09-29 05:00:00	IWM	ETF	178.37	178.68	178.37	178.57	7484.0
2023-09-29 06:00:00	IWM	ETF	178.61	178.83	178.46	178.66	38420.0
2023-09-29 07:00:00	IWM	ETF	178.6	178.75	178.23	178.28	25020.0
2023-09-29 08:00:00	IWM	ETF	178.6112	179.4	177.65	179.11	356842.0
2023-09-29 09:00:00	IWM	ETF	179.09	179.16	178.12	178.7125	4511112.0
2023-09-29 10:00:00	IWM	ETF	178.72	178.88	177.62	178.06	3600557.0
2023-09-29 11:00:00	IWM	ETF	178.07	178.54	177.105	177.46	3350754.0
2023-09-29 12:00:00	IWM	ETF	177.45	178.05	177.04	177.2	2194080.0
2023-09-29 13:00:00	IWM	ETF	177.19	177.19	176.34	176.36	2458077.0
2023-09-29 14:00:00	IWM	ETF	176.35	177.105	176.15	177.06	2528867.0
2023-09-29 15:00:00	IWM	ETF	177.06	177.205	176.44	176.64	6745094.0
2023-09-29 16:00:00	IWM	ETF	176.65	177.03	176.55	176.83	2966770.0
2023-09-29 17:00:00	IWM	ETF	176.81	176.91	176.76	176.76	3275.0
2023-09-29 18:00:00	IWM	ETF	176.76	176.78	176.74	176.74	801.0
2023-09-29 19:00:00	IWM	ETF	176.74	176.76	176.74	176.76	2450.0
2023-09-29 04:00:00	DIA	ETF	337.99	337.99	337.76	337.76	1985.0
2023-09-29 05:00:00	DIA	ETF	337.9	337.94	337.9	337.94	500.0

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

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