PREVIEW / etf_1hour / 2023-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-24.parquet
  size:    476 KB
  rows:    17,362

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-24 04:00:00	SPY	ETF	445.8	446.36	445.64	445.69	44478.0
2023-08-24 05:00:00	SPY	ETF	445.77	445.79	444.66	444.97	50900.0
2023-08-24 06:00:00	SPY	ETF	444.95	445.8	444.9	445.73	43983.0
2023-08-24 07:00:00	SPY	ETF	445.72	446.0	445.2	445.29	295034.0
2023-08-24 08:00:00	SPY	ETF	446.0	446.6	444.6	444.83	648376.0
2023-08-24 09:00:00	SPY	ETF	444.83	446.15	443.48	444.95	7800584.0
2023-08-24 10:00:00	SPY	ETF	444.955	445.22	441.06	441.12	11930003.0
2023-08-24 11:00:00	SPY	ETF	441.125	441.16	439.185	439.2	9613766.0
2023-08-24 12:00:00	SPY	ETF	439.21	440.818	439.1101	439.89	7445770.0
2023-08-24 13:00:00	SPY	ETF	439.89	440.08	439.02	439.3399	6404101.0
2023-08-24 14:00:00	SPY	ETF	439.35	439.9	438.52	439.065	6323326.0
2023-08-24 15:00:00	SPY	ETF	439.075	439.33	436.855	436.92	19017963.0
2023-08-24 16:00:00	SPY	ETF	436.92	437.21	436.29	436.76	3775393.0
2023-08-24 17:00:00	SPY	ETF	436.78	436.95	436.6501	436.88	75111.0
2023-08-24 18:00:00	SPY	ETF	436.81	437.41	436.8	437.41	96697.0
2023-08-24 19:00:00	SPY	ETF	437.41	437.42	436.89	437.21	67590.0
2023-08-24 04:00:00	QQQ	ETF	373.46	374.58	373.46	373.7	211096.0
2023-08-24 05:00:00	QQQ	ETF	373.72	373.75	372.82	373.09	75429.0
2023-08-24 06:00:00	QQQ	ETF	373.18	373.83	373.18	373.63	103721.0
2023-08-24 07:00:00	QQQ	ETF	373.66	374.09	373.27	373.39	175906.0
2023-08-24 08:00:00	QQQ	ETF	373.62	374.64	369.386	372.78	682490.0
2023-08-24 09:00:00	QQQ	ETF	372.71	374.28	369.0201	369.94	9077239.0
2023-08-24 10:00:00	QQQ	ETF	369.96	370.22	365.26	365.485	10914089.0
2023-08-24 11:00:00	QQQ	ETF	365.5	365.51	363.1891	363.3701	7412823.0
2023-08-24 12:00:00	QQQ	ETF	363.38	365.51	363.31	364.51	5626109.0
2023-08-24 13:00:00	QQQ	ETF	364.505	364.84	363.5854	363.94	4099985.0
2023-08-24 14:00:00	QQQ	ETF	363.95	364.7	362.91	363.5799	4423125.0
2023-08-24 15:00:00	QQQ	ETF	363.5799	363.75	361.01	361.09	9669749.0
2023-08-24 16:00:00	QQQ	ETF	361.11	361.42	360.1	360.45	2036597.0
2023-08-24 17:00:00	QQQ	ETF	360.46	360.48	360.0	360.48	131370.0
2023-08-24 18:00:00	QQQ	ETF	360.48	361.38	360.46	361.38	198049.0
2023-08-24 19:00:00	QQQ	ETF	361.23	361.23	360.5	360.9	135308.0
2023-08-24 04:00:00	IWM	ETF	186.01	186.29	185.78	185.8	15974.0
2023-08-24 05:00:00	IWM	ETF	185.86	185.87	185.15	185.15	15326.0
2023-08-24 06:00:00	IWM	ETF	185.36	185.68	185.36	185.66	9986.0
2023-08-24 07:00:00	IWM	ETF	185.72	185.86	185.46	185.47	42529.0
2023-08-24 08:00:00	IWM	ETF	186.23	186.34	185.18	185.3201	86653.0
2023-08-24 09:00:00	IWM	ETF	185.41	186.18	184.54	186.15	3196937.0
2023-08-24 10:00:00	IWM	ETF	186.17	186.335	184.75	184.795	3766311.0
2023-08-24 11:00:00	IWM	ETF	184.81	184.815	183.69	183.77	2843602.0
2023-08-24 12:00:00	IWM	ETF	183.77	184.485	183.685	184.04	2767603.0
2023-08-24 13:00:00	IWM	ETF	184.04	184.09	183.565	183.76	1592064.0
2023-08-24 14:00:00	IWM	ETF	183.76	183.99	183.575	183.87	1848385.0
2023-08-24 15:00:00	IWM	ETF	183.87	184.1	183.2	183.24	4477755.0
2023-08-24 16:00:00	IWM	ETF	183.22	183.38	183.05	183.34	2000039.0
2023-08-24 17:00:00	IWM	ETF	183.32	183.42	183.25	183.39	6781.0
2023-08-24 18:00:00	IWM	ETF	183.39	183.55	183.37	183.51	30022.0
2023-08-24 19:00:00	IWM	ETF	183.49	183.56	183.32	183.5	36163.0
2023-08-24 04:00:00	DIA	ETF	344.91	345.06	344.78	345.03	8345.0
2023-08-24 05:00:00	DIA	ETF	344.77	344.8	344.12	344.23	4250.0

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

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