PREVIEW / etf_1hour / 2024-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-02-14.parquet
  size:    541 KB
  rows:    19,830

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-14 04:00:00	SPY	ETF	495.0	496.57	495.0	496.51	20315.0
2024-02-14 05:00:00	SPY	ETF	496.5	496.5	496.07	496.37	43131.0
2024-02-14 06:00:00	SPY	ETF	496.18	496.53	495.71	496.52	25667.0
2024-02-14 07:00:00	SPY	ETF	496.49	496.84	496.31	496.44	264160.0
2024-02-14 08:00:00	SPY	ETF	496.55	497.13	494.37	496.4	498121.0
2024-02-14 09:00:00	SPY	ETF	496.42	497.3	495.78	496.88	6631538.0
2024-02-14 10:00:00	SPY	ETF	496.9	497.99	495.94	495.955	7778661.0
2024-02-14 11:00:00	SPY	ETF	495.95	496.33	495.15	495.336	7137849.0
2024-02-14 12:00:00	SPY	ETF	495.35	496.33	494.4	496.2	5082658.0
2024-02-14 13:00:00	SPY	ETF	496.21	497.14	495.42	496.5701	4955643.0
2024-02-14 14:00:00	SPY	ETF	496.58	497.1047	495.22	496.92	5951044.0
2024-02-14 15:00:00	SPY	ETF	496.92	499.07	496.61	498.625	13501505.0
2024-02-14 16:00:00	SPY	ETF	498.62	499.33	498.38	498.84	2811462.0
2024-02-14 17:00:00	SPY	ETF	498.84	498.99	498.75	498.93	77126.0
2024-02-14 18:00:00	SPY	ETF	498.91	498.98	498.79	498.94	57426.0
2024-02-14 19:00:00	SPY	ETF	498.9391	498.9391	498.6	498.65	74059.0
2024-02-14 04:00:00	QQQ	ETF	430.05	431.43	429.62	431.36	70939.0
2024-02-14 05:00:00	QQQ	ETF	431.4	431.4	430.97	431.3	60561.0
2024-02-14 06:00:00	QQQ	ETF	431.17	431.31	430.53	431.22	63263.0
2024-02-14 07:00:00	QQQ	ETF	431.26	431.81	431.15	431.29	144743.0
2024-02-14 08:00:00	QQQ	ETF	429.19	431.78	428.8	431.0	653186.0
2024-02-14 09:00:00	QQQ	ETF	431.0	431.97	430.13	431.28	4284867.0
2024-02-14 10:00:00	QQQ	ETF	431.29	432.65	430.17	430.18	5718783.0
2024-02-14 11:00:00	QQQ	ETF	430.1687	430.75	429.215	429.78	5087901.0
2024-02-14 12:00:00	QQQ	ETF	429.79	431.21	428.8799	430.96	3600917.0
2024-02-14 13:00:00	QQQ	ETF	430.98	431.85	430.035	431.183	3206428.0
2024-02-14 14:00:00	QQQ	ETF	431.18	431.465	429.85	431.45	3537910.0
2024-02-14 15:00:00	QQQ	ETF	431.46	433.65	431.15	433.24	8424465.0
2024-02-14 16:00:00	QQQ	ETF	433.24	433.48	432.96	433.3	1764958.0
2024-02-14 17:00:00	QQQ	ETF	433.28	433.39	433.11	433.3	66537.0
2024-02-14 18:00:00	QQQ	ETF	433.26	433.56	433.18	433.44	53853.0
2024-02-14 19:00:00	QQQ	ETF	433.45	433.45	433.17	433.22	70735.0
2024-02-14 04:00:00	IWM	ETF	195.45	196.89	195.45	196.81	47469.0
2024-02-14 05:00:00	IWM	ETF	196.68	196.94	196.32	196.84	88324.0
2024-02-14 06:00:00	IWM	ETF	196.85	196.91	196.38	196.82	89747.0
2024-02-14 07:00:00	IWM	ETF	196.82	197.16	196.68	196.82	205957.0
2024-02-14 08:00:00	IWM	ETF	196.7801	197.48	195.16	196.86	361704.0
2024-02-14 09:00:00	IWM	ETF	196.99	197.98	196.75	197.53	4975112.0
2024-02-14 10:00:00	IWM	ETF	197.54	197.9442	196.67	196.79	4830478.0
2024-02-14 11:00:00	IWM	ETF	196.8	197.75	196.23	197.095	3537282.0
2024-02-14 12:00:00	IWM	ETF	197.09	197.965	196.42	197.93	2651793.0
2024-02-14 13:00:00	IWM	ETF	197.93	198.705	197.52	198.505	2945353.0
2024-02-14 14:00:00	IWM	ETF	198.51	199.3	197.815	199.3	4100666.0
2024-02-14 15:00:00	IWM	ETF	199.2975	199.79	199.18	199.2	8306328.0
2024-02-14 16:00:00	IWM	ETF	199.13	199.67	199.06	199.43	2132216.0
2024-02-14 17:00:00	IWM	ETF	199.45	199.55	199.13	199.42	23203.0
2024-02-14 18:00:00	IWM	ETF	199.46	199.74	199.46	199.7	25194.0
2024-02-14 19:00:00	IWM	ETF	199.73	199.73	199.57	199.6	14107.0
2024-02-14 04:00:00	DIA	ETF	383.4	383.61	383.4	383.61	1050.0
2024-02-14 05:00:00	DIA	ETF	383.78	383.78	383.78	383.78	102.0

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

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