PREVIEW / etf_1hour / 2023-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-20.parquet
  size:    471 KB
  rows:    16,977

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-01-20 04:00:00	SPY	ETF	389.37	389.46	388.65	388.8	33390.0
2023-01-20 05:00:00	SPY	ETF	388.76	389.43	388.36	389.42	64286.0
2023-01-20 06:00:00	SPY	ETF	389.3	389.3	388.74	389.05	30103.0
2023-01-20 07:00:00	SPY	ETF	389.05	390.03	388.85	389.83	209687.0
2023-01-20 08:00:00	SPY	ETF	389.07	390.2	388.6204	389.11	455657.0
2023-01-20 09:00:00	SPY	ETF	389.1	390.22	388.38	389.708	5781355.0
2023-01-20 10:00:00	SPY	ETF	389.71	391.17	389.29	390.65	7834660.0
2023-01-20 11:00:00	SPY	ETF	390.67	392.48	390.6	391.76	7540606.0
2023-01-20 12:00:00	SPY	ETF	391.77	392.33	391.74	391.8599	3750308.0
2023-01-20 13:00:00	SPY	ETF	391.86	393.6	391.1	393.42	6642215.0
2023-01-20 14:00:00	SPY	ETF	393.42	394.35	393.21	394.31	6690057.0
2023-01-20 15:00:00	SPY	ETF	394.305	396.04	394.305	395.83	16641681.0
2023-01-20 16:00:00	SPY	ETF	395.83	395.979	388.0	395.85	5133803.0
2023-01-20 17:00:00	SPY	ETF	395.85	396.25	395.77	395.87	556515.0
2023-01-20 18:00:00	SPY	ETF	395.86	396.1	395.86	395.95	226045.0
2023-01-20 19:00:00	SPY	ETF	396.0	396.29	396.0	396.29	19758.0
2023-01-20 04:00:00	QQQ	ETF	276.04	276.1	275.38	275.71	45484.0
2023-01-20 05:00:00	QQQ	ETF	275.55	276.32	275.35	276.28	61361.0
2023-01-20 06:00:00	QQQ	ETF	276.23	276.43	275.88	276.39	87086.0
2023-01-20 07:00:00	QQQ	ETF	276.35	277.171	276.19	277.024	245419.0
2023-01-20 08:00:00	QQQ	ETF	276.51	277.26	275.356	276.32	373679.0
2023-01-20 09:00:00	QQQ	ETF	276.35	277.9	275.71	277.3	4483792.0
2023-01-20 10:00:00	QQQ	ETF	277.35	278.5007	276.74	277.6999	4327775.0
2023-01-20 11:00:00	QQQ	ETF	277.72	279.57	277.64	279.11	4672821.0
2023-01-20 12:00:00	QQQ	ETF	279.12	279.8	279.085	279.31	2635361.0
2023-01-20 13:00:00	QQQ	ETF	279.32	281.05	278.69	280.93	4699737.0
2023-01-20 14:00:00	QQQ	ETF	280.95	281.695	280.81	281.59	4102765.0
2023-01-20 15:00:00	QQQ	ETF	281.6	283.02	281.6	282.78	9786882.0
2023-01-20 16:00:00	QQQ	ETF	282.78	282.84	282.38	282.83	1334212.0
2023-01-20 17:00:00	QQQ	ETF	282.83	282.92	282.68	282.75	948315.0
2023-01-20 18:00:00	QQQ	ETF	282.74	282.89	282.68	282.82	142165.0
2023-01-20 19:00:00	QQQ	ETF	282.81	283.1	282.81	283.1	25321.0
2023-01-20 04:00:00	IWM	ETF	182.26	182.27	181.76	181.85	12128.0
2023-01-20 05:00:00	IWM	ETF	181.84	182.15	181.68	182.15	16131.0
2023-01-20 06:00:00	IWM	ETF	181.96	182.01	181.75	181.88	14469.0
2023-01-20 07:00:00	IWM	ETF	181.83	182.45	181.76	182.36	93774.0
2023-01-20 08:00:00	IWM	ETF	181.85	182.6	181.8	182.16	83027.0
2023-01-20 09:00:00	IWM	ETF	182.07	183.49	181.27	183.3	3492007.0
2023-01-20 10:00:00	IWM	ETF	183.3	183.84	182.8	182.88	2337776.0
2023-01-20 11:00:00	IWM	ETF	182.905	183.82	182.89	183.55	1415200.0
2023-01-20 12:00:00	IWM	ETF	183.54	183.8	183.24	183.2403	1242142.0
2023-01-20 13:00:00	IWM	ETF	183.245	183.97	182.78	183.87	1757169.0
2023-01-20 14:00:00	IWM	ETF	183.87	184.49	183.78	184.48	1569841.0
2023-01-20 15:00:00	IWM	ETF	184.48	185.15	184.48	185.06	4240658.0
2023-01-20 16:00:00	IWM	ETF	185.04	185.12	184.83	185.1	4179796.0
2023-01-20 17:00:00	IWM	ETF	185.23	185.23	184.95	185.02	2097252.0
2023-01-20 18:00:00	IWM	ETF	185.08	185.12	184.93	185.0	15057.0
2023-01-20 19:00:00	IWM	ETF	185.0	186.0	184.95	185.38	35197.0
2023-01-20 05:00:00	DIA	ETF	330.37	330.37	330.36	330.36	700.0
2023-01-20 06:00:00	DIA	ETF	330.2	330.22	329.97	329.97	1500.0

> showing 50 of 16,977 rows — these rows as CSV

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