PREVIEW / etf_1hour / 2022-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-25.parquet
  size:    445 KB
  rows:    16,254

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
2022-05-25 04:00:00	SPY	ETF	394.62	394.62	393.35	393.8	58902.0
2022-05-25 05:00:00	SPY	ETF	393.69	394.21	392.71	394.18	35180.0
2022-05-25 06:00:00	SPY	ETF	394.09	394.41	392.91	392.99	74019.0
2022-05-25 07:00:00	SPY	ETF	393.01	393.41	391.39	392.07	510209.0
2022-05-25 08:00:00	SPY	ETF	393.11	396.54	391.17	392.35	429718.0
2022-05-25 09:00:00	SPY	ETF	392.3	395.36	391.89	394.44	6905786.0
2022-05-25 10:00:00	SPY	ETF	394.43	397.44	393.52	396.3601	8190261.0
2022-05-25 11:00:00	SPY	ETF	396.37	396.48	394.17	395.15	5911122.0
2022-05-25 12:00:00	SPY	ETF	395.14	395.75	393.122	394.45	5206194.0
2022-05-25 13:00:00	SPY	ETF	394.44	395.19	393.29	394.48	4377488.0
2022-05-25 14:00:00	SPY	ETF	394.5	397.91	392.57	397.655	12348226.0
2022-05-25 15:00:00	SPY	ETF	397.68	399.45	396.4	397.55	17442972.0
2022-05-25 16:00:00	SPY	ETF	397.55	397.61	395.43	396.65	4313872.0
2022-05-25 17:00:00	SPY	ETF	396.79	396.83	396.57	396.76	70598.0
2022-05-25 18:00:00	SPY	ETF	396.88	397.33	396.8	397.27	109728.0
2022-05-25 19:00:00	SPY	ETF	397.26	397.49	396.56	396.69	120759.0
2022-05-25 04:00:00	QQQ	ETF	289.5	289.5	286.8	287.41	101965.0
2022-05-25 05:00:00	QQQ	ETF	287.3	287.68	286.17	287.34	56342.0
2022-05-25 06:00:00	QQQ	ETF	287.4	287.82	286.53	286.64	90513.0
2022-05-25 07:00:00	QQQ	ETF	286.63	286.94	284.7	285.23	360404.0
2022-05-25 08:00:00	QQQ	ETF	286.81	289.42	284.61	285.66	707132.0
2022-05-25 09:00:00	QQQ	ETF	285.71	289.09	285.45	287.82	8462324.0
2022-05-25 10:00:00	QQQ	ETF	287.82	290.84	286.59	289.62	9111108.0
2022-05-25 11:00:00	QQQ	ETF	289.66	290.19	288.06	289.055	4247008.0
2022-05-25 12:00:00	QQQ	ETF	289.03	289.485	287.43	288.67	3107027.0
2022-05-25 13:00:00	QQQ	ETF	288.63	289.38	287.5399	288.88	2628526.0
2022-05-25 14:00:00	QQQ	ETF	288.875	291.96	287.0	291.81	11336095.0
2022-05-25 15:00:00	QQQ	ETF	291.825	293.39	290.11	291.36	10117499.0
2022-05-25 16:00:00	QQQ	ETF	291.31	291.38	288.01	289.93	3009619.0
2022-05-25 17:00:00	QQQ	ETF	289.76	291.26	289.0	289.7	188385.0
2022-05-25 18:00:00	QQQ	ETF	289.95	290.58	289.89	290.38	202078.0
2022-05-25 19:00:00	QQQ	ETF	290.47	290.65	289.87	289.92	106503.0
2022-05-25 04:00:00	IWM	ETF	176.0	176.0	175.28	175.76	19834.0
2022-05-25 05:00:00	IWM	ETF	175.57	175.99	175.2	175.94	13475.0
2022-05-25 06:00:00	IWM	ETF	176.0	176.1	175.12	175.12	65875.0
2022-05-25 07:00:00	IWM	ETF	175.12	175.3	174.47	174.84	102063.0
2022-05-25 08:00:00	IWM	ETF	174.78	175.12	174.49	175.08	81473.0
2022-05-25 09:00:00	IWM	ETF	175.04	176.84	174.81	176.59	2730670.0
2022-05-25 10:00:00	IWM	ETF	176.58	178.777	176.27	178.05	4147363.0
2022-05-25 11:00:00	IWM	ETF	178.04	178.28	176.87	177.47	1628948.0
2022-05-25 12:00:00	IWM	ETF	177.46	177.84	176.6	177.39	1555522.0
2022-05-25 13:00:00	IWM	ETF	177.335	177.57	176.8	177.28	1225836.0
2022-05-25 14:00:00	IWM	ETF	177.27	179.0	176.28	178.87	4683753.0
2022-05-25 15:00:00	IWM	ETF	178.88	179.78	178.43	178.82	4416780.0
2022-05-25 16:00:00	IWM	ETF	178.81	178.88	178.18	178.73	1421286.0
2022-05-25 17:00:00	IWM	ETF	178.71	178.89	178.52	178.59	15074.0
2022-05-25 18:00:00	IWM	ETF	178.68	179.03	178.68	178.88	22699.0
2022-05-25 19:00:00	IWM	ETF	178.89	179.04	178.53	178.64	25714.0
2022-05-25 04:00:00	DIA	ETF	319.05	319.05	319.0	319.0	700.0
2022-05-25 05:00:00	DIA	ETF	318.55	319.04	318.55	319.04	200.0

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

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