PREVIEW / etf_1hour / 2023-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-16.parquet
  size:    470 KB
  rows:    17,338

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-03-16 04:00:00	SPY	ETF	390.54	390.96	389.34	389.34	82537.0
2023-03-16 05:00:00	SPY	ETF	389.32	389.5	388.0	388.74	74460.0
2023-03-16 06:00:00	SPY	ETF	388.74	389.06	388.2	389.0	138369.0
2023-03-16 07:00:00	SPY	ETF	389.02	389.07	387.53	388.48	426203.0
2023-03-16 08:00:00	SPY	ETF	387.96	390.85	387.51	387.96	1020541.0
2023-03-16 09:00:00	SPY	ETF	387.93	388.65	386.29	388.59	9839340.0
2023-03-16 10:00:00	SPY	ETF	388.59	392.06	386.59	391.58	17082839.0
2023-03-16 11:00:00	SPY	ETF	391.59	394.45	390.804	393.86	18350901.0
2023-03-16 12:00:00	SPY	ETF	393.86	395.49	392.4	395.255	13132567.0
2023-03-16 13:00:00	SPY	ETF	395.26	396.14	394.33	395.025	11105832.0
2023-03-16 14:00:00	SPY	ETF	395.02	395.2499	393.62	395.21	8892778.0
2023-03-16 15:00:00	SPY	ETF	395.21	396.47	395.0501	396.03	22910793.0
2023-03-16 16:00:00	SPY	ETF	396.03	396.52	395.0	396.13	5982184.0
2023-03-16 17:00:00	SPY	ETF	396.15	396.16	395.85	395.919	164677.0
2023-03-16 18:00:00	SPY	ETF	395.95	396.04	395.27	395.91	526874.0
2023-03-16 19:00:00	SPY	ETF	395.9	396.29	395.8599	396.02	115702.0
2023-03-16 04:00:00	QQQ	ETF	300.3	300.54	299.53	299.65	88702.0
2023-03-16 05:00:00	QQQ	ETF	299.6	299.82	298.67	299.28	73869.0
2023-03-16 06:00:00	QQQ	ETF	299.4	299.69	298.91	299.61	28530.0
2023-03-16 07:00:00	QQQ	ETF	299.61	299.88	298.78	299.47	188079.0
2023-03-16 08:00:00	QQQ	ETF	299.42	300.27	298.1	298.6	827219.0
2023-03-16 09:00:00	QQQ	ETF	298.58	299.7	297.19	299.7	7395745.0
2023-03-16 10:00:00	QQQ	ETF	299.67	302.5	298.38	302.1	9765097.0
2023-03-16 11:00:00	QQQ	ETF	302.1	305.57	301.64	305.05	13190299.0
2023-03-16 12:00:00	QQQ	ETF	305.05	305.98	303.72	305.77	9103716.0
2023-03-16 13:00:00	QQQ	ETF	305.78	306.09	304.77	305.44	7039806.0
2023-03-16 14:00:00	QQQ	ETF	305.45	306.18	304.8	306.08	5144756.0
2023-03-16 15:00:00	QQQ	ETF	306.09	307.18	305.94	306.8006	13285467.0
2023-03-16 16:00:00	QQQ	ETF	306.82	307.03	306.31	306.69	1758766.0
2023-03-16 17:00:00	QQQ	ETF	306.72	306.76	306.4	306.48	90179.0
2023-03-16 18:00:00	QQQ	ETF	306.47	306.86	306.3	306.83	273855.0
2023-03-16 19:00:00	QQQ	ETF	306.81	307.1	306.8	307.0	116972.0
2023-03-16 04:00:00	IWM	ETF	174.77	174.99	173.62	173.67	36864.0
2023-03-16 05:00:00	IWM	ETF	173.52	173.59	172.7	173.13	46908.0
2023-03-16 06:00:00	IWM	ETF	173.13	173.24	172.57	172.99	22435.0
2023-03-16 07:00:00	IWM	ETF	172.99	173.07	171.85	172.54	150355.0
2023-03-16 08:00:00	IWM	ETF	172.72	173.9896	171.76	171.8	309022.0
2023-03-16 09:00:00	IWM	ETF	171.75	172.66	170.94	172.41	5010054.0
2023-03-16 10:00:00	IWM	ETF	172.41	175.08	170.495	174.3	7692128.0
2023-03-16 11:00:00	IWM	ETF	174.3	176.01	173.63	175.395	6634363.0
2023-03-16 12:00:00	IWM	ETF	175.395	176.485	174.39	176.435	4857422.0
2023-03-16 13:00:00	IWM	ETF	176.44	177.38	175.97	176.16	5115681.0
2023-03-16 14:00:00	IWM	ETF	176.16	176.22	175.2	176.115	2894989.0
2023-03-16 15:00:00	IWM	ETF	176.12	176.55	175.62	176.04	5736317.0
2023-03-16 16:00:00	IWM	ETF	175.98	176.4	175.9	176.08	2140708.0
2023-03-16 17:00:00	IWM	ETF	176.03	176.09	175.7504	175.8	47592.0
2023-03-16 18:00:00	IWM	ETF	175.78	175.98	175.01	175.58	485940.0
2023-03-16 19:00:00	IWM	ETF	175.55	175.79	175.43	175.6	56373.0
2023-03-16 04:00:00	DIA	ETF	320.36	320.61	319.81	320.0	6797.0
2023-03-16 05:00:00	DIA	ETF	318.26	318.66	318.26	318.66	2200.0

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

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