PREVIEW / etf_1hour / 2021-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-21.parquet
  size:    421 KB
  rows:    14,818

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-21 04:00:00	SPY	ETF	451.33	451.38	450.94	451.09	30528.0
2021-10-21 05:00:00	SPY	ETF	451.18	451.41	451.09	451.41	10256.0
2021-10-21 06:00:00	SPY	ETF	451.42	451.44	450.97	450.97	29868.0
2021-10-21 07:00:00	SPY	ETF	451.07	451.37	450.9	450.94	97985.0
2021-10-21 08:00:00	SPY	ETF	451.0846	452.749	450.8	451.37	292526.0
2021-10-21 09:00:00	SPY	ETF	451.34	452.2	451.21	452.0073	3795983.0
2021-10-21 10:00:00	SPY	ETF	452.0	452.86	451.77	452.33	4197688.0
2021-10-21 11:00:00	SPY	ETF	452.35	452.58	451.36	451.95	4465105.0
2021-10-21 12:00:00	SPY	ETF	451.955	452.27	451.77	452.134	2728757.0
2021-10-21 13:00:00	SPY	ETF	452.12	452.42	451.7629	451.92	2493641.0
2021-10-21 14:00:00	SPY	ETF	451.93	452.49	451.91	452.49	2566699.0
2021-10-21 15:00:00	SPY	ETF	452.5	453.829	452.5	453.61	8776129.0
2021-10-21 16:00:00	SPY	ETF	453.62	453.76	452.4	452.65	3077403.0
2021-10-21 17:00:00	SPY	ETF	452.78	452.97	452.59	452.6	155041.0
2021-10-21 18:00:00	SPY	ETF	452.65	453.59	452.29	452.56	47536.0
2021-10-21 19:00:00	SPY	ETF	452.51	452.74	452.37	452.54	79773.0
2021-10-21 04:00:00	QQQ	ETF	374.09	374.09	373.77	374.06	33567.0
2021-10-21 05:00:00	QQQ	ETF	374.11	374.45	374.11	374.41	29790.0
2021-10-21 06:00:00	QQQ	ETF	374.44	374.44	374.0	374.0	13120.0
2021-10-21 07:00:00	QQQ	ETF	374.06	374.24	373.36	373.43	59362.0
2021-10-21 08:00:00	QQQ	ETF	374.0901	375.261	373.15	373.95	249301.0
2021-10-21 09:00:00	QQQ	ETF	373.97	375.31	373.85	374.96	2579180.0
2021-10-21 10:00:00	QQQ	ETF	374.95	376.425	374.84	376.12	3214938.0
2021-10-21 11:00:00	QQQ	ETF	376.13	376.56	375.34	375.81	2361636.0
2021-10-21 12:00:00	QQQ	ETF	375.8177	376.4	375.35	376.29	1780818.0
2021-10-21 13:00:00	QQQ	ETF	376.3	376.359	375.71	375.86	1237671.0
2021-10-21 14:00:00	QQQ	ETF	375.86	376.41	375.75	376.41	1349125.0
2021-10-21 15:00:00	QQQ	ETF	376.42	377.47	376.38	377.28	4854667.0
2021-10-21 16:00:00	QQQ	ETF	377.28	377.42	374.68	374.97	2874816.0
2021-10-21 17:00:00	QQQ	ETF	375.07	375.1999	374.75	374.79	93221.0
2021-10-21 18:00:00	QQQ	ETF	374.8	375.52	374.8	375.41	154532.0
2021-10-21 19:00:00	QQQ	ETF	375.34	375.59	375.1	375.2	156417.0
2021-10-21 04:00:00	IWM	ETF	226.5	226.5	226.16	226.41	6333.0
2021-10-21 05:00:00	IWM	ETF	226.43	226.53	226.27	226.53	5132.0
2021-10-21 06:00:00	IWM	ETF	226.56	226.61	226.3	226.39	15709.0
2021-10-21 07:00:00	IWM	ETF	226.42	226.64	226.38	226.48	139809.0
2021-10-21 08:00:00	IWM	ETF	226.3901	227.18	226.37	226.96	73332.0
2021-10-21 09:00:00	IWM	ETF	226.96	228.57	226.87	228.47	2714114.0
2021-10-21 10:00:00	IWM	ETF	228.46	229.01	227.82	227.84	2473730.0
2021-10-21 11:00:00	IWM	ETF	227.87	227.96	226.62	227.07	1760376.0
2021-10-21 12:00:00	IWM	ETF	227.08	227.51	226.99	227.39	995566.0
2021-10-21 13:00:00	IWM	ETF	227.39	227.74	226.79	226.94	908781.0
2021-10-21 14:00:00	IWM	ETF	226.94	227.74	226.935	227.48	1673174.0
2021-10-21 15:00:00	IWM	ETF	227.5	228.03	227.435	227.94	2485090.0
2021-10-21 16:00:00	IWM	ETF	227.95	228.4	227.81	228.32	1007586.0
2021-10-21 17:00:00	IWM	ETF	228.12	228.41	227.95	228.06	60153.0
2021-10-21 18:00:00	IWM	ETF	228.08	228.26	227.97	228.11	33278.0
2021-10-21 19:00:00	IWM	ETF	228.1	228.12	227.85	227.96	21613.0
2021-10-21 04:00:00	DIA	ETF	355.12	355.15	354.89	354.95	1999.0
2021-10-21 05:00:00	DIA	ETF	355.02	355.02	355.02	355.02	112.0

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

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