PREVIEW / etf_1hour / 2023-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-21.parquet
  size:    476 KB
  rows:    17,243

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-21 04:00:00	SPY	ETF	453.0	453.32	452.87	453.32	22977.0
2023-07-21 05:00:00	SPY	ETF	453.32	453.33	452.96	453.24	20734.0
2023-07-21 06:00:00	SPY	ETF	453.33	453.63	453.33	453.58	23587.0
2023-07-21 07:00:00	SPY	ETF	453.56	453.56	453.1	453.1	73624.0
2023-07-21 08:00:00	SPY	ETF	453.5691	454.4301	452.64	454.43	286304.0
2023-07-21 09:00:00	SPY	ETF	454.45	454.75	452.58	452.83	6445666.0
2023-07-21 10:00:00	SPY	ETF	452.84	453.57	452.21	453.09	7772113.0
2023-07-21 11:00:00	SPY	ETF	453.09	454.0406	453.06	453.69	5090212.0
2023-07-21 12:00:00	SPY	ETF	453.69	453.7	452.61	452.98	3850729.0
2023-07-21 13:00:00	SPY	ETF	452.98	454.165	452.91	454.05	4026294.0
2023-07-21 14:00:00	SPY	ETF	454.07	454.13	453.1	453.2	4085319.0
2023-07-21 15:00:00	SPY	ETF	453.21	453.24	452.17	452.19	14293587.0
2023-07-21 16:00:00	SPY	ETF	452.19	452.3939	451.99	452.19	5884785.0
2023-07-21 17:00:00	SPY	ETF	452.29	452.3	452.0055	452.1	111415.0
2023-07-21 18:00:00	SPY	ETF	452.12	452.18	451.9912	451.9912	30660.0
2023-07-21 19:00:00	SPY	ETF	452.09	452.09	451.91	451.95	12442.0
2023-07-21 04:00:00	QQQ	ETF	377.79	378.57	377.59	378.38	103110.0
2023-07-21 05:00:00	QQQ	ETF	378.26	378.36	377.79	378.21	28935.0
2023-07-21 06:00:00	QQQ	ETF	378.24	378.83	378.24	378.78	103180.0
2023-07-21 07:00:00	QQQ	ETF	378.76	378.85	378.13	378.18	135828.0
2023-07-21 08:00:00	QQQ	ETF	378.7606	379.43	376.72	379.37	526372.0
2023-07-21 09:00:00	QQQ	ETF	379.42	379.92	377.54	377.55	7408459.0
2023-07-21 10:00:00	QQQ	ETF	377.56	378.19	375.81	376.6	7912395.0
2023-07-21 11:00:00	QQQ	ETF	376.6	378.06	376.43	377.26	4624572.0
2023-07-21 12:00:00	QQQ	ETF	377.27	377.41	375.95	376.51	3783673.0
2023-07-21 13:00:00	QQQ	ETF	376.51	378.37	376.41	378.22	3620417.0
2023-07-21 14:00:00	QQQ	ETF	378.21	378.27	376.42	376.48	3629215.0
2023-07-21 15:00:00	QQQ	ETF	376.49	376.55	375.191	375.575	9647508.0
2023-07-21 16:00:00	QQQ	ETF	375.58	376.02	375.57	375.97	3504983.0
2023-07-21 17:00:00	QQQ	ETF	375.97	375.98	375.56	375.69	60268.0
2023-07-21 18:00:00	QQQ	ETF	375.58	375.61	375.44	375.51	29206.0
2023-07-21 19:00:00	QQQ	ETF	375.53	375.7	375.46	375.7	27256.0
2023-07-21 04:00:00	IWM	ETF	195.7	195.93	195.62	195.9	14174.0
2023-07-21 05:00:00	IWM	ETF	195.93	196.0	195.85	196.0	2530.0
2023-07-21 06:00:00	IWM	ETF	196.0	196.25	195.98	196.15	31613.0
2023-07-21 07:00:00	IWM	ETF	196.11	196.14	195.98	196.03	24287.0
2023-07-21 08:00:00	IWM	ETF	196.0	196.72	195.5	196.67	141164.0
2023-07-21 09:00:00	IWM	ETF	196.66	196.7	194.54	194.88	2969150.0
2023-07-21 10:00:00	IWM	ETF	194.89	195.54	194.46	194.92	3461693.0
2023-07-21 11:00:00	IWM	ETF	194.93	195.63	194.82	195.36	2646756.0
2023-07-21 12:00:00	IWM	ETF	195.37	195.37	194.42	194.69	2153543.0
2023-07-21 13:00:00	IWM	ETF	194.68	195.33	194.67	195.3099	1404449.0
2023-07-21 14:00:00	IWM	ETF	195.315	195.33	194.58	194.67	1241918.0
2023-07-21 15:00:00	IWM	ETF	194.675	194.72	194.0901	194.44	4253699.0
2023-07-21 16:00:00	IWM	ETF	194.46	194.5	194.17	194.27	2114469.0
2023-07-21 17:00:00	IWM	ETF	194.3	194.35	194.21	194.23	4982.0
2023-07-21 18:00:00	IWM	ETF	194.2	194.46	194.2	194.21	540866.0
2023-07-21 19:00:00	IWM	ETF	194.25	194.35	194.25	194.28	3469.0
2023-07-21 04:00:00	DIA	ETF	352.44	352.65	352.44	352.57	1083.0
2023-07-21 07:00:00	DIA	ETF	352.39	352.499	352.1	352.1	6234.0

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

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