PREVIEW / etf_1hour / 2022-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-20.parquet
  size:    438 KB
  rows:    16,206

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-09-20 04:00:00	SPY	ETF	388.33	388.98	387.39	387.78	85900.0
2022-09-20 05:00:00	SPY	ETF	387.96	387.96	386.51	386.9	71694.0
2022-09-20 06:00:00	SPY	ETF	386.79	387.04	386.31	387.02	125140.0
2022-09-20 07:00:00	SPY	ETF	387.03	387.43	386.69	386.74	204555.0
2022-09-20 08:00:00	SPY	ETF	386.9835	390.18	385.34	385.9	487734.0
2022-09-20 09:00:00	SPY	ETF	385.885	386.17	383.41	383.88	6823938.0
2022-09-20 10:00:00	SPY	ETF	383.87	384.76	382.74	384.65	7787661.0
2022-09-20 11:00:00	SPY	ETF	384.66	385.86	384.13	385.68	5935106.0
2022-09-20 12:00:00	SPY	ETF	385.7	386.12	383.82	384.21	5646692.0
2022-09-20 13:00:00	SPY	ETF	384.21	384.32	381.195	381.41	7271644.0
2022-09-20 14:00:00	SPY	ETF	381.405	383.65	381.35	383.33	8182054.0
2022-09-20 15:00:00	SPY	ETF	383.325	385.47	382.85	384.17	13765100.0
2022-09-20 16:00:00	SPY	ETF	384.16	384.98	384.09	384.74	2531650.0
2022-09-20 17:00:00	SPY	ETF	384.71	384.74	384.5	384.58	71701.0
2022-09-20 18:00:00	SPY	ETF	384.59	384.63	384.01	384.44	107889.0
2022-09-20 19:00:00	SPY	ETF	384.42	384.5	383.83	384.34	78762.0
2022-09-20 04:00:00	QQQ	ETF	290.96	290.96	289.88	290.32	87031.0
2022-09-20 05:00:00	QQQ	ETF	290.25	290.34	289.3	289.56	105551.0
2022-09-20 06:00:00	QQQ	ETF	289.55	289.77	289.1	289.67	77667.0
2022-09-20 07:00:00	QQQ	ETF	289.72	290.16	289.32	289.39	272597.0
2022-09-20 08:00:00	QQQ	ETF	289.72	292.0	288.47	289.05	580297.0
2022-09-20 09:00:00	QQQ	ETF	289.06	289.27	287.79	288.6	6273767.0
2022-09-20 10:00:00	QQQ	ETF	288.59	289.68	287.8601	289.51	7255472.0
2022-09-20 11:00:00	QQQ	ETF	289.5	290.92	289.1163	290.85	4016115.0
2022-09-20 12:00:00	QQQ	ETF	290.89	291.07	288.94	289.3	3477200.0
2022-09-20 13:00:00	QQQ	ETF	289.31	289.41	286.38	286.57	4528053.0
2022-09-20 14:00:00	QQQ	ETF	286.55	288.5	286.49	288.24	5281958.0
2022-09-20 15:00:00	QQQ	ETF	288.25	289.77	287.9	288.69	7937764.0
2022-09-20 16:00:00	QQQ	ETF	288.72	289.41	288.7	289.25	1081699.0
2022-09-20 17:00:00	QQQ	ETF	289.23	289.35	288.73	289.03	497236.0
2022-09-20 18:00:00	QQQ	ETF	289.04	289.13	288.7	288.86	68943.0
2022-09-20 19:00:00	QQQ	ETF	288.88	288.95	288.33	288.73	138498.0
2022-09-20 04:00:00	IWM	ETF	180.45	180.54	180.0	180.37	15254.0
2022-09-20 05:00:00	IWM	ETF	180.32	180.38	179.58	179.76	18097.0
2022-09-20 06:00:00	IWM	ETF	179.53	179.87	179.24	179.78	16041.0
2022-09-20 07:00:00	IWM	ETF	179.83	180.07	179.69	179.72	32466.0
2022-09-20 08:00:00	IWM	ETF	179.79	179.9896	178.92	179.35	141502.0
2022-09-20 09:00:00	IWM	ETF	179.35	179.48	177.66	177.79	2611449.0
2022-09-20 10:00:00	IWM	ETF	177.81	178.41	177.32	178.24	2318292.0
2022-09-20 11:00:00	IWM	ETF	178.22	178.83	177.975	178.735	1754896.0
2022-09-20 12:00:00	IWM	ETF	178.74	178.94	177.88	178.15	1130448.0
2022-09-20 13:00:00	IWM	ETF	178.15	178.19	176.71	176.77	1176465.0
2022-09-20 14:00:00	IWM	ETF	176.765	177.79	176.76	177.72	2066547.0
2022-09-20 15:00:00	IWM	ETF	177.7	178.6	177.51	178.08	3665993.0
2022-09-20 16:00:00	IWM	ETF	178.06	178.53	177.9478	178.48	672534.0
2022-09-20 17:00:00	IWM	ETF	178.42	178.42	178.06	178.3	207583.0
2022-09-20 18:00:00	IWM	ETF	178.34	178.4	178.13	178.32	18848.0
2022-09-20 19:00:00	IWM	ETF	178.37	178.4	178.04	178.32	30765.0
2022-09-20 04:00:00	DIA	ETF	309.5	309.94	309.5	309.92	3300.0
2022-09-20 05:00:00	DIA	ETF	309.62	309.62	308.95	308.95	4800.0

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

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