PREVIEW / etf_1hour / 2023-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-22.parquet
  size:    464 KB
  rows:    17,214

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
2023-03-22 04:00:00	SPY	ETF	397.94	398.19	397.47	397.85	57152.0
2023-03-22 05:00:00	SPY	ETF	397.88	398.56	397.76	398.37	39833.0
2023-03-22 06:00:00	SPY	ETF	398.3	399.06	398.08	398.92	29778.0
2023-03-22 07:00:00	SPY	ETF	398.9	399.34	398.52	398.67	110553.0
2023-03-22 08:00:00	SPY	ETF	398.86	399.32	397.78	398.76	223642.0
2023-03-22 09:00:00	SPY	ETF	398.72	399.06	398.08	398.57	5240797.0
2023-03-22 10:00:00	SPY	ETF	398.58	399.88	398.31	399.25	6380494.0
2023-03-22 11:00:00	SPY	ETF	399.24	399.39	398.39	398.915	4625614.0
2023-03-22 12:00:00	SPY	ETF	398.91	398.98	397.84	397.93	4686993.0
2023-03-22 13:00:00	SPY	ETF	397.94	398.77	397.37	398.54	4936847.0
2023-03-22 14:00:00	SPY	ETF	398.58	402.49	397.4	398.56	25901884.0
2023-03-22 15:00:00	SPY	ETF	398.56	399.89	392.07	392.14	29450762.0
2023-03-22 16:00:00	SPY	ETF	392.16	392.99	391.87	392.35	6483719.0
2023-03-22 17:00:00	SPY	ETF	392.41	392.65	392.22	392.4	121239.0
2023-03-22 18:00:00	SPY	ETF	392.57	393.0	392.51	392.9	160981.0
2023-03-22 19:00:00	SPY	ETF	392.88	392.9	392.54	392.76	55259.0
2023-03-22 04:00:00	QQQ	ETF	309.28	309.34	308.75	308.93	50714.0
2023-03-22 05:00:00	QQQ	ETF	308.82	309.64	308.81	309.39	26633.0
2023-03-22 06:00:00	QQQ	ETF	309.48	309.89	309.32	309.83	41487.0
2023-03-22 07:00:00	QQQ	ETF	309.78	310.14	309.59	309.75	100360.0
2023-03-22 08:00:00	QQQ	ETF	309.7614	310.572	308.8296	309.85	168357.0
2023-03-22 09:00:00	QQQ	ETF	309.78	310.82	309.74	310.51	2932260.0
2023-03-22 10:00:00	QQQ	ETF	310.5	311.85	310.035	311.215	5048417.0
2023-03-22 11:00:00	QQQ	ETF	311.21	311.978	310.59	311.66	2794445.0
2023-03-22 12:00:00	QQQ	ETF	311.67	311.67	310.29	310.7	2566296.0
2023-03-22 13:00:00	QQQ	ETF	310.71	311.66	310.21	311.465	2519527.0
2023-03-22 14:00:00	QQQ	ETF	311.51	315.25	310.33	311.41	20305116.0
2023-03-22 15:00:00	QQQ	ETF	311.41	313.08	305.95	305.99	18483157.0
2023-03-22 16:00:00	QQQ	ETF	306.01	306.45	305.51	306.08	2358301.0
2023-03-22 17:00:00	QQQ	ETF	306.19	306.28	306.08	306.2	191275.0
2023-03-22 18:00:00	QQQ	ETF	306.12	306.65	306.01	306.58	169238.0
2023-03-22 19:00:00	QQQ	ETF	306.55	306.65	306.27	306.5	125214.0
2023-03-22 04:00:00	IWM	ETF	176.38	176.65	176.09	176.55	10528.0
2023-03-22 05:00:00	IWM	ETF	176.47	176.92	176.43	176.88	5544.0
2023-03-22 06:00:00	IWM	ETF	176.75	177.17	176.56	177.05	27029.0
2023-03-22 07:00:00	IWM	ETF	177.03	177.23	176.62	176.63	17498.0
2023-03-22 08:00:00	IWM	ETF	176.2604	177.02	176.2604	176.61	40840.0
2023-03-22 09:00:00	IWM	ETF	176.66	176.78	175.15	175.96	3326050.0
2023-03-22 10:00:00	IWM	ETF	175.94	176.56	175.85	176.17	2808466.0
2023-03-22 11:00:00	IWM	ETF	176.16	176.31	175.29	175.4716	1995880.0
2023-03-22 12:00:00	IWM	ETF	175.47	175.71	175.18	175.41	2731014.0
2023-03-22 13:00:00	IWM	ETF	175.42	175.66	174.97	175.57	2655315.0
2023-03-22 14:00:00	IWM	ETF	175.59	177.35	174.57	174.91	9121381.0
2023-03-22 15:00:00	IWM	ETF	174.87	175.64	171.53	171.54	12901534.0
2023-03-22 16:00:00	IWM	ETF	171.54	172.35	171.5	172.04	2568672.0
2023-03-22 17:00:00	IWM	ETF	172.17	172.27	171.64	172.05	456677.0
2023-03-22 18:00:00	IWM	ETF	172.05	172.34	172.0	172.17	26791.0
2023-03-22 19:00:00	IWM	ETF	172.02	172.18	171.92	172.08	54047.0
2023-03-22 04:00:00	DIA	ETF	324.72	325.08	324.72	324.9	500.0
2023-03-22 05:00:00	DIA	ETF	325.28	325.28	325.28	325.28	300.0

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

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