PREVIEW / etf_1hour / 2023-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-26.parquet
  size:    482 KB
  rows:    17,611

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
2023-07-26 04:00:00	SPY	ETF	455.78	455.78	455.24	455.24	38952.0
2023-07-26 05:00:00	SPY	ETF	455.35	455.47	454.88	455.1	9906.0
2023-07-26 06:00:00	SPY	ETF	455.14	455.14	454.6	454.77	21923.0
2023-07-26 07:00:00	SPY	ETF	454.8	455.14	454.69	454.95	105696.0
2023-07-26 08:00:00	SPY	ETF	454.7587	456.1	454.37	454.44	219833.0
2023-07-26 09:00:00	SPY	ETF	454.39	455.16	454.35	454.8192	3877422.0
2023-07-26 10:00:00	SPY	ETF	454.815	454.99	454.05	454.1475	4736348.0
2023-07-26 11:00:00	SPY	ETF	454.15	454.98	453.99	454.94	4077061.0
2023-07-26 12:00:00	SPY	ETF	454.935	455.13	454.025	454.255	3462516.0
2023-07-26 13:00:00	SPY	ETF	454.25	454.481	454.07	454.24	3538235.0
2023-07-26 14:00:00	SPY	ETF	454.17	456.99	453.81	456.0	13196516.0
2023-07-26 15:00:00	SPY	ETF	456.01	456.21	453.38	455.51	18437069.0
2023-07-26 16:00:00	SPY	ETF	455.51	456.61	455.15	455.2	3780509.0
2023-07-26 17:00:00	SPY	ETF	455.15	455.51	455.07	455.28	553717.0
2023-07-26 18:00:00	SPY	ETF	455.28	455.51	455.05	455.43	98419.0
2023-07-26 19:00:00	SPY	ETF	455.47	455.7	455.42	455.6	50377.0
2023-07-26 04:00:00	QQQ	ETF	378.72	378.8	378.22	378.28	49489.0
2023-07-26 05:00:00	QQQ	ETF	378.36	378.5	378.08	378.35	12989.0
2023-07-26 06:00:00	QQQ	ETF	378.41	378.41	377.73	377.91	26689.0
2023-07-26 07:00:00	QQQ	ETF	377.97	378.37	377.79	377.979	66037.0
2023-07-26 08:00:00	QQQ	ETF	377.98	379.064	377.4	377.61	289165.0
2023-07-26 09:00:00	QQQ	ETF	377.61	378.21	376.43	377.87	4861950.0
2023-07-26 10:00:00	QQQ	ETF	377.87	378.07	375.6	375.73	4623301.0
2023-07-26 11:00:00	QQQ	ETF	375.73	377.15	375.18	376.9016	3627709.0
2023-07-26 12:00:00	QQQ	ETF	376.91	377.198	375.8199	376.064	2351817.0
2023-07-26 13:00:00	QQQ	ETF	376.06	376.415	375.87	376.2	1890737.0
2023-07-26 14:00:00	QQQ	ETF	376.18	379.24	375.7	377.99	8764529.0
2023-07-26 15:00:00	QQQ	ETF	378.01	378.32	375.31	377.55	8702891.0
2023-07-26 16:00:00	QQQ	ETF	377.53	379.86	377.45	377.84	1185914.0
2023-07-26 17:00:00	QQQ	ETF	377.84	378.35	377.82	378.35	112737.0
2023-07-26 18:00:00	QQQ	ETF	378.31	378.42	378.01	378.31	86835.0
2023-07-26 19:00:00	QQQ	ETF	378.33	378.55	378.3	378.52	56684.0
2023-07-26 04:00:00	IWM	ETF	195.62	195.65	195.34	195.34	6998.0
2023-07-26 05:00:00	IWM	ETF	195.37	195.52	195.08	195.27	3227.0
2023-07-26 06:00:00	IWM	ETF	195.29	195.34	195.15	195.25	5309.0
2023-07-26 07:00:00	IWM	ETF	195.3	195.3	195.02	195.14	15794.0
2023-07-26 08:00:00	IWM	ETF	195.23	195.3904	194.8	194.81	62316.0
2023-07-26 09:00:00	IWM	ETF	194.88	196.67	194.55	196.1501	2605855.0
2023-07-26 10:00:00	IWM	ETF	196.16	196.325	195.54	195.65	2552946.0
2023-07-26 11:00:00	IWM	ETF	195.645	196.1	195.37	196.08	1446502.0
2023-07-26 12:00:00	IWM	ETF	196.07	196.239	195.7618	195.93	798325.0
2023-07-26 13:00:00	IWM	ETF	195.93	196.05	195.565	195.58	753505.0
2023-07-26 14:00:00	IWM	ETF	195.57	197.16	195.39	196.77	3095042.0
2023-07-26 15:00:00	IWM	ETF	196.78	196.9	195.64	196.48	4708842.0
2023-07-26 16:00:00	IWM	ETF	196.46	196.75	196.01	196.01	716337.0
2023-07-26 17:00:00	IWM	ETF	196.05	196.15	195.9	196.13	31827.0
2023-07-26 18:00:00	IWM	ETF	196.05	196.13	195.85	196.0	30241.0
2023-07-26 19:00:00	IWM	ETF	196.08	196.2	196.07	196.19	16378.0
2023-07-26 05:00:00	DIA	ETF	353.51	353.51	353.51	353.51	604.0
2023-07-26 06:00:00	DIA	ETF	353.51	353.65	353.51	353.65	603.0

> showing 50 of 17,611 rows — these rows as CSV

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