PREVIEW / etf_1hour / 2023-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-11-21.parquet
  size:    500 KB
  rows:    18,224

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
2023-11-21 04:00:00	SPY	ETF	454.4	454.4	453.74	453.75	17953.0
2023-11-21 05:00:00	SPY	ETF	453.75	454.14	453.75	453.99	8464.0
2023-11-21 06:00:00	SPY	ETF	454.0	454.0	453.68	453.71	33964.0
2023-11-21 07:00:00	SPY	ETF	453.75	454.0	453.49	453.54	133297.0
2023-11-21 08:00:00	SPY	ETF	453.741	454.51	453.0	453.05	321184.0
2023-11-21 09:00:00	SPY	ETF	453.05	453.32	452.71	452.82	4358268.0
2023-11-21 10:00:00	SPY	ETF	452.82	453.175	451.9599	452.68	7368174.0
2023-11-21 11:00:00	SPY	ETF	452.68	452.91	452.22	452.885	4907894.0
2023-11-21 12:00:00	SPY	ETF	452.89	453.59	452.7599	453.5397	3777603.0
2023-11-21 13:00:00	SPY	ETF	453.535	453.57	452.6414	453.24	3764048.0
2023-11-21 14:00:00	SPY	ETF	453.26	453.555	452.82	453.305	4697515.0
2023-11-21 15:00:00	SPY	ETF	453.31	453.65	452.89	453.27	8349786.0
2023-11-21 16:00:00	SPY	ETF	453.26	453.27	451.88	452.94	2251398.0
2023-11-21 17:00:00	SPY	ETF	452.97	453.16	452.85	452.95	77648.0
2023-11-21 18:00:00	SPY	ETF	452.96	452.96	452.5	452.72	54445.0
2023-11-21 19:00:00	SPY	ETF	452.72	453.0002	452.71	452.98	21225.0
2023-11-21 04:00:00	QQQ	ETF	390.8	391.0	390.49	390.56	43754.0
2023-11-21 05:00:00	QQQ	ETF	390.52	390.99	390.49	390.7	17160.0
2023-11-21 06:00:00	QQQ	ETF	390.77	390.78	390.12	390.18	51973.0
2023-11-21 07:00:00	QQQ	ETF	390.21	390.52	389.69	389.76	113857.0
2023-11-21 08:00:00	QQQ	ETF	390.2099	391.3	388.84	388.92	341479.0
2023-11-21 09:00:00	QQQ	ETF	388.89	389.23	388.23	388.3799	5096388.0
2023-11-21 10:00:00	QQQ	ETF	388.37	388.81	386.7	387.33	6074165.0
2023-11-21 11:00:00	QQQ	ETF	387.34	387.81	386.95	387.77	4398492.0
2023-11-21 12:00:00	QQQ	ETF	387.78	388.49	387.6	388.4	2987027.0
2023-11-21 13:00:00	QQQ	ETF	388.39	388.4288	387.32	388.12	2827524.0
2023-11-21 14:00:00	QQQ	ETF	388.115	388.51	387.71	388.37	3212529.0
2023-11-21 15:00:00	QQQ	ETF	388.37	388.73	388.06	388.43	7236402.0
2023-11-21 16:00:00	QQQ	ETF	388.43	389.19	386.5	387.98	3255269.0
2023-11-21 17:00:00	QQQ	ETF	388.07	388.16	387.83	387.93	96910.0
2023-11-21 18:00:00	QQQ	ETF	387.87	387.87	387.36	387.6	84374.0
2023-11-21 19:00:00	QQQ	ETF	387.6	387.87	387.6	387.84	70858.0
2023-11-21 04:00:00	IWM	ETF	179.02	179.04	178.77	178.78	21942.0
2023-11-21 05:00:00	IWM	ETF	178.8	179.16	178.76	178.92	4117.0
2023-11-21 06:00:00	IWM	ETF	178.89	178.89	178.7	178.79	44971.0
2023-11-21 07:00:00	IWM	ETF	178.84	179.01	178.56	178.56	112315.0
2023-11-21 08:00:00	IWM	ETF	178.8298	179.7	177.98	178.02	220618.0
2023-11-21 09:00:00	IWM	ETF	178.01	178.505	177.1	177.3401	3777594.0
2023-11-21 10:00:00	IWM	ETF	177.35	178.17	177.33	178.03	3074510.0
2023-11-21 11:00:00	IWM	ETF	178.03	178.15	177.37	177.5401	3067621.0
2023-11-21 12:00:00	IWM	ETF	177.54	177.74	177.25	177.65	2223757.0
2023-11-21 13:00:00	IWM	ETF	177.65	177.65	176.96	177.12	3365354.0
2023-11-21 14:00:00	IWM	ETF	177.11	177.43	176.96	177.22	2344344.0
2023-11-21 15:00:00	IWM	ETF	177.22	177.45	176.91	177.03	4652282.0
2023-11-21 16:00:00	IWM	ETF	177.02	177.03	176.6	177.0	899989.0
2023-11-21 17:00:00	IWM	ETF	177.0	177.15	176.97	177.04	43159.0
2023-11-21 18:00:00	IWM	ETF	177.04	177.04	176.88	176.89	18181.0
2023-11-21 19:00:00	IWM	ETF	176.99	177.16	176.99	177.14	16160.0
2023-11-21 04:00:00	DIA	ETF	351.32	351.33	351.27	351.27	1450.0
2023-11-21 06:00:00	DIA	ETF	350.94	351.09	350.94	351.04	1763.0

> showing 50 of 18,224 rows — these rows as CSV

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