PREVIEW / etf_1hour / 2024-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-03-26.parquet
  size:    523 KB
  rows:    19,635

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-26 04:00:00	SPY	ETF	520.98	521.7	520.91	521.51	12406.0
2024-03-26 05:00:00	SPY	ETF	521.5	522.0	521.5	521.89	27245.0
2024-03-26 06:00:00	SPY	ETF	521.97	522.18	521.97	522.17	47303.0
2024-03-26 07:00:00	SPY	ETF	522.16	522.2	521.76	522.1	82094.0
2024-03-26 08:00:00	SPY	ETF	522.1	522.25	520.56	521.24	251029.0
2024-03-26 09:00:00	SPY	ETF	521.2	521.44	520.81	521.25	3073651.0
2024-03-26 10:00:00	SPY	ETF	521.25	521.58	520.65	521.3	4908843.0
2024-03-26 11:00:00	SPY	ETF	521.29	521.4599	521.0699	521.3969	2563570.0
2024-03-26 12:00:00	SPY	ETF	521.4	521.46	520.75	520.88	2974169.0
2024-03-26 13:00:00	SPY	ETF	520.87	521.01	520.49	520.655	2600523.0
2024-03-26 14:00:00	SPY	ETF	520.66	521.05	520.635	520.85	2630168.0
2024-03-26 15:00:00	SPY	ETF	520.86	520.91	518.4	518.66	18157577.0
2024-03-26 16:00:00	SPY	ETF	518.66	519.48	518.36	519.36	5224672.0
2024-03-26 17:00:00	SPY	ETF	519.31	519.5	518.81	519.45	74244.0
2024-03-26 18:00:00	SPY	ETF	519.46	519.51	519.3	519.46	53563.0
2024-03-26 19:00:00	SPY	ETF	519.46	519.72	519.36	519.7	74307.0
2024-03-26 20:00:00	SPY	ETF	519.71	519.71	519.71	519.71	100.0
2024-03-26 04:00:00	QQQ	ETF	446.3	447.0	446.19	446.8	59129.0
2024-03-26 05:00:00	QQQ	ETF	446.85	447.33	446.79	447.11	41991.0
2024-03-26 06:00:00	QQQ	ETF	447.18	447.34	446.96	447.27	31763.0
2024-03-26 07:00:00	QQQ	ETF	447.2	447.45	446.87	447.35	83048.0
2024-03-26 08:00:00	QQQ	ETF	447.35	447.41	445.093	446.3	289322.0
2024-03-26 09:00:00	QQQ	ETF	446.28	446.91	445.85	446.775	2839816.0
2024-03-26 10:00:00	QQQ	ETF	446.775	447.225	445.43	446.12	4371033.0
2024-03-26 11:00:00	QQQ	ETF	446.15	446.59	445.83	446.54	2222939.0
2024-03-26 12:00:00	QQQ	ETF	446.55	446.75	445.47	445.65	2057331.0
2024-03-26 13:00:00	QQQ	ETF	445.64	445.99	445.34	445.5399	1858810.0
2024-03-26 14:00:00	QQQ	ETF	445.52	446.12	445.51	445.91	1781759.0
2024-03-26 15:00:00	QQQ	ETF	445.92	445.93	443.09	443.31	9295618.0
2024-03-26 16:00:00	QQQ	ETF	443.31	444.15	443.12	444.0	1049223.0
2024-03-26 17:00:00	QQQ	ETF	444.03	444.04	443.32	443.99	77265.0
2024-03-26 18:00:00	QQQ	ETF	443.98	444.01	443.79	443.96	27898.0
2024-03-26 19:00:00	QQQ	ETF	443.94	444.35	443.9	444.27	44609.0
2024-03-26 04:00:00	IWM	ETF	206.31	206.71	206.27	206.71	24373.0
2024-03-26 05:00:00	IWM	ETF	206.6	207.22	206.46	207.08	28453.0
2024-03-26 06:00:00	IWM	ETF	207.08	207.16	206.94	207.11	10470.0
2024-03-26 07:00:00	IWM	ETF	207.04	207.24	206.94	207.19	63858.0
2024-03-26 08:00:00	IWM	ETF	207.03	207.2	206.5	206.83	136320.0
2024-03-26 09:00:00	IWM	ETF	206.92	207.635	206.49	206.8	2623118.0
2024-03-26 10:00:00	IWM	ETF	206.83	206.86	205.64	206.205	2646696.0
2024-03-26 11:00:00	IWM	ETF	206.21	206.215	205.44	205.8921	2313681.0
2024-03-26 12:00:00	IWM	ETF	205.89	206.08	205.78	205.83	1099703.0
2024-03-26 13:00:00	IWM	ETF	205.83	206.18	205.72	205.94	1364987.0
2024-03-26 14:00:00	IWM	ETF	205.94	206.485	205.91	206.24	1015798.0
2024-03-26 15:00:00	IWM	ETF	206.24	206.24	204.99	205.14	4117320.0
2024-03-26 16:00:00	IWM	ETF	205.17	205.56	205.08	205.43	1932430.0
2024-03-26 17:00:00	IWM	ETF	205.42	205.59	205.37	205.46	9053.0
2024-03-26 18:00:00	IWM	ETF	205.54	205.58	205.42	205.5	17001.0
2024-03-26 19:00:00	IWM	ETF	205.51	205.67	205.51	205.59	55004.0
2024-03-26 04:00:00	DIA	ETF	393.21	393.56	393.21	393.56	300.0

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

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