PREVIEW / etf_1hour / 2024-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-02-06.parquet
  size:    534 KB
  rows:    19,575

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-02-06 04:00:00	SPY	ETF	492.99	493.28	492.8	492.82	6674.0
2024-02-06 05:00:00	SPY	ETF	492.8	492.8	492.41	492.67	10029.0
2024-02-06 06:00:00	SPY	ETF	492.75	492.77	492.05	492.26	13326.0
2024-02-06 07:00:00	SPY	ETF	492.34	492.6	492.03	492.51	55765.0
2024-02-06 08:00:00	SPY	ETF	492.35	493.5	492.03	493.37	206283.0
2024-02-06 09:00:00	SPY	ETF	493.4	494.32	492.98	493.0095	5158899.0
2024-02-06 10:00:00	SPY	ETF	493.01	493.18	492.05	492.825	7219209.0
2024-02-06 11:00:00	SPY	ETF	492.81	493.43	492.25	492.35	4778258.0
2024-02-06 12:00:00	SPY	ETF	492.37	492.96	492.1	492.57	4206382.0
2024-02-06 13:00:00	SPY	ETF	492.575	493.55	492.45	493.515	4186979.0
2024-02-06 14:00:00	SPY	ETF	493.52	493.57	492.11	493.15	6070640.0
2024-02-06 15:00:00	SPY	ETF	493.16	494.04	492.635	493.97	8976526.0
2024-02-06 16:00:00	SPY	ETF	493.97	494.08	492.2716	493.7	2435788.0
2024-02-06 17:00:00	SPY	ETF	493.7	493.86	493.65	493.65	84704.0
2024-02-06 18:00:00	SPY	ETF	493.72	494.0	493.72	493.8	80441.0
2024-02-06 19:00:00	SPY	ETF	493.84	493.93	493.7	493.82	53366.0
2024-02-06 04:00:00	QQQ	ETF	429.37	429.97	429.26	429.31	56990.0
2024-02-06 05:00:00	QQQ	ETF	429.05	429.45	429.0	429.45	16457.0
2024-02-06 06:00:00	QQQ	ETF	429.51	429.56	427.99	428.31	110702.0
2024-02-06 07:00:00	QQQ	ETF	428.4	428.79	427.9	428.7	148445.0
2024-02-06 08:00:00	QQQ	ETF	428.3797	430.15	427.96	429.45	227267.0
2024-02-06 09:00:00	QQQ	ETF	429.58	430.22	427.43	427.47	4311543.0
2024-02-06 10:00:00	QQQ	ETF	427.49	427.57	426.13	427.08	5250920.0
2024-02-06 11:00:00	QQQ	ETF	427.07	427.68	425.64	425.82	4173336.0
2024-02-06 12:00:00	QQQ	ETF	425.84	426.535	425.22	425.94	3816041.0
2024-02-06 13:00:00	QQQ	ETF	425.95	426.95	425.87	426.905	2102998.0
2024-02-06 14:00:00	QQQ	ETF	426.9	427.12	425.2601	427.02	2927358.0
2024-02-06 15:00:00	QQQ	ETF	427.02	427.7	426.15	427.65	4881226.0
2024-02-06 16:00:00	QQQ	ETF	427.64	427.78	426.7654	427.35	916528.0
2024-02-06 17:00:00	QQQ	ETF	427.39	427.39	427.03	427.12	41458.0
2024-02-06 18:00:00	QQQ	ETF	427.19	427.65	427.19	427.39	135934.0
2024-02-06 19:00:00	QQQ	ETF	427.43	427.6	427.2505	427.55	53467.0
2024-02-06 04:00:00	IWM	ETF	191.91	192.05	191.74	191.74	10870.0
2024-02-06 05:00:00	IWM	ETF	191.62	191.63	191.07	191.15	15783.0
2024-02-06 06:00:00	IWM	ETF	191.37	191.37	191.02	191.23	13553.0
2024-02-06 07:00:00	IWM	ETF	191.26	191.28	191.0	191.27	74100.0
2024-02-06 08:00:00	IWM	ETF	191.25	192.5	191.01	191.69	129232.0
2024-02-06 09:00:00	IWM	ETF	191.7	193.53	191.02	192.96	4890170.0
2024-02-06 10:00:00	IWM	ETF	192.97	193.8	192.41	193.23	4021336.0
2024-02-06 11:00:00	IWM	ETF	193.24	193.77	192.835	192.97	2436892.0
2024-02-06 12:00:00	IWM	ETF	192.98	193.29	192.69	192.85	2049040.0
2024-02-06 13:00:00	IWM	ETF	192.855	193.51	192.6	193.44	2327317.0
2024-02-06 14:00:00	IWM	ETF	193.44	193.45	192.44	193.12	3383919.0
2024-02-06 15:00:00	IWM	ETF	193.125	193.64	192.93	193.61	5911557.0
2024-02-06 16:00:00	IWM	ETF	193.67	193.69	193.28	193.62	1077059.0
2024-02-06 17:00:00	IWM	ETF	193.604	193.67	193.5	193.58	41001.0
2024-02-06 18:00:00	IWM	ETF	193.6	193.86	193.58	193.63	29580.0
2024-02-06 19:00:00	IWM	ETF	193.63	193.72	193.5	193.55	36872.0
2024-02-06 04:00:00	DIA	ETF	383.58	383.58	383.43	383.43	497.0
2024-02-06 05:00:00	DIA	ETF	383.08	383.08	382.78	382.79	1788.0

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

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