PREVIEW / etf_1hour / 2021-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-17.parquet
  size:    435 KB
  rows:    15,310

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-17 04:00:00	SPY	ETF	469.48	469.48	468.96	469.04	6652.0
2021-11-17 05:00:00	SPY	ETF	469.03	469.04	468.88	468.88	13811.0
2021-11-17 06:00:00	SPY	ETF	468.9	469.08	468.8	469.01	18827.0
2021-11-17 07:00:00	SPY	ETF	469.06	469.31	468.95	468.95	233510.0
2021-11-17 08:00:00	SPY	ETF	469.1599	469.4004	468.4	468.73	712498.0
2021-11-17 09:00:00	SPY	ETF	468.74	469.05	467.48	467.58	4306260.0
2021-11-17 10:00:00	SPY	ETF	467.57	468.82	467.49	468.49	5376085.0
2021-11-17 11:00:00	SPY	ETF	468.485	469.165	468.17	469.085	2643352.0
2021-11-17 12:00:00	SPY	ETF	469.08	469.19	467.66	468.09	3886859.0
2021-11-17 13:00:00	SPY	ETF	468.1	468.75	467.91	468.722	2135055.0
2021-11-17 14:00:00	SPY	ETF	468.71	468.72	467.96	468.49	2551418.0
2021-11-17 15:00:00	SPY	ETF	468.5	468.77	467.97	468.11	8727559.0
2021-11-17 16:00:00	SPY	ETF	468.12	468.27	467.69	468.02	2563986.0
2021-11-17 17:00:00	SPY	ETF	468.04	468.04	467.94	467.99	52603.0
2021-11-17 18:00:00	SPY	ETF	467.99	468.32	467.96	468.32	89349.0
2021-11-17 19:00:00	SPY	ETF	468.34	468.52	468.24	468.37	144550.0
2021-11-17 04:00:00	QQQ	ETF	397.82	398.02	397.7	397.79	31744.0
2021-11-17 05:00:00	QQQ	ETF	397.82	397.87	397.5	397.66	18026.0
2021-11-17 06:00:00	QQQ	ETF	397.72	397.94	397.61	397.86	21994.0
2021-11-17 07:00:00	QQQ	ETF	397.89	398.1	397.71	397.73	93867.0
2021-11-17 08:00:00	QQQ	ETF	397.76	398.1	397.14	397.62	154183.0
2021-11-17 09:00:00	QQQ	ETF	397.59	397.92	396.64	397.0	3056434.0
2021-11-17 10:00:00	QQQ	ETF	396.99	398.66	396.97	398.2	3778705.0
2021-11-17 11:00:00	QQQ	ETF	398.219	399.575	398.05	399.55	2267719.0
2021-11-17 12:00:00	QQQ	ETF	399.5419	399.7196	397.23	397.47	3762063.0
2021-11-17 13:00:00	QQQ	ETF	397.4881	398.58	397.08	398.55	2128280.0
2021-11-17 14:00:00	QQQ	ETF	398.5719	398.5719	397.8	398.41	1425961.0
2021-11-17 15:00:00	QQQ	ETF	398.38	398.42	397.43	397.65	4201928.0
2021-11-17 16:00:00	QQQ	ETF	397.64	397.87	396.95	397.86	1316987.0
2021-11-17 17:00:00	QQQ	ETF	397.71	397.98	397.63	397.8	98305.0
2021-11-17 18:00:00	QQQ	ETF	397.86	398.08	397.83	398.04	47964.0
2021-11-17 19:00:00	QQQ	ETF	398.0	398.23	397.95	398.11	62728.0
2021-11-17 04:00:00	IWM	ETF	238.78	238.85	238.26	238.33	9229.0
2021-11-17 05:00:00	IWM	ETF	238.37	238.4	238.17	238.22	17016.0
2021-11-17 06:00:00	IWM	ETF	238.2	238.44	238.2	238.44	10924.0
2021-11-17 07:00:00	IWM	ETF	238.44	238.65	238.2	238.23	45513.0
2021-11-17 08:00:00	IWM	ETF	238.41	238.6	237.64	238.09	85451.0
2021-11-17 09:00:00	IWM	ETF	238.08	238.2101	236.66	236.7799	2332408.0
2021-11-17 10:00:00	IWM	ETF	236.76	237.15	235.85	236.61	2580951.0
2021-11-17 11:00:00	IWM	ETF	236.59	236.785	236.02	236.37	1688092.0
2021-11-17 12:00:00	IWM	ETF	236.37	236.4981	235.13	235.76	2125389.0
2021-11-17 13:00:00	IWM	ETF	235.75	236.55	235.73	236.51	1694783.0
2021-11-17 14:00:00	IWM	ETF	236.51	236.51	235.43	235.786	1571324.0
2021-11-17 15:00:00	IWM	ETF	235.81	236.39	235.67	235.85	4394960.0
2021-11-17 16:00:00	IWM	ETF	235.855	236.0	235.45	235.6	1780475.0
2021-11-17 17:00:00	IWM	ETF	235.86	235.86	235.61	235.69	1740830.0
2021-11-17 18:00:00	IWM	ETF	235.69	235.94	235.65	235.94	21715.0
2021-11-17 19:00:00	IWM	ETF	235.94	236.23	235.85	236.18	33196.0
2021-11-17 04:00:00	DIA	ETF	361.87	361.88	361.56	361.56	7800.0
2021-11-17 05:00:00	DIA	ETF	361.63	361.7	361.51	361.51	2481.0

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

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