PREVIEW / etf_1hour / 2022-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-20.parquet
  size:    442 KB
  rows:    16,198

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-07-20 04:00:00	SPY	ETF	393.11	393.57	392.52	392.84	46872.0
2022-07-20 05:00:00	SPY	ETF	392.82	393.33	392.79	393.17	13140.0
2022-07-20 06:00:00	SPY	ETF	393.24	393.25	391.0	391.71	129588.0
2022-07-20 07:00:00	SPY	ETF	391.76	391.95	391.25	391.46	277762.0
2022-07-20 08:00:00	SPY	ETF	391.49	394.32	390.89	391.93	737469.0
2022-07-20 09:00:00	SPY	ETF	391.91	392.93	391.31	391.4593	4857671.0
2022-07-20 10:00:00	SPY	ETF	391.46	395.95	391.03	395.95	8976911.0
2022-07-20 11:00:00	SPY	ETF	395.95	395.978	394.65	395.77	5399091.0
2022-07-20 12:00:00	SPY	ETF	395.77	396.26	393.36	394.69	6662114.0
2022-07-20 13:00:00	SPY	ETF	394.68	394.77	392.42	392.5401	6745239.0
2022-07-20 14:00:00	SPY	ETF	392.54	394.885	392.47	394.5399	5793416.0
2022-07-20 15:00:00	SPY	ETF	394.52	395.83	394.3572	394.79	10546801.0
2022-07-20 16:00:00	SPY	ETF	394.8	395.32	393.94	394.04	3742679.0
2022-07-20 17:00:00	SPY	ETF	393.9	394.77	393.9	394.14	109585.0
2022-07-20 18:00:00	SPY	ETF	394.03	394.17	393.53	393.67	62012.0
2022-07-20 19:00:00	SPY	ETF	393.67	394.51	393.13	394.21	86558.0
2022-07-20 04:00:00	QQQ	ETF	298.6	299.44	298.49	299.06	75822.0
2022-07-20 05:00:00	QQQ	ETF	299.01	299.5	298.95	299.42	49020.0
2022-07-20 06:00:00	QQQ	ETF	299.35	299.42	297.5	298.19	163742.0
2022-07-20 07:00:00	QQQ	ETF	298.18	298.33	297.76	297.88	317188.0
2022-07-20 08:00:00	QQQ	ETF	297.88	300.0	297.4	298.15	789834.0
2022-07-20 09:00:00	QQQ	ETF	298.13	300.21	297.9329	298.62	7452358.0
2022-07-20 10:00:00	QQQ	ETF	298.63	303.5	298.28	303.48	9296822.0
2022-07-20 11:00:00	QQQ	ETF	303.49	304.015	302.32	303.7005	6182979.0
2022-07-20 12:00:00	QQQ	ETF	303.71	304.24	301.43	302.81	6687916.0
2022-07-20 13:00:00	QQQ	ETF	302.8	302.95	300.35	300.8404	6897153.0
2022-07-20 14:00:00	QQQ	ETF	300.865	302.94	300.77	302.6874	3918987.0
2022-07-20 15:00:00	QQQ	ETF	302.68	303.84	302.51	303.02	7158699.0
2022-07-20 16:00:00	QQQ	ETF	303.01	303.7	301.9	302.11	3446482.0
2022-07-20 17:00:00	QQQ	ETF	302.15	302.41	301.95	302.34	60475.0
2022-07-20 18:00:00	QQQ	ETF	302.31	302.43	301.67	301.95	258752.0
2022-07-20 19:00:00	QQQ	ETF	301.95	302.53	301.92	302.23	183104.0
2022-07-20 04:00:00	IWM	ETF	178.86	179.33	178.77	178.87	22099.0
2022-07-20 05:00:00	IWM	ETF	178.92	179.15	178.78	179.03	8112.0
2022-07-20 06:00:00	IWM	ETF	179.0	179.03	177.89	178.35	29692.0
2022-07-20 07:00:00	IWM	ETF	178.4	178.46	178.0	178.27	83774.0
2022-07-20 08:00:00	IWM	ETF	178.3	178.65	177.79	178.5	85502.0
2022-07-20 09:00:00	IWM	ETF	178.51	179.8093	178.29	178.75	2461895.0
2022-07-20 10:00:00	IWM	ETF	178.77	181.41	178.48	181.4	3748293.0
2022-07-20 11:00:00	IWM	ETF	181.42	181.42	180.61	181.09	2169094.0
2022-07-20 12:00:00	IWM	ETF	181.09	181.45	179.71	180.33	1926661.0
2022-07-20 13:00:00	IWM	ETF	180.33	180.54	179.34	179.82	1880289.0
2022-07-20 14:00:00	IWM	ETF	179.82	181.05	179.76	180.96	1561342.0
2022-07-20 15:00:00	IWM	ETF	180.98	181.81	180.89	181.51	3886380.0
2022-07-20 16:00:00	IWM	ETF	181.49	181.63	180.86	180.86	2136640.0
2022-07-20 17:00:00	IWM	ETF	181.01	181.01	180.72	180.81	66487.0
2022-07-20 18:00:00	IWM	ETF	180.81	180.99	180.47	180.6	154367.0
2022-07-20 19:00:00	IWM	ETF	180.59	181.02	180.5	180.82	45192.0
2022-07-20 04:00:00	DIA	ETF	318.31	318.41	318.31	318.39	1300.0
2022-07-20 05:00:00	DIA	ETF	318.39	318.58	318.39	318.58	800.0

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

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