PREVIEW / etf_1hour / 2022-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-19.parquet
  size:    441 KB
  rows:    15,933

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-19 04:00:00	SPY	ETF	382.62	383.75	382.49	383.61	34565.0
2022-07-19 05:00:00	SPY	ETF	383.56	384.9	383.56	384.6	61629.0
2022-07-19 06:00:00	SPY	ETF	384.64	385.75	384.48	385.25	86272.0
2022-07-19 07:00:00	SPY	ETF	385.19	385.3	384.55	385.12	229809.0
2022-07-19 08:00:00	SPY	ETF	385.14	385.8	382.47	385.59	528269.0
2022-07-19 09:00:00	SPY	ETF	385.57	386.92	385.39	386.8721	6409067.0
2022-07-19 10:00:00	SPY	ETF	386.885	388.9701	386.23	388.81	8566285.0
2022-07-19 11:00:00	SPY	ETF	388.82	389.9	388.71	389.68	5600334.0
2022-07-19 12:00:00	SPY	ETF	389.675	390.5	388.79	390.4901	4999257.0
2022-07-19 13:00:00	SPY	ETF	390.49	391.63	389.78	391.5991	4941880.0
2022-07-19 14:00:00	SPY	ETF	391.6	392.34	391.05	391.7416	6948079.0
2022-07-19 15:00:00	SPY	ETF	391.765	392.87	391.34	392.25	16261113.0
2022-07-19 16:00:00	SPY	ETF	392.24	393.36	392.09	393.04	5100996.0
2022-07-19 17:00:00	SPY	ETF	393.0	393.38	393.0	393.32	51815.0
2022-07-19 18:00:00	SPY	ETF	393.32	393.33	392.72	393.01	61311.0
2022-07-19 19:00:00	SPY	ETF	393.05	393.17	392.75	393.0	41255.0
2022-07-19 04:00:00	QQQ	ETF	289.56	290.7	289.55	290.64	60707.0
2022-07-19 05:00:00	QQQ	ETF	290.6	291.54	290.58	291.29	188362.0
2022-07-19 06:00:00	QQQ	ETF	291.18	292.28	291.12	291.9	213098.0
2022-07-19 07:00:00	QQQ	ETF	291.9	292.1	291.47	291.96	243956.0
2022-07-19 08:00:00	QQQ	ETF	291.8296	292.47	289.32	292.26	525699.0
2022-07-19 09:00:00	QQQ	ETF	292.24	293.7	291.47	293.25	5875656.0
2022-07-19 10:00:00	QQQ	ETF	293.26	295.14	291.93	295.08	6391250.0
2022-07-19 11:00:00	QQQ	ETF	295.08	296.3	295.01	296.025	5200785.0
2022-07-19 12:00:00	QQQ	ETF	296.0389	296.68	295.251	296.65	3781092.0
2022-07-19 13:00:00	QQQ	ETF	296.65	297.84	296.12	297.775	3325420.0
2022-07-19 14:00:00	QQQ	ETF	297.78	298.42	297.06	297.76	5096310.0
2022-07-19 15:00:00	QQQ	ETF	297.77	298.6	297.45	298.23	9135705.0
2022-07-19 16:00:00	QQQ	ETF	298.21	300.0	298.01	299.43	2383251.0
2022-07-19 17:00:00	QQQ	ETF	299.39	300.01	299.39	299.9	186036.0
2022-07-19 18:00:00	QQQ	ETF	299.85	299.85	298.3	299.5	511541.0
2022-07-19 19:00:00	QQQ	ETF	299.46	299.6	299.2	299.42	245033.0
2022-07-19 04:00:00	IWM	ETF	172.95	173.5	172.95	173.5	17361.0
2022-07-19 05:00:00	IWM	ETF	173.57	174.1	173.49	173.9	14723.0
2022-07-19 06:00:00	IWM	ETF	173.92	174.61	173.89	174.36	11669.0
2022-07-19 07:00:00	IWM	ETF	174.3	174.3	173.89	174.2	39355.0
2022-07-19 08:00:00	IWM	ETF	173.9604	174.53	173.71	174.37	71982.0
2022-07-19 09:00:00	IWM	ETF	174.4	176.45	174.32	176.405	3024979.0
2022-07-19 10:00:00	IWM	ETF	176.41	177.57	175.89	177.31	3472584.0
2022-07-19 11:00:00	IWM	ETF	177.3	178.08	177.18	178.07	2287981.0
2022-07-19 12:00:00	IWM	ETF	178.065	178.23	177.67	178.14	1363785.0
2022-07-19 13:00:00	IWM	ETF	178.1499	178.77	177.72	178.7243	1627607.0
2022-07-19 14:00:00	IWM	ETF	178.74	178.89	178.19	178.41	2187560.0
2022-07-19 15:00:00	IWM	ETF	178.42	178.82	178.29	178.68	4435493.0
2022-07-19 16:00:00	IWM	ETF	178.69	179.07	178.49	178.77	909837.0
2022-07-19 17:00:00	IWM	ETF	178.85	178.99	178.71	178.97	11920.0
2022-07-19 18:00:00	IWM	ETF	178.91	178.91	178.59	178.84	127761.0
2022-07-19 19:00:00	IWM	ETF	178.81	178.94	178.69	178.76	60979.0
2022-07-19 04:00:00	DIA	ETF	311.46	311.6	311.46	311.6	1200.0
2022-07-19 05:00:00	DIA	ETF	311.58	312.43	311.58	312.43	969.0

> showing 50 of 15,933 rows — these rows as CSV

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