PREVIEW / etf_1hour / 2021-11-24

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-24.parquet
  size:    428 KB
  rows:    15,129

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-24 04:00:00	SPY	ETF	468.02	468.2	466.57	466.88	22867.0
2021-11-24 05:00:00	SPY	ETF	466.82	467.36	466.48	466.48	9080.0
2021-11-24 06:00:00	SPY	ETF	466.46	467.7	466.33	467.12	49442.0
2021-11-24 07:00:00	SPY	ETF	467.13	467.38	466.49	466.7	99464.0
2021-11-24 08:00:00	SPY	ETF	466.73	468.25	465.73	465.98	493538.0
2021-11-24 09:00:00	SPY	ETF	465.97	466.705	465.19	466.26	6740667.0
2021-11-24 10:00:00	SPY	ETF	466.25	467.65	465.63	467.41	7800845.0
2021-11-24 11:00:00	SPY	ETF	467.4	468.705	466.94	468.05	5701456.0
2021-11-24 12:00:00	SPY	ETF	468.05	468.6911	467.72	468.65	2929153.0
2021-11-24 13:00:00	SPY	ETF	468.65	469.02	468.45	468.476	2582500.0
2021-11-24 14:00:00	SPY	ETF	468.47	469.1	467.31	468.6201	5224286.0
2021-11-24 15:00:00	SPY	ETF	468.61	469.57	468.405	469.37	11874752.0
2021-11-24 16:00:00	SPY	ETF	469.36	469.73	469.21	469.55	3851834.0
2021-11-24 17:00:00	SPY	ETF	469.5	469.65	469.48	469.61	30945.0
2021-11-24 18:00:00	SPY	ETF	469.63	469.82	469.6	469.76	20021.0
2021-11-24 19:00:00	SPY	ETF	469.77	470.27	469.7	470.22	32023.0
2021-11-24 04:00:00	QQQ	ETF	397.17	397.74	396.25	396.65	36878.0
2021-11-24 05:00:00	QQQ	ETF	396.42	396.9	395.64	395.64	34284.0
2021-11-24 06:00:00	QQQ	ETF	395.63	397.13	395.61	396.46	78384.0
2021-11-24 07:00:00	QQQ	ETF	396.4	396.7	395.7	395.9	120958.0
2021-11-24 08:00:00	QQQ	ETF	395.92	398.55	394.551	394.8	590098.0
2021-11-24 09:00:00	QQQ	ETF	394.78	395.12	392.54	394.47	7179217.0
2021-11-24 10:00:00	QQQ	ETF	394.45	396.63	393.81	396.08	7969342.0
2021-11-24 11:00:00	QQQ	ETF	396.07	398.28	395.13	397.52	5299006.0
2021-11-24 12:00:00	QQQ	ETF	397.53	397.96	396.68	397.73	2585032.0
2021-11-24 13:00:00	QQQ	ETF	397.74	398.25	397.37	397.45	2278031.0
2021-11-24 14:00:00	QQQ	ETF	397.43	398.255	396.18	397.9801	4643964.0
2021-11-24 15:00:00	QQQ	ETF	397.97	399.05	397.68	398.89	5088663.0
2021-11-24 16:00:00	QQQ	ETF	398.89	398.89	398.55	398.7	1053666.0
2021-11-24 17:00:00	QQQ	ETF	398.75	398.84	398.63	398.84	553732.0
2021-11-24 18:00:00	QQQ	ETF	398.8	398.93	398.68	398.8	62923.0
2021-11-24 19:00:00	QQQ	ETF	398.85	399.22	398.78	399.17	41143.0
2021-11-24 04:00:00	IWM	ETF	231.18	231.26	229.74	229.93	27945.0
2021-11-24 05:00:00	IWM	ETF	229.87	230.5	229.85	229.88	17469.0
2021-11-24 06:00:00	IWM	ETF	229.76	230.62	229.64	230.4	17583.0
2021-11-24 07:00:00	IWM	ETF	230.38	230.68	229.95	230.08	64391.0
2021-11-24 08:00:00	IWM	ETF	230.0501	231.55	229.5	229.57	129266.0
2021-11-24 09:00:00	IWM	ETF	229.56	229.91	228.54	229.67	3049023.0
2021-11-24 10:00:00	IWM	ETF	229.67	231.53	229.21	230.67	5278649.0
2021-11-24 11:00:00	IWM	ETF	230.68	231.6	230.47	231.17	2165635.0
2021-11-24 12:00:00	IWM	ETF	231.15	231.22	230.37	231.02	1362274.0
2021-11-24 13:00:00	IWM	ETF	231.03	231.61	230.9901	231.085	1013642.0
2021-11-24 14:00:00	IWM	ETF	231.09	231.46	230.26	231.25	1628344.0
2021-11-24 15:00:00	IWM	ETF	231.23	231.99	230.96	231.57	2860348.0
2021-11-24 16:00:00	IWM	ETF	231.58	231.86	229.9302	231.73	1112157.0
2021-11-24 17:00:00	IWM	ETF	231.69	231.78	231.58	231.78	20644.0
2021-11-24 18:00:00	IWM	ETF	231.78	232.04	231.58	232.03	36590.0
2021-11-24 19:00:00	IWM	ETF	232.03	232.46	232.03	232.46	29527.0
2021-11-24 04:00:00	DIA	ETF	357.82	357.82	357.82	357.82	100.0
2021-11-24 05:00:00	DIA	ETF	356.97	357.03	356.97	357.03	900.0

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

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