PREVIEW / etf_1hour / 2024-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-02-20.parquet
  size:    545 KB
  rows:    20,254

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-20 04:00:00	SPY	ETF	498.33	498.65	497.84	498.1	30334.0
2024-02-20 05:00:00	SPY	ETF	497.89	497.89	497.38	497.45	27876.0
2024-02-20 06:00:00	SPY	ETF	497.5	497.93	497.0	497.92	33113.0
2024-02-20 07:00:00	SPY	ETF	497.95	498.28	497.64	497.96	89296.0
2024-02-20 08:00:00	SPY	ETF	497.78	499.51	497.4204	497.75	194819.0
2024-02-20 09:00:00	SPY	ETF	497.79	498.41	496.17	496.6801	6378187.0
2024-02-20 10:00:00	SPY	ETF	496.68	497.03	495.745	497.02	8329730.0
2024-02-20 11:00:00	SPY	ETF	497.02	497.3	495.67	495.74	5125312.0
2024-02-20 12:00:00	SPY	ETF	495.75	495.76	494.45	495.4889	6744915.0
2024-02-20 13:00:00	SPY	ETF	495.48	495.98	494.75	495.8982	5079674.0
2024-02-20 14:00:00	SPY	ETF	495.9	496.8	495.205	496.715	5565743.0
2024-02-20 15:00:00	SPY	ETF	496.72	496.88	495.1	496.74	15478142.0
2024-02-20 16:00:00	SPY	ETF	496.74	496.78	496.13	496.5	2422432.0
2024-02-20 17:00:00	SPY	ETF	496.51	496.76	496.21	496.45	143236.0
2024-02-20 18:00:00	SPY	ETF	496.35	496.8	496.26	496.39	62894.0
2024-02-20 19:00:00	SPY	ETF	496.33	496.65	496.03	496.06	21820.0
2024-02-20 04:00:00	QQQ	ETF	429.07	429.81	428.46	428.75	86305.0
2024-02-20 05:00:00	QQQ	ETF	428.39	428.39	427.56	427.73	60478.0
2024-02-20 06:00:00	QQQ	ETF	427.6	428.39	427.44	428.32	83333.0
2024-02-20 07:00:00	QQQ	ETF	428.39	429.15	428.25	428.84	210003.0
2024-02-20 08:00:00	QQQ	ETF	428.79	429.96	427.8104	428.82	617957.0
2024-02-20 09:00:00	QQQ	ETF	428.79	430.08	425.69	426.16	6920323.0
2024-02-20 10:00:00	QQQ	ETF	426.14	426.5	424.21	426.45	7363026.0
2024-02-20 11:00:00	QQQ	ETF	426.45	427.02	424.7413	424.77	4476025.0
2024-02-20 12:00:00	QQQ	ETF	424.77	425.01	423.5	424.74	4949566.0
2024-02-20 13:00:00	QQQ	ETF	424.74	425.449	424.06	425.405	3682917.0
2024-02-20 14:00:00	QQQ	ETF	425.42	426.5	424.78	426.33	4025669.0
2024-02-20 15:00:00	QQQ	ETF	426.34	427.36	425.38	427.33	7795899.0
2024-02-20 16:00:00	QQQ	ETF	427.32	427.35	426.41	426.58	1956295.0
2024-02-20 17:00:00	QQQ	ETF	426.57	426.62	426.18	426.28	179460.0
2024-02-20 18:00:00	QQQ	ETF	426.31	426.75	426.13	426.32	169968.0
2024-02-20 19:00:00	QQQ	ETF	426.27	426.59	425.96	425.98	113332.0
2024-02-20 04:00:00	IWM	ETF	200.19	200.52	199.86	200.43	39751.0
2024-02-20 05:00:00	IWM	ETF	200.3	200.45	200.09	200.2	17996.0
2024-02-20 06:00:00	IWM	ETF	200.02	200.47	199.88	200.47	16216.0
2024-02-20 07:00:00	IWM	ETF	200.46	200.61	200.05	200.05	64563.0
2024-02-20 08:00:00	IWM	ETF	200.45	200.55	199.77	199.91	154795.0
2024-02-20 09:00:00	IWM	ETF	199.87	199.87	198.54	199.25	4573661.0
2024-02-20 10:00:00	IWM	ETF	199.23	199.72	198.76	199.56	3915706.0
2024-02-20 11:00:00	IWM	ETF	199.58	199.63	198.74	198.78	2562283.0
2024-02-20 12:00:00	IWM	ETF	198.78	198.78	198.01	198.58	2233675.0
2024-02-20 13:00:00	IWM	ETF	198.58	198.74	198.13	198.64	1911503.0
2024-02-20 14:00:00	IWM	ETF	198.63	198.91	198.04	198.71	1748538.0
2024-02-20 15:00:00	IWM	ETF	198.72	198.9	198.13	198.87	4641847.0
2024-02-20 16:00:00	IWM	ETF	198.88	199.15	198.77	199.12	1687924.0
2024-02-20 17:00:00	IWM	ETF	199.09	199.09	198.82	198.86	20412.0
2024-02-20 18:00:00	IWM	ETF	198.96	199.19	198.9	198.98	31720.0
2024-02-20 19:00:00	IWM	ETF	198.91	199.06	198.73	198.73	59335.0
2024-02-20 04:00:00	DIA	ETF	385.7	385.7	385.35	385.5	989.0
2024-02-20 05:00:00	DIA	ETF	385.61	385.61	385.29	385.45	617.0

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

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