PREVIEW / etf_1hour / 2022-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-10.parquet
  size:    461 KB
  rows:    16,458

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-02-10 04:00:00	SPY	ETF	456.7	456.7	456.0	456.4	37045.0
2022-02-10 05:00:00	SPY	ETF	456.37	456.9	456.17	456.82	17723.0
2022-02-10 06:00:00	SPY	ETF	456.94	457.0	456.54	456.54	140072.0
2022-02-10 07:00:00	SPY	ETF	456.56	457.38	456.56	457.13	97150.0
2022-02-10 08:00:00	SPY	ETF	457.17	457.883	451.99	453.1	2623042.0
2022-02-10 09:00:00	SPY	ETF	453.1	455.55	450.86	455.17	12887867.0
2022-02-10 10:00:00	SPY	ETF	455.17	457.71	455.0	455.51	14930583.0
2022-02-10 11:00:00	SPY	ETF	455.51	456.34	454.27	456.21	9219401.0
2022-02-10 12:00:00	SPY	ETF	456.2	456.535	452.75	453.72	10536454.0
2022-02-10 13:00:00	SPY	ETF	453.68	454.38	450.0	452.07	13598756.0
2022-02-10 14:00:00	SPY	ETF	452.06	452.22	449.46	449.87	10467080.0
2022-02-10 15:00:00	SPY	ETF	449.86	451.15	447.2	449.38	22818202.0
2022-02-10 16:00:00	SPY	ETF	449.39	449.44	448.04	449.08	5018590.0
2022-02-10 17:00:00	SPY	ETF	449.07	449.13	448.8	449.0	100838.0
2022-02-10 18:00:00	SPY	ETF	448.99	449.33	447.93	448.0	184082.0
2022-02-10 19:00:00	SPY	ETF	448.03	448.13	446.99	447.5	106162.0
2022-02-10 04:00:00	QQQ	ETF	365.2	365.49	364.99	365.47	58686.0
2022-02-10 05:00:00	QQQ	ETF	365.38	365.78	365.32	365.75	13619.0
2022-02-10 06:00:00	QQQ	ETF	365.79	365.9	365.44	365.63	38709.0
2022-02-10 07:00:00	QQQ	ETF	365.64	366.39	365.62	366.26	165511.0
2022-02-10 08:00:00	QQQ	ETF	365.8105	367.03	360.83	361.0	3376798.0
2022-02-10 09:00:00	QQQ	ETF	360.9	364.15	359.0	363.57	14532696.0
2022-02-10 10:00:00	QQQ	ETF	363.58	366.4885	363.22	363.8699	14289054.0
2022-02-10 11:00:00	QQQ	ETF	363.85	364.86	362.1808	364.68	10047897.0
2022-02-10 12:00:00	QQQ	ETF	364.69	365.24	360.98	362.689	9973333.0
2022-02-10 13:00:00	QQQ	ETF	362.63	363.44	359.14	361.33	10660087.0
2022-02-10 14:00:00	QQQ	ETF	361.31	361.72	358.66	359.16	7814188.0
2022-02-10 15:00:00	QQQ	ETF	359.14	360.22	356.54	358.45	14031247.0
2022-02-10 16:00:00	QQQ	ETF	358.46	358.59	357.38	358.34	2229119.0
2022-02-10 17:00:00	QQQ	ETF	358.26	358.3496	358.05	358.29	39325.0
2022-02-10 18:00:00	QQQ	ETF	358.32	358.71	357.38	357.3804	231521.0
2022-02-10 19:00:00	QQQ	ETF	357.43	357.6	356.5	357.2	277547.0
2022-02-10 04:00:00	IWM	ETF	206.13	206.22	205.86	206.04	15505.0
2022-02-10 05:00:00	IWM	ETF	206.03	206.22	205.86	206.22	9948.0
2022-02-10 06:00:00	IWM	ETF	206.23	206.35	206.04	206.3	13799.0
2022-02-10 07:00:00	IWM	ETF	206.29	206.52	206.25	206.36	29527.0
2022-02-10 08:00:00	IWM	ETF	206.36	206.84	203.46	203.72	509272.0
2022-02-10 09:00:00	IWM	ETF	203.71	206.38	202.35	206.16	4360988.0
2022-02-10 10:00:00	IWM	ETF	206.15	208.598	205.86	207.22	4935169.0
2022-02-10 11:00:00	IWM	ETF	207.27	208.38	206.68	208.28	3453763.0
2022-02-10 12:00:00	IWM	ETF	208.27	209.05	206.74	207.43	3228602.0
2022-02-10 13:00:00	IWM	ETF	207.43	207.86	204.12	205.56	4328718.0
2022-02-10 14:00:00	IWM	ETF	205.57	205.57	203.51	203.78	3799303.0
2022-02-10 15:00:00	IWM	ETF	203.81	204.42	202.12	203.52	6759682.0
2022-02-10 16:00:00	IWM	ETF	203.44	203.59	202.7	203.2	926039.0
2022-02-10 17:00:00	IWM	ETF	203.29	203.44	202.86	203.14	791158.0
2022-02-10 18:00:00	IWM	ETF	203.13	203.44	202.4	202.42	93725.0
2022-02-10 19:00:00	IWM	ETF	202.52	202.56	201.85	202.1404	56829.0
2022-02-10 04:00:00	DIA	ETF	357.7	357.72	357.53	357.53	1603.0
2022-02-10 06:00:00	DIA	ETF	357.79	357.79	357.79	357.79	2000.0

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

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