PREVIEW / etf_1hour / 2023-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-08.parquet
  size:    490 KB
  rows:    17,681

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-08 04:00:00	SPY	ETF	449.85	449.96	449.0	449.39	41127.0
2023-08-08 05:00:00	SPY	ETF	449.39	449.39	448.42	448.84	37500.0
2023-08-08 06:00:00	SPY	ETF	448.9	449.01	448.15	448.28	50781.0
2023-08-08 07:00:00	SPY	ETF	448.34	448.38	447.2	447.67	409049.0
2023-08-08 08:00:00	SPY	ETF	448.3386	449.82	446.61	447.72	563602.0
2023-08-08 09:00:00	SPY	ETF	447.7	448.15	446.085	446.585	7782325.0
2023-08-08 10:00:00	SPY	ETF	446.585	446.875	445.4	445.5399	9950152.0
2023-08-08 11:00:00	SPY	ETF	445.54	446.29	445.2705	445.69	6113222.0
2023-08-08 12:00:00	SPY	ETF	445.69	446.955	445.63	446.59	5102032.0
2023-08-08 13:00:00	SPY	ETF	446.6	447.4081	446.54	447.2449	5296268.0
2023-08-08 14:00:00	SPY	ETF	447.25	448.57	446.94	448.33	5578337.0
2023-08-08 15:00:00	SPY	ETF	448.34	449.23	448.15	448.75	10854528.0
2023-08-08 16:00:00	SPY	ETF	448.76	448.9	448.56	448.7	2114911.0
2023-08-08 17:00:00	SPY	ETF	448.73	448.76	448.6	448.68	31756.0
2023-08-08 18:00:00	SPY	ETF	448.71	448.79	448.56	448.6	35767.0
2023-08-08 19:00:00	SPY	ETF	448.75	448.75	448.54	448.62	30979.0
2023-08-08 04:00:00	QQQ	ETF	374.13	374.69	373.43	373.93	48389.0
2023-08-08 05:00:00	QQQ	ETF	373.95	373.95	373.2	373.64	23520.0
2023-08-08 06:00:00	QQQ	ETF	373.71	373.8	373.07	373.25	49716.0
2023-08-08 07:00:00	QQQ	ETF	373.34	373.42	371.97	372.45	381249.0
2023-08-08 08:00:00	QQQ	ETF	373.3394	375.471	371.2	372.58	575693.0
2023-08-08 09:00:00	QQQ	ETF	372.55	372.85	370.12	370.6099	5385858.0
2023-08-08 10:00:00	QQQ	ETF	370.59	370.93	369.07	369.11	7647760.0
2023-08-08 11:00:00	QQQ	ETF	369.12	370.05	368.82	369.18	5105706.0
2023-08-08 12:00:00	QQQ	ETF	369.185	370.58	369.05	370.11	3363117.0
2023-08-08 13:00:00	QQQ	ETF	370.13	370.9	369.855	370.77	3197465.0
2023-08-08 14:00:00	QQQ	ETF	370.77	371.84	370.41	371.6002	3452132.0
2023-08-08 15:00:00	QQQ	ETF	371.59	372.45	371.08	371.94	4820165.0
2023-08-08 16:00:00	QQQ	ETF	371.94	372.17	371.84	371.9716	877205.0
2023-08-08 17:00:00	QQQ	ETF	371.96	372.0	371.73	371.93	66216.0
2023-08-08 18:00:00	QQQ	ETF	371.93	372.14	371.86	371.94	58522.0
2023-08-08 19:00:00	QQQ	ETF	371.94	372.07	371.84	372.0	43782.0
2023-08-08 04:00:00	IWM	ETF	193.72	193.72	193.16	193.28	19739.0
2023-08-08 05:00:00	IWM	ETF	193.3	193.3	192.51	192.87	15304.0
2023-08-08 06:00:00	IWM	ETF	192.91	192.94	192.2	192.2	22249.0
2023-08-08 07:00:00	IWM	ETF	192.3	192.31	191.76	192.04	118012.0
2023-08-08 08:00:00	IWM	ETF	192.2984	193.48	191.58	192.0	198742.0
2023-08-08 09:00:00	IWM	ETF	192.0	192.23	190.91	191.49	5046383.0
2023-08-08 10:00:00	IWM	ETF	191.48	191.54	190.52	191.18	3527222.0
2023-08-08 11:00:00	IWM	ETF	191.19	191.47	190.78	191.25	2230140.0
2023-08-08 12:00:00	IWM	ETF	191.25	191.9	191.22	191.805	1361138.0
2023-08-08 13:00:00	IWM	ETF	191.8	192.505	191.79	192.5	1958649.0
2023-08-08 14:00:00	IWM	ETF	192.5	193.03	192.33	192.89	1599284.0
2023-08-08 15:00:00	IWM	ETF	192.89	193.29	192.83	193.14	4002131.0
2023-08-08 16:00:00	IWM	ETF	193.08	193.23	192.99	193.0	556635.0
2023-08-08 17:00:00	IWM	ETF	192.98	193.1	192.93	193.1	294441.0
2023-08-08 18:00:00	IWM	ETF	193.03	193.16	192.98	192.99	22595.0
2023-08-08 19:00:00	IWM	ETF	193.03	193.05	192.94	192.94	10043.0
2023-08-08 04:00:00	DIA	ETF	354.27	354.27	353.57	353.72	1770.0
2023-08-08 05:00:00	DIA	ETF	353.42	353.42	352.97	353.12	2540.0

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

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