PREVIEW / etf_1hour / 2022-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-17.parquet
  size:    459 KB
  rows:    16,875

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-06-17 04:00:00	SPY	ETF	367.67	369.51	367.67	368.6	94215.0
2022-06-17 05:00:00	SPY	ETF	368.5	369.36	367.57	368.75	62678.0
2022-06-17 06:00:00	SPY	ETF	368.69	369.1	368.11	368.37	116937.0
2022-06-17 07:00:00	SPY	ETF	368.46	369.5	368.1	368.58	356509.0
2022-06-17 08:00:00	SPY	ETF	368.35	369.5	366.7	367.24	811892.0
2022-06-17 09:00:00	SPY	ETF	367.19	369.38	365.42	368.39	8943247.0
2022-06-17 10:00:00	SPY	ETF	368.41	368.59	362.17	363.54	12383374.0
2022-06-17 11:00:00	SPY	ETF	363.57	367.26	362.8	364.78	10197732.0
2022-06-17 12:00:00	SPY	ETF	364.81	366.2306	364.03	365.71	5803131.0
2022-06-17 13:00:00	SPY	ETF	365.72	368.75	365.4526	367.2599	7822773.0
2022-06-17 14:00:00	SPY	ETF	367.26	369.0	366.98	367.46	7420199.0
2022-06-17 15:00:00	SPY	ETF	367.48	368.2299	365.65	365.84	18095479.0
2022-06-17 16:00:00	SPY	ETF	365.84	367.0	365.71	366.59	5694954.0
2022-06-17 17:00:00	SPY	ETF	366.38	366.99	365.5	366.2301	334006.0
2022-06-17 18:00:00	SPY	ETF	366.24	366.72	366.24	366.52	26263.0
2022-06-17 19:00:00	SPY	ETF	366.52	366.68	366.21	366.33	8670.0
2022-06-17 04:00:00	QQQ	ETF	273.06	274.88	272.76	274.0	191774.0
2022-06-17 05:00:00	QQQ	ETF	273.9	274.75	273.7	274.49	66465.0
2022-06-17 06:00:00	QQQ	ETF	274.45	275.1	274.06	274.56	217385.0
2022-06-17 07:00:00	QQQ	ETF	274.53	275.35	274.23	274.6	429147.0
2022-06-17 08:00:00	QQQ	ETF	274.5	275.35	272.3	273.41	768530.0
2022-06-17 09:00:00	QQQ	ETF	273.32	276.06	271.63	275.18	8178872.0
2022-06-17 10:00:00	QQQ	ETF	275.24	275.37	270.5119	271.77	8810166.0
2022-06-17 11:00:00	QQQ	ETF	271.77	275.28	270.94	273.2997	6976518.0
2022-06-17 12:00:00	QQQ	ETF	273.29	275.1101	272.62	274.6554	4288521.0
2022-06-17 13:00:00	QQQ	ETF	274.6599	277.19	274.47	275.8899	5500800.0
2022-06-17 14:00:00	QQQ	ETF	275.89	276.88	275.32	275.5799	4080109.0
2022-06-17 15:00:00	QQQ	ETF	275.579	276.23	274.09	274.71	9431357.0
2022-06-17 16:00:00	QQQ	ETF	274.69	275.28	274.62	275.0	2743361.0
2022-06-17 17:00:00	QQQ	ETF	274.97	275.06	274.69	274.85	1201036.0
2022-06-17 18:00:00	QQQ	ETF	274.91	275.15	274.76	275.05	28940.0
2022-06-17 19:00:00	QQQ	ETF	275.0	275.14	274.88	275.0	36996.0
2022-06-17 04:00:00	IWM	ETF	165.16	166.06	165.15	165.61	47468.0
2022-06-17 05:00:00	IWM	ETF	165.86	166.05	165.1	165.77	9598.0
2022-06-17 06:00:00	IWM	ETF	165.71	166.0	165.55	165.69	29034.0
2022-06-17 07:00:00	IWM	ETF	165.56	166.06	165.46	165.56	67884.0
2022-06-17 08:00:00	IWM	ETF	165.71	165.88	165.03	165.14	74704.0
2022-06-17 09:00:00	IWM	ETF	165.02	167.52	164.22	167.16	4203036.0
2022-06-17 10:00:00	IWM	ETF	167.16	167.26	163.7	164.58	3636382.0
2022-06-17 11:00:00	IWM	ETF	164.59	165.99	164.08	165.04	3125660.0
2022-06-17 12:00:00	IWM	ETF	165.06	165.75	164.35	165.195	2764503.0
2022-06-17 13:00:00	IWM	ETF	165.185	166.63	165.02	165.5	2031800.0
2022-06-17 14:00:00	IWM	ETF	165.54	166.68	165.49	165.76	2140518.0
2022-06-17 15:00:00	IWM	ETF	165.75	166.34	164.94	165.18	4680610.0
2022-06-17 16:00:00	IWM	ETF	165.18	165.96	165.05	165.71	2337689.0
2022-06-17 17:00:00	IWM	ETF	165.82	165.82	165.18	165.5	2337681.0
2022-06-17 18:00:00	IWM	ETF	165.58	165.67	165.43	165.67	4817.0
2022-06-17 19:00:00	IWM	ETF	165.66	165.76	165.3	165.3	12631.0
2022-06-17 04:00:00	DIA	ETF	301.25	301.9	301.25	301.46	1950.0
2022-06-17 05:00:00	DIA	ETF	301.7	301.87	300.88	300.88	2000.0

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

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