PREVIEW / etf_1hour / 2023-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-18.parquet
  size:    478 KB
  rows:    17,519

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-08-18 04:00:00	SPY	ETF	435.87	436.37	435.77	436.19	54666.0
2023-08-18 05:00:00	SPY	ETF	436.15	436.26	435.29	435.65	37435.0
2023-08-18 06:00:00	SPY	ETF	435.63	436.04	435.3	435.42	50381.0
2023-08-18 07:00:00	SPY	ETF	435.45	435.52	433.93	434.22	371152.0
2023-08-18 08:00:00	SPY	ETF	435.2119	436.77	433.36	433.89	1107799.0
2023-08-18 09:00:00	SPY	ETF	433.81	435.24	433.01	434.24	9169093.0
2023-08-18 10:00:00	SPY	ETF	434.22	435.1	433.455	435.05	10470014.0
2023-08-18 11:00:00	SPY	ETF	435.05	436.52	434.71	436.42	8034394.0
2023-08-18 12:00:00	SPY	ETF	436.42	436.5511	435.61	435.84	5621950.0
2023-08-18 13:00:00	SPY	ETF	435.85	436.15	434.75	435.905	6119091.0
2023-08-18 14:00:00	SPY	ETF	435.91	436.76	435.49	435.93	6748408.0
2023-08-18 15:00:00	SPY	ETF	435.96	437.57	435.36	436.46	17430994.0
2023-08-18 16:00:00	SPY	ETF	436.46	436.97	434.38	436.05	3483876.0
2023-08-18 17:00:00	SPY	ETF	436.01	436.11	435.97	436.11	86989.0
2023-08-18 18:00:00	SPY	ETF	436.06	436.09	435.9	436.0	40415.0
2023-08-18 19:00:00	SPY	ETF	436.0	436.24	436.0	436.22	51574.0
2023-08-18 04:00:00	QQQ	ETF	358.16	358.41	357.81	358.25	65534.0
2023-08-18 05:00:00	QQQ	ETF	358.18	358.34	357.36	357.59	78739.0
2023-08-18 06:00:00	QQQ	ETF	357.7	357.92	357.04	357.18	80181.0
2023-08-18 07:00:00	QQQ	ETF	357.2	357.32	355.48	355.92	399634.0
2023-08-18 08:00:00	QQQ	ETF	356.7381	358.848	355.2	355.669	838821.0
2023-08-18 09:00:00	QQQ	ETF	355.63	356.83	354.92	355.48	7558532.0
2023-08-18 10:00:00	QQQ	ETF	355.46	356.89	354.71	356.441	7638990.0
2023-08-18 11:00:00	QQQ	ETF	356.44	357.93	355.67	357.8	6459566.0
2023-08-18 12:00:00	QQQ	ETF	357.8	358.1499	357.01	357.27	4460073.0
2023-08-18 13:00:00	QQQ	ETF	357.27	357.75	356.12	357.63	4232716.0
2023-08-18 14:00:00	QQQ	ETF	357.65	358.825	357.28	358.1017	4548374.0
2023-08-18 15:00:00	QQQ	ETF	358.11	359.41	357.47	358.14	7907140.0
2023-08-18 16:00:00	QQQ	ETF	358.13	358.61	357.9	358.04	1597422.0
2023-08-18 17:00:00	QQQ	ETF	358.01	358.25	357.99	358.25	203301.0
2023-08-18 18:00:00	QQQ	ETF	358.23	358.3	358.1	358.1	20436.0
2023-08-18 19:00:00	QQQ	ETF	358.07	358.54	358.05	358.54	34392.0
2023-08-18 04:00:00	IWM	ETF	183.58	183.83	183.39	183.63	6973.0
2023-08-18 05:00:00	IWM	ETF	183.63	183.74	183.18	183.58	8724.0
2023-08-18 06:00:00	IWM	ETF	183.52	183.76	183.26	183.27	9381.0
2023-08-18 07:00:00	IWM	ETF	183.33	183.39	182.59	182.84	73524.0
2023-08-18 08:00:00	IWM	ETF	182.6614	184.09	182.23	182.66	153701.0
2023-08-18 09:00:00	IWM	ETF	182.63	184.64	181.94	183.88	4384762.0
2023-08-18 10:00:00	IWM	ETF	183.86	184.27	183.34	184.2469	3828048.0
2023-08-18 11:00:00	IWM	ETF	184.24	184.89	184.24	184.76	3628984.0
2023-08-18 12:00:00	IWM	ETF	184.77	185.05	184.61	184.77	1719652.0
2023-08-18 13:00:00	IWM	ETF	184.77	185.06	184.39	184.975	1645092.0
2023-08-18 14:00:00	IWM	ETF	184.97	185.25	184.8	184.97	1751397.0
2023-08-18 15:00:00	IWM	ETF	184.97	185.24	184.515	184.69	4194611.0
2023-08-18 16:00:00	IWM	ETF	184.65	185.0	181.8575	184.42	1396804.0
2023-08-18 17:00:00	IWM	ETF	184.46	184.65	184.41	184.58	259951.0
2023-08-18 18:00:00	IWM	ETF	184.58	184.59	184.5	184.54	6120.0
2023-08-18 19:00:00	IWM	ETF	184.57	184.69	184.46	184.57	8629.0
2023-08-18 06:00:00	DIA	ETF	344.45	344.45	344.15	344.15	850.0
2023-08-18 07:00:00	DIA	ETF	344.15	344.19	343.21	343.32	6861.0

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

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