PREVIEW / etf_1hour / 2023-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-09.parquet
  size:    479 KB
  rows:    17,417

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-08-09 04:00:00	SPY	ETF	449.96	450.6	449.62	450.52	26405.0
2023-08-09 05:00:00	SPY	ETF	450.48	450.63	449.98	450.12	10738.0
2023-08-09 06:00:00	SPY	ETF	450.19	450.4	449.8	449.8	10158.0
2023-08-09 07:00:00	SPY	ETF	449.78	450.3	449.43	450.19	191110.0
2023-08-09 08:00:00	SPY	ETF	449.47	450.6204	449.26	449.5	348910.0
2023-08-09 09:00:00	SPY	ETF	449.43	449.61	448.03	448.3405	4309935.0
2023-08-09 10:00:00	SPY	ETF	448.35	448.805	447.26	447.39	6621089.0
2023-08-09 11:00:00	SPY	ETF	447.395	447.7	444.96	445.395	9282838.0
2023-08-09 12:00:00	SPY	ETF	445.39	446.64	445.255	446.26	5473391.0
2023-08-09 13:00:00	SPY	ETF	446.2501	447.86	446.05	447.5205	5968221.0
2023-08-09 14:00:00	SPY	ETF	447.525	448.8864	447.36	448.21	6570090.0
2023-08-09 15:00:00	SPY	ETF	448.21	448.28	445.43	445.75	19542119.0
2023-08-09 16:00:00	SPY	ETF	445.74	446.47	445.6775	446.43	4834943.0
2023-08-09 17:00:00	SPY	ETF	446.44	446.49	446.2	446.36	82433.0
2023-08-09 18:00:00	SPY	ETF	446.4	446.73	446.4	446.65	55902.0
2023-08-09 19:00:00	SPY	ETF	446.66	446.91	446.58	446.81	32158.0
2023-08-09 04:00:00	QQQ	ETF	373.24	373.88	373.1	373.75	37246.0
2023-08-09 05:00:00	QQQ	ETF	373.74	373.76	373.13	373.26	24534.0
2023-08-09 06:00:00	QQQ	ETF	373.21	373.36	372.81	372.81	16736.0
2023-08-09 07:00:00	QQQ	ETF	372.86	373.3	372.4	373.17	165655.0
2023-08-09 08:00:00	QQQ	ETF	372.8	373.7104	372.279	372.51	268468.0
2023-08-09 09:00:00	QQQ	ETF	372.52	372.65	369.93	370.3117	4250844.0
2023-08-09 10:00:00	QQQ	ETF	370.34	370.855	368.52	368.5412	5524843.0
2023-08-09 11:00:00	QQQ	ETF	368.54	369.04	367.14	367.61	6377225.0
2023-08-09 12:00:00	QQQ	ETF	367.61	368.86	367.5	368.15	3693491.0
2023-08-09 13:00:00	QQQ	ETF	368.145	369.935	367.93	369.571	3152607.0
2023-08-09 14:00:00	QQQ	ETF	369.58	370.97	369.3801	370.14	4204410.0
2023-08-09 15:00:00	QQQ	ETF	370.145	370.25	367.58	367.87	9177145.0
2023-08-09 16:00:00	QQQ	ETF	367.88	368.61	367.8004	368.45	2467912.0
2023-08-09 17:00:00	QQQ	ETF	368.45	368.63	368.25	368.35	81927.0
2023-08-09 18:00:00	QQQ	ETF	368.39	368.86	368.39	368.7499	89875.0
2023-08-09 19:00:00	QQQ	ETF	368.74	368.96	368.47	368.86	74093.0
2023-08-09 04:00:00	IWM	ETF	193.8	194.06	193.7	194.04	22971.0
2023-08-09 05:00:00	IWM	ETF	194.01	194.09	193.77	193.84	5795.0
2023-08-09 06:00:00	IWM	ETF	193.88	194.04	193.74	193.74	28082.0
2023-08-09 07:00:00	IWM	ETF	193.67	194.0	193.47	193.88	51998.0
2023-08-09 08:00:00	IWM	ETF	193.54	194.02	193.14	193.17	41550.0
2023-08-09 09:00:00	IWM	ETF	193.12	193.23	191.8	192.5	3052846.0
2023-08-09 10:00:00	IWM	ETF	192.5	192.82	191.61	191.94	2762009.0
2023-08-09 11:00:00	IWM	ETF	191.96	192.22	190.75	190.98	2517312.0
2023-08-09 12:00:00	IWM	ETF	190.97	191.54	190.89	191.43	1658065.0
2023-08-09 13:00:00	IWM	ETF	191.42	192.0505	191.33	191.89	1367233.0
2023-08-09 14:00:00	IWM	ETF	191.88	192.62	191.81	192.15	1895211.0
2023-08-09 15:00:00	IWM	ETF	192.145	192.25	191.31	191.565	4037198.0
2023-08-09 16:00:00	IWM	ETF	191.57	191.85	191.57	191.75	829403.0
2023-08-09 17:00:00	IWM	ETF	191.82	191.95	191.61	191.72	7525.0
2023-08-09 18:00:00	IWM	ETF	191.77	191.91	191.77	191.82	11153.0
2023-08-09 19:00:00	IWM	ETF	191.84	192.01	191.81	191.92	30568.0
2023-08-09 04:00:00	DIA	ETF	353.67	353.92	353.61	353.92	2325.0
2023-08-09 05:00:00	DIA	ETF	353.93	353.98	353.82	353.82	600.0

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

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