PREVIEW / etf_1hour / 2024-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-03-28.parquet
  size:    542 KB
  rows:    20,032

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
2024-03-28 04:00:00	SPY	ETF	522.82	522.96	522.6	522.73	43906.0
2024-03-28 05:00:00	SPY	ETF	522.74	522.91	522.41	522.51	10619.0
2024-03-28 06:00:00	SPY	ETF	522.68	523.15	522.68	522.99	31165.0
2024-03-28 07:00:00	SPY	ETF	522.86	523.05	522.56	522.87	74193.0
2024-03-28 08:00:00	SPY	ETF	522.85	523.48	522.54	523.11	488133.0
2024-03-28 09:00:00	SPY	ETF	523.17	523.6707	522.78	523.24	3186164.0
2024-03-28 10:00:00	SPY	ETF	523.25	523.73	522.93	523.43	5285492.0
2024-03-28 11:00:00	SPY	ETF	523.42	523.73	523.16	523.59	3687840.0
2024-03-28 12:00:00	SPY	ETF	523.59	523.6	523.08	523.35	4259142.0
2024-03-28 13:00:00	SPY	ETF	523.35	523.49	522.92	523.38	3543101.0
2024-03-28 14:00:00	SPY	ETF	523.39	524.285	523.02	524.13	6483029.0
2024-03-28 15:00:00	SPY	ETF	524.14	524.61	522.93	523.12	19145453.0
2024-03-28 16:00:00	SPY	ETF	523.12	523.4758	522.77	523.02	6222036.0
2024-03-28 17:00:00	SPY	ETF	522.9905	523.0495	522.8002	522.85	141695.0
2024-03-28 18:00:00	SPY	ETF	522.86	523.55	522.86	523.2	82901.0
2024-03-28 19:00:00	SPY	ETF	523.19	523.19	522.93	522.95	13275.0
2024-03-28 04:00:00	QQQ	ETF	444.9	445.16	444.5	444.5	40371.0
2024-03-28 05:00:00	QQQ	ETF	444.55	444.63	443.88	444.32	26772.0
2024-03-28 06:00:00	QQQ	ETF	444.39	444.95	444.39	444.6	78583.0
2024-03-28 07:00:00	QQQ	ETF	444.59	444.87	444.27	444.62	127740.0
2024-03-28 08:00:00	QQQ	ETF	443.24	445.45	443.24	444.75	191356.0
2024-03-28 09:00:00	QQQ	ETF	444.83	445.61	443.76	445.0399	2973631.0
2024-03-28 10:00:00	QQQ	ETF	445.04	445.64	444.14	444.82	3822156.0
2024-03-28 11:00:00	QQQ	ETF	444.82	445.08	444.35	445.0	2854203.0
2024-03-28 12:00:00	QQQ	ETF	445.011	445.03	444.0	444.32	2444421.0
2024-03-28 13:00:00	QQQ	ETF	444.32	444.38	443.7313	444.1	1886927.0
2024-03-28 14:00:00	QQQ	ETF	444.12	445.03	443.65	444.86	2698743.0
2024-03-28 15:00:00	QQQ	ETF	444.875	445.15	443.82	443.97	8302618.0
2024-03-28 16:00:00	QQQ	ETF	443.96	444.29	443.61	444.0	1180644.0
2024-03-28 17:00:00	QQQ	ETF	444.0	444.13	443.96	444.0	54741.0
2024-03-28 18:00:00	QQQ	ETF	444.03	444.28	444.01	444.15	22193.0
2024-03-28 19:00:00	QQQ	ETF	444.1	444.15	443.95	443.98	16187.0
2024-03-28 04:00:00	IWM	ETF	209.4	209.44	209.23	209.33	66907.0
2024-03-28 05:00:00	IWM	ETF	209.34	209.43	209.22	209.38	3166.0
2024-03-28 06:00:00	IWM	ETF	209.45	209.69	209.41	209.57	13821.0
2024-03-28 07:00:00	IWM	ETF	209.47	210.05	209.47	210.01	75731.0
2024-03-28 08:00:00	IWM	ETF	209.76	210.22	209.2504	210.04	342024.0
2024-03-28 09:00:00	IWM	ETF	210.13	210.7997	209.8	210.29	3213469.0
2024-03-28 10:00:00	IWM	ETF	210.29	211.44	210.11	211.105	5067509.0
2024-03-28 11:00:00	IWM	ETF	211.11	211.875	210.66	211.695	4611128.0
2024-03-28 12:00:00	IWM	ETF	211.68	211.78	210.815	210.85	2726050.0
2024-03-28 13:00:00	IWM	ETF	210.85	211.035	210.51	210.66	1650391.0
2024-03-28 14:00:00	IWM	ETF	210.67	210.745	210.175	210.73	2319411.0
2024-03-28 15:00:00	IWM	ETF	210.72	210.81	210.155	210.31	6048390.0
2024-03-28 16:00:00	IWM	ETF	210.3	210.539	210.2	210.37	1834521.0
2024-03-28 17:00:00	IWM	ETF	210.35	210.45	210.15	210.15	16758.0
2024-03-28 18:00:00	IWM	ETF	210.17	210.35	210.17	210.34	22771.0
2024-03-28 19:00:00	IWM	ETF	210.27	210.35	210.23	210.23	5403.0
2024-03-28 04:00:00	DIA	ETF	397.14	397.57	397.06	397.57	7475.0
2024-03-28 05:00:00	DIA	ETF	397.64	397.64	397.44	397.48	1461.0

> showing 50 of 20,032 rows — these rows as CSV

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