PREVIEW / etf_1hour / 2022-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-27.parquet
  size:    461 KB
  rows:    17,165

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-27 04:00:00	SPY	ETF	369.22	369.42	367.85	368.53	69400.0
2022-09-27 05:00:00	SPY	ETF	368.17	368.18	366.75	366.79	57801.0
2022-09-27 06:00:00	SPY	ETF	366.86	368.87	366.86	368.48	157407.0
2022-09-27 07:00:00	SPY	ETF	368.42	369.6	367.01	369.23	779688.0
2022-09-27 08:00:00	SPY	ETF	368.4801	369.89	366.13	368.33	1073544.0
2022-09-27 09:00:00	SPY	ETF	368.32	370.4	367.61	368.444	9662540.0
2022-09-27 10:00:00	SPY	ETF	368.45	368.96	365.88	368.255	12480575.0
2022-09-27 11:00:00	SPY	ETF	368.3	368.54	364.0155	364.065	10378175.0
2022-09-27 12:00:00	SPY	ETF	364.07	364.17	361.19	362.7301	12577606.0
2022-09-27 13:00:00	SPY	ETF	362.72	362.725	360.87	361.76	8488077.0
2022-09-27 14:00:00	SPY	ETF	361.76	364.59	361.36	364.03	8732864.0
2022-09-27 15:00:00	SPY	ETF	364.03	364.05	362.08	363.39	13866864.0
2022-09-27 16:00:00	SPY	ETF	363.39	363.9	361.0	363.77	4023369.0
2022-09-27 17:00:00	SPY	ETF	363.84	365.2	363.38	363.9	167313.0
2022-09-27 18:00:00	SPY	ETF	363.97	364.31	363.41	364.07	177540.0
2022-09-27 19:00:00	SPY	ETF	364.08	364.4	363.5	363.57	140910.0
2022-09-27 04:00:00	QQQ	ETF	278.06	278.56	277.39	277.5	229045.0
2022-09-27 05:00:00	QQQ	ETF	277.53	277.53	276.49	276.6	73515.0
2022-09-27 06:00:00	QQQ	ETF	276.78	278.16	276.73	277.84	177976.0
2022-09-27 07:00:00	QQQ	ETF	277.81	278.86	277.54	278.52	664851.0
2022-09-27 08:00:00	QQQ	ETF	278.46	279.13	274.575	277.95	715154.0
2022-09-27 09:00:00	QQQ	ETF	277.92	280.21	277.5103	278.2825	7634485.0
2022-09-27 10:00:00	QQQ	ETF	278.31	278.62	276.25	278.23	9158149.0
2022-09-27 11:00:00	QQQ	ETF	278.26	278.5	274.72	274.7862	6398290.0
2022-09-27 12:00:00	QQQ	ETF	274.76	274.84	272.11	273.735	8513477.0
2022-09-27 13:00:00	QQQ	ETF	273.73	273.73	272.31	273.0285	5059345.0
2022-09-27 14:00:00	QQQ	ETF	273.03	275.25	272.6	274.75	5972310.0
2022-09-27 15:00:00	QQQ	ETF	274.75	275.04	273.27	274.53	9367853.0
2022-09-27 16:00:00	QQQ	ETF	274.5	275.06	274.0	275.0	2104319.0
2022-09-27 17:00:00	QQQ	ETF	275.05	275.62	274.48	274.79	249398.0
2022-09-27 18:00:00	QQQ	ETF	274.97	275.55	274.8	275.3	169982.0
2022-09-27 19:00:00	QQQ	ETF	275.29	275.53	274.83	274.87	103407.0
2022-09-27 04:00:00	IWM	ETF	166.88	167.1	166.39	166.4	79563.0
2022-09-27 05:00:00	IWM	ETF	166.27	166.34	165.47	165.47	28435.0
2022-09-27 06:00:00	IWM	ETF	165.59	166.66	165.5	166.4	60828.0
2022-09-27 07:00:00	IWM	ETF	166.4	167.0	166.2	166.8	105174.0
2022-09-27 08:00:00	IWM	ETF	166.2996	167.03	165.14	166.28	117129.0
2022-09-27 09:00:00	IWM	ETF	166.19	167.63	165.83	166.79	4898537.0
2022-09-27 10:00:00	IWM	ETF	166.81	167.62	165.29	167.56	5239457.0
2022-09-27 11:00:00	IWM	ETF	167.52	167.61	164.92	164.93	2971283.0
2022-09-27 12:00:00	IWM	ETF	164.94	165.06	163.49	164.15	3586580.0
2022-09-27 13:00:00	IWM	ETF	164.12	164.2	163.28	163.73	2454517.0
2022-09-27 14:00:00	IWM	ETF	163.75	165.11	163.52	164.96	2722239.0
2022-09-27 15:00:00	IWM	ETF	164.97	165.06	164.04	164.72	4850031.0
2022-09-27 16:00:00	IWM	ETF	164.73	165.12	164.32	165.07	1933220.0
2022-09-27 17:00:00	IWM	ETF	165.09	165.35	164.73	165.14	101814.0
2022-09-27 18:00:00	IWM	ETF	165.1	165.38	164.82	165.13	24844.0
2022-09-27 19:00:00	IWM	ETF	165.16	165.41	164.93	164.96	64136.0
2022-09-27 04:00:00	DIA	ETF	296.07	296.12	295.17	295.18	3691.0
2022-09-27 05:00:00	DIA	ETF	295.0	295.0	294.08	294.08	3400.0

> showing 50 of 17,165 rows — these rows as CSV

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