PREVIEW / etf_1hour / 2023-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-14.parquet
  size:    485 KB
  rows:    17,536

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
2023-07-14 04:00:00	SPY	ETF	449.51	449.63	449.36	449.36	21874.0
2023-07-14 05:00:00	SPY	ETF	449.39	449.45	449.16	449.36	9408.0
2023-07-14 06:00:00	SPY	ETF	449.3	450.02	449.3	449.92	63652.0
2023-07-14 07:00:00	SPY	ETF	449.93	450.33	449.92	450.17	132343.0
2023-07-14 08:00:00	SPY	ETF	450.06	450.61	449.27	450.51	348659.0
2023-07-14 09:00:00	SPY	ETF	450.43	451.09	450.19	451.03	5828927.0
2023-07-14 10:00:00	SPY	ETF	451.03	451.36	449.52	450.155	10080793.0
2023-07-14 11:00:00	SPY	ETF	450.155	450.815	450.05	450.49	5548576.0
2023-07-14 12:00:00	SPY	ETF	450.5	450.54	449.56	449.8096	4749859.0
2023-07-14 13:00:00	SPY	ETF	449.81	450.14	449.19	449.8387	4289476.0
2023-07-14 14:00:00	SPY	ETF	449.84	450.26	449.19	449.2699	4575897.0
2023-07-14 15:00:00	SPY	ETF	449.265	449.55	448.49	449.28	12035210.0
2023-07-14 16:00:00	SPY	ETF	449.27	449.28	448.8	448.82	2607709.0
2023-07-14 17:00:00	SPY	ETF	448.85	449.03	448.82	448.9	151864.0
2023-07-14 18:00:00	SPY	ETF	448.84	449.39	448.84	449.3	37496.0
2023-07-14 19:00:00	SPY	ETF	449.27	449.3	449.15	449.19	8632.0
2023-07-14 04:00:00	QQQ	ETF	379.5	379.97	379.3	379.3	61451.0
2023-07-14 05:00:00	QQQ	ETF	379.29	379.36	378.76	378.81	31428.0
2023-07-14 06:00:00	QQQ	ETF	378.85	379.1	378.73	378.84	81609.0
2023-07-14 07:00:00	QQQ	ETF	378.86	379.49	378.83	379.35	260833.0
2023-07-14 08:00:00	QQQ	ETF	379.01	379.9504	378.89	379.33	334436.0
2023-07-14 09:00:00	QQQ	ETF	379.32	381.768	379.15	381.67	5905541.0
2023-07-14 10:00:00	QQQ	ETF	381.63	382.86	380.34	381.16	9680069.0
2023-07-14 11:00:00	QQQ	ETF	381.1882	382.2499	381.04	381.86	4372206.0
2023-07-14 12:00:00	QQQ	ETF	381.865	381.9	380.385	380.62	3904672.0
2023-07-14 13:00:00	QQQ	ETF	380.62	380.665	379.65	380.03	3884170.0
2023-07-14 14:00:00	QQQ	ETF	380.04	380.5801	378.9	378.96	4011009.0
2023-07-14 15:00:00	QQQ	ETF	378.95	379.16	378.18	379.1	7866472.0
2023-07-14 16:00:00	QQQ	ETF	379.1	379.3	378.83	378.9	1882299.0
2023-07-14 17:00:00	QQQ	ETF	378.88	378.9399	378.76	378.87	42631.0
2023-07-14 18:00:00	QQQ	ETF	378.85	379.03	378.8	379.01	9531.0
2023-07-14 19:00:00	QQQ	ETF	379.01	379.12	378.92	379.11	20965.0
2023-07-14 04:00:00	IWM	ETF	193.09	193.17	192.97	193.0	10168.0
2023-07-14 05:00:00	IWM	ETF	192.96	193.01	192.86	192.86	6010.0
2023-07-14 06:00:00	IWM	ETF	192.92	193.16	192.85	193.07	30478.0
2023-07-14 07:00:00	IWM	ETF	193.09	193.31	193.03	193.26	44264.0
2023-07-14 08:00:00	IWM	ETF	192.9004	193.53	192.9004	193.5	259361.0
2023-07-14 09:00:00	IWM	ETF	193.44	193.51	191.93	192.14	3425405.0
2023-07-14 10:00:00	IWM	ETF	192.11	192.15	190.29	190.91	5887310.0
2023-07-14 11:00:00	IWM	ETF	190.92	191.5166	190.85	191.37	3140183.0
2023-07-14 12:00:00	IWM	ETF	191.38	191.72	191.0	191.58	2091384.0
2023-07-14 13:00:00	IWM	ETF	191.59	191.83	191.26	191.64	1994398.0
2023-07-14 14:00:00	IWM	ETF	191.64	191.73	191.195	191.32	2612311.0
2023-07-14 15:00:00	IWM	ETF	191.31	191.64	191.06	191.59	3789902.0
2023-07-14 16:00:00	IWM	ETF	191.59	191.63	191.36	191.41	1508864.0
2023-07-14 17:00:00	IWM	ETF	191.4	191.51	191.26	191.51	44291.0
2023-07-14 18:00:00	IWM	ETF	191.5	191.69	191.5	191.65	9707.0
2023-07-14 19:00:00	IWM	ETF	191.65	191.65	191.53	191.53	15584.0
2023-07-14 04:00:00	DIA	ETF	343.64	343.7	343.54	343.7	509.0
2023-07-14 05:00:00	DIA	ETF	343.74	344.39	343.74	344.29	16115.0

> showing 50 of 17,536 rows — these rows as CSV

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