PREVIEW / etf_1hour / 2022-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-10.parquet
  size:    455 KB
  rows:    16,760

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-06-10 04:00:00	SPY	ETF	400.9	402.35	400.9	401.35	65552.0
2022-06-10 05:00:00	SPY	ETF	401.3	402.08	401.22	401.28	21517.0
2022-06-10 06:00:00	SPY	ETF	401.51	401.57	400.6	400.97	84293.0
2022-06-10 07:00:00	SPY	ETF	401.1	402.05	400.88	401.3	225028.0
2022-06-10 08:00:00	SPY	ETF	401.1	402.3	394.73	394.79	3630929.0
2022-06-10 09:00:00	SPY	ETF	394.79	396.52	392.92	393.38	11108475.0
2022-06-10 10:00:00	SPY	ETF	393.39	393.39	390.18	390.84	14646029.0
2022-06-10 11:00:00	SPY	ETF	390.85	391.6	389.87	391.07	8487891.0
2022-06-10 12:00:00	SPY	ETF	391.07	391.89	390.04	390.56	6788554.0
2022-06-10 13:00:00	SPY	ETF	390.57	392.81	389.93	391.62	9962637.0
2022-06-10 14:00:00	SPY	ETF	391.63	393.45	390.87	393.1	8183893.0
2022-06-10 15:00:00	SPY	ETF	393.1	394.25	389.75	389.82	25663221.0
2022-06-10 16:00:00	SPY	ETF	389.81	391.21	389.53	390.55	6354147.0
2022-06-10 17:00:00	SPY	ETF	390.73	390.95	389.8	390.85	197667.0
2022-06-10 18:00:00	SPY	ETF	390.85	390.89	390.05	390.05	105185.0
2022-06-10 19:00:00	SPY	ETF	390.11	390.33	390.1	390.29	30442.0
2022-06-10 04:00:00	QQQ	ETF	299.0	300.56	299.0	299.74	76327.0
2022-06-10 05:00:00	QQQ	ETF	299.7	300.68	299.7	300.05	29719.0
2022-06-10 06:00:00	QQQ	ETF	300.22	300.22	299.34	299.56	48554.0
2022-06-10 07:00:00	QQQ	ETF	299.76	300.49	299.45	299.83	274161.0
2022-06-10 08:00:00	QQQ	ETF	299.8299	300.72	293.49	293.52	4480613.0
2022-06-10 09:00:00	QQQ	ETF	293.55	294.87	291.24	291.7251	10578082.0
2022-06-10 10:00:00	QQQ	ETF	291.68	291.69	289.095	289.19	12425181.0
2022-06-10 11:00:00	QQQ	ETF	289.19	289.78	288.384	289.37	7454687.0
2022-06-10 12:00:00	QQQ	ETF	289.38	289.989	288.67	289.29	5227027.0
2022-06-10 13:00:00	QQQ	ETF	289.29	291.369	288.69	290.25	5552003.0
2022-06-10 14:00:00	QQQ	ETF	290.24	291.44	289.64	291.11	4970814.0
2022-06-10 15:00:00	QQQ	ETF	291.11	292.04	288.64	288.68	12334292.0
2022-06-10 16:00:00	QQQ	ETF	288.68	289.6	288.65	289.26	2055638.0
2022-06-10 17:00:00	QQQ	ETF	289.03	289.22	288.84	289.08	186086.0
2022-06-10 18:00:00	QQQ	ETF	289.08	289.23	288.92	288.92	28759.0
2022-06-10 19:00:00	QQQ	ETF	288.92	289.0	288.6	288.65	43046.0
2022-06-10 04:00:00	IWM	ETF	183.92	183.92	183.49	183.5	2971.0
2022-06-10 05:00:00	IWM	ETF	183.61	183.61	183.47	183.47	3470.0
2022-06-10 06:00:00	IWM	ETF	183.54	183.54	183.12	183.22	22200.0
2022-06-10 07:00:00	IWM	ETF	183.41	183.82	183.27	183.43	41718.0
2022-06-10 08:00:00	IWM	ETF	183.3	183.95	180.62	180.65	610834.0
2022-06-10 09:00:00	IWM	ETF	180.64	181.55	180.1101	180.58	3570132.0
2022-06-10 10:00:00	IWM	ETF	180.5	180.58	178.54	178.84	4184956.0
2022-06-10 11:00:00	IWM	ETF	178.85	178.94	177.88	178.52	2692121.0
2022-06-10 12:00:00	IWM	ETF	178.525	178.985	177.67	178.04	2333539.0
2022-06-10 13:00:00	IWM	ETF	178.05	179.01	177.65	178.36	2176888.0
2022-06-10 14:00:00	IWM	ETF	178.37	179.265	177.99	179.1	2298065.0
2022-06-10 15:00:00	IWM	ETF	179.1	180.01	178.48	178.61	6225959.0
2022-06-10 16:00:00	IWM	ETF	178.59	179.5	178.42	178.85	1544994.0
2022-06-10 17:00:00	IWM	ETF	179.21	187.59	178.69	178.92	35129.0
2022-06-10 18:00:00	IWM	ETF	178.92	178.92	178.63	178.73	11914.0
2022-06-10 19:00:00	IWM	ETF	178.64	179.08	178.63	178.88	8334.0
2022-06-10 04:00:00	DIA	ETF	322.75	323.34	322.75	323.2	3490.0
2022-06-10 05:00:00	DIA	ETF	322.8	322.8	322.8	322.8	500.0

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

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