PREVIEW / etf_1hour / 2023-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-23.parquet
  size:    471 KB
  rows:    17,180

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-06-23 04:00:00	SPY	ETF	434.63	434.98	434.3	434.35	41510.0
2023-06-23 05:00:00	SPY	ETF	434.35	434.71	434.3	434.65	14565.0
2023-06-23 06:00:00	SPY	ETF	434.63	434.7	434.2	434.33	120820.0
2023-06-23 07:00:00	SPY	ETF	434.37	435.03	434.34	434.61	224642.0
2023-06-23 08:00:00	SPY	ETF	434.64	435.4	432.97	433.15	860073.0
2023-06-23 09:00:00	SPY	ETF	433.16	433.589	432.7117	433.405	6772535.0
2023-06-23 10:00:00	SPY	ETF	433.4	434.24	433.105	433.575	7418916.0
2023-06-23 11:00:00	SPY	ETF	433.58	433.99	432.84	433.855	6102626.0
2023-06-23 12:00:00	SPY	ETF	433.86	434.83	433.71	434.55	5894055.0
2023-06-23 13:00:00	SPY	ETF	434.56	435.06	434.2	434.58	4044669.0
2023-06-23 14:00:00	SPY	ETF	434.575	434.66	432.89	432.97	8212745.0
2023-06-23 15:00:00	SPY	ETF	432.98	433.98	432.47	433.21	18851423.0
2023-06-23 16:00:00	SPY	ETF	433.21	433.42	432.56	433.04	4182900.0
2023-06-23 17:00:00	SPY	ETF	433.0599	433.21	432.86	432.91	60829.0
2023-06-23 18:00:00	SPY	ETF	432.91	433.21	432.66	432.74	21040.0
2023-06-23 19:00:00	SPY	ETF	432.73	432.82	432.67	432.73	12554.0
2023-06-23 04:00:00	QQQ	ETF	364.88	364.88	363.37	363.48	90882.0
2023-06-23 05:00:00	QQQ	ETF	363.55	364.11	363.55	364.0	88188.0
2023-06-23 06:00:00	QQQ	ETF	363.99	364.07	363.45	363.76	45187.0
2023-06-23 07:00:00	QQQ	ETF	363.76	364.6	363.76	364.18	205671.0
2023-06-23 08:00:00	QQQ	ETF	364.01	364.89	361.67	362.179	783397.0
2023-06-23 09:00:00	QQQ	ETF	362.1	363.3	360.8227	361.655	6129963.0
2023-06-23 10:00:00	QQQ	ETF	361.66	363.2	361.17	362.35	5440754.0
2023-06-23 11:00:00	QQQ	ETF	362.36	362.85	361.35	362.545	4093656.0
2023-06-23 12:00:00	QQQ	ETF	362.55	364.2	362.5399	364.05	3991949.0
2023-06-23 13:00:00	QQQ	ETF	364.05	364.88	363.7761	364.1799	3192937.0
2023-06-23 14:00:00	QQQ	ETF	364.18	364.35	362.33	362.48	3453601.0
2023-06-23 15:00:00	QQQ	ETF	362.48	363.23	361.89	362.55	7469062.0
2023-06-23 16:00:00	QQQ	ETF	362.54	362.88	362.05	362.41	849578.0
2023-06-23 17:00:00	QQQ	ETF	362.43	362.54	362.3407	362.3407	39410.0
2023-06-23 18:00:00	QQQ	ETF	362.36	362.54	362.22	362.22	15562.0
2023-06-23 19:00:00	QQQ	ETF	362.25	362.36	362.0	362.18	20529.0
2023-06-23 04:00:00	IWM	ETF	182.05	182.34	182.0	182.03	15189.0
2023-06-23 05:00:00	IWM	ETF	182.14	182.14	181.89	182.07	9943.0
2023-06-23 06:00:00	IWM	ETF	182.05	182.05	181.65	181.65	9975.0
2023-06-23 07:00:00	IWM	ETF	181.72	181.99	181.66	181.79	70615.0
2023-06-23 08:00:00	IWM	ETF	181.79	182.3	180.55	180.88	266115.0
2023-06-23 09:00:00	IWM	ETF	180.82	182.18	180.54	182.14	4415763.0
2023-06-23 10:00:00	IWM	ETF	182.14	182.41	181.34	181.805	3515082.0
2023-06-23 11:00:00	IWM	ETF	181.8	181.93	181.02	181.24	3188423.0
2023-06-23 12:00:00	IWM	ETF	181.23	181.85	181.19	181.56	2483425.0
2023-06-23 13:00:00	IWM	ETF	181.56	181.9121	181.38	181.72	1881124.0
2023-06-23 14:00:00	IWM	ETF	181.725	181.75	180.39	180.39	3702805.0
2023-06-23 15:00:00	IWM	ETF	180.39	180.54	180.05	180.4	14045538.0
2023-06-23 16:00:00	IWM	ETF	180.4	180.57	180.03	180.52	2753165.0
2023-06-23 17:00:00	IWM	ETF	180.52	180.55	180.35	180.35	12986.0
2023-06-23 18:00:00	IWM	ETF	180.31	180.44	179.81	179.96	83108.0
2023-06-23 19:00:00	IWM	ETF	179.96	180.14	179.84	180.14	15666.0
2023-06-23 04:00:00	DIA	ETF	338.0	338.38	338.0	338.38	3100.0
2023-06-23 07:00:00	DIA	ETF	338.25	338.48	338.25	338.34	3780.0

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

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