PREVIEW / etf_1hour / 2022-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-05.parquet
  size:    458 KB
  rows:    16,328

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-04-05 04:00:00	SPY	ETF	457.3	457.44	456.55	456.63	13895.0
2022-04-05 05:00:00	SPY	ETF	456.61	456.75	455.79	455.85	17292.0
2022-04-05 06:00:00	SPY	ETF	455.84	456.1	455.32	455.79	29005.0
2022-04-05 07:00:00	SPY	ETF	455.74	456.13	455.44	456.0	100870.0
2022-04-05 08:00:00	SPY	ETF	455.8	457.0	455.34	455.36	126256.0
2022-04-05 09:00:00	SPY	ETF	455.44	457.18	455.03	456.91	5246399.0
2022-04-05 10:00:00	SPY	ETF	456.91	457.83	453.79	455.09	12254408.0
2022-04-05 11:00:00	SPY	ETF	455.09	455.26	453.48	453.51	6034179.0
2022-04-05 12:00:00	SPY	ETF	453.5	453.92	452.67	453.558	5673242.0
2022-04-05 13:00:00	SPY	ETF	453.55	454.67	452.5	453.02	5458524.0
2022-04-05 14:00:00	SPY	ETF	453.02	453.47	452.375	452.51	5181420.0
2022-04-05 15:00:00	SPY	ETF	452.5	452.77	449.82	451.1	17061619.0
2022-04-05 16:00:00	SPY	ETF	451.12	453.3896	450.975	451.68	3739002.0
2022-04-05 17:00:00	SPY	ETF	451.68	451.86	451.65	451.75	81525.0
2022-04-05 18:00:00	SPY	ETF	451.7	451.71	451.16	451.48	92664.0
2022-04-05 19:00:00	SPY	ETF	451.4704	451.59	451.23	451.27	38467.0
2022-04-05 04:00:00	QQQ	ETF	369.75	369.88	369.21	369.21	35969.0
2022-04-05 05:00:00	QQQ	ETF	369.23	369.28	368.47	368.57	44768.0
2022-04-05 06:00:00	QQQ	ETF	368.51	368.77	367.97	368.46	65996.0
2022-04-05 07:00:00	QQQ	ETF	368.5	368.77	368.1	368.66	107947.0
2022-04-05 08:00:00	QQQ	ETF	368.3601	369.576	367.74	367.82	296836.0
2022-04-05 09:00:00	QQQ	ETF	367.82	368.54	366.54	367.03	5282227.0
2022-04-05 10:00:00	QQQ	ETF	367.01	367.72	363.19	364.46	11105760.0
2022-04-05 11:00:00	QQQ	ETF	364.46	364.77	362.59	362.67	5556078.0
2022-04-05 12:00:00	QQQ	ETF	362.66	363.19	361.63	362.7	4700370.0
2022-04-05 13:00:00	QQQ	ETF	362.69	363.86	361.6	362.23	4505179.0
2022-04-05 14:00:00	QQQ	ETF	362.2199	363.09	361.87	362.14	5058865.0
2022-04-05 15:00:00	QQQ	ETF	362.14	362.44	359.93	361.13	11771613.0
2022-04-05 16:00:00	QQQ	ETF	361.17	361.89	360.85	361.89	1979513.0
2022-04-05 17:00:00	QQQ	ETF	361.85	361.9	361.73	361.8	71992.0
2022-04-05 18:00:00	QQQ	ETF	361.8	361.83	361.24	361.49	140732.0
2022-04-05 19:00:00	QQQ	ETF	361.46	361.52	361.16	361.16	82521.0
2022-04-05 04:00:00	IWM	ETF	208.36	208.49	208.05	208.15	12611.0
2022-04-05 05:00:00	IWM	ETF	208.17	208.22	207.64	207.71	6287.0
2022-04-05 06:00:00	IWM	ETF	207.77	207.83	207.45	207.83	19852.0
2022-04-05 07:00:00	IWM	ETF	207.74	208.06	207.71	208.02	39790.0
2022-04-05 08:00:00	IWM	ETF	207.78	208.15	207.77	207.81	39167.0
2022-04-05 09:00:00	IWM	ETF	207.89	209.435	207.21	207.4175	2095679.0
2022-04-05 10:00:00	IWM	ETF	207.34	207.8	204.85	205.385	4301368.0
2022-04-05 11:00:00	IWM	ETF	205.385	205.68	204.9	204.94	1610527.0
2022-04-05 12:00:00	IWM	ETF	204.97	205.17	204.27	204.91	1524702.0
2022-04-05 13:00:00	IWM	ETF	204.92	205.54	204.26	204.51	1437290.0
2022-04-05 14:00:00	IWM	ETF	204.505	204.81	204.125	204.1954	1483922.0
2022-04-05 15:00:00	IWM	ETF	204.19	204.34	202.51	203.05	6049604.0
2022-04-05 16:00:00	IWM	ETF	202.99	203.46	202.99	203.4	1371379.0
2022-04-05 17:00:00	IWM	ETF	203.25	203.58	202.99	203.37	17765.0
2022-04-05 18:00:00	IWM	ETF	203.35	203.42	203.09	203.29	40042.0
2022-04-05 19:00:00	IWM	ETF	203.29	203.39	203.16	203.17	32549.0
2022-04-05 04:00:00	DIA	ETF	349.38	349.48	349.38	349.48	760.0
2022-04-05 05:00:00	DIA	ETF	349.19	349.19	349.19	349.19	300.0

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

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