PREVIEW / etf_1hour / 2023-03-27

all etf 1-hour files

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

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-27 04:00:00	SPY	ETF	397.25	397.25	395.84	396.83	77277.0
2023-03-27 05:00:00	SPY	ETF	396.96	397.6	396.65	397.2	34193.0
2023-03-27 06:00:00	SPY	ETF	397.51	398.26	397.5	397.96	73710.0
2023-03-27 07:00:00	SPY	ETF	397.94	398.8	397.94	398.38	508501.0
2023-03-27 08:00:00	SPY	ETF	398.4	398.75	395.6	398.0	342416.0
2023-03-27 09:00:00	SPY	ETF	398.05	398.92	397.41	398.0399	7518746.0
2023-03-27 10:00:00	SPY	ETF	398.04	398.22	396.23	396.41	8499717.0
2023-03-27 11:00:00	SPY	ETF	396.41	396.87	395.56	395.96	5718768.0
2023-03-27 12:00:00	SPY	ETF	395.95	396.97	395.57	396.43	5872296.0
2023-03-27 13:00:00	SPY	ETF	396.45	397.545	396.04	396.83	5120919.0
2023-03-27 14:00:00	SPY	ETF	396.84	398.12	396.385	398.04	5585688.0
2023-03-27 15:00:00	SPY	ETF	398.04	398.27	395.84	396.45	14917705.0
2023-03-27 16:00:00	SPY	ETF	396.45	396.95	396.2524	396.92	2718732.0
2023-03-27 17:00:00	SPY	ETF	396.99	397.0	396.2735	396.93	1519386.0
2023-03-27 18:00:00	SPY	ETF	396.89	396.89	396.55	396.84	105367.0
2023-03-27 19:00:00	SPY	ETF	396.87	397.06	396.82	397.01	78460.0
2023-03-27 04:00:00	QQQ	ETF	310.78	311.45	310.35	311.32	62883.0
2023-03-27 05:00:00	QQQ	ETF	311.32	311.69	311.1	311.41	33709.0
2023-03-27 06:00:00	QQQ	ETF	311.57	312.04	311.57	311.86	47494.0
2023-03-27 07:00:00	QQQ	ETF	311.82	312.5	311.79	312.21	217161.0
2023-03-27 08:00:00	QQQ	ETF	312.21	312.7	310.13	311.48	362103.0
2023-03-27 09:00:00	QQQ	ETF	311.53	312.7	310.71	311.9099	6694788.0
2023-03-27 10:00:00	QQQ	ETF	311.91	312.2905	310.09	310.17	5986465.0
2023-03-27 11:00:00	QQQ	ETF	310.18	310.35	308.09	308.26	5037969.0
2023-03-27 12:00:00	QQQ	ETF	308.26	309.18	307.89	308.52	4485475.0
2023-03-27 13:00:00	QQQ	ETF	308.51	309.5641	307.9701	308.9	3439581.0
2023-03-27 14:00:00	QQQ	ETF	308.88	310.18	308.48	310.1	3234774.0
2023-03-27 15:00:00	QQQ	ETF	310.095	310.3901	308.16	308.705	8175178.0
2023-03-27 16:00:00	QQQ	ETF	308.71	309.16	308.66	309.05	1494499.0
2023-03-27 17:00:00	QQQ	ETF	309.0	309.07	308.97	309.0	40619.0
2023-03-27 18:00:00	QQQ	ETF	308.94	309.1	308.79	309.09	31778.0
2023-03-27 19:00:00	QQQ	ETF	309.09	309.33	309.08	309.29	78954.0
2023-03-27 04:00:00	IWM	ETF	171.92	172.8	171.92	172.72	22154.0
2023-03-27 05:00:00	IWM	ETF	172.73	173.2	172.61	173.11	39235.0
2023-03-27 06:00:00	IWM	ETF	173.2	173.66	173.07	173.6	67738.0
2023-03-27 07:00:00	IWM	ETF	173.55	174.4	173.55	173.83	224032.0
2023-03-27 08:00:00	IWM	ETF	173.89	174.2	173.2304	173.89	150074.0
2023-03-27 09:00:00	IWM	ETF	173.93	174.1	172.6	173.24	3832234.0
2023-03-27 10:00:00	IWM	ETF	173.25	173.72	172.61	172.64	2913710.0
2023-03-27 11:00:00	IWM	ETF	172.65	173.09	172.36	172.805	2642790.0
2023-03-27 12:00:00	IWM	ETF	172.8	173.49	172.575	173.4801	2632546.0
2023-03-27 13:00:00	IWM	ETF	173.49	174.35	173.38	173.88	2842515.0
2023-03-27 14:00:00	IWM	ETF	173.87	174.52	173.67	174.475	2478547.0
2023-03-27 15:00:00	IWM	ETF	174.46	174.73	173.56	173.78	6733687.0
2023-03-27 16:00:00	IWM	ETF	173.8	174.18	173.7	174.17	1631374.0
2023-03-27 17:00:00	IWM	ETF	174.12	174.2397	173.7	174.16	52116.0
2023-03-27 18:00:00	IWM	ETF	174.09	174.15	173.9	174.15	13601.0
2023-03-27 19:00:00	IWM	ETF	174.15	174.24	174.09	174.18	14103.0
2023-03-27 04:00:00	DIA	ETF	322.72	323.17	322.72	323.17	2336.0
2023-03-27 05:00:00	DIA	ETF	323.33	323.58	323.33	323.58	1393.0

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

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