PREVIEW / etf_1hour / 2021-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-18.parquet
  size:    433 KB
  rows:    15,262

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-18 04:00:00	SPY	ETF	469.25	469.85	469.25	469.45	39908.0
2021-11-18 05:00:00	SPY	ETF	469.33	469.55	469.22	469.55	57051.0
2021-11-18 06:00:00	SPY	ETF	469.49	469.8	469.39	469.61	64812.0
2021-11-18 07:00:00	SPY	ETF	469.62	469.63	469.18	469.21	168595.0
2021-11-18 08:00:00	SPY	ETF	469.6	469.8004	468.471	469.21	213999.0
2021-11-18 09:00:00	SPY	ETF	469.23	469.49	468.275	468.49	4228174.0
2021-11-18 10:00:00	SPY	ETF	468.5	468.7	466.34	467.505	7519758.0
2021-11-18 11:00:00	SPY	ETF	467.49	469.25	467.12	469.0	4913868.0
2021-11-18 12:00:00	SPY	ETF	469.04	469.97	468.77	469.015	3979961.0
2021-11-18 13:00:00	SPY	ETF	469.0	469.56	468.88	469.3799	2651996.0
2021-11-18 14:00:00	SPY	ETF	469.355	469.559	468.64	469.49	2913776.0
2021-11-18 15:00:00	SPY	ETF	469.49	470.01	469.36	469.72	8943788.0
2021-11-18 16:00:00	SPY	ETF	469.71	470.13	469.0	470.0	2410789.0
2021-11-18 17:00:00	SPY	ETF	470.0	470.04	469.73	469.97	83580.0
2021-11-18 18:00:00	SPY	ETF	469.97	470.21	469.73	470.01	71005.0
2021-11-18 19:00:00	SPY	ETF	470.01	470.25	469.9096	470.1	47841.0
2021-11-18 04:00:00	QQQ	ETF	398.62	400.0	398.62	399.46	69516.0
2021-11-18 05:00:00	QQQ	ETF	399.47	399.78	399.35	399.78	21982.0
2021-11-18 06:00:00	QQQ	ETF	399.76	399.95	399.61	399.79	35811.0
2021-11-18 07:00:00	QQQ	ETF	399.74	399.82	399.55	399.61	89443.0
2021-11-18 08:00:00	QQQ	ETF	399.6701	399.9496	397.928	399.71	258294.0
2021-11-18 09:00:00	QQQ	ETF	399.73	400.31	398.65	399.71	4535654.0
2021-11-18 10:00:00	QQQ	ETF	399.76	400.26	397.45	398.81	6997915.0
2021-11-18 11:00:00	QQQ	ETF	398.78	401.68	398.18	401.1	4785510.0
2021-11-18 12:00:00	QQQ	ETF	401.09	401.94	400.35	400.7	3524899.0
2021-11-18 13:00:00	QQQ	ETF	400.67	401.235	400.3981	400.6589	2051246.0
2021-11-18 14:00:00	QQQ	ETF	400.64	401.17	399.93	400.91	2242363.0
2021-11-18 15:00:00	QQQ	ETF	400.91	402.27	400.74	401.75	5777531.0
2021-11-18 16:00:00	QQQ	ETF	401.74	402.36	401.68	402.33	879002.0
2021-11-18 17:00:00	QQQ	ETF	402.33	402.5	401.75	402.15	41880.0
2021-11-18 18:00:00	QQQ	ETF	402.18	402.3	401.99	402.12	75713.0
2021-11-18 19:00:00	QQQ	ETF	402.06	402.3	402.02	402.27	33501.0
2021-11-18 04:00:00	IWM	ETF	236.18	236.91	236.18	236.41	11457.0
2021-11-18 05:00:00	IWM	ETF	236.34	236.42	236.23	236.31	7553.0
2021-11-18 06:00:00	IWM	ETF	236.43	236.56	236.34	236.37	8941.0
2021-11-18 07:00:00	IWM	ETF	236.33	236.45	235.82	235.91	68068.0
2021-11-18 08:00:00	IWM	ETF	236.31	236.5096	235.86	236.41	66693.0
2021-11-18 09:00:00	IWM	ETF	236.47	237.07	235.24	235.24	2800737.0
2021-11-18 10:00:00	IWM	ETF	235.24	235.47	233.05	234.34	6396883.0
2021-11-18 11:00:00	IWM	ETF	234.34	235.42	234.05	235.11	2642829.0
2021-11-18 12:00:00	IWM	ETF	235.145	235.77	234.37	234.685	2095164.0
2021-11-18 13:00:00	IWM	ETF	234.67	234.86	234.32	234.37	995446.0
2021-11-18 14:00:00	IWM	ETF	234.38	234.695	233.555	234.565	1776188.0
2021-11-18 15:00:00	IWM	ETF	234.56	234.94	234.14	234.87	4408712.0
2021-11-18 16:00:00	IWM	ETF	234.86	235.04	234.43	234.87	3177666.0
2021-11-18 17:00:00	IWM	ETF	234.93	234.93	234.85	234.92	27243.0
2021-11-18 18:00:00	IWM	ETF	234.92	235.1	234.76	235.0	140830.0
2021-11-18 19:00:00	IWM	ETF	235.03	235.2	234.96	235.04	33652.0
2021-11-18 04:00:00	DIA	ETF	360.48	360.48	360.44	360.44	2999.0
2021-11-18 05:00:00	DIA	ETF	360.36	360.36	360.35	360.35	900.0

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

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