PREVIEW / etf_1hour / 2022-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-14.parquet
  size:    465 KB
  rows:    17,081

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
2022-11-14 04:00:00	SPY	ETF	398.0	398.0	396.38	396.43	86043.0
2022-11-14 05:00:00	SPY	ETF	396.51	397.07	396.2	396.93	35111.0
2022-11-14 06:00:00	SPY	ETF	396.91	397.3	396.62	396.9	43140.0
2022-11-14 07:00:00	SPY	ETF	396.96	397.6	396.8	397.57	118032.0
2022-11-14 08:00:00	SPY	ETF	397.55	397.91	396.5	397.04	374971.0
2022-11-14 09:00:00	SPY	ETF	397.08	397.8	395.92	397.1255	6492002.0
2022-11-14 10:00:00	SPY	ETF	397.14	398.97	397.13	398.43	7098030.0
2022-11-14 11:00:00	SPY	ETF	398.425	398.62	396.35	397.89	6288678.0
2022-11-14 12:00:00	SPY	ETF	397.8899	399.23	397.39	398.62	4249245.0
2022-11-14 13:00:00	SPY	ETF	398.62	400.17	398.39	400.1001	4864372.0
2022-11-14 14:00:00	SPY	ETF	400.1	400.1799	398.53	398.75	4928203.0
2022-11-14 15:00:00	SPY	ETF	398.78	399.49	394.83	395.18	13372192.0
2022-11-14 16:00:00	SPY	ETF	395.18	397.9008	394.9763	395.93	4147113.0
2022-11-14 17:00:00	SPY	ETF	396.0	396.07	395.73	396.0	143571.0
2022-11-14 18:00:00	SPY	ETF	395.97	396.3	395.86	395.86	121241.0
2022-11-14 19:00:00	SPY	ETF	395.85	396.03	395.61	395.68	93364.0
2022-11-14 04:00:00	QQQ	ETF	286.51	286.85	285.68	285.75	46051.0
2022-11-14 05:00:00	QQQ	ETF	285.78	286.26	285.5	286.06	56143.0
2022-11-14 06:00:00	QQQ	ETF	286.0	286.32	285.78	286.04	54078.0
2022-11-14 07:00:00	QQQ	ETF	286.13	286.84	285.98	286.77	169744.0
2022-11-14 08:00:00	QQQ	ETF	286.13	288.175	285.8296	286.16	396228.0
2022-11-14 09:00:00	QQQ	ETF	286.15	286.54	284.44	285.49	5757682.0
2022-11-14 10:00:00	QQQ	ETF	285.5	287.25	285.5	286.73	7281815.0
2022-11-14 11:00:00	QQQ	ETF	286.72	287.48	285.12	286.9086	5615431.0
2022-11-14 12:00:00	QQQ	ETF	286.92	288.115	286.43	287.49	4006987.0
2022-11-14 13:00:00	QQQ	ETF	287.5	289.13	287.27	289.08	3183970.0
2022-11-14 14:00:00	QQQ	ETF	289.0899	289.215	287.72	288.14	2924445.0
2022-11-14 15:00:00	QQQ	ETF	288.17	288.85	285.06	285.38	8765964.0
2022-11-14 16:00:00	QQQ	ETF	285.38	286.12	285.35	286.02	1831980.0
2022-11-14 17:00:00	QQQ	ETF	286.05	286.18	285.44	286.11	457501.0
2022-11-14 18:00:00	QQQ	ETF	286.05	286.42	286.03	286.03	48043.0
2022-11-14 19:00:00	QQQ	ETF	286.01	286.2599	285.89	285.9	125549.0
2022-11-14 04:00:00	IWM	ETF	186.71	186.71	185.7	185.7	18133.0
2022-11-14 05:00:00	IWM	ETF	185.78	186.05	185.64	185.91	5464.0
2022-11-14 06:00:00	IWM	ETF	185.95	186.16	185.87	185.9	9112.0
2022-11-14 07:00:00	IWM	ETF	185.97	186.3	185.89	186.28	35856.0
2022-11-14 08:00:00	IWM	ETF	186.27	186.8	185.92	186.03	97676.0
2022-11-14 09:00:00	IWM	ETF	186.11	186.355	184.6317	185.67	2595545.0
2022-11-14 10:00:00	IWM	ETF	185.67	186.95	185.65	186.6	2283433.0
2022-11-14 11:00:00	IWM	ETF	186.59	186.69	185.07	185.7017	2143017.0
2022-11-14 12:00:00	IWM	ETF	185.7	186.645	185.422	186.37	1580212.0
2022-11-14 13:00:00	IWM	ETF	186.37	187.785	186.282	187.67	1895184.0
2022-11-14 14:00:00	IWM	ETF	187.66	187.74	186.48	186.61	1708211.0
2022-11-14 15:00:00	IWM	ETF	186.59	186.94	184.8	184.93	3866405.0
2022-11-14 16:00:00	IWM	ETF	184.81	185.5	184.81	185.36	1745829.0
2022-11-14 17:00:00	IWM	ETF	185.36	185.45	184.81	185.35	41510.0
2022-11-14 18:00:00	IWM	ETF	185.41	185.56	185.33	185.36	15222.0
2022-11-14 19:00:00	IWM	ETF	185.43	185.45	185.19	185.23	19868.0
2022-11-14 04:00:00	DIA	ETF	336.71	336.8	336.71	336.8	800.0
2022-11-14 05:00:00	DIA	ETF	336.35	336.78	336.35	336.78	1897.0

> showing 50 of 17,081 rows — these rows as CSV

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