PREVIEW / etf_1hour / 2023-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-02.parquet
  size:    501 KB
  rows:    18,376

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-08-02 04:00:00	SPY	ETF	452.78	454.7	451.74	452.73	92013.0
2023-08-02 05:00:00	SPY	ETF	452.7	453.28	452.3	453.09	203298.0
2023-08-02 06:00:00	SPY	ETF	453.13	454.37	453.11	454.37	121302.0
2023-08-02 07:00:00	SPY	ETF	454.37	454.8	454.13	454.251	288645.0
2023-08-02 08:00:00	SPY	ETF	454.55	454.8	451.8604	453.67	467642.0
2023-08-02 09:00:00	SPY	ETF	453.64	453.65	452.34	452.98	8459744.0
2023-08-02 10:00:00	SPY	ETF	452.99	453.085	450.44	450.63	12423761.0
2023-08-02 11:00:00	SPY	ETF	450.63	451.67	450.29	450.31	9014028.0
2023-08-02 12:00:00	SPY	ETF	450.3	451.0964	449.98	450.85	7109124.0
2023-08-02 13:00:00	SPY	ETF	450.845	451.435	450.455	450.57	5075415.0
2023-08-02 14:00:00	SPY	ETF	450.58	451.08	450.2601	450.6182	4917284.0
2023-08-02 15:00:00	SPY	ETF	450.62	450.9	449.3499	450.14	15605511.0
2023-08-02 16:00:00	SPY	ETF	450.16	450.46	449.72	449.98	3088480.0
2023-08-02 17:00:00	SPY	ETF	449.99	450.05	449.85	449.91	88613.0
2023-08-02 18:00:00	SPY	ETF	449.99	450.72	449.98	450.72	88848.0
2023-08-02 19:00:00	SPY	ETF	450.74	450.91	450.68	450.9	101974.0
2023-08-02 04:00:00	QQQ	ETF	378.23	379.0	377.43	378.43	126587.0
2023-08-02 05:00:00	QQQ	ETF	378.49	378.87	378.09	378.64	77079.0
2023-08-02 06:00:00	QQQ	ETF	378.68	379.83	378.65	379.81	151940.0
2023-08-02 07:00:00	QQQ	ETF	379.8	380.48	379.8	379.98	256819.0
2023-08-02 08:00:00	QQQ	ETF	380.06	383.077	377.5796	379.53	612959.0
2023-08-02 09:00:00	QQQ	ETF	379.52	379.52	377.21	377.7	7472273.0
2023-08-02 10:00:00	QQQ	ETF	377.69	377.865	374.8801	375.02	8521372.0
2023-08-02 11:00:00	QQQ	ETF	375.02	375.79	373.95	373.96	8329188.0
2023-08-02 12:00:00	QQQ	ETF	373.97	374.845	373.13	374.735	7127240.0
2023-08-02 13:00:00	QQQ	ETF	374.74	375.44	374.26	374.48	4479502.0
2023-08-02 14:00:00	QQQ	ETF	374.49	375.55	374.425	375.01	3350820.0
2023-08-02 15:00:00	QQQ	ETF	375.025	375.39	373.56	374.39	9436623.0
2023-08-02 16:00:00	QQQ	ETF	374.39	374.69	373.89	374.01	2430276.0
2023-08-02 17:00:00	QQQ	ETF	374.0	374.12	373.84	374.05	173454.0
2023-08-02 18:00:00	QQQ	ETF	374.03	374.92	374.03	374.92	107379.0
2023-08-02 19:00:00	QQQ	ETF	374.95	375.16	374.84	374.97	99991.0
2023-08-02 04:00:00	IWM	ETF	195.4	195.46	194.39	194.99	45836.0
2023-08-02 05:00:00	IWM	ETF	195.04	195.54	194.81	195.44	17054.0
2023-08-02 06:00:00	IWM	ETF	195.49	196.19	195.43	196.19	37856.0
2023-08-02 07:00:00	IWM	ETF	196.18	196.39	196.0	196.1	83584.0
2023-08-02 08:00:00	IWM	ETF	196.35	196.5	194.41	196.23	128988.0
2023-08-02 09:00:00	IWM	ETF	196.21	196.29	195.02	195.54	3911513.0
2023-08-02 10:00:00	IWM	ETF	195.555	195.74	194.39	194.5	4538525.0
2023-08-02 11:00:00	IWM	ETF	194.51	195.1	194.33	194.51	2636629.0
2023-08-02 12:00:00	IWM	ETF	194.51	195.14	194.09	194.95	2648339.0
2023-08-02 13:00:00	IWM	ETF	194.95	195.36	194.93	195.101	1409156.0
2023-08-02 14:00:00	IWM	ETF	195.12	195.44	195.05	195.25	1448090.0
2023-08-02 15:00:00	IWM	ETF	195.26	195.41	194.6	195.1	4792300.0
2023-08-02 16:00:00	IWM	ETF	195.11	195.35	195.0	195.15	829823.0
2023-08-02 17:00:00	IWM	ETF	195.14	195.17	195.01	195.11	14838.0
2023-08-02 18:00:00	IWM	ETF	195.11	195.47	195.11	195.43	18269.0
2023-08-02 19:00:00	IWM	ETF	195.45	195.62	195.45	195.56	57544.0
2023-08-02 04:00:00	DIA	ETF	353.86	353.86	353.49	353.54	2747.0
2023-08-02 05:00:00	DIA	ETF	353.76	354.36	353.72	354.29	12825.0

> showing 50 of 18,376 rows — these rows as CSV

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