PREVIEW / etf_1hour / 2021-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-21.parquet
  size:    421 KB
  rows:    14,901

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-21 04:00:00	SPY	ETF	435.0	438.93	435.0	438.09	113819.0
2021-09-21 05:00:00	SPY	ETF	438.28	438.35	437.51	438.12	87602.0
2021-09-21 06:00:00	SPY	ETF	438.1	438.26	437.7	437.94	160436.0
2021-09-21 07:00:00	SPY	ETF	437.97	438.0	436.88	437.46	620888.0
2021-09-21 08:00:00	SPY	ETF	437.9001	438.43	436.13	436.38	1378163.0
2021-09-21 09:00:00	SPY	ETF	436.38	437.91	435.5	436.39	10620380.0
2021-09-21 10:00:00	SPY	ETF	436.39	436.74	433.07	433.75	14241201.0
2021-09-21 11:00:00	SPY	ETF	433.77	436.23	433.15	435.865	8599349.0
2021-09-21 12:00:00	SPY	ETF	435.88	436.97	434.93	435.395	7969163.0
2021-09-21 13:00:00	SPY	ETF	435.38	435.6	433.78	434.2114	6535581.0
2021-09-21 14:00:00	SPY	ETF	434.22	435.78	433.545	434.979	6517555.0
2021-09-21 15:00:00	SPY	ETF	434.98	436.05	433.54	433.68	14661041.0
2021-09-21 16:00:00	SPY	ETF	433.68	433.84	432.4	433.06	4091550.0
2021-09-21 17:00:00	SPY	ETF	433.06	433.34	433.05	433.15	123285.0
2021-09-21 18:00:00	SPY	ETF	433.11	433.63	432.8	432.82	76011.0
2021-09-21 19:00:00	SPY	ETF	432.85	433.05	432.5	432.56	59836.0
2021-09-21 04:00:00	QQQ	ETF	367.06	369.51	367.06	368.94	132399.0
2021-09-21 05:00:00	QQQ	ETF	369.05	369.11	368.3	368.63	34816.0
2021-09-21 06:00:00	QQQ	ETF	368.64	368.72	368.33	368.65	42463.0
2021-09-21 07:00:00	QQQ	ETF	368.65	368.67	368.1	368.55	136661.0
2021-09-21 08:00:00	QQQ	ETF	368.6301	368.9	367.43	367.47	602184.0
2021-09-21 09:00:00	QQQ	ETF	367.61	368.81	366.28	367.25	5807580.0
2021-09-21 10:00:00	QQQ	ETF	367.25	367.59	364.99	365.58	7263140.0
2021-09-21 11:00:00	QQQ	ETF	365.59	368.3	365.08	367.78	4675192.0
2021-09-21 12:00:00	QQQ	ETF	367.81	368.49	366.6401	367.02	2518209.0
2021-09-21 13:00:00	QQQ	ETF	367.01	367.2	365.68	366.09	3115012.0
2021-09-21 14:00:00	QQQ	ETF	366.11	367.92	365.64	367.23	3481766.0
2021-09-21 15:00:00	QQQ	ETF	367.22	368.113	365.93	366.02	5346999.0
2021-09-21 16:00:00	QQQ	ETF	366.03	366.19	364.7	365.38	1316294.0
2021-09-21 17:00:00	QQQ	ETF	365.36	365.37	365.15	365.24	32861.0
2021-09-21 18:00:00	QQQ	ETF	365.29	366.15	365.24	365.28	104955.0
2021-09-21 19:00:00	QQQ	ETF	365.3	365.45	364.88	364.94	55331.0
2021-09-21 04:00:00	IWM	ETF	219.29	220.25	219.29	220.06	35383.0
2021-09-21 05:00:00	IWM	ETF	219.84	220.02	219.55	220.02	26107.0
2021-09-21 06:00:00	IWM	ETF	219.95	220.0	219.61	219.77	105151.0
2021-09-21 07:00:00	IWM	ETF	219.75	219.8	218.85	219.29	172574.0
2021-09-21 08:00:00	IWM	ETF	218.96	219.76	218.44	218.44	216604.0
2021-09-21 09:00:00	IWM	ETF	218.52	219.29	217.29	217.67	4637148.0
2021-09-21 10:00:00	IWM	ETF	217.69	218.04	215.82	216.49	4051080.0
2021-09-21 11:00:00	IWM	ETF	216.51	218.03	216.17	217.8	2840345.0
2021-09-21 12:00:00	IWM	ETF	217.81	218.63	216.915	217.47	2288433.0
2021-09-21 13:00:00	IWM	ETF	217.47	218.05	217.14	217.545	1668437.0
2021-09-21 14:00:00	IWM	ETF	217.57	218.45	217.04	217.99	1607980.0
2021-09-21 15:00:00	IWM	ETF	217.99	218.83	217.44	217.58	3583329.0
2021-09-21 16:00:00	IWM	ETF	217.59	217.59	216.74	217.1	781712.0
2021-09-21 17:00:00	IWM	ETF	217.18	217.36	216.9	216.95	23894.0
2021-09-21 18:00:00	IWM	ETF	217.13	217.34	217.03	217.11	28361.0
2021-09-21 19:00:00	IWM	ETF	217.03	217.03	216.76	216.82	51326.0
2021-09-21 04:00:00	DIA	ETF	343.5	343.52	343.01	343.01	5085.0
2021-09-21 05:00:00	DIA	ETF	343.13	343.14	342.75	343.0	2834.0

> showing 50 of 14,901 rows — these rows as CSV

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