PREVIEW / etf_1hour / 2023-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-28.parquet
  size:    487 KB
  rows:    17,609

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-28 04:00:00	SPY	ETF	426.28	426.36	425.6	425.89	37656.0
2023-09-28 05:00:00	SPY	ETF	425.88	426.56	424.95	426.56	56131.0
2023-09-28 06:00:00	SPY	ETF	426.52	426.82	426.13	426.5	100826.0
2023-09-28 07:00:00	SPY	ETF	426.5	426.5	425.3	425.87	430457.0
2023-09-28 08:00:00	SPY	ETF	425.87	427.54	425.13	425.46	1511723.0
2023-09-28 09:00:00	SPY	ETF	425.42	426.77	424.87	426.7	7130127.0
2023-09-28 10:00:00	SPY	ETF	426.72	427.56	425.32	427.36	10784263.0
2023-09-28 11:00:00	SPY	ETF	427.35	429.615	426.97	429.44	12250161.0
2023-09-28 12:00:00	SPY	ETF	429.44	430.2499	428.57	428.92	9566768.0
2023-09-28 13:00:00	SPY	ETF	428.94	429.27	427.66	428.155	7377390.0
2023-09-28 14:00:00	SPY	ETF	428.17	429.105	427.47	428.385	7040589.0
2023-09-28 15:00:00	SPY	ETF	428.39	429.765	427.97	428.53	13710513.0
2023-09-28 16:00:00	SPY	ETF	428.53	429.05	425.9452	428.92	2620260.0
2023-09-28 17:00:00	SPY	ETF	428.99	428.99	428.53	428.75	140557.0
2023-09-28 18:00:00	SPY	ETF	428.75	429.31	428.75	429.02	237908.0
2023-09-28 19:00:00	SPY	ETF	429.04	429.06	428.61	428.67	59993.0
2023-09-28 04:00:00	QQQ	ETF	355.17	355.34	354.52	354.65	42454.0
2023-09-28 05:00:00	QQQ	ETF	354.62	355.18	353.75	355.18	89469.0
2023-09-28 06:00:00	QQQ	ETF	355.05	355.29	354.64	354.97	104269.0
2023-09-28 07:00:00	QQQ	ETF	354.97	354.98	353.83	354.27	246639.0
2023-09-28 08:00:00	QQQ	ETF	354.6	356.08	353.72	353.98	1795401.0
2023-09-28 09:00:00	QQQ	ETF	354.19	355.47	353.24	355.3	6998416.0
2023-09-28 10:00:00	QQQ	ETF	355.31	356.37	353.79	356.21	6238694.0
2023-09-28 11:00:00	QQQ	ETF	356.2	359.32	355.62	359.2501	6924352.0
2023-09-28 12:00:00	QQQ	ETF	359.27	360.17	358.51	358.81	5446392.0
2023-09-28 13:00:00	QQQ	ETF	358.82	359.19	357.37	357.845	4123080.0
2023-09-28 14:00:00	QQQ	ETF	357.84	358.66	356.92	357.695	4165933.0
2023-09-28 15:00:00	QQQ	ETF	357.695	359.37	357.57	358.05	6875356.0
2023-09-28 16:00:00	QQQ	ETF	358.05	358.66	354.2467	358.52	1941515.0
2023-09-28 17:00:00	QQQ	ETF	358.47	358.47	358.18	358.36	62308.0
2023-09-28 18:00:00	QQQ	ETF	358.42	358.9	358.4	358.7	56086.0
2023-09-28 19:00:00	QQQ	ETF	358.7	358.7	358.23	358.31	72364.0
2023-09-28 04:00:00	IWM	ETF	176.06	176.1	175.62	175.94	24386.0
2023-09-28 05:00:00	IWM	ETF	175.88	175.93	175.39	175.93	4152.0
2023-09-28 06:00:00	IWM	ETF	176.07	176.3	176.05	176.16	13517.0
2023-09-28 07:00:00	IWM	ETF	176.15	176.18	175.64	175.96	57083.0
2023-09-28 08:00:00	IWM	ETF	175.97	176.91	175.5	175.8	155678.0
2023-09-28 09:00:00	IWM	ETF	175.79	177.19	175.79	177.15	3366473.0
2023-09-28 10:00:00	IWM	ETF	177.15	177.3525	175.97	176.92	4294398.0
2023-09-28 11:00:00	IWM	ETF	176.92	178.21	176.75	178.18	4123756.0
2023-09-28 12:00:00	IWM	ETF	178.18	178.57	177.76	177.91	3284024.0
2023-09-28 13:00:00	IWM	ETF	177.915	178.03	177.34	177.58	2383942.0
2023-09-28 14:00:00	IWM	ETF	177.59	177.94	177.3	177.71	1989549.0
2023-09-28 15:00:00	IWM	ETF	177.715	178.22	177.38	177.66	4894348.0
2023-09-28 16:00:00	IWM	ETF	177.58	177.9	177.49	177.84	1161499.0
2023-09-28 17:00:00	IWM	ETF	177.83	177.9	177.71	177.8698	16257.0
2023-09-28 18:00:00	IWM	ETF	177.87	178.08	177.86	177.94	13623.0
2023-09-28 19:00:00	IWM	ETF	177.93	177.94	177.8	177.84	71660.0
2023-09-28 04:00:00	DIA	ETF	335.44	335.44	335.01	335.02	2155.0
2023-09-28 05:00:00	DIA	ETF	335.16	335.48	334.76	335.48	4206.0

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

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