PREVIEW / etf_1hour / 2021-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-23.parquet
  size:    439 KB
  rows:    15,701

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-11-23 04:00:00	SPY	ETF	466.66	467.0	465.71	466.98	57015.0
2021-11-23 05:00:00	SPY	ETF	467.13	467.5	467.09	467.17	71608.0
2021-11-23 06:00:00	SPY	ETF	467.19	467.53	466.42	467.3	43053.0
2021-11-23 07:00:00	SPY	ETF	467.28	467.72	466.9	467.12	164901.0
2021-11-23 08:00:00	SPY	ETF	467.49	467.72	465.4	467.43	344686.0
2021-11-23 09:00:00	SPY	ETF	467.46	469.095	466.26	468.575	7280460.0
2021-11-23 10:00:00	SPY	ETF	468.57	468.71	465.02	465.07	9824544.0
2021-11-23 11:00:00	SPY	ETF	465.065	467.03	464.45	466.21	7842873.0
2021-11-23 12:00:00	SPY	ETF	466.21	466.71	465.21	465.49	4580042.0
2021-11-23 13:00:00	SPY	ETF	465.46	466.938	464.93	466.27	4640836.0
2021-11-23 14:00:00	SPY	ETF	466.28	467.83	465.53	467.55	6725811.0
2021-11-23 15:00:00	SPY	ETF	467.54	468.67	466.97	468.24	12059814.0
2021-11-23 16:00:00	SPY	ETF	468.24	468.29	467.45	468.0	5836734.0
2021-11-23 17:00:00	SPY	ETF	467.85	468.08	467.85	467.91	20730.0
2021-11-23 18:00:00	SPY	ETF	467.97	468.21	467.7	467.79	48272.0
2021-11-23 19:00:00	SPY	ETF	467.81	468.3	467.81	468.05	54639.0
2021-11-23 04:00:00	QQQ	ETF	398.19	398.19	397.31	398.15	215279.0
2021-11-23 05:00:00	QQQ	ETF	398.23	398.59	397.96	397.96	142486.0
2021-11-23 06:00:00	QQQ	ETF	398.09	398.56	397.36	398.32	74897.0
2021-11-23 07:00:00	QQQ	ETF	398.44	399.15	397.96	398.16	250466.0
2021-11-23 08:00:00	QQQ	ETF	398.05	399.24	396.85	398.58	478357.0
2021-11-23 09:00:00	QQQ	ETF	398.6	400.23	396.9	399.73	7291945.0
2021-11-23 10:00:00	QQQ	ETF	399.73	399.89	393.96	394.09	11588536.0
2021-11-23 11:00:00	QQQ	ETF	394.09	396.593	393.44	395.15	9215618.0
2021-11-23 12:00:00	QQQ	ETF	395.14	395.93	394.01	394.25	4745904.0
2021-11-23 13:00:00	QQQ	ETF	394.24	395.24	392.92	394.58	5981193.0
2021-11-23 14:00:00	QQQ	ETF	394.6	396.345	393.39	396.035	6242071.0
2021-11-23 15:00:00	QQQ	ETF	396.05	397.8	395.43	397.48	8066312.0
2021-11-23 16:00:00	QQQ	ETF	397.49	397.58	396.66	397.27	1132870.0
2021-11-23 17:00:00	QQQ	ETF	397.16	397.24	397.0	397.2	37394.0
2021-11-23 18:00:00	QQQ	ETF	397.24	397.48	396.95	397.02	60763.0
2021-11-23 19:00:00	QQQ	ETF	397.09	397.48	397.09	397.3	32134.0
2021-11-23 04:00:00	IWM	ETF	231.58	231.58	229.75	230.78	29968.0
2021-11-23 05:00:00	IWM	ETF	230.91	231.32	230.9	231.0	15918.0
2021-11-23 06:00:00	IWM	ETF	230.86	231.6	230.62	231.4	35497.0
2021-11-23 07:00:00	IWM	ETF	231.41	231.62	231.16	231.38	46913.0
2021-11-23 08:00:00	IWM	ETF	231.4	231.85	229.85	231.53	126571.0
2021-11-23 09:00:00	IWM	ETF	231.6	233.0	230.89	232.53	2826111.0
2021-11-23 10:00:00	IWM	ETF	232.54	232.62	229.03	229.09	4960103.0
2021-11-23 11:00:00	IWM	ETF	229.11	230.68	228.62	230.065	3994452.0
2021-11-23 12:00:00	IWM	ETF	230.06	230.49	229.29	229.92	2397573.0
2021-11-23 13:00:00	IWM	ETF	229.88	230.46	229.33	229.935	1891302.0
2021-11-23 14:00:00	IWM	ETF	229.93	230.86	229.35	230.61	2124295.0
2021-11-23 15:00:00	IWM	ETF	230.61	231.67	230.35	231.34	4752378.0
2021-11-23 16:00:00	IWM	ETF	231.33	231.33	230.2344	231.14	3630125.0
2021-11-23 17:00:00	IWM	ETF	231.18	231.26	230.9	231.11	10370.0
2021-11-23 18:00:00	IWM	ETF	231.2	231.33	231.0	231.13	23482.0
2021-11-23 19:00:00	IWM	ETF	231.1	231.56	231.1	231.36	71170.0
2021-11-23 04:00:00	DIA	ETF	355.1	356.0	355.1	356.0	1149.0
2021-11-23 05:00:00	DIA	ETF	356.16	356.49	356.15	356.34	2378.0

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

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