PREVIEW / etf_1hour / 2021-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-01.parquet
  size:    424 KB
  rows:    14,658

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-01 04:00:00	SPY	ETF	453.47	453.54	453.2	453.29	41978.0
2021-09-01 05:00:00	SPY	ETF	453.25	453.27	453.0	453.05	23658.0
2021-09-01 06:00:00	SPY	ETF	453.01	453.31	452.93	453.31	69678.0
2021-09-01 07:00:00	SPY	ETF	453.33	453.33	453.02	453.31	90455.0
2021-09-01 08:00:00	SPY	ETF	453.32	453.54	451.898	453.03	353224.0
2021-09-01 09:00:00	SPY	ETF	453.05	453.13	451.82	452.0	5555259.0
2021-09-01 10:00:00	SPY	ETF	452.01	452.67	451.98	452.59	6389248.0
2021-09-01 11:00:00	SPY	ETF	452.58	452.67	452.1101	452.37	3733162.0
2021-09-01 12:00:00	SPY	ETF	452.3698	452.995	452.35	452.96	4367051.0
2021-09-01 13:00:00	SPY	ETF	452.9799	453.11	452.86	453.03	2492857.0
2021-09-01 14:00:00	SPY	ETF	453.0301	453.06	452.23	452.345	4373321.0
2021-09-01 15:00:00	SPY	ETF	452.34	452.47	451.545	451.82	9294876.0
2021-09-01 16:00:00	SPY	ETF	451.81	452.45	451.7	451.86	2263999.0
2021-09-01 17:00:00	SPY	ETF	451.99	451.99	451.75	451.85	68792.0
2021-09-01 18:00:00	SPY	ETF	451.85	452.05	451.8	451.9	30343.0
2021-09-01 19:00:00	SPY	ETF	451.91	452.01	451.86	451.97	16883.0
2021-09-01 20:00:00	SPY	ETF	451.8	451.98	451.8	451.98	500.0
2021-09-01 04:00:00	QQQ	ETF	380.52	381.03	380.45	380.51	30987.0
2021-09-01 05:00:00	QQQ	ETF	380.43	380.56	380.0	380.47	30023.0
2021-09-01 06:00:00	QQQ	ETF	380.53	380.82	380.5	380.77	21251.0
2021-09-01 07:00:00	QQQ	ETF	380.77	380.99	380.57	380.99	79435.0
2021-09-01 08:00:00	QQQ	ETF	380.6506	381.45	380.234	381.15	257541.0
2021-09-01 09:00:00	QQQ	ETF	381.12	382.71	380.85	382.04	3963935.0
2021-09-01 10:00:00	QQQ	ETF	382.04	382.48	381.79	382.18	3496652.0
2021-09-01 11:00:00	QQQ	ETF	382.18	382.44	381.78	382.16	1893373.0
2021-09-01 12:00:00	QQQ	ETF	382.16	382.435	382.05	382.225	1602232.0
2021-09-01 13:00:00	QQQ	ETF	382.24	382.45	382.09	382.288	1058190.0
2021-09-01 14:00:00	QQQ	ETF	382.28	382.29	381.04	381.37	2224475.0
2021-09-01 15:00:00	QQQ	ETF	381.38	381.64	380.37	380.59	5856157.0
2021-09-01 16:00:00	QQQ	ETF	380.59	381.6902	380.4	380.57	1132762.0
2021-09-01 17:00:00	QQQ	ETF	380.52	380.58	380.45	380.52	33845.0
2021-09-01 18:00:00	QQQ	ETF	380.5	380.79	380.49	380.61	43093.0
2021-09-01 19:00:00	QQQ	ETF	380.63	380.77	380.61	380.77	25205.0
2021-09-01 04:00:00	IWM	ETF	227.12	227.85	227.12	227.84	14826.0
2021-09-01 05:00:00	IWM	ETF	227.8	227.8	227.4	227.4	9811.0
2021-09-01 06:00:00	IWM	ETF	227.4	227.78	227.4	227.78	115203.0
2021-09-01 07:00:00	IWM	ETF	227.79	227.79	227.4	227.73	23913.0
2021-09-01 08:00:00	IWM	ETF	227.76	227.79	227.11	227.34	75675.0
2021-09-01 09:00:00	IWM	ETF	227.27	227.27	224.87	225.09	3389504.0
2021-09-01 10:00:00	IWM	ETF	225.15	226.78	225.01	226.695	2681498.0
2021-09-01 11:00:00	IWM	ETF	226.685	226.94	226.22	226.79	1357756.0
2021-09-01 12:00:00	IWM	ETF	226.79	228.24	226.63	228.09	1927324.0
2021-09-01 13:00:00	IWM	ETF	228.105	228.21	227.69	228.12	1238965.0
2021-09-01 14:00:00	IWM	ETF	228.12	228.15	227.2589	227.5491	2013141.0
2021-09-01 15:00:00	IWM	ETF	227.55	227.69	226.975	227.45	3256055.0
2021-09-01 16:00:00	IWM	ETF	227.44	227.51	226.8959	227.42	712148.0
2021-09-01 17:00:00	IWM	ETF	227.62	227.62	227.15	227.45	37509.0
2021-09-01 18:00:00	IWM	ETF	227.45	227.65	227.4	227.56	44699.0
2021-09-01 19:00:00	IWM	ETF	227.53	227.67	227.49	227.55	15909.0
2021-09-01 04:00:00	DIA	ETF	355.17	355.44	355.17	355.34	550.0

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

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