PREVIEW / etf_1hour / 2024-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-05-17.parquet
  size:    526 KB
  rows:    19,221

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-05-17 04:00:00	SPY	ETF	528.8	528.8	528.1	528.37	11787.0
2024-05-17 05:00:00	SPY	ETF	528.4	528.82	528.4	528.82	7313.0
2024-05-17 06:00:00	SPY	ETF	528.68	528.75	528.5	528.75	4793.0
2024-05-17 07:00:00	SPY	ETF	528.78	529.09	528.6	528.9	104846.0
2024-05-17 08:00:00	SPY	ETF	528.8099	529.33	528.6104	529.32	192777.0
2024-05-17 09:00:00	SPY	ETF	529.31	529.31	528.36	528.745	3763776.0
2024-05-17 10:00:00	SPY	ETF	528.76	529.3	528.342	529.11	4832545.0
2024-05-17 11:00:00	SPY	ETF	529.11	529.125	528.27	528.83	3323774.0
2024-05-17 12:00:00	SPY	ETF	528.83	529.0295	528.05	528.7899	3060811.0
2024-05-17 13:00:00	SPY	ETF	528.78	528.9	528.485	528.72	2406441.0
2024-05-17 14:00:00	SPY	ETF	528.725	528.94	527.32	528.8051	4934642.0
2024-05-17 15:00:00	SPY	ETF	528.81	529.52	528.62	529.43	9178437.0
2024-05-17 16:00:00	SPY	ETF	529.42	529.5	528.669	529.48	3200269.0
2024-05-17 17:00:00	SPY	ETF	529.48	529.65	529.26	529.49	152843.0
2024-05-17 18:00:00	SPY	ETF	529.48	529.7005	529.48	529.64	28953.0
2024-05-17 19:00:00	SPY	ETF	529.61	529.7	529.57	529.6	14109.0
2024-05-17 04:00:00	QQQ	ETF	452.0	452.0	451.3	451.68	33326.0
2024-05-17 05:00:00	QQQ	ETF	451.74	452.22	451.74	452.22	13840.0
2024-05-17 06:00:00	QQQ	ETF	452.26	452.42	452.01	452.42	33216.0
2024-05-17 07:00:00	QQQ	ETF	452.45	452.67	452.19	452.48	52321.0
2024-05-17 08:00:00	QQQ	ETF	452.4503	452.92	451.4196	452.88	141383.0
2024-05-17 09:00:00	QQQ	ETF	452.89	452.89	451.35	451.78	2653996.0
2024-05-17 10:00:00	QQQ	ETF	451.79	452.72	451.39	452.44	3383642.0
2024-05-17 11:00:00	QQQ	ETF	452.445	452.45	451.39	452.1501	2512166.0
2024-05-17 12:00:00	QQQ	ETF	452.16	452.32	451.06	451.8391	2044503.0
2024-05-17 13:00:00	QQQ	ETF	451.83	451.84	451.09	451.235	1675578.0
2024-05-17 14:00:00	QQQ	ETF	451.24	451.39	449.5399	451.2832	3453508.0
2024-05-17 15:00:00	QQQ	ETF	451.295	451.84	451.08	451.77	5400125.0
2024-05-17 16:00:00	QQQ	ETF	451.76	451.77	451.35	451.68	872356.0
2024-05-17 17:00:00	QQQ	ETF	451.66	451.66	451.39	451.65	24708.0
2024-05-17 18:00:00	QQQ	ETF	451.64	451.8	451.6	451.64	14613.0
2024-05-17 19:00:00	QQQ	ETF	451.64	451.65	451.55	451.55	10195.0
2024-05-17 04:00:00	IWM	ETF	208.0	208.12	207.77	208.0	16644.0
2024-05-17 05:00:00	IWM	ETF	207.98	208.24	207.98	208.24	4527.0
2024-05-17 06:00:00	IWM	ETF	208.11	208.24	208.02	208.24	4273.0
2024-05-17 07:00:00	IWM	ETF	208.25	208.33	207.9	207.9	44834.0
2024-05-17 08:00:00	IWM	ETF	208.2	208.3	207.55	207.68	140771.0
2024-05-17 09:00:00	IWM	ETF	207.65	208.51	207.56	208.06	2921924.0
2024-05-17 10:00:00	IWM	ETF	208.05	208.52	207.77	208.27	2858727.0
2024-05-17 11:00:00	IWM	ETF	208.28	208.29	207.82	208.195	2386332.0
2024-05-17 12:00:00	IWM	ETF	208.19	208.38	207.78	208.05	2108188.0
2024-05-17 13:00:00	IWM	ETF	208.05	208.12	207.77	208.0	1575511.0
2024-05-17 14:00:00	IWM	ETF	208.0	208.01	207.35	207.845	2846222.0
2024-05-17 15:00:00	IWM	ETF	207.85	208.14	207.63	208.11	4635293.0
2024-05-17 16:00:00	IWM	ETF	208.08	208.13	207.95	208.02	734418.0
2024-05-17 17:00:00	IWM	ETF	208.02	208.15	207.99	208.1	6668.0
2024-05-17 18:00:00	IWM	ETF	208.15	208.35	208.13	208.24	3689.0
2024-05-17 19:00:00	IWM	ETF	208.24	208.29	208.13	208.13	4532.0
2024-05-17 04:00:00	DIA	ETF	398.44	398.44	398.2	398.2	350.0
2024-05-17 05:00:00	DIA	ETF	398.55	398.55	398.55	398.55	200.0

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

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