PREVIEW / etf_1hour / 2024-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-02-05.parquet
  size:    548 KB
  rows:    20,153

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-05 04:00:00	SPY	ETF	493.65	493.73	492.84	493.04	22757.0
2024-02-05 05:00:00	SPY	ETF	493.05	493.77	493.05	493.57	15027.0
2024-02-05 06:00:00	SPY	ETF	493.56	493.65	493.45	493.47	10983.0
2024-02-05 07:00:00	SPY	ETF	493.46	493.94	493.3	493.85	62148.0
2024-02-05 08:00:00	SPY	ETF	493.3908	493.93	492.78	492.89	271535.0
2024-02-05 09:00:00	SPY	ETF	492.95	493.71	492.83	493.44	5509818.0
2024-02-05 10:00:00	SPY	ETF	493.39	493.44	490.23	490.855	10631733.0
2024-02-05 11:00:00	SPY	ETF	490.86	492.165	490.7	492.14	5801579.0
2024-02-05 12:00:00	SPY	ETF	492.14	493.39	492.03	493.03	5640255.0
2024-02-05 13:00:00	SPY	ETF	493.03	493.5	492.58	493.14	4057616.0
2024-02-05 14:00:00	SPY	ETF	493.14	494.17	492.87	493.98	5080549.0
2024-02-05 15:00:00	SPY	ETF	494.0	494.03	492.52	492.58	12606930.0
2024-02-05 16:00:00	SPY	ETF	492.57	493.306	491.4696	492.46	4131885.0
2024-02-05 17:00:00	SPY	ETF	492.47	492.55	492.3	492.43	239182.0
2024-02-05 18:00:00	SPY	ETF	492.42	492.6	492.19	492.22	39632.0
2024-02-05 19:00:00	SPY	ETF	492.3	492.59	492.3	492.57	26450.0
2024-02-05 04:00:00	QQQ	ETF	428.75	429.05	427.9	428.13	105639.0
2024-02-05 05:00:00	QQQ	ETF	428.13	429.04	428.12	428.97	56139.0
2024-02-05 06:00:00	QQQ	ETF	428.93	429.06	428.58	428.69	37569.0
2024-02-05 07:00:00	QQQ	ETF	428.7	429.38	428.52	429.34	209282.0
2024-02-05 08:00:00	QQQ	ETF	428.9892	429.44	428.0804	428.51	331722.0
2024-02-05 09:00:00	QQQ	ETF	428.6	429.42	427.95	428.6501	4510241.0
2024-02-05 10:00:00	QQQ	ETF	428.65	428.65	425.0	425.94	6454344.0
2024-02-05 11:00:00	QQQ	ETF	425.94	427.62	425.7387	427.55	3753902.0
2024-02-05 12:00:00	QQQ	ETF	427.55	428.98	427.42	428.4	3834365.0
2024-02-05 13:00:00	QQQ	ETF	428.42	429.02	427.98	428.45	2766023.0
2024-02-05 14:00:00	QQQ	ETF	428.48	429.61	428.1023	429.38	3162861.0
2024-02-05 15:00:00	QQQ	ETF	429.385	429.41	427.88	428.45	4918429.0
2024-02-05 16:00:00	QQQ	ETF	428.45	428.72	428.03	428.58	853322.0
2024-02-05 17:00:00	QQQ	ETF	428.59	428.66	428.5	428.59	27133.0
2024-02-05 18:00:00	QQQ	ETF	428.54	428.75	428.35	428.44	44832.0
2024-02-05 19:00:00	QQQ	ETF	428.45	428.8	428.45	428.69	30852.0
2024-02-05 04:00:00	IWM	ETF	193.53	193.53	192.89	193.02	22491.0
2024-02-05 05:00:00	IWM	ETF	192.97	193.27	192.95	193.15	17608.0
2024-02-05 06:00:00	IWM	ETF	193.14	193.25	193.0	193.07	20208.0
2024-02-05 07:00:00	IWM	ETF	193.0	193.33	192.74	193.23	168849.0
2024-02-05 08:00:00	IWM	ETF	193.06	193.89	192.27	192.41	215765.0
2024-02-05 09:00:00	IWM	ETF	192.4	192.6	191.15	191.68	5204088.0
2024-02-05 10:00:00	IWM	ETF	191.67	191.67	190.06	190.56	7700743.0
2024-02-05 11:00:00	IWM	ETF	190.57	191.1999	190.395	190.97	3557658.0
2024-02-05 12:00:00	IWM	ETF	190.97	192.24	190.94	191.96	3012782.0
2024-02-05 13:00:00	IWM	ETF	191.95	192.5	191.74	192.3	2292402.0
2024-02-05 14:00:00	IWM	ETF	192.3	193.11	192.16	192.91	2513057.0
2024-02-05 15:00:00	IWM	ETF	192.91	192.99	191.82	191.89	6021906.0
2024-02-05 16:00:00	IWM	ETF	191.87	192.05	191.51	191.79	2426444.0
2024-02-05 17:00:00	IWM	ETF	191.76	191.92	191.71	191.84	32599.0
2024-02-05 18:00:00	IWM	ETF	191.76	191.88	191.63	191.6499	35625.0
2024-02-05 19:00:00	IWM	ETF	191.75	191.85	191.7	191.7	12891.0
2024-02-05 04:00:00	DIA	ETF	386.0	386.0	385.24	385.24	1416.0
2024-02-05 05:00:00	DIA	ETF	385.81	385.81	385.81	385.81	100.0

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

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