PREVIEW / etf_1hour / 2021-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-20.parquet
  size:    466 KB
  rows:    16,532

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
2021-09-20 04:00:00	SPY	ETF	436.91	439.49	436.03	436.37	318315.0
2021-09-20 05:00:00	SPY	ETF	436.42	436.5	435.15	435.52	442392.0
2021-09-20 06:00:00	SPY	ETF	435.48	436.15	435.48	435.52	134642.0
2021-09-20 07:00:00	SPY	ETF	435.54	435.96	434.5	434.54	1066001.0
2021-09-20 08:00:00	SPY	ETF	434.53	438.6	433.48	434.15	1407332.0
2021-09-20 09:00:00	SPY	ETF	434.23	436.56	433.79	435.72	16983454.0
2021-09-20 10:00:00	SPY	ETF	435.75	435.84	433.88	434.17	19964355.0
2021-09-20 11:00:00	SPY	ETF	434.15	435.22	432.85	432.8868	11961333.0
2021-09-20 12:00:00	SPY	ETF	432.885	433.02	431.59	431.62	11258838.0
2021-09-20 13:00:00	SPY	ETF	431.615	432.4	430.69	431.99	10574537.0
2021-09-20 14:00:00	SPY	ETF	432.01	432.35	429.17	429.71	17593880.0
2021-09-20 15:00:00	SPY	ETF	429.695	434.42	428.86	434.06	34627657.0
2021-09-20 16:00:00	SPY	ETF	434.07	434.34	432.96	433.69	7051715.0
2021-09-20 17:00:00	SPY	ETF	433.83	434.02	433.66	433.79	229660.0
2021-09-20 18:00:00	SPY	ETF	433.71	434.4	433.71	434.17	430336.0
2021-09-20 19:00:00	SPY	ETF	434.14	435.05	433.61	435.05	151788.0
2021-09-20 04:00:00	QQQ	ETF	372.48	372.48	369.43	369.8	163984.0
2021-09-20 05:00:00	QQQ	ETF	369.72	369.88	368.9	369.34	71054.0
2021-09-20 06:00:00	QQQ	ETF	369.36	369.94	369.19	369.44	96760.0
2021-09-20 07:00:00	QQQ	ETF	369.45	369.67	367.8	368.001	724240.0
2021-09-20 08:00:00	QQQ	ETF	368.0	375.1625	366.84	367.34	1181013.0
2021-09-20 09:00:00	QQQ	ETF	367.33	369.25	366.49	368.17	7856287.0
2021-09-20 10:00:00	QQQ	ETF	368.17	368.26	365.32	365.53	9742995.0
2021-09-20 11:00:00	QQQ	ETF	365.465	366.66	364.51	364.57	5094038.0
2021-09-20 12:00:00	QQQ	ETF	364.55	364.67	363.4	363.6	4921981.0
2021-09-20 13:00:00	QQQ	ETF	363.6	364.36	362.79	363.77	5349494.0
2021-09-20 14:00:00	QQQ	ETF	363.81	364.1	361.04	361.68	7156821.0
2021-09-20 15:00:00	QQQ	ETF	361.67	365.93	360.93	365.82	15126010.0
2021-09-20 16:00:00	QQQ	ETF	365.71	365.96	364.86	365.31	2475917.0
2021-09-20 17:00:00	QQQ	ETF	365.39	365.9	365.03	365.51	151557.0
2021-09-20 18:00:00	QQQ	ETF	365.51	365.9	365.41	365.63	139356.0
2021-09-20 19:00:00	QQQ	ETF	365.63	366.3	365.13	366.22	142008.0
2021-09-20 04:00:00	IWM	ETF	220.29	220.29	218.64	218.95	46628.0
2021-09-20 05:00:00	IWM	ETF	218.91	219.0	217.97	218.0	106811.0
2021-09-20 06:00:00	IWM	ETF	218.09	218.44	217.83	217.96	126957.0
2021-09-20 07:00:00	IWM	ETF	218.07	218.38	217.1	217.13	346095.0
2021-09-20 08:00:00	IWM	ETF	217.09	219.83	216.4	216.96	506486.0
2021-09-20 09:00:00	IWM	ETF	216.99	218.99	216.49	218.31	7021033.0
2021-09-20 10:00:00	IWM	ETF	218.31	218.63	216.35	217.17	4796201.0
2021-09-20 11:00:00	IWM	ETF	217.14	218.2	215.85	216.06	3419152.0
2021-09-20 12:00:00	IWM	ETF	216.04	216.08	215.1	215.2	3472526.0
2021-09-20 13:00:00	IWM	ETF	215.19	216.71	214.72	216.62	3717912.0
2021-09-20 14:00:00	IWM	ETF	216.65	216.92	214.51	214.955	3492710.0
2021-09-20 15:00:00	IWM	ETF	214.95	217.42	214.22	217.13	6898637.0
2021-09-20 16:00:00	IWM	ETF	217.19	217.29	216.41	216.78	1970695.0
2021-09-20 17:00:00	IWM	ETF	216.96	217.19	216.58	217.05	501469.0
2021-09-20 18:00:00	IWM	ETF	216.83	217.4669	216.75	217.08	158709.0
2021-09-20 19:00:00	IWM	ETF	217.08	217.68	216.63	217.68	131231.0
2021-09-20 04:00:00	DIA	ETF	341.47	341.49	340.68	341.08	7150.0
2021-09-20 05:00:00	DIA	ETF	340.9	340.9	339.99	340.2	14463.0

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

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