PREVIEW / etf_1hour / 2024-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-03-08.parquet
  size:    540 KB
  rows:    20,160

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-08 04:00:00	SPY	ETF	515.75	515.87	515.57	515.7	12237.0
2024-03-08 05:00:00	SPY	ETF	515.69	515.69	515.5	515.61	15482.0
2024-03-08 06:00:00	SPY	ETF	515.59	515.65	514.77	514.91	14125.0
2024-03-08 07:00:00	SPY	ETF	514.88	514.92	514.02	514.3	168459.0
2024-03-08 08:00:00	SPY	ETF	514.31	516.8	513.15	516.27	1257582.0
2024-03-08 09:00:00	SPY	ETF	516.27	517.8004	515.06	517.76	5665644.0
2024-03-08 10:00:00	SPY	ETF	517.76	518.2201	516.9485	517.55	6916972.0
2024-03-08 11:00:00	SPY	ETF	517.54	517.63	513.94	514.017	13023248.0
2024-03-08 12:00:00	SPY	ETF	514.01	514.9	512.3	512.55	8034403.0
2024-03-08 13:00:00	SPY	ETF	512.55	513.26	511.13	511.71	8829240.0
2024-03-08 14:00:00	SPY	ETF	511.71	514.46	511.64	513.83	7857738.0
2024-03-08 15:00:00	SPY	ETF	513.83	514.4	511.72	511.76	12072221.0
2024-03-08 16:00:00	SPY	ETF	511.77	512.67	511.7	512.17	2163554.0
2024-03-08 17:00:00	SPY	ETF	512.14	512.15	511.76	511.76	64892.0
2024-03-08 18:00:00	SPY	ETF	511.76	511.97	511.72	511.7219	361100.0
2024-03-08 19:00:00	SPY	ETF	511.7205	511.82	511.61	511.64	36565.0
2024-03-08 04:00:00	QQQ	ETF	445.89	446.4	445.6	446.24	59258.0
2024-03-08 05:00:00	QQQ	ETF	446.2	446.22	445.6	445.96	37107.0
2024-03-08 06:00:00	QQQ	ETF	445.85	446.06	444.75	445.08	58417.0
2024-03-08 07:00:00	QQQ	ETF	445.16	445.38	444.17	444.59	221166.0
2024-03-08 08:00:00	QQQ	ETF	445.12	447.02	443.22	446.62	1515712.0
2024-03-08 09:00:00	QQQ	ETF	446.55	447.5113	445.07	447.46	4523062.0
2024-03-08 10:00:00	QQQ	ETF	447.47	448.64	446.425	447.28	6015239.0
2024-03-08 11:00:00	QQQ	ETF	447.24	447.4	441.66	442.31	13449656.0
2024-03-08 12:00:00	QQQ	ETF	442.3	443.2	439.32	439.63	7179295.0
2024-03-08 13:00:00	QQQ	ETF	439.59	440.63	438.34	439.155	6759365.0
2024-03-08 14:00:00	QQQ	ETF	439.18	442.31	439.035	441.525	5836784.0
2024-03-08 15:00:00	QQQ	ETF	441.52	442.14	438.98	439.0	10004675.0
2024-03-08 16:00:00	QQQ	ETF	438.99	439.95	438.99	439.39	2026141.0
2024-03-08 17:00:00	QQQ	ETF	439.42	439.63	438.8	438.83	75739.0
2024-03-08 18:00:00	QQQ	ETF	438.83	438.98	438.2	438.31	64768.0
2024-03-08 19:00:00	QQQ	ETF	438.31	438.38	438.0	438.01	61681.0
2024-03-08 04:00:00	IWM	ETF	207.5	207.61	207.26	207.51	16655.0
2024-03-08 05:00:00	IWM	ETF	207.42	207.46	207.17	207.42	14738.0
2024-03-08 06:00:00	IWM	ETF	207.45	207.45	206.88	206.88	17172.0
2024-03-08 07:00:00	IWM	ETF	206.99	207.03	206.37	206.52	50501.0
2024-03-08 08:00:00	IWM	ETF	206.54	209.77	205.5	209.2	1064237.0
2024-03-08 09:00:00	IWM	ETF	209.13	210.41	208.45	209.92	4945174.0
2024-03-08 10:00:00	IWM	ETF	209.92	210.2	209.03	209.79	4407619.0
2024-03-08 11:00:00	IWM	ETF	209.78	209.83	207.31	207.43	5208121.0
2024-03-08 12:00:00	IWM	ETF	207.43	208.06	206.69	206.8	3337066.0
2024-03-08 13:00:00	IWM	ETF	206.8	206.92	205.8	206.17	2977735.0
2024-03-08 14:00:00	IWM	ETF	206.17	207.77	206.145	207.47	2355839.0
2024-03-08 15:00:00	IWM	ETF	207.465	207.7098	206.5	206.77	4994877.0
2024-03-08 16:00:00	IWM	ETF	206.77	207.26	206.74	206.97	1150562.0
2024-03-08 17:00:00	IWM	ETF	206.9999	207.08	206.84	206.93	22098.0
2024-03-08 18:00:00	IWM	ETF	206.83	206.9499	206.83	206.83	4621.0
2024-03-08 19:00:00	IWM	ETF	206.72	206.89	206.72	206.8	4435.0
2024-03-08 05:00:00	DIA	ETF	388.21	388.21	388.21	388.21	300.0
2024-03-08 06:00:00	DIA	ETF	387.81	387.81	387.75	387.75	1125.0

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

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