PREVIEW / etf_1hour / 2024-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-03-25.parquet
  size:    528 KB
  rows:    19,769

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-25 04:00:00	SPY	ETF	520.85	521.38	520.85	521.1	19034.0
2024-03-25 05:00:00	SPY	ETF	521.08	521.13	520.28	520.3	15140.0
2024-03-25 06:00:00	SPY	ETF	520.28	520.42	520.03	520.08	23951.0
2024-03-25 07:00:00	SPY	ETF	520.13	520.13	519.39	519.66	103589.0
2024-03-25 08:00:00	SPY	ETF	519.79	521.12	519.49	519.89	119984.0
2024-03-25 09:00:00	SPY	ETF	519.8897	520.41	519.61	520.3	4256448.0
2024-03-25 10:00:00	SPY	ETF	520.28	520.89	520.06	520.64	4634207.0
2024-03-25 11:00:00	SPY	ETF	520.65	520.86	520.3799	520.595	3259503.0
2024-03-25 12:00:00	SPY	ETF	520.59	520.7	520.23	520.43	3249921.0
2024-03-25 13:00:00	SPY	ETF	520.44	520.705	520.13	520.66	3006842.0
2024-03-25 14:00:00	SPY	ETF	520.67	520.95	520.56	520.81	2440943.0
2024-03-25 15:00:00	SPY	ETF	520.82	520.83	519.67	519.81	11044155.0
2024-03-25 16:00:00	SPY	ETF	519.81	520.13	519.77	520.11	4267513.0
2024-03-25 17:00:00	SPY	ETF	520.11	520.13	520.01	520.13	90930.0
2024-03-25 18:00:00	SPY	ETF	520.14	520.4503	519.77	520.319	92928.0
2024-03-25 19:00:00	SPY	ETF	520.37	520.53	520.24	520.47	15593.0
2024-03-25 04:00:00	QQQ	ETF	445.65	446.04	445.49	445.88	52490.0
2024-03-25 05:00:00	QQQ	ETF	445.8	445.8	445.03	445.16	25826.0
2024-03-25 06:00:00	QQQ	ETF	445.1	445.25	444.47	444.55	54277.0
2024-03-25 07:00:00	QQQ	ETF	444.59	444.63	443.53	443.83	140572.0
2024-03-25 08:00:00	QQQ	ETF	443.83	446.714	443.51	443.99	178912.0
2024-03-25 09:00:00	QQQ	ETF	443.98	444.27	442.54	444.07	3678077.0
2024-03-25 10:00:00	QQQ	ETF	444.05	445.56	443.78	445.09	3761585.0
2024-03-25 11:00:00	QQQ	ETF	445.09	445.83	444.93	445.465	2761742.0
2024-03-25 12:00:00	QQQ	ETF	445.46	445.49	444.82	445.25	1803823.0
2024-03-25 13:00:00	QQQ	ETF	445.28	445.92	444.93	445.81	1768376.0
2024-03-25 14:00:00	QQQ	ETF	445.81	446.26	445.7	446.15	1854746.0
2024-03-25 15:00:00	QQQ	ETF	446.165	446.21	444.7	444.74	4856156.0
2024-03-25 16:00:00	QQQ	ETF	444.74	445.32	444.73	445.2702	644402.0
2024-03-25 17:00:00	QQQ	ETF	445.27	445.36	445.0	445.13	103615.0
2024-03-25 18:00:00	QQQ	ETF	445.16	445.52	445.16	445.31	46770.0
2024-03-25 19:00:00	QQQ	ETF	445.36	445.55	445.17	445.5	35599.0
2024-03-25 04:00:00	IWM	ETF	205.13	205.49	205.13	205.27	12830.0
2024-03-25 05:00:00	IWM	ETF	205.28	205.37	205.13	205.13	4618.0
2024-03-25 06:00:00	IWM	ETF	205.24	205.24	204.92	205.15	13399.0
2024-03-25 07:00:00	IWM	ETF	205.28	205.28	204.9	204.95	99537.0
2024-03-25 08:00:00	IWM	ETF	205.2	205.42	204.92	205.42	55850.0
2024-03-25 09:00:00	IWM	ETF	205.38	207.01	205.35	206.75	2869752.0
2024-03-25 10:00:00	IWM	ETF	206.74	206.88	206.1805	206.8699	2051253.0
2024-03-25 11:00:00	IWM	ETF	206.87	206.895	206.48	206.52	1161778.0
2024-03-25 12:00:00	IWM	ETF	206.51	206.52	206.17	206.45	1295241.0
2024-03-25 13:00:00	IWM	ETF	206.46	206.4799	206.24	206.45	745674.0
2024-03-25 14:00:00	IWM	ETF	206.45	206.56	206.28	206.32	883798.0
2024-03-25 15:00:00	IWM	ETF	206.32	206.32	205.51	205.51	3213626.0
2024-03-25 16:00:00	IWM	ETF	205.52	205.72	205.45	205.69	435701.0
2024-03-25 17:00:00	IWM	ETF	205.71	205.92	205.67	205.84	27931.0
2024-03-25 18:00:00	IWM	ETF	205.83	206.15	205.75	206.09	40544.0
2024-03-25 19:00:00	IWM	ETF	206.05	206.25	205.54	206.16	425673.0
2024-03-25 04:00:00	DIA	ETF	394.02	394.02	394.02	394.02	100.0
2024-03-25 05:00:00	DIA	ETF	394.04	394.04	394.03	394.03	500.0

> showing 50 of 19,769 rows — these rows as CSV

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