PREVIEW / etf_1hour / 2022-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-12.parquet
  size:    436 KB
  rows:    15,780

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-12 04:00:00	SPY	ETF	381.82	382.49	381.39	382.0	28746.0
2022-07-12 05:00:00	SPY	ETF	382.14	382.19	381.1	381.33	47335.0
2022-07-12 06:00:00	SPY	ETF	381.38	382.35	381.18	381.18	49729.0
2022-07-12 07:00:00	SPY	ETF	381.23	383.0	381.13	382.36	304190.0
2022-07-12 08:00:00	SPY	ETF	381.278	383.24	381.15	382.9	547749.0
2022-07-12 09:00:00	SPY	ETF	382.94	386.16	382.8	383.75	6071557.0
2022-07-12 10:00:00	SPY	ETF	383.72	384.27	382.525	384.0416	6194910.0
2022-07-12 11:00:00	SPY	ETF	384.04	385.35	383.5	384.33	4856918.0
2022-07-12 12:00:00	SPY	ETF	384.32	385.22	383.92	384.8201	3322496.0
2022-07-12 13:00:00	SPY	ETF	384.82	385.38	383.66	384.43	3230816.0
2022-07-12 14:00:00	SPY	ETF	384.4	384.51	382.48	382.5	3748197.0
2022-07-12 15:00:00	SPY	ETF	382.51	382.51	378.99	380.8802	16472313.0
2022-07-12 16:00:00	SPY	ETF	380.89	380.9	380.3	380.81	2743049.0
2022-07-12 17:00:00	SPY	ETF	380.81	380.8496	380.67	380.8496	48037.0
2022-07-12 18:00:00	SPY	ETF	380.85	381.08	380.6	380.71	66037.0
2022-07-12 19:00:00	SPY	ETF	380.75	381.21	379.98	380.64	94204.0
2022-07-12 04:00:00	QQQ	ETF	287.26	287.37	286.55	287.23	98788.0
2022-07-12 05:00:00	QQQ	ETF	287.28	287.5	286.7	286.99	42821.0
2022-07-12 06:00:00	QQQ	ETF	287.03	288.05	287.03	287.28	108324.0
2022-07-12 07:00:00	QQQ	ETF	287.25	289.38	287.2	288.8	509025.0
2022-07-12 08:00:00	QQQ	ETF	287.31	289.84	286.64	289.4	564781.0
2022-07-12 09:00:00	QQQ	ETF	289.4	292.28	288.03	288.16	8328353.0
2022-07-12 10:00:00	QQQ	ETF	288.14	289.35	286.9	288.53	8443175.0
2022-07-12 11:00:00	QQQ	ETF	288.54	289.96	288.05	289.0899	4212096.0
2022-07-12 12:00:00	QQQ	ETF	289.06	289.99	288.6	289.53	3106028.0
2022-07-12 13:00:00	QQQ	ETF	289.54	290.2	288.3501	289.23	3126377.0
2022-07-12 14:00:00	QQQ	ETF	289.23	289.32	287.432	287.45	2705037.0
2022-07-12 15:00:00	QQQ	ETF	287.45	287.46	284.61	286.19	10256057.0
2022-07-12 16:00:00	QQQ	ETF	286.22	286.31	285.88	286.21	1742568.0
2022-07-12 17:00:00	QQQ	ETF	286.2	286.39	286.05	286.13	53341.0
2022-07-12 18:00:00	QQQ	ETF	286.14	286.44	286.01	286.1	113740.0
2022-07-12 19:00:00	QQQ	ETF	286.1	286.48	285.84	286.05	200333.0
2022-07-12 04:00:00	IWM	ETF	171.48	171.48	170.71	171.08	22370.0
2022-07-12 05:00:00	IWM	ETF	171.12	171.24	170.63	170.63	12004.0
2022-07-12 06:00:00	IWM	ETF	170.75	171.21	170.52	170.52	17650.0
2022-07-12 07:00:00	IWM	ETF	170.54	171.37	170.5	170.95	73590.0
2022-07-12 08:00:00	IWM	ETF	170.49	171.56	170.49	171.23	73741.0
2022-07-12 09:00:00	IWM	ETF	171.25	173.08	171.19	171.7	2335084.0
2022-07-12 10:00:00	IWM	ETF	171.67	172.48	170.9	172.47	2143640.0
2022-07-12 11:00:00	IWM	ETF	172.46	173.01	172.13	172.525	1669651.0
2022-07-12 12:00:00	IWM	ETF	172.53	173.225	172.15	173.09	1600809.0
2022-07-12 13:00:00	IWM	ETF	173.09	173.36	172.49	173.03	1282805.0
2022-07-12 14:00:00	IWM	ETF	173.05	173.07	172.06	172.09	1335126.0
2022-07-12 15:00:00	IWM	ETF	172.09	172.09	170.56	171.51	4590537.0
2022-07-12 16:00:00	IWM	ETF	171.47	171.68	171.4	171.51	1517012.0
2022-07-12 17:00:00	IWM	ETF	171.46	171.78	171.46	171.75	39707.0
2022-07-12 18:00:00	IWM	ETF	171.75	171.75	171.51	171.52	28612.0
2022-07-12 19:00:00	IWM	ETF	171.5204	171.75	171.34	171.53	50653.0
2022-07-12 04:00:00	DIA	ETF	309.9	310.09	309.9	310.09	1105.0
2022-07-12 05:00:00	DIA	ETF	309.91	309.91	309.19	309.19	2300.0

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

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