PREVIEW / etf_1hour / 2021-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-20.parquet
  size:    425 KB
  rows:    15,004

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-10-20 04:00:00	SPY	ETF	449.11	450.72	449.11	450.61	30920.0
2021-10-20 05:00:00	SPY	ETF	450.59	450.81	450.4	450.71	15173.0
2021-10-20 06:00:00	SPY	ETF	450.7	450.77	450.48	450.67	38964.0
2021-10-20 07:00:00	SPY	ETF	450.72	450.8	450.2	450.29	99058.0
2021-10-20 08:00:00	SPY	ETF	450.5699	451.0	450.11	450.67	169219.0
2021-10-20 09:00:00	SPY	ETF	450.68	452.01	450.48	451.59	4921237.0
2021-10-20 10:00:00	SPY	ETF	451.59	452.732	451.33	452.0786	6087646.0
2021-10-20 11:00:00	SPY	ETF	452.07	452.54	451.8	452.51	3619755.0
2021-10-20 12:00:00	SPY	ETF	452.505	452.57	452.2	452.5	1987706.0
2021-10-20 13:00:00	SPY	ETF	452.5	452.53	451.02	451.8	4612056.0
2021-10-20 14:00:00	SPY	ETF	451.805	452.36	451.72	452.23	3738111.0
2021-10-20 15:00:00	SPY	ETF	452.23	452.51	451.635	452.4	9040080.0
2021-10-20 16:00:00	SPY	ETF	452.4	452.58	451.85	452.0	2896870.0
2021-10-20 17:00:00	SPY	ETF	452.03	452.41	451.95	451.97	223055.0
2021-10-20 18:00:00	SPY	ETF	451.97	452.41	451.81	451.91	135911.0
2021-10-20 19:00:00	SPY	ETF	451.98	452.06	451.51	451.59	56983.0
2021-10-20 04:00:00	QQQ	ETF	375.0	375.33	374.84	375.16	52941.0
2021-10-20 05:00:00	QQQ	ETF	375.14	375.57	375.1	375.44	28591.0
2021-10-20 06:00:00	QQQ	ETF	375.48	375.69	375.36	375.66	17326.0
2021-10-20 07:00:00	QQQ	ETF	375.61	375.73	375.12	375.2	84171.0
2021-10-20 08:00:00	QQQ	ETF	375.4696	375.95	374.72	375.8	246130.0
2021-10-20 09:00:00	QQQ	ETF	375.8	376.39	375.38	375.6	3958132.0
2021-10-20 10:00:00	QQQ	ETF	375.59	376.565	374.96	375.53	4374100.0
2021-10-20 11:00:00	QQQ	ETF	375.545	375.97	375.035	375.915	2787233.0
2021-10-20 12:00:00	QQQ	ETF	375.91	375.94	374.92	375.23	1717706.0
2021-10-20 13:00:00	QQQ	ETF	375.24	375.32	373.46	374.33	3678139.0
2021-10-20 14:00:00	QQQ	ETF	374.32	374.905	374.25	374.76	1738631.0
2021-10-20 15:00:00	QQQ	ETF	374.75	375.08	374.3505	374.98	4071100.0
2021-10-20 16:00:00	QQQ	ETF	374.99	375.1	374.26	374.35	985763.0
2021-10-20 17:00:00	QQQ	ETF	374.51	374.98	374.22	374.27	254617.0
2021-10-20 18:00:00	QQQ	ETF	374.3	374.51	374.1	374.14	47926.0
2021-10-20 19:00:00	QQQ	ETF	374.18	374.31	373.85	373.85	46142.0
2021-10-20 04:00:00	IWM	ETF	225.52	225.78	225.52	225.74	6987.0
2021-10-20 05:00:00	IWM	ETF	225.73	225.85	225.52	225.71	4874.0
2021-10-20 06:00:00	IWM	ETF	225.56	225.6	225.39	225.5	8766.0
2021-10-20 07:00:00	IWM	ETF	225.51	225.55	225.19	225.19	31556.0
2021-10-20 08:00:00	IWM	ETF	225.4901	226.1	225.13	225.65	79715.0
2021-10-20 09:00:00	IWM	ETF	225.72	226.16	225.12	225.99	1807121.0
2021-10-20 10:00:00	IWM	ETF	225.99	227.97	225.78	227.225	2748888.0
2021-10-20 11:00:00	IWM	ETF	227.22	227.89	227.04	227.8	1527743.0
2021-10-20 12:00:00	IWM	ETF	227.79	227.98	227.47	227.75	1142994.0
2021-10-20 13:00:00	IWM	ETF	227.75	227.81	226.71	227.18	1449632.0
2021-10-20 14:00:00	IWM	ETF	227.17	227.5	227.02	227.17	1126818.0
2021-10-20 15:00:00	IWM	ETF	227.17	227.44	226.81	227.34	2724555.0
2021-10-20 16:00:00	IWM	ETF	227.37	227.39	227.1	227.25	1346694.0
2021-10-20 17:00:00	IWM	ETF	227.31	227.39	227.07	227.23	208618.0
2021-10-20 18:00:00	IWM	ETF	227.29	227.34	227.11	227.16	10453.0
2021-10-20 19:00:00	IWM	ETF	227.2	227.25	226.98	227.0	16375.0
2021-10-20 04:00:00	DIA	ETF	354.28	354.49	354.28	354.49	2343.0
2021-10-20 05:00:00	DIA	ETF	354.53	354.62	354.48	354.5	10851.0

> showing 50 of 15,004 rows — these rows as CSV

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