PREVIEW / etf_1hour / 2024-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-03-05.parquet
  size:    537 KB
  rows:    20,115

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-05 04:00:00	SPY	ETF	510.73	511.0	510.5	510.55	12859.0
2024-03-05 05:00:00	SPY	ETF	510.54	510.95	510.4	510.86	19573.0
2024-03-05 06:00:00	SPY	ETF	510.92	511.12	510.78	511.01	141752.0
2024-03-05 07:00:00	SPY	ETF	511.01	511.24	510.45	510.549	96052.0
2024-03-05 08:00:00	SPY	ETF	511.0716	511.4	510.02	510.15	240426.0
2024-03-05 09:00:00	SPY	ETF	510.1699	510.33	509.32	509.66	5406069.0
2024-03-05 10:00:00	SPY	ETF	509.7	510.7	507.5	508.12	9619436.0
2024-03-05 11:00:00	SPY	ETF	508.12	508.41	506.96	507.68	5722881.0
2024-03-05 12:00:00	SPY	ETF	507.66	508.51	507.54	507.99	4017349.0
2024-03-05 13:00:00	SPY	ETF	508.01	508.159	506.67	506.76	4946216.0
2024-03-05 14:00:00	SPY	ETF	506.76	507.375	505.3	505.72	6751244.0
2024-03-05 15:00:00	SPY	ETF	505.73	507.37	504.91	507.15	15848366.0
2024-03-05 16:00:00	SPY	ETF	507.14	507.8	507.0844	507.71	3610516.0
2024-03-05 17:00:00	SPY	ETF	507.71	507.83	507.18	507.75	265469.0
2024-03-05 18:00:00	SPY	ETF	507.7	507.7	507.22	507.34	129671.0
2024-03-05 19:00:00	SPY	ETF	507.37	507.38	506.97	506.97	79215.0
2024-03-05 04:00:00	QQQ	ETF	441.32	441.88	440.72	440.77	125837.0
2024-03-05 05:00:00	QQQ	ETF	440.76	441.09	440.31	440.99	67114.0
2024-03-05 06:00:00	QQQ	ETF	441.05	441.48	441.01	441.48	29887.0
2024-03-05 07:00:00	QQQ	ETF	441.51	442.14	441.15	441.311	179525.0
2024-03-05 08:00:00	QQQ	ETF	441.69	443.687	440.4104	440.92	607950.0
2024-03-05 09:00:00	QQQ	ETF	440.86	441.19	438.31	438.72	5972394.0
2024-03-05 10:00:00	QQQ	ETF	438.74	439.76	435.54	436.26	8042691.0
2024-03-05 11:00:00	QQQ	ETF	436.29	436.91	435.4803	436.24	4866457.0
2024-03-05 12:00:00	QQQ	ETF	436.208	437.19	436.1951	436.575	3340145.0
2024-03-05 13:00:00	QQQ	ETF	436.58	436.61	434.72	434.8	3570603.0
2024-03-05 14:00:00	QQQ	ETF	434.79	435.57	434.0	434.26	3942602.0
2024-03-05 15:00:00	QQQ	ETF	434.25	436.155	433.65	436.05	9024171.0
2024-03-05 16:00:00	QQQ	ETF	436.05	437.42	434.2817	437.33	3274996.0
2024-03-05 17:00:00	QQQ	ETF	437.291	437.6	437.23	437.44	153592.0
2024-03-05 18:00:00	QQQ	ETF	437.36	437.36	436.6	436.8	159690.0
2024-03-05 19:00:00	QQQ	ETF	436.8	436.87	436.34	436.41	85596.0
2024-03-05 04:00:00	IWM	ETF	204.84	205.18	204.7	204.74	40186.0
2024-03-05 05:00:00	IWM	ETF	204.81	205.11	204.77	204.95	12559.0
2024-03-05 06:00:00	IWM	ETF	205.08	205.41	205.03	205.25	14689.0
2024-03-05 07:00:00	IWM	ETF	205.25	205.3	204.72	204.72	98630.0
2024-03-05 08:00:00	IWM	ETF	204.7	205.27	204.43	204.64	115335.0
2024-03-05 09:00:00	IWM	ETF	204.75	205.46	204.09	204.93	2836318.0
2024-03-05 10:00:00	IWM	ETF	204.95	205.91	204.15	204.59	4450146.0
2024-03-05 11:00:00	IWM	ETF	204.58	204.75	203.98	204.59	2155057.0
2024-03-05 12:00:00	IWM	ETF	204.59	205.18	204.55	205.03	2213087.0
2024-03-05 13:00:00	IWM	ETF	205.03	205.21	204.205	204.265	2425067.0
2024-03-05 14:00:00	IWM	ETF	204.24	204.54	203.28	203.395	3234279.0
2024-03-05 15:00:00	IWM	ETF	203.38	203.91	203.01	203.72	7662594.0
2024-03-05 16:00:00	IWM	ETF	203.73	203.99	203.71	203.76	994369.0
2024-03-05 17:00:00	IWM	ETF	203.73	203.97	203.73	203.86	34864.0
2024-03-05 18:00:00	IWM	ETF	203.85	203.85	203.58	203.8	43137.0
2024-03-05 19:00:00	IWM	ETF	203.78	203.78	203.41	203.41	74312.0
2024-03-05 04:00:00	DIA	ETF	389.59	389.9	389.59	389.68	1857.0
2024-03-05 05:00:00	DIA	ETF	389.79	389.82	389.7	389.82	3809.0

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

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