PREVIEW / etf_1hour / 2022-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-29.parquet
  size:    459 KB
  rows:    16,855

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-09-29 04:00:00	SPY	ETF	366.02	367.48	364.0	366.09	176996.0
2022-09-29 05:00:00	SPY	ETF	366.3	368.29	366.0	367.69	148261.0
2022-09-29 06:00:00	SPY	ETF	367.57	367.7	366.44	367.06	147671.0
2022-09-29 07:00:00	SPY	ETF	367.07	368.5	367.02	367.35	428264.0
2022-09-29 08:00:00	SPY	ETF	367.17	370.85	364.77	365.8	1987504.0
2022-09-29 09:00:00	SPY	ETF	365.77	367.35	362.81	363.19	10528529.0
2022-09-29 10:00:00	SPY	ETF	363.19	363.33	360.59	362.56	15524051.0
2022-09-29 11:00:00	SPY	ETF	362.56	364.67	362.12	364.01	10414950.0
2022-09-29 12:00:00	SPY	ETF	364.0	364.43	362.17	362.2701	6210343.0
2022-09-29 13:00:00	SPY	ETF	362.275	362.455	360.44	360.5	7603461.0
2022-09-29 14:00:00	SPY	ETF	360.51	361.58	359.7	359.919	9760218.0
2022-09-29 15:00:00	SPY	ETF	359.92	363.255	359.883	362.79	21607618.0
2022-09-29 16:00:00	SPY	ETF	362.8	363.8	362.72	363.28	6198660.0
2022-09-29 17:00:00	SPY	ETF	363.24	363.28	362.79	363.0	105056.0
2022-09-29 18:00:00	SPY	ETF	362.99	364.1	362.85	363.74	258530.0
2022-09-29 19:00:00	SPY	ETF	363.83	364.43	363.7	364.21	81742.0
2022-09-29 04:00:00	QQQ	ETF	277.46	277.46	275.63	276.05	180372.0
2022-09-29 05:00:00	QQQ	ETF	276.3	277.82	275.97	277.07	91221.0
2022-09-29 06:00:00	QQQ	ETF	277.03	277.12	275.93	276.45	156701.0
2022-09-29 07:00:00	QQQ	ETF	276.4	277.65	276.37	276.62	344031.0
2022-09-29 08:00:00	QQQ	ETF	276.58	280.2	274.57	275.5	1451930.0
2022-09-29 09:00:00	QQQ	ETF	275.45	276.58	272.48	272.8	8809769.0
2022-09-29 10:00:00	QQQ	ETF	272.81	273.07	270.45	271.83	11806620.0
2022-09-29 11:00:00	QQQ	ETF	271.83	273.27	271.23	272.8224	6597046.0
2022-09-29 12:00:00	QQQ	ETF	272.84	273.175	270.91	271.04	4278054.0
2022-09-29 13:00:00	QQQ	ETF	271.04	271.44	269.51	269.5855	5673421.0
2022-09-29 14:00:00	QQQ	ETF	269.6	270.49	268.84	269.2	7321742.0
2022-09-29 15:00:00	QQQ	ETF	269.19	272.28	269.16	272.04	15433893.0
2022-09-29 16:00:00	QQQ	ETF	272.04	272.65	271.85	272.18	2478022.0
2022-09-29 17:00:00	QQQ	ETF	272.05	272.15	271.7	271.8	381725.0
2022-09-29 18:00:00	QQQ	ETF	271.83	272.76	271.8	272.37	330635.0
2022-09-29 19:00:00	QQQ	ETF	272.4	273.13	272.4	272.94	203685.0
2022-09-29 04:00:00	IWM	ETF	167.55	167.9	167.19	167.51	67988.0
2022-09-29 05:00:00	IWM	ETF	167.55	168.78	167.55	168.42	18826.0
2022-09-29 06:00:00	IWM	ETF	168.49	168.63	167.99	168.33	24341.0
2022-09-29 07:00:00	IWM	ETF	168.31	169.05	168.31	168.37	130622.0
2022-09-29 08:00:00	IWM	ETF	168.36	169.9	166.67	167.29	461298.0
2022-09-29 09:00:00	IWM	ETF	167.27	168.13	164.93	165.04	3620735.0
2022-09-29 10:00:00	IWM	ETF	165.02	165.165	163.8	164.845	4059662.0
2022-09-29 11:00:00	IWM	ETF	164.83	166.27	164.66	165.91	2844018.0
2022-09-29 12:00:00	IWM	ETF	165.87	166.0489	165.05	165.24	1826777.0
2022-09-29 13:00:00	IWM	ETF	165.24	165.405	164.53	164.57	1944342.0
2022-09-29 14:00:00	IWM	ETF	164.57	165.13	164.31	164.45	2230327.0
2022-09-29 15:00:00	IWM	ETF	164.44	166.22	164.43	166.1	3839218.0
2022-09-29 16:00:00	IWM	ETF	166.13	166.5	165.4766	166.33	871756.0
2022-09-29 17:00:00	IWM	ETF	166.29	166.33	166.06	166.2	459145.0
2022-09-29 18:00:00	IWM	ETF	166.2	166.8	166.05	166.54	54814.0
2022-09-29 19:00:00	IWM	ETF	166.66	166.9	166.54	166.83	17116.0
2022-09-29 04:00:00	DIA	ETF	293.06	293.9	293.06	293.9	5642.0
2022-09-29 05:00:00	DIA	ETF	294.66	294.91	294.55	294.91	1225.0

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

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